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

Reply via email to