PostgreSQL Statistics Unleashed: Mastering Query Optimization Through Data-Driven Insights
Presented by:
Anita Singh
Anita Singh brings over two decades of experience architecting database solutions for mission-critical applications across diverse industries and technologies. For the past 5+ years at AWS, she has specialized in accelerating PostgreSQL adoption—particularly migrations from Oracle and SQL Server to PostgreSQL. She thrives in customer-focused environments, combining strong analytical capabilities with interpersonal skills to navigate complex technical challenges while inspiring teams to achieve their best.
Angel Duenas Neyra
Angel Duenas is a Technical Account Manager at AWS, specializing in PostgreSQL. As part of the Technical Field Community, he guides customers in optimizing their PostgreSQL implementations on AWS. Angel helps clients build scalable, secure, and high-performance database solutions, enabling them to innovate and achieve their business objectives efficiently.
No video of the event yet, sorry!
Understanding Database Statistics in PostgreSQL
Database statistics are the secret weapon behind PostgreSQL's query optimizer, directly impacting query performance and overall database health. This session takes you beyond the basics to explore how PostgreSQL collects, maintains, and leverages statistics to make intelligent decisions about query execution.
Whether you're managing a handful of databases or thousands of RDS PostgreSQL instances, understanding statistics is crucial for maintaining optimal performance. This deep dive will equip you with both theoretical knowledge and practical techniques for working with PostgreSQL statistics in production environments.
What You'll Learn:
Statistics Types and Their Purpose: Explore table statistics, index statistics, extended statistics, and how each type serves the query optimizer Inside the Query Optimizer: Understand how PostgreSQL uses statistics to estimate plan costs and select optimal execution paths Manual Statistics Management: Master the ANALYZE command and learn when manual intervention improves performance Monitoring and Troubleshooting: Identify and resolve statistics-related performance bottlenecks using practical diagnostic techniques Production Best Practices: Implement strategies for maintaining healthy statistics across large-scale PostgreSQL deployments Key Takeaways:
By the end of this session, you'll have a comprehensive understanding of PostgreSQL's statistics system and actionable knowledge to optimize query performance in your own environments. You'll learn to recognize when statistics need attention, how to update them effectively, and how to prevent common statistics-related performance issues before they impact your users.
Who Should Attend:
Database administrators, developers, and architects working with PostgreSQL who want to understand the foundation of query optimization and improve their database performance tuning skills.
- Date:
- Duration:
- 20 min
- Room:
- Conference:
- Postgres Conference: 2026
- Language:
- Track:
- Essentials
- Difficulty:
- Medium