PostgreSQL Query Performance Insights
recording made private on YouTubehttps://youtu.be/km_JeUGHGXw
summary
Covers using PostgreSQL observability tools—pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor—to measure and analyze query performance patterns. Shows how those tools together reveal query behavior so you can optimize queries and ensure the database handles average and peak loads.
AI-written summary · about
related talks
50mPostgreSQL Query Performance Insights
51mPostgreSQL Query Performance Insights
41mOptimizing your app by understanding your PostgreSQL database
47mIdentifying Slow Queries and Fixing Them!
39mDeep dive into PostgreSQL internal statistics
51mPostgreSQL: Practical Examples of SQL Query Optimization
25mPoint-in-time query tuning and observability with pg_stat_statements
57mQuery Logging and Workload Analysis