ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
Stephen Frost 00:40Finding Slow Queries 01:03Logging 02:20log_min_duration_statement 02:32log_line_prefix 03:59log_checkpoints 06:08Connection Logging 07:06log_lock_waits 08:10log_temp_files 10:17log_autovacum_min_duration 11:43Log Analysis (pgBadger) 12:42pg_stat_statements 17:47Understanding why queries are slow 23:10PostgreSQL Configuration 23:23Dead Tuples / Bloat 23:42Retrieving data 27:26Putting things together (Joins) 30:15Adding it all up (Aggregates) 32:26What's the best plan? 33:27Automating collections of plans 34:08Analyzing plans 35:14Fixing slow queries 35:59Prepared queries 38:44Query review 40:07Review and the some 49:28Questions? 52:09
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.
That was a very useful info, thanks!
Very good stuff :-)
Yep good stuff here.
Good stuff
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
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.
That was a very useful info, thanks!
Very good stuff :-)
Yep good stuff here.
Good stuff