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