Dashboards

Module:

• PGSQL

Categories:

• 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 Overview

PGSQL Alert : Global PGSQL key metrics and alerting events

PGSQL Alert

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

PGSQL Shard

---

Cluster

PGSQL Cluster: The main dashboard for a PGSQL cluster

PGSQL Cluster

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

PGRDS Cluster

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

PGSQL Service

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

PGSQL Activity

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

PGSQL Replication

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

PGSQL Databases

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

PGSQL Patroni

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

PGSQL PITR

---

Instance

PGSQL Instance: The main dashboard for a single PGSQL instance

PGSQL Instance

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

PGRDS Instance

PGSQL Proxy: Metrics about haproxy the service provider

PGSQL Proxy

PGSQL Pgbouncer: Metrics about one single pgbouncer connection pool instance

PGSQL Pgbouncer

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

PGSQL Persist

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

PGSQL Xacts

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

PGSQL Session

PGSQL Exporter: Postgres & Pgbouncer exporter self monitoring metrics

PGSQL Exporter

---

Database

PGSQL Database: The main dashboard for a single PGSQL database

PGSQL Database

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

PGSQL Tables

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

PGSQL Table

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

PGSQL Query

---

PGCAT

PGCAT Instance: Instance information from database catalog directly

PGCAT Instance

PGCAT Database: Database information from database catalog directly

PGCAT Database

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

PGCAT Schema

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

PGCAT Table

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

PGCAT Query

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

PGCAT Locks

---

PGLOG

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

PGLOG Overview

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

PGLOG Session

---

Gallery

PGSQL Shard

PGSQL Cluster

PGSQL Service

PGSQL Activity

PGSQL Replication

PGSQL Databases

PGSQL Instance

PGSQL Proxy

PGSQL Pgbouncer

PGSQL Session

PGSQL Xacts

PGSQL Persist

PGSQL Database

PGSQL Tables

PGSQL Table

PGSQL Query

PGCAT Instance

PGCAT Database

PGCAT Schema

PGCAT Table

PGCAT Lock

PGCAT Query

PGLOG Overview

PGLOG Session