From the course: Advanced SQL for Query Tuning and Performance Optimization
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Challenge: Analyze schema statistics - SQL Tutorial
From the course: Advanced SQL for Query Tuning and Performance Optimization
Challenge: Analyze schema statistics
“
(upbeat music) - [Narrator] In this challenge, we're considering a scenario where we've created a table called sensor_metrics and we've inserted a large number of rows. Now, we want to make sure our table statistics are up to date. So what command would you run to update statistics on the sensor_metrics table?
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Collect statistics about data in tables3m 21s
-
(Locked)
Analyzing execution statistics with pg_stat_statements1m 54s
-
(Locked)
Reviewing execution plans with the auto_explain module2m 34s
-
(Locked)
Additional analysis with other pg_stats data1m 26s
-
(Locked)
Challenge: Analyze schema statistics23s
-
(Locked)
Solution: Analyze schema statistics16s
-
(Locked)
-
-