PGCon2010 - Final Release II

PGCon 2010
The PostgreSQL Conference

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


More useful statistics information for DBAs

NTT has developed "pgstatsinfo", that collects database activities and statistics automatically, and shows the information to DBAs in user-friendly shapes. Also pgstatsinfo 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