PgBouncer Connection Pool
Client Connections
0
0% of 10,000
Server Connections
0
0% of 600
Active Transactions
0
Currently processing
Waiting Clients
0
In queue
Backend Distribution
hel1dc6p
0 (0%)
localhost
0 (0%)
Active Pools
| Database | User | Cl Active | Cl Wait | Sv Active | Sv Idle |
|---|---|---|---|---|---|
| Loading... | |||||
Query Performance (Avg ms)
PgBouncer Memory Cache
Client Cache
0%
Server Cache
0%
Pool Cache
0%
Primary Master - hel1dc6 (100.70.149.7:5432)
Master Connections
-
of max
Active Queries
-
Currently executing
Streaming Replicas
-
Connected
Blocking Locks
0
Blocker chains
Database Breakdown
| Database | Size | Commits | Rollbacks | Cache Hit % | Temp Files | Deadlocks |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Replication to Replicas
| Replica | Application | State | Replay Lag |
|---|---|---|---|
| Loading... | |||
Replication Slots
Loading...
WAL Statistics
Current LSN
-
WAL Records
-
WAL Written
-
Buffers Full
-
Checkpoint Statistics
Timed
-
Requested
-
Write Time
-
Sync Time
-
pg_stat_statements - Query Performance
| # | Mean (ms) | Calls | Total (ms) | Rows | Query |
|---|---|---|---|---|---|
| Loading... | |||||
| # | Total (ms) | Mean (ms) | Calls | Rows | Query |
|---|---|---|---|---|---|
| Loading... | |||||
| # | Calls | Mean (ms) | Total (ms) | Rows | Query |
|---|---|---|---|---|---|
| Loading... | |||||
Active Queries
| PID | User | DB | Duration | Wait | Query |
|---|---|---|---|---|---|
| No active queries | |||||
Blocking Lock Chains
No blocking queries
Long-Running Transactions (> 60s)
No long-running transactions
Autovacuum Workers (16 max configured)
No active autovacuum operations
PIMEDONE - Top Tables by Size
| Table | Size | Live | Dead | Dead % |
|---|---|---|---|---|
| Loading... | ||||
PIMEDONE - Top Tables by Dead Tuples
| Table | Dead Tuples | Dead % | Last Autovacuum |
|---|---|---|---|
| Loading... | |||
Master Configuration
Loading...
PostgreSQL Backends
Total Database Size
-
hel1dc6p + localhost
Transaction Commit Rate
-
commits / total
Connection Usage
-
of max_connections
Cache Hit Ratio
-
Buffer cache effectiveness
Connection States
Wait Events
Lock Statistics
Total Locks
0
Granted
0
Waiting
0
Lock Modes
-
WAL & Checkpoints
Current LSN
-
Checkpoints (Timed)
0
Checkpoints (Req)
0
Buffers Written
0
Replication Status
hel1dc6p (Primary/Replica)
Loading...
localhost (Replica)
Loading...
Top Tables by Size
| Table | Size | Dead % | Seq/Idx |
|---|---|---|---|
| Loading... | |||
Unused Indexes
| Index | Size |
|---|---|
| Loading... | |
Active Vacuum Operations
No active vacuum operations
PostgreSQL Configuration
max_connections
-
shared_buffers
effective_cache_size
-
work_mem
-
maintenance_work_mem
-
Backend Details
hel1dc6p (100.71.1.25:5433)
Loading...
Status
Loading...
localhost (127.0.0.1:5432)
Loading...
Status
Loading...