Re: pg_stat_get_backen_last_activity() ??? - Mailing list pgsql-general

Sean Chittenden <sean@chittenden.org> writes:
> (gdb) bt
> #0  0x283d0c58 in recvfrom () from /usr/lib/libc.so.4
> #1  0x283c092b in recv () from /usr/lib/libc.so.4
> #2  0x80f11c6 in secure_read ()
> #3  0x80f4557 in StreamConnection ()
> #4  0x80f4935 in pq_getbyte ()
> #5  0x81377b0 in PostgresMain ()
> #6  0x811a63c in PostmasterMain ()
> #7  0x8119e5b in PostmasterMain ()
> #8  0x811934b in PostmasterMain ()
> #9  0x8118e94 in PostmasterMain ()
> #10 0x80f53d7 in main ()
> #11 0x8069b3e in _start ()

> Any ideas on how I can figure out what the mystery query/app/lib is
> that's causing my backend to hang with a zillion connections that are
> all idle?

Well, that particular backend is not hung: the stack trace proves it's
waiting for a command from its frontend.  Perhaps you need to look
through your other Postgres processes.

            regards, tom lane