PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Kyotaro Horiguchi |
| Schedule | |
|---|---|
| Day | Talks - Day 3 - Thursday - 2015-06-18 |
| Room | DMS 1140 |
| Start time | 15:00 |
| Duration | 00:45 |
| Info | |
| ID | 826 |
| Event type | Lecture |
| Track | DBA |
| Language used for presentation | English |
Monitor more of PostgreSQL
pg_statsinfo comes with new features
There are many information vanishes as the server operates. pgstatsinfo/pgstatsreporter is a monitoring tool which records such various status and statistics of PostgreSQL server and lets you see them in graphical and interactive way. It is very usable not only for DBAs to check the health of the server daily, but for technical support to find out what happened in the past on the remote site. It is widely adopted among our systems using PostgreSQL and the new pgstatsinfo 3.1 has new features to support them more.
The new pg_statsinfo 3.1 has the following new features in comparison to 2.5. This talk will introduce these features with demo and dig inside some of them.
Collecting plan statistics. Plan statistics is based on an original pgstatstatements-like extension named pgstoreplans, which is a similar tool to 2ndQuadrant's pgstatplans but it still differs in some points to fit to pg_stastinfo.
Statistics of autovacuum/analyze including cancellation stats. Cancellation stats would be in some situations.
Storing server logs into the repositiry database. Stored logs are examined using filtering feature of pgstatsreporter.
Storing alerts previously only emitted into server log. Alerts gets more valuable with pgstatsreporter.