pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedR: Too many IDLE in current_query
2+ messages / 2 participants
[nested] [flat]
* R: Too many IDLE in current_query
@ 2011-07-12 16:03 francescoboccacci@libero.it <francescoboccacci@libero.it>
0 siblings, 1 reply; 2+ messages in thread
From: francescoboccacci@libero.it @ 2011-07-12 16:03 UTC (permalink / raw)
To: francescoboccacci@libero.it; pgsql-admin
Hi,
i add another question to my previous mail.. why all the rows of my query
have waiting field false?
Thanks
Francesco
>----Messaggio originale----
>Da: francescoboccacci@libero.it
>Data: 12/07/2011 17.38
>A: <pgsql-admin@postgresql.org>
>Ogg: [ADMIN] Too many IDLE in current_query
>
>Dear all,
>i'm checking my postgresql server to try to monitoring all activity that
are
>running.
>i run this query:
>
>postgres=# select
>current_timestamp - query_start as runtime,
>current_query
>from pg_stat_activity
>order by 1 desc;
>
>and the resul is many rows like this:
>
>
> runtime | current_query
>-------------------------+---------------------------------------------
> 34 days 06:53:59.959751 | <IDLE>
> 34 days 06:53:59.924254 | <IDLE>
> 34 days 06:53:56.870348 | <IDLE>
> 34 days 06:04:34.553884 | <IDLE>
> 34 days 06:04:24.975262 | <IDLE>
> 34 days 06:04:20.951703 | <IDLE>
> 34 days 06:04:11.200763 | <IDLE>
> 34 days 02:45:07.633385 | <IDLE>
> 20 days 06:21:00.519184 | <IDLE>
> 20 days 04:56:16.008164 | <IDLE>
> 20 days 04:35:46.465805 | <IDLE>
> 20 days 01:44:22.723898 | <IDLE>
> 19 days 07:32:29.484493 | <IDLE>
> 2 days 09:08:29.955712 | <IDLE>
> 2 days 09:08:29.929274 | <IDLE>
> 2 days 09:08:29.914055 | <IDLE>
> 2 days 09:08:29.910676 | <IDLE>
> 2 days 09:08:29.231103 | <IDLE>
> 2 days 09:08:29.22941 | <IDLE>
> 2 days 09:08:29.20836 | <IDLE>
> 2 days 09:08:29.203906 | <IDLE>
> 2 days 09:08:29.198813 | <IDLE>
> 2 days 09:08:29.19535 | <IDLE>
> 2 days 09:08:28.214741 | <IDLE>
> 2 days 09:08:28.210447 | <IDLE>
> 2 days 09:08:28.183688 | <IDLE>
> 2 days 09:08:28.179618 | <IDLE>
> 2 days 09:08:28.161658 | <IDLE>
> 2 days 09:08:28.151496 | <IDLE>
> 1 day 09:03:14.978079 | <IDLE>
> 1 day 09:03:12.246013 | <IDLE>
> 1 day 08:53:47.763229 | <IDLE>
> 1 day 08:53:46.744188 | <IDLE>
> 1 day 08:49:21.584343 | <IDLE>
> 1 day 07:44:18.245998 | <IDLE>
> 1 day 05:18:29.171981 | <IDLE>
> 1 day 03:25:18.260414 | <IDLE>
> 1 day 02:47:34.402538 | <IDLE>
> 1 day 02:47:33.816568 | <IDLE>
> 1 day 02:47:33.472902 | <IDLE>
> 1 day 00:59:58.531684 | <IDLE>
> 07:07:43.146363 | <IDLE>
> 06:52:19.014704 | <IDLE>
>...
>...
>
>i know that this is just a snapshot of the situation of the server in a
>particular moment, so i know that i can see all IDLE queries.
>The strange thing is that there are quesries that are running from 34 days.
I
>think is strange.
>Do you have any suggestions? My postgresql version is 8.4. I know that in
>postgresql 9.0 i can see also application_name filed.
>Thanks for your help
>
>Francesco Boccacci
>
>--
>Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: R: Too many IDLE in current_query
@ 2011-07-12 16:07 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: francescoboccacci@libero.it <francescoboccacci@libero.it>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2011-07-12 16:07 UTC (permalink / raw)
To: francescoboccacci@libero.it <francescoboccacci@libero.it>; pgsql-admin
"francescoboccacci@libero.it" <francescoboccacci@libero.it> wrote:
> i add another question to my previous mail.. why all the rows of
> my query have waiting field false?
That indicates whether the query is waiting for a heavyweight lock
to clear, not whether it is waiting for user input.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-07-12 16:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-07-12 16:03 R: Too many IDLE in current_query francescoboccacci@libero.it <francescoboccacci@libero.it>
2011-07-12 16:07 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox