Re: pg_stat_get_backen_last_activity() ???

Sean Chittenden <sean(at)chittenden(dot)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