Schedule - PGDay Chicago 2024

Becoming a PG_STAT_* (star)

Date: 2024-04-26
Time: 15:30–16:15
Room: Hub1
Level: Intermediate

Want to become a PostgreSQL performance monitoring star?

Come and explore the world of the PostgreSQL Cumulative Statistics System, a.k.a. the pg_stat views, and see how this system can give you insights on critical workload activity such as visibility into I/O activity and much more that can help in real-time troubleshooting as well as proactive monitoring.

In this talk, we will explore why this system exists, the wealth of feature it offers, effective usage and highlight recent development, such as “pg_stat_io” which was added in PostgreSQL 16. We will also walk through real world examples of using this system and provide helpful scripts.


Chirag Dave
Sami Imseih