Le 06/01/2011 17:53, Benjamin Krajmalnik a écrit : > While playing around with pgadmin to see the state of running queries, I > noticed that all of the queries are falling under the category of "slow > processes" or "idle process". Some of the process whose query is > showing as idle are tagged as idle processes, while some are tagged as > slow processes. >
There is actually more possibilities: * idle process: for each process that don't currently run a query and aren't in a transaction block * blocked process: for each process waiting on a lock * active process: for each process executing a query since less than 10 seconds * slow process: for each process executing a query since at least 10 seconds > Could this be an "artifact" of using a connection pooler, since the > client start times are sometimes a few minutes old? What is the > criteria for determining if a process is "slow"? > We use query_start to check if a query is slow, so I don't think it has anything to do with a connection pooler. > Running pg 8.4 on FreeBSD 7.2 amd64. > -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support