PgHero
No long running queries
High number of connections 709
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

709 connections

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

Top Sources Connections
erps1 - accf_tata31mar21 - 192.168.93.222
 101
cims1 - accf_tata31mar21 - 192.168.93.224
 100
cims2 - accf_tata31mar21 - 192.168.93.225
 100
cims3 - accf_tata31mar21 - 192.168.93.244
 100
erps2 - accf_tata31mar21 - 192.168.93.223
 100
erps3 - accf_tata31mar21 - 192.168.93.243
 100
erps_rep2 - accf_tata31mar21 - 192.168.93.229
 50
rails_runner
parasapp - accf_tata31mar21 - 115.242.205.210
 6
rails_runner
parasapp - accf_tata31mar21 - 202.83.27.229
 6
rails_runner
parasapp - accf_tata31mar21 - 103.112.23.90
 5