PgHero
No long running queries
High number of connections 628
Vacuuming healthy
No columns near integer overflow
No invalid indexes or constraints
No duplicate indexes
No suggested indexes
No slow queries

High Number of Connections

628 connections

Use connection pooling for better performance. PgBouncer is a solid option.

Top Sources Connections
erps1 - accf_tata31mar21 - 192.168.93.222
100
cims2 - accf_tata31mar21 - 192.168.93.225
95
erps3 - accf_tata31mar21 - 192.168.93.243
95
erps2 - accf_tata31mar21 - 192.168.93.223
94
cims1 - accf_tata31mar21 - 192.168.93.224
91
erps_rep2 - accf_tata31mar21 - 192.168.93.229
50
rails_runner
parasapp - accf_tata31mar21 - 103.112.23.90
11
rails_runner
parasapp - accf_tata31mar21 - 202.83.27.229
11
cims_rep1 - accf_tata31mar21 - 192.168.93.228
7
rails_runner
parasapp - accf_tata31mar21 - 125.21.182.147
7