PostgreSQL Query Performance Insights

on YouTube ↗50m

" summary

Explains how to use pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor to get real signals: pg_stat_statements adds 3–4% overhead and defaults to 5000 queries retained; auto_explain forces plans into logs; pgBadger parses huge logs (author created a 4GB log in 15 minutes at ~5000 TPS); pg_stat_activity is ephemeral; pg_stat_monitor implements per-minute buckets and stores actual parameter values plus histograms and is moving from RC to GA.

AI-written summary · about

" chapters (9)

1. 0:00Start
2. 1:39Presentation Outline
3. 5:34Components of Query Processing
4. 9:03EXPLAIN - Basics: Costs
5. 16:23EXPLAIN ANALYZE - Basics
6. 31:15pg_stat_statements - Challenges
7. 36:03auto_explain Extension
8. 42:00pgbadger Challenges
9. 47:33Tools for the Use Case

" related talks

• 51mPostgreSQL Query Performance InsightsHamid Quddus Akhtar · Percona Live 2022
• 57mQuery Logging and Workload AnalysisGreg Smith · Postgres Open 2012
• 25mPoint-in-time query tuning and observability with pg_stat_statementsRyan Booz · Citus Con: An Event for Postgres 2022
• 39mDeep dive into PostgreSQL internal statisticsAleksey Lesovskiy · HighLoad++ 2015
• 31mpg_stat_advisor: Optimizing PostgreSQL Planner with InsightsIlia Evdokimov · FOSSASIA PGDay 2025
• 27mPostgres Performance in 15 MinutesJosh Berkus · DjangoCon US 2015
• 49mLeveraging pgBadger for Effective PostgreSQL TroubleshootingAlicja Kucharczyk · PostgreSQL Conference Europe 2023
• 26mBe Good Friends with Query PlannerAtsushi Torikoshi · PGConf India 2025