How to monitor query plans using pgwatch and pg_stat_plans. See step by step walkthrough showing how easy it is to integrate such extensions.

CYBERTEC PostgreSQL

pg_stat_plans is a new PostgreSQL extension that tracks aggregated statistics for query plans rather than SQL statements. This walkthrough demonstrates integrating pg_stat_plans with pgwatch monitoring tool to track query plans for resource-intensive queries. The tutorial covers writing custom SQL queries to join pg_stat_statements with pg_stat_plans, configuring pgwatch with YAML files to define custom metrics, storing results in a PostgreSQL sink database, and creating Grafana dashboards to visualize different execution plans chosen by the planner for the same query over time.

Monitoring query plans with pgwatch and pg_stat_plans