No long running queries
High number of connections 734
Vacuuming healthy
No columns near integer overflow
No invalid indexes or constraints
No duplicate indexes
1 suggested index
No slow queries
High Number of Connections
734 connections
Use connection pooling for better performance. PgBouncer is a solid option.
| Top Sources |
Connections |
| cims2 - accf_tata31mar21 - 192.168.93.225 |
100 |
| cims3 - accf_tata31mar21 - 192.168.93.246 |
100 |
| erps2 - accf_tata31mar21 - 192.168.93.223 |
100 |
| erps3 - accf_tata31mar21 - 192.168.93.243 |
100 |
| cims1 - accf_tata31mar21 - 192.168.93.224 |
97 |
| erps1 - accf_tata31mar21 - 192.168.93.222 |
94 |
| cims_rep2 - accf_tata31mar21 - 192.168.93.229 |
50 |
| erps_rep1 - accf_tata31mar21 - 192.168.93.228 |
50 |
| rails_runner parasapp - accf_tata31mar21 - 117.203.168.41 |
8 |
| rails_runner parasapp - accf_tata31mar21 - 125.21.182.147 |
8 |
Suggested Indexes
Add indexes to speed up queries.
rails generate migration add_suggested_indexes
And paste
commit_db_transaction
add_index :pghero_space_stats, [:relation, :captured_at], algorithm: :concurrently
Details
CREATE INDEX CONCURRENTLY ON pghero_space_stats (relation, captured_at)
Rows: 4274288
Row progression: 4274288, 898, 90
Row estimates
- relation (=): 898
- captured_at (>=): 427850
- schema (=): 2137144
- database (=): 4274288
Existing indexes
- id PRIMARY
- database, captured_at
to speed up
| Total Time |
Average Time |
Calls |
|
0 min
0.1%
|
31 ms
|
174
pghero
·
details
|
SELECT captured_at, size AS size_bytes FROM pghero_space_stats WHERE database = $1 AND captured_at >= $2 AND schema = $3 AND relation = $4 ORDER BY 1 ASC /*pghero*/
|