The Slow Query Log
- A foreign key check takes a row lock on the parent you didn't write to —
- Generic vs. custom plans: why your parameterized query gets slow after five executions —
- autovacuum has been running on schedule, so why is the table still bloated —
- INSERT ... ON CONFLICT DO UPDATE takes a lock you can't see in the query, and it can deadlock —
- work_mem doesn't mean what the name suggests, and raising it globally can take your server down —
- Index-only scans that aren't: the visibility map's role in a plan you can't explain —
- ADD COLUMN is instant, until it isn't: what still takes an AccessExclusiveLock —
- Reading EXPLAIN (ANALYZE, BUFFERS) without fooling yourself —
- Why your partitioned table isn't actually getting pruned —
- pgbouncer transaction pooling: the four things it silently breaks —