Configuring PostgreSQL for Logging & Query Optimization Ft Ryan Booz | January 13th 2026 |
Struggling with slow queries in PostgreSQL? This session dives into practical, real-world techniques to identify, analyze, and optimize query performance.
Learn how to use powerful tools like pg_stat_statements, auto_explain, and query logging to pinpoint bottlenecks and improve efficiency. We also cover common query patterns, when to rewrite them, and hands-on optimization strategies that can significantly boost performance.
🔍 What you’ll learn:
How to identify slow queries in PostgreSQL
Using pg_stat_statements for performance insights
Leveraging auto_explain for query analysis
Effective query logging techniques
Query rewriting strategies for faster execution
Real-world performance tuning tips
💡 Whether you're a developer, data engineer, or database administrator, this session will help you write faster queries and scale your applications efficiently.
🔥 Keywords:
PostgreSQL performance tuning, slow query optimization, pg_stat_statements tutorial, auto_explain PostgreSQL, SQL query optimization, database performance, PostgreSQL tips, query tuning, database optimization
🔗 Stay Connected with Prairie Postgres:
🌐 Website: https://prairiepostgres.org/
💻 GitHub: https://github.com/prairiepostgres
💼 LinkedIn: / prairie-postgres
📅 Meetup: https://www.meetup.com/illinois-prair...
🎯 Don’t forget to:
👍 Like the video
💬 Comment your questions
🔔 Subscribe for more PostgreSQL talks, tutorials, and community events