Presented by:

Chirag Dave is a Principal Database Specialist Solutions Architect with Amazon Web Services. he maintains technical relationship with customers, making recommendations on security, cost, performance, reliability, operational efficiency and best-practice architectures.

9b26fc26f335eeb42af4aad3d25e6498

Sami Imseih

Amazon Web Services
No video of the event yet, sorry!

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.

Date:
2024 April 18 12:10 PDT
Duration:
50 min
Room:
San Pedro
Conference:
Postgres Conference 2024
Language:
English
Track:
Ops
Difficulty:
Intermediate