Stuck processes, viewing the queries inside
От | Bryan Field-Elliot |
---|---|
Тема | Stuck processes, viewing the queries inside |
Дата | |
Msg-id | 1069112426.4482.27.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Stuck processes, viewing the queries inside
|
Список | pgsql-general |
We have a running server (v7.3) which, over time, seems to accumulate a bunch of "stuck" PostgreSQL instances which appear to be dead inside of a transaction. For example, "ps" reveals many of these: postgres 17683 0.0 0.4 7376 1032 ? S Nov13 0:21 postgres: bryan sourceid 127.0.0.1 idle in transaction As admin, I'd like to run "psql" and peer inside the system (using the Statistics Collector) to see which queries have been run inside some of these stuck transactions. It will help me debug what's going wrong. This page: http://www.postgresql.org/docs/7.3/static/monitoring-stats.html gives lots of intereseting methods for pulling information on the running state, but I can't see a query for "given a process ID currently in a transaction, show me all the queries which have been run in it so far". Any pointers would be appreciated, Bryan
В списке pgsql-general по дате отправления: