No long running queries
High number of connections 714
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
714 connections
Use connection pooling for better performance. PgBouncer is a solid option.
| Top Sources |
Connections |
| erps1 - accf_tata31mar21 - 192.168.93.222 |
100 |
| cims1 - accf_tata31mar21 - 192.168.93.224 |
99 |
| cims2 - accf_tata31mar21 - 192.168.93.225 |
99 |
| erps2 - accf_tata31mar21 - 192.168.93.223 |
99 |
| erps3 - accf_tata31mar21 - 192.168.93.243 |
98 |
| cims3 - accf_tata31mar21 - 192.168.93.246 |
93 |
| erps_rep2 - accf_tata31mar21 - 192.168.93.229 |
50 |
| rails_runner parasapp - accf_tata31mar21 - 125.21.182.147 |
7 |
| rails_runner parasapp - accf_tata31mar21 - 202.83.27.229 |
7 |
| rails_runner parasapp - accf_tata31mar21 - 14.139.220.115 |
6 |
Suggested Indexes
Add indexes to speed up queries.
rails generate migration add_suggested_indexes
And paste
commit_db_transaction
add_index :itemwise_corporate_coverages, [:item_group_id, :corporate_id], algorithm: :concurrently
Details
CREATE INDEX CONCURRENTLY ON itemwise_corporate_coverages (item_group_id, corporate_id)
Rows: 1158364
Row progression: 1158364, 80, 1
Row estimates
- item_group_id (=): 80
- corporate_id (=): 9267
- location_id (=): 128707
Existing indexes
- id PRIMARY
- item_id
to speed up
| Total Time |
Average Time |
Calls |
|
0 min
0.2%
|
131 ms
|
80
erps1
·
details
|
SELECT "itemwise_corporate_coverages".* FROM "itemwise_corporate_coverages" WHERE ("itemwise_corporate_coverages"."location_id" = $1) AND ("itemwise_corporate_coverages"."corporate_id" = $2) AND ("itemwise_corporate_coverages"."item_group_id" = $3) LIMIT $4
|