PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Will Leinweber |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2013-05-24 |
| Room | MRT 221 |
| Start time | 13:30 |
| Duration | 01:00 |
| Info | |
| 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