Monitoring Dashboards

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

There are 26 PostgreSQL-related monitoring dashboards in Pigsty, organized hierarchically into Overview, Cluster, Instance, and Database categories, and by data source into PGSQL, PGCAT, and PGLOG categories.

Overview

Overview

• pgsql-overview: Main dashboard for the PGSQL module
• pgsql-alert: Global critical metrics and alert events for PGSQL
• pgsql-shard: Overview of horizontally sharded PGSQL clusters, such as Citus / GPSQL clusters

Cluster

• pgsql-cluster: Main dashboard for a PGSQL cluster
• pgrds-cluster: RDS version of PGSQL Cluster, focused on all PostgreSQL-specific metrics
• pgsql-activity: Focus on PGSQL cluster sessions/load/QPS/TPS/locks
• pgsql-replication: Focus on PGSQL cluster replication, slots, and pub/sub
• pgsql-service: Focus on PGSQL cluster services, proxies, routing, and load balancing
• pgsql-databases: Focus on database CRUD, slow queries, and table statistics across all instances
• pgsql-patroni: Focus on cluster high availability status and Patroni component status
• pgsql-pitr: Focus on cluster PITR process context for point-in-time recovery assistance

Instance

• pgsql-instance: Main dashboard for a single PGSQL instance
• pgrds-instance: RDS version of PGSQL Instance, focused on all PostgreSQL-specific metrics
• pgcat-instance: Instance information retrieved directly from the database catalog
• pgsql-proxy: Detailed metrics for a single HAProxy load balancer
• pgsql-pgbouncer: Metrics overview in a single Pgbouncer connection pool instance
• pgsql-persist: Persistence metrics: WAL, XID, checkpoints, archiving, IO
• pgsql-session: Session and active/idle time metrics in a single instance
• pgsql-xacts: Metrics related to transactions, locks, TPS/QPS
• pgsql-exporter: Self-monitoring metrics for Postgres and Pgbouncer monitoring components

Database

• pgsql-database: Main dashboard for a single PGSQL database
• pgcat-database: Database information retrieved directly from the database catalog
• pgsql-tables: Table/index access metrics within a single database
• pgsql-table: Details of a single table (QPS/RT/index/sequences…)
• pgcat-table: Details of a single table retrieved directly from the database catalog (stats/bloat…)
• pgsql-query: Details of a single query (QPS/RT)
• pgcat-query: Details of a single query retrieved directly from the database catalog (SQL/stats)
• pgcat-schema: Information about schemas retrieved directly from the database catalog (tables/indexes/sequences…)
• pgcat-locks: Information about activities and lock waits retrieved directly from the database catalog

Overview

PGSQL Overview: Main dashboard for the PGSQL module

PGSQL Alert: Global critical metrics overview and alert event listing for PGSQL

PGSQL Shard: Shows horizontal metric comparisons within a PGSQL horizontally sharded cluster, such as CITUS / GPSQL clusters

Cluster

PGSQL Cluster: Main dashboard for a PGSQL cluster

PGRDS Cluster: RDS version of PGSQL Cluster, focused on all PostgreSQL-specific metrics

PGSQL Service: Focus on PGSQL cluster services, proxies, routing, and load balancing

PGSQL Activity: Focus on PGSQL cluster sessions/load/QPS/TPS/locks

PGSQL Replication: Focus on PGSQL cluster replication, slots, and pub/sub

PGSQL Databases: Focus on database CRUD, slow queries, and table statistics across all instances

PGSQL Patroni: Focus on cluster high availability status and Patroni component status

PGSQL PITR: Focus on cluster PITR process context for point-in-time recovery assistance

Instance

PGSQL Instance: Main dashboard for a single PGSQL instance

PGRDS Instance: RDS version of PGSQL Instance, focused on all PostgreSQL-specific metrics

PGSQL Proxy: Detailed metrics for a single HAProxy load balancer

PGSQL Pgbouncer: Metrics overview in a single Pgbouncer connection pool instance

PGSQL Persist: Persistence metrics: WAL, XID, checkpoints, archiving, IO

PGSQL Xacts: Metrics related to transactions, locks, TPS/QPS

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

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

Database

PGSQL Database: Main dashboard for a single PGSQL database

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

PGSQL Table: Details of a single table (QPS/RT/index/sequences…)

PGSQL Query: Details of a single query (QPS/RT)

PGCAT

PGCAT Instance: Instance information retrieved directly from the database catalog

PGCAT Database: Database information retrieved directly from the database catalog

PGCAT Schema: Information about schemas retrieved directly from the database catalog (tables/indexes/sequences…)

PGCAT Table: Details of a single table retrieved directly from the database catalog (stats/bloat…)

PGCAT Query: Details of a single query retrieved directly from the database catalog (SQL/stats)

PGCAT Locks: Information about activities and lock waits retrieved directly from the database catalog

PGLOG

PGLOG Overview: Overview of CSV log samples in Pigsty CMDB

PGLOG Session: Log details of a session in CSV log samples in Pigsty CMDB

Gallery

For details, refer to pigsty/wiki/gallery.