Becoming a PG_STAT_* (star)
Presented by:
Chirag Dave
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.
Sami Imseih
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