Postgres Open 2016 - Identifying Slow Queries and Fixing Them!

Identifying Slow Queries and Fixing Them! - Stephen Frost

[@johanjaimes10]

Stephen Frost 00:40 Finding Slow Queries 01:03 Logging 02:20 log_min_duration_statement 02:32 log_line_prefix 03:59 log_checkpoints 06:08 Connection Logging 07:06 log_lock_waits 08:10 log_temp_files 10:17 log_autovacum_min_duration 11:43 Log Analysis (pgBadger) 12:42 pg_stat_statements 17:47 Understanding why queries are slow 23:10 PostgreSQL Configuration 23:23 Dead Tuples / Bloat 23:42 Retrieving data 27:26 Putting things together (Joins) 30:15 Adding it all up (Aggregates) 32:26 What's the best plan? 33:27 Automating collections of plans 34:08 Analyzing plans 35:14 Fixing slow queries 35:59 Prepared queries 38:44 Query review 40:07 Review and the some 49:28 Questions? 52:09

[@zachary_thomas]

For the data analysts out there: practical advice for writing queries begins at around the 44:00 mark and then at the Q&A portion around the 49:00 mark.

[@alanrodriguez354]

That was a very useful info, thanks!

[@mrmik82]

Very good stuff :-)

[@MrMikomi]

Yep good stuff here.

[@quaryaband]

Good stuff