Every connection to PostgreSQL consumes resources: memory for session state,
CPU for query processing, and slots against max_connections.
PG Pilot tracks all active connections to help you:
- Identify connection pool issues
- Detect blocking queries
- Find abandoned connections
- Analyze connection patterns by application
What it monitors
- Active, idle, and waiting connections
- Connection blocking and lock waits
- Long-running queries (>5 minutes)
- Idle transactions (transaction started but not executing)
- Connection pool utilization percentage
- Connections grouped by application, user, or database
How to use
Navigate to the Connections section from the main navigation.
Overview
See connection counts by state:
- Active: Currently executing queries
- Idle: Connected but not doing anything
- Idle in transaction: Has an open transaction but not executing
Blocking Detection
Queries that are blocked show:
- The blocking query
- Wait duration
- Lock type being waited on
Filtering
Filter connections by:
- Application name
- Username
- Database
- Client IP address
- Connection state
Grouping
Aggregate connections by:
- Application name (identify heavy clients)
- Database (multi-tenant analysis)
- User (permission auditing)