Chapters
Transcript
Episode notes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Introduction
00:00 • 2min
How to Use AutoXplain to Log Execution Plans
02:01 • 2min
How to Set a Log Mean Duration for AutoXplain
03:37 • 2min
How to Optimize a Slow Query Group
05:59 • 3min
The Pros and Cons of Auto Explain
09:14 • 3min
The Best of Both Worlds
11:54 • 2min
The Future of Pichastat Statements
13:29 • 2min
The Worst Thing in Post-Guses
15:13 • 4min
The Importance of Track Timing in Postgres
19:13 • 2min
The Benefits of Using Buffers in Production Systems
21:23 • 2min
The Importance of Buffers and Timing
22:56 • 2min
Benchmarking for Continuous Optimization
25:14 • 4min
How to Measure Overhead in PGSIS
29:16 • 2min
The Limitations of Auto-Explained Power
31:13 • 2min
The Differences Between Log Mean and Auto-Explain
32:52 • 4min