A Map for Monitoring PostgreSQL | PgDay San Francisco 2020 | Lukas Fittl

024d6a0dd14fb31c804969a57a06dfbe?s=47 Citus Data
January 21, 2020

A Map for Monitoring PostgreSQL | PgDay San Francisco 2020 | Lukas Fittl

Understanding how your Postgres database works can be difficult. In this talk we’ll take a look at what can be measured to gain better insights into performance, reliability, and other essential functions of the database.

We’ll take a look at some of the advancements in Postgres monitoring over the years, such as being able to see the 95th percentile of the performance of particular queries, watching details of index creation, or tracking details of auto vacuum performance.

Lastly, we’ll also talk about what can not be measured using the standard Postgres statistics system, and how you may still get important details in such cases.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

January 21, 2020
Tweet