Schedule - PGConf NYC 2025

Becoming a PG_STAT_*STAR [Returns]

Date: 2025-10-01
Time: 11:00–11:50
Room: Hub One
Level: Intermediate
Feedback: Leave feedback

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.

Slides

The following slides have been made available for this session:

Speaker

Chirag Dave
Sami Imseih