Pigsty Dashboards

Historical documentation restored from the Pigsty v1.5.1 tag.

Pigsty provides a professional and easy-to-use PostgreSQL monitor system that distills the industry’s monitoring best practices.

The Pigsty monitoring dashboard consists of several relatively independent boards.

Application	Description
Home	Home
`PGSQL`	PostgreSQL Database Monitor
`REDIS`	Redis Database Monitor
`NODES`	Host Node Monitor
`INFRA`	Infra monitoring/logging
APP	Extra added applications

HOME

Pigsty’s home page provides navigation to the various boards.

The PostgreSQL monitoring dashboard has its level, from the top down, as follows：

Global: Focuses on the entire environment, the big picture global metrics.
Cluster: Focuses on aggregated metrics for a single database cluster.
Instance: Focuses on singleton instance objects: database instances, nodes, LBs, and various topic boards.
Database (objects): Detailed information about activities, tables, and queries within the database.

Most of the monitoring dashboards can be jumped level through tables and tuples.

Overview	Cluster	Instance	Database
PGSQL Overview	PGSQL Cluster	PGSQL Instance	PGSQL Database
PGSQL Alert	PGSQL Service	PGSQL Node	PGSQL Tables
PGSQL Shard	PGSQL Database	PGSQL Proxy	PGSQL Table
PGSQL MatrixDB	PGSQL Replication	PGSQL Xacts	PGSQL Query
	PGSQL Activity	PGSQL Queries	PGCAT Table
	PGSQL Cluster Monly	PGSQL Session	PGCAT Query
		PGCAT Instance	PGCAT Database

REDIS monitor is divided into a global overview, singleton clusters, and singleton instances.

NODES monitor is divided into a global overview, single-node clusters, and single nodes.

INFRA Monitor is used to monitoring the infra and contains the following Dashboards.

Pigsty comes with a typical application, PGLOG, for analyzing CSV log samples from PG.

Visit https://github.com/vonng/pigsty-app for more sample applications.