# Dashboard

> check visualized information
---

> Grafana Dashboards for PostgreSQL clusters: [Demo](https://g.pgsty.com/d/pgsql-overview) & [Gallery](https://github.com/pgsty/pigsty/wiki/Gallery).

[![pigsty-dashboard.jpg](/img/pigsty/dashboard.gif)](https://github.com/pgsty/pigsty/wiki/Gallery)

There are 26 default grafana dashboards about PostgreSQL and categorized into 4 levels. and categorized into [PGSQL](/docs/pgsql/dashboard/#overview), [PGCAT](/docs/pgsql/dashboard/#pgcat) & [PGLOG](/docs/pgsql/dashboard/#pglog) by datasource.

|                        Overview                        |                           Cluster                            |                         Instance                         |                        Database                        |
|:------------------------------------------------------:|:------------------------------------------------------------:|:--------------------------------------------------------:|:------------------------------------------------------:|
| [PGSQL Overview](https://g.pgsty.com/d/pgsql-overview) |     [PGSQL Cluster](https://g.pgsty.com/d/pgsql-cluster)     |  [PGSQL Instance](https://g.pgsty.com/d/pgsql-instance)  | [PGSQL Database](https://g.pgsty.com/d/pgsql-database) |
|    [PGSQL Alert](https://g.pgsty.com/d/pgsql-alert)    |     [PGRDS Cluster](https://g.pgsty.com/d/pgrds-cluster)     |  [PGRDS Instance](https://g.pgsty.com/d/pgrds-instance)  | [PGCAT Database](https://g.pgsty.com/d/pgcat-database) |
|    [PGSQL Shard](https://g.pgsty.com/d/pgsql-shard)    |    [PGSQL Activity](https://g.pgsty.com/d/pgsql-activity)    |  [PGCAT Instance](https://g.pgsty.com/d/pgcat-instance)  |   [PGSQL Tables](https://g.pgsty.com/d/pgsql-tables)   |
|                                                        | [PGSQL Replication](https://g.pgsty.com/d/pgsql-replication) |   [PGSQL Persist](https://g.pgsty.com/d/pgsql-persist)   |    [PGSQL Table](https://g.pgsty.com/d/pgsql-table)    |
|                                                        |     [PGSQL Service](https://g.pgsty.com/d/pgsql-service)     |     [PGSQL Proxy](https://g.pgsty.com/d/pgsql-proxy)     |    [PGCAT Table](https://g.pgsty.com/d/pgcat-table)    |
|                                                        |   [PGSQL Databases](https://g.pgsty.com/d/pgsql-databases)   | [PGSQL Pgbouncer](https://g.pgsty.com/d/pgsql-pgbouncer) |    [PGSQL Query](https://g.pgsty.com/d/pgsql-query)    |
|                                                        |     [PGSQL Patroni](https://g.pgsty.com/d/pgsql-patroni)     |   [PGSQL Session](https://g.pgsty.com/d/pgsql-session)   |    [PGCAT Query](https://g.pgsty.com/d/pgcat-query)    |
|                                                        |        [PGSQL PITR](https://g.pgsty.com/d/pgsql-pitr)        |     [PGSQL Xacts](https://g.pgsty.com/d/pgsql-xacts)     |    [PGCAT Locks](https://g.pgsty.com/d/pgcat-locks)    |
|                                                        |                                                              |  [PGSQL Exporter](https://g.pgsty.com/d/pgsql-exporter)  |   [PGCAT Schema](https://g.pgsty.com/d/pgcat-schema)   |

**Overview**

- [pgsql-overview](https://g.pgsty.com/d/pgsql-overview) : The main dashboard for PGSQL module
- [pgsql-alert](https://g.pgsty.com/d/pgsql-alert) : Global PGSQL key metrics and alerting events
- [pgsql-shard](https://g.pgsty.com/d/pgsql-shard) : Overview of a horizontal sharded PGSQL cluster, e.g. citus / gpsql cluster

**Cluster**

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

**Instance**

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

**Database**

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

------

## Overview

[PGSQL Overview](https://g.pgsty.com/d/pgsql-overview) : The main dashboard for PGSQL module



[PGSQL Alert](https://g.pgsty.com/d/pgsql-alert) : Global PGSQL key metrics and alerting events



[PGSQL Shard](https://g.pgsty.com/d/pgsql-shard) : Overview of a horizontal sharded PGSQL cluster, e.g. CITUS / GPSQL cluster



------

## Cluster

[PGSQL Cluster](https://g.pgsty.com/d/pgsql-cluster): The main dashboard for a PGSQL cluster



[PGRDS Cluster](https://g.pgsty.com/d/pgrds-cluster): The PGSQL Cluster dashboard for RDS, focus on all postgres metrics only.



[PGSQL Service](https://g.pgsty.com/d/pgsql-service): Cares about PGSQL cluster services, proxies, routes, and load balancers.



[PGSQL Activity](https://g.pgsty.com/d/pgsql-activity): Cares about the Session/Load/QPS/TPS/Locks of a PGSQL cluster



[PGSQL Replication](https://g.pgsty.com/d/pgsql-replication): Cares about PGSQL cluster replication, slots, and pub/sub.



[PGSQL Databases](https://g.pgsty.com/d/pgsql-databases): Cares about database CRUD, slow queries, and table statistics cross all instances.



[PGSQL Patroni](https://g.pgsty.com/d/pgsql-patroni): Cares about cluster HA agent: patroni status.



[PGSQL PITR](https://g.pgsty.com/d/pgsql-pitr): Cares about context of cluster status during PITR procedure



------

## Instance

[PGSQL Instance](https://g.pgsty.com/d/pgsql-instance): The main dashboard for a single PGSQL instance



[PGRDS Instance](https://g.pgsty.com/d/pgrds-instance): The PGSQL Instance dashboard for RDS, focus on all postgres metrics only.



[PGSQL Proxy](https://g.pgsty.com/d/pgsql-proxy): Metrics about haproxy the service provider



[PGSQL Pgbouncer](https://g.pgsty.com/d/pgsql-pgbouncer): Metrics about one single pgbouncer connection pool instance



[PGSQL Persist](https://g.pgsty.com/d/pgsql-persist): Metrics about persistence: WAL, XID, Checkpoint, Archive, IO



[PGSQL Xacts](https://g.pgsty.com/d/pgsql-xacts): Metrics about transactions, locks, queries, etc…



[PGSQL Session](https://g.pgsty.com/d/pgsql-session): Metrics about sessions and active/idle time in a single instance



[PGSQL Exporter](https://g.pgsty.com/d/pgsql-exporter): Postgres & Pgbouncer exporter self monitoring metrics



------

## Database

[PGSQL Database](https://g.pgsty.com/d/pgsql-database): The main dashboard for a single PGSQL database



[PGSQL Tables](https://g.pgsty.com/d/pgsql-tables) : Table/Index access metrics inside a single database



[PGSQL Table](https://g.pgsty.com/d/pgsql-table): Detailed information (QPS/RT/Index/Seq…) about a single table



[PGSQL Query](https://g.pgsty.com/d/pgsql-query): Detailed information (QPS/RT) about a single query



------

## PGCAT

[PGCAT Instance](https://g.pgsty.com/d/pgcat-instance): Instance information from database catalog directly



[PGCAT Database](https://g.pgsty.com/d/pgcat-database): Database information from database catalog directly



[PGCAT Schema](https://g.pgsty.com/d/pgcat-schema): Detailed information about one single schema from database catalog directly



[PGCAT Table](https://g.pgsty.com/d/pgcat-table): Detailed information about one single table from database catalog directly



[PGCAT Query](https://g.pgsty.com/d/pgcat-query): Detailed information about one single type of query from database catalog directly



[PGCAT Locks](https://g.pgsty.com/d/pgcat-locks): Detailed information about live locks & activity from database catalog directly



------

## PGLOG

[PGLOG Overview](https://g.pgsty.com/d/pglog-overview): Overview of csv log sample in pigsty meta database



[PGLOG Overview](https://g.pgsty.com/d/pglog-overview): Detail of one single session of csv log sample in pigsty meta database
