Re: pg_stat_get_backen_last_activity() ???
От | Tom Lane |
---|---|
Тема | Re: pg_stat_get_backen_last_activity() ??? |
Дата | |
Msg-id | 8989.1051138333@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: pg_stat_get_backen_last_activity() ??? (Sean Chittenden <sean@chittenden.org>) |
Ответы |
Re: pg_stat_get_backen_last_activity() ???
|
Список | 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
В списке pgsql-general по дате отправления: