Dashboard

Grafana Dashboards for PostgreSQL clusters: Demo & Gallery.

There are 26 default grafana dashboards about PostgreSQL and categorized into 4 levels. and categorized into PGSQL, PGCAT & PGLOG by datasource.

Overview	Cluster	Instance	Database
PGSQL Overview	PGSQL Cluster	PGSQL Instance	PGSQL Database
PGSQL Alert	PGRDS Cluster	PGRDS Instance	PGCAT Database
PGSQL Shard	PGSQL Activity	PGCAT Instance	PGSQL Tables
	PGSQL Replication	PGSQL Persist	PGSQL Table
	PGSQL Service	PGSQL Proxy	PGCAT Table
	PGSQL Databases	PGSQL Pgbouncer	PGSQL Query
	PGSQL Patroni	PGSQL Session	PGCAT Query
	PGSQL PITR	PGSQL Xacts	PGCAT Locks
		PGSQL Exporter	PGCAT Schema

Overview

pgsql-overview : The main dashboard for PGSQL module
pgsql-alert : Global PGSQL key metrics and alerting events
pgsql-shard : Overview of a horizontal sharded PGSQL cluster, e.g. citus / gpsql cluster

Cluster

pgsql-cluster: The main dashboard for a PGSQL cluster
pgrds-cluster: The PGSQL Cluster dashboard for RDS, focus on all postgres metrics only.
pgsql-activity: Cares about the Session/Load/QPS/TPS/Locks of a PGSQL cluster
pgsql-replication: Cares about PGSQL cluster replication, slots, and pub/sub.
pgsql-service: Cares about PGSQL cluster services, proxies, routes, and load balancers.
pgsql-databases: Cares about database CRUD, slow queries, and table statistics cross all instances.
pgsql-patroni: Cares about cluster HA agent: patroni status.
pgsql-pitr: Cares about context of cluster status during PITR procedure

Instance

pgsql-instance: The main dashboard for a single PGSQL instance
pgrds-instance: The PGSQL Instance dashboard for RDS, focus on all postgres metrics only.
pgcat-instance: Instance information from database catalog directly
pgsql-persist: Metrics about persistence: WAL, XID, Checkpoint, Archive, IO
pgsql-proxy: Metrics about haproxy the service provider
pgsql-queries: Overview of all queries in a single instance
pgsql-session: Metrics about sessions and active/idle time in a single instance
pgsql-xacts: Metrics about transactions, locks, queries, etc…
pgsql-exporter: Postgres & Pgbouncer exporter self monitoring metrics

Database

pgsql-database: The main dashboard for a single PGSQL database
pgcat-database: Database information from database catalog directly
pgsql-tables : Table/Index access metrics inside a single database
pgsql-table: Detailed information (QPS/RT/Index/Seq…) about a single table
pgcat-table: Detailed information (Stats/Bloat/…) about a single table from database catalog directly
pgsql-query: Detailed information (QPS/RT) about a single query
pgcat-query: Detailed information (SQL/Stats) about a single query from database catalog directly

Overview

PGSQL Overview : The main dashboard for PGSQL module

PGSQL Alert : Global PGSQL key metrics and alerting events

PGSQL Shard : Overview of a horizontal sharded PGSQL cluster, e.g. CITUS / GPSQL cluster

Cluster

PGSQL Cluster: The main dashboard for a PGSQL cluster

PGRDS Cluster: The PGSQL Cluster dashboard for RDS, focus on all postgres metrics only.

PGSQL Service: Cares about PGSQL cluster services, proxies, routes, and load balancers.

PGSQL Activity: Cares about the Session/Load/QPS/TPS/Locks of a PGSQL cluster

PGSQL Replication: Cares about PGSQL cluster replication, slots, and pub/sub.

PGSQL Databases: Cares about database CRUD, slow queries, and table statistics cross all instances.

PGSQL Patroni: Cares about cluster HA agent: patroni status.

PGSQL PITR: Cares about context of cluster status during PITR procedure

Instance

PGSQL Instance: The main dashboard for a single PGSQL instance

PGRDS Instance: The PGSQL Instance dashboard for RDS, focus on all postgres metrics only.

PGSQL Proxy: Metrics about haproxy the service provider

PGSQL Pgbouncer: Metrics about one single pgbouncer connection pool instance

PGSQL Persist: Metrics about persistence: WAL, XID, Checkpoint, Archive, IO

PGSQL Xacts: Metrics about transactions, locks, queries, etc…

PGSQL Session: Metrics about sessions and active/idle time in a single instance

PGSQL Exporter: Postgres & Pgbouncer exporter self monitoring metrics

Database

PGSQL Database: The main dashboard for a single PGSQL database

PGSQL Tables : Table/Index access metrics inside a single database

PGSQL Table: Detailed information (QPS/RT/Index/Seq…) about a single table

PGSQL Query: Detailed information (QPS/RT) about a single query

PGCAT

PGCAT Instance: Instance information from database catalog directly

PGCAT Database: Database information from database catalog directly

PGCAT Schema: Detailed information about one single schema from database catalog directly

PGCAT Table: Detailed information about one single table from database catalog directly

PGCAT Query: Detailed information about one single type of query from database catalog directly

PGCAT Locks: Detailed information about live locks & activity from database catalog directly

PGLOG

PGLOG Overview: Overview of csv log sample in pigsty meta database

PGLOG Overview: Detail of one single session of csv log sample in pigsty meta database