According to a comment on this question I asked about idle connections in PostgreSQL 9.2, some uncommitted transactions (possibly related to some of those idle connections) might cause some performance issues.
What is a good way to determine if there are uncommitted transactions (bonus points if there is a way to know if the connection they're on is idle or not)?
Thanks very much!
pgtop
. You may also hunt for rows showing "idle in transaction" in the output ofps aux
. – dezso Apr 11 '13 at 5:20pgtop
looks interesting; is there an equivalent for Windows? – Max Vernon♦ Apr 11 '13 at 14:25