Use this dashboard to monitor your PlanetScale Postgres branches across connections and session states, commit throughput, PgBouncer connection pools, locks, write-ahead log archiving, storage, and pod resources.
Dashboard JSON
Recommended. Uses the V2 dashboard schema and needs SigNoz v0.135.0 or newer.
Import it in SigNoz with Dashboards → + New dashboard → Import JSON. Import guide
What This Dashboard Monitors
- Overview: Open connections, connection utilization, commit throughput, WAL archive lag, storage used, and CPU utilization at a glance
- Connections & Sessions: Connections by state and role, open connections against
max_connections, commit rate by database, and per-pod connection utilization - PgBouncer Connection Pool: Client and server pool states, PgBouncer to Postgres connections, max client wait, CPU per peer, and peers against the client connection limit
- Locks: Lock counts by mode
- Write-Ahead Log (WAL): Pending archive size, archiver lag and outcomes, and age of the last successful archive
- Storage: Volume used percentage and available capacity against total
- Pod Resources: Per-pod CPU, memory, disk IOPS, and pod status phases
Metrics Included
Overview
- Open Connections: Current open Postgres connections
- Connection Utilization: Open connections as a percentage of
max_connections - Commit Throughput: Transaction commit rate
- WAL Archive Lag: Pending WAL bytes waiting to archive
- Storage Used: Volume used percentage
- CPU Utilization: Database pod CPU utilization
Connections & Sessions
- Connections by State: Postgres connections split by session state
- Open Connections vs max_connections: Open connections against the configured limit
- Connections by Role: Connections grouped by database role
- Commit Rate by Database: Transaction commit rate per database
- Connection Utilization % by Pod: Per-pod connection utilization percentage
PgBouncer Connection Pool
- PgBouncer Client Connections: Client connections into PgBouncer
- PgBouncer → Postgres Connections: Server connections from PgBouncer to Postgres
- Client Pool by State: PgBouncer client pool connections by state
- Server Pool by State: PgBouncer server pool connections by state
- Max Client Wait: Longest client wait time for a server connection
- PgBouncer CPU per Peer: PgBouncer CPU usage per peer process
- PgBouncer Peers vs Max Client Conn: Peer processes against the max client connection limit
Locks
- Locks by Mode: Active locks grouped by lock mode
Write-Ahead Log (WAL)
- WAL Pending Archive Size: Bytes pending WAL archive
- WAL Archiver Lag: Time lag of the WAL archiver
- WAL Archiver Outcomes: WAL archive success and failure counts
- Last Successful Archive Age: Time since the last successful WAL archive
- Connection Utilization % over time: Connection utilization trend over the selected range
Storage
- Volume Used %: Volume used as a percentage of capacity
- Volume Available vs Capacity: Available volume bytes against total capacity
Pod Resources
- CPU Utilization by Pod: Per-pod CPU utilization
- Memory Utilization by Pod: Per-pod memory utilization
- Memory RSS by Pod: Per-pod resident set size
- Disk IOPS by Pod: Per-pod disk I/O operations per second
- Pods by Status Phase: Pod count grouped by status phase
Dashboard Variables
- branch: Filter by PlanetScale database branch
- role: Filter by Postgres database role
