Backends idle-in-transaction ({#DATABASE})
7
0
pg.query.integer[{$PG_CONN},{$PG_DB},"select count(*) from pg_stat_activity where state = 'idle in transaction' and datname = current_database();"]
60
30
400
0
3
0
0
0
0
1
0
0
Number of backends currently idle-in-transaction in this database. This is the only column in this view that returns a value reflecting current state; all other columns return the accumulated values since the last reset.
0
PostgreSQL Database Backend Connections
Backends waiting ({#DATABASE})
7
0
pg.query.integer[{$PG_CONN},{$PG_DB},"select count(*) from pg_stat_activity where waiting='t'; and datname = current_database()"]
60
30
400
0
3
0
0
0
0
1
0
0
Number of backends currently waiting on a lock in this database. This is the only column in this view that returns a value reflecting current state; all other columns return the accumulated values since the last reset.
0
PostgreSQL Database Backend Connections