Dashboard

Pigsty provides numerous out-of-the-box Grafana monitoring dashboards for PostgreSQL: Demo & Gallery.

The current source provides 31 PostgreSQL-related dashboards: 29 PostgreSQL / PGCAT dashboards under files/grafana/pgsql, plus two PGLOG dashboards under files/grafana/app. They are organized by hierarchy into Overview, Cluster, Instance, and Database categories, and by data source into PGSQL, PGCAT, and PGLOG.

Overview

Overview

• pgsql-overview: Main dashboard for the PGSQL module
• pgsql-alert: Global key metrics and alert events for PGSQL
• pgsql-shard: Overview of horizontally sharded PGSQL clusters (e.g., Citus/GPSQL)

Cluster

• pgsql-cluster: Main dashboard for a PGSQL cluster
• pgrds-cluster: RDS version of PGSQL Cluster, focusing on PostgreSQL-native metrics
• pgsql-activity: Session/load/QPS/TPS/locks for PGSQL cluster
• pgsql-replication: Replication, slots, and pub/sub for PGSQL cluster
• pgsql-service: Service, proxy, routing, and load balancing for PGSQL cluster
• pgsql-databases: Database CRUD, slow queries, and table statistics across all instances
• pgsql-patroni: HA status and Patroni component status for cluster
• pgsql-pitr: PITR context for point-in-time recovery assistance

Instance

• pgsql-instance: Main dashboard for a single PGSQL instance
• pgrds-instance: RDS version of PGSQL Instance, focusing on PostgreSQL-native metrics
• pgcat-instance: Instance info retrieved directly from database catalog
• pgsql-proxy: Detailed metrics for a single HAProxy load balancer
• pgsql-pgbouncer: Metrics overview for a single Pgbouncer connection pooler
• pgsql-persist: Persistence metrics: WAL, XID, checkpoint, archive, IO
• pgsql-session: Session and active/idle time metrics for a single instance
• pgsql-xacts: Transaction, lock, TPS/QPS related metrics
• pgsql-exporter: Self-monitoring metrics for Postgres and Pgbouncer exporters

Database

• pgsql-database: Main dashboard for a single PGSQL database
• pgcat-database: Database info retrieved directly from database catalog
• pgsql-tables: Table/index access metrics within a single database
• pgsql-table: Detailed info for a single table (QPS/RT/index/sequence…)
• pgcat-table: Detailed table info from database catalog (stats/bloat…)
• pgsql-query: Detailed info for a query type (QPS/RT)
• pgcat-query: Query details from database catalog (SQL/stats)
• pgcat-schema: Schema info from database catalog (tables/indexes/sequences…)
• pgcat-locks: Activity and lock wait info from database catalog

Overview

PGSQL Overview: Main dashboard for the PGSQL module

PGSQL Alert: Global core metrics overview and alert events

PGSQL Shard: Cross-shard metric comparison for horizontally sharded PGSQL clusters (e.g., CITUS/GPSQL)

Cluster

PGSQL Cluster: Main dashboard for a PGSQL cluster

PGRDS Cluster: RDS version of PGSQL Cluster, focusing on PostgreSQL-native metrics

PGSQL Service: Service, proxy, routing, and load balancing for PGSQL cluster

PGSQL Activity: Session/load/QPS/TPS/locks for PGSQL cluster

PGSQL Replication: Replication, slots, and pub/sub for PGSQL cluster

PGSQL Databases: Database CRUD, slow queries, and table statistics across all instances

PGSQL Patroni: HA status and Patroni component status for cluster

PGSQL PITR: PITR context for point-in-time recovery assistance

Instance

PGSQL Instance: Main dashboard for a single PGSQL instance

PGRDS Instance: RDS version of PGSQL Instance, focusing on PostgreSQL-native metrics

PGSQL Proxy: Detailed metrics for a single HAProxy load balancer

PGSQL Pgbouncer: Metrics overview for a single Pgbouncer connection pooler

PGSQL Persist: Persistence metrics: WAL, XID, checkpoint, archive, IO

PGSQL Xacts: Transaction, lock, TPS/QPS related metrics

PGSQL Session: Session and active/idle time metrics for a single instance

PGSQL Exporter: Self-monitoring metrics for Postgres/Pgbouncer exporters

Database

PGSQL Database: Main dashboard for a single PGSQL database

PGSQL Tables: Table/index access metrics within a single database

PGSQL Table: Detailed info for a single table (QPS/RT/index/sequence…)

PGSQL Query: Detailed info for a query type (QPS/RT)

PGCAT

PGCAT Instance: Instance info retrieved directly from database catalog

PGCAT Database: Database info retrieved directly from database catalog

PGCAT Schema: Schema info from database catalog (tables/indexes/sequences…)

PGCAT Table: Detailed table info from database catalog (stats/bloat…)

PGCAT Query: Query details from database catalog (SQL/stats)

PGCAT Locks: Activity and lock wait info from database catalog

PGLOG

PGLOG Overview: Overview of CSV log samples in Pigsty CMDB

PGLOG Session: Log details for a single session in CSV log samples

Gallery

See pigsty/wiki/gallery for details.