"Gurjeet Singh" <[EMAIL PROTECTED]> writes: > The situation seems pretty bad!!
I think at least part of your problem is not understanding that a single transaction sees a frozen snapshot of pg_stat_activity. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend