What is considered a "slow processes"

From: "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: What is considered a "slow processes"
Date: 2011-01-06 16:53:18
Message-ID: F4E6A2751A2823418A21D4A160B689887B0C9D@fletch.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

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"?

Running pg 8.4 on FreeBSD 7.2 amd64.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message damien clochard 2011-01-06 21:33:24 pg_hba.conf editor is buggy
Previous Message Rainer Kuhi 2011-01-06 14:05:44 Re: pgAdmin v1.12.2: SQL output grid font base