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

778 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.246
 100
erps2 - accf_tata31mar21 - 192.168.93.223
 100
erps3 - accf_tata31mar21 - 192.168.93.243
 100
cims_rep2 - accf_tata31mar21 - 192.168.93.229
 50
erps_rep1 - accf_tata31mar21 - 192.168.93.228
 50
rails_runner
parasapp - accf_tata31mar21 - 202.83.27.229
 10
rails_runner
parasapp - accf_tata31mar21 - 103.112.23.90
 8