R: Too many IDLE in current_query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx
>Data: 12/07/2011 17.38
>A: <pgsql-admin@xxxxxxxxxxxxxx>
>Ogg:  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@xxxxxxxxxxxxxx)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin
>



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux