Level: Intermediate
This comprehensive guide explores PostgreSQL's built-in statistics collection system, focusing on the powerful pg_stat views. Learn how to leverage these views to gain deep insights into database performance, including I/O patterns, query execution statistics, and resource utilization.
This talk will also cover PostgreSQL 18's upcoming features and recent enhancements to the statistics system, providing database administrators and developers with essential tools for maintaining optimal database performance. We will cover about enhancements to pg_stat_statements, pg_stat_checkpointer, etc.