PGCon2010 - Final Release

PGCon 2010
The PostgreSQL Conference

Speakers
Tatsuhito Kasahara
Schedule
Day Talks - 1 - 2010-05-20
Room DMS 1140
Start time 13:30
Duration 01:00
Info
ID 216
Event type Lecture
Track DBA
Language used for presentation English
Feedback

pg_statsinfo

More useful statistics information for DBAs

NTT has developed "pg_statsinfo", that collects database activities and statistics automatically, and shows the information to DBAs in user-friendly shapes. Also pg_statsinfo can collect statistics from multiple DBs, so this tool makes it much easier to monitor the status of many DB servers

PostgreSQL provides many useful statistics about DB activities and conditions via system views and contrib modules. But for many DBAs, it is difficult to see whether a DB has problems or not from original statistics information.

This presentation will cover the following topics.

  • How pg_statsinfo collects statistics from PostgreSQL
  • Architecture of the reporting tool
  • Requirements for PostgreSQL core to collect more useful information