Postgres Open 2016 - Identifying Slow Queries and Fixing Them!

[@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!

[@MrMikomi]

Yep good stuff here.

[@mrmik82]

Very good stuff :-)

[@quaryaband]

Good stuff