PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Will Leinweber
Day Talks - Day 2 - 2013-05-24
Room MRT 221
Start time 13:30
Duration 01:00
ID 588
Event type Lecture
Track Performance
Language used for presentation English

Visualizing Postgres

in realtime

Postgres comes with several introspection tools out of the box. Some are easier to understand than others, but they are all useful. Recent improvements in 9.2's pgstatstatements make it even easier gain insights into the performance of your application.

This talk will explore these built in tools, and what it takes to combine them to provide real-time visualizations of your database.

Other topics will incldue - What metrics are the most valuable and how to use them - A deep dive into example application for realtime postgres visibility - Storage of postgres statistics - Tools for time series visualization - Collecting metrics at scale - What works and, just as importantly, what does not work