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