Idle query that's not "<IDLE>"?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Idle query that's not "<IDLE>"?
Date: 2018-11-06 20:46:20
Message-ID: 579485f2-10a5-50bc-ef15-f731e756e970@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

v9.6.6

Why do these idle queries (pids 8357, 11260 and 11355) "remember" the
queries they ran instead of having the text "<IDLE>"?

postgres=# select pid,
           xact_start as txn_start,
           to_char(EXTRACT(epoch FROM now() - query_start), '999,999.0000')
as query_age_secs,
           state,
           cast (query as char(20))
from pg_stat_activity
where datname <> 'postgres'
order by query_start;
;

 pid  |           txn_start           | query_age_secs | state  |        query
------+-------------------------------+----------------+--------+----------------------
26538 | 2018-11-06 14:40:55.053842-05 |    3,451.9853  | active | SELECT 
to_char(b.pr
27497 | 2018-11-06 14:59:26.946854-05 |    2,340.5871  | active | SELECT 
to_char(b.pr
29110 | 2018-11-06 14:59:50.479934-05 |    2,317.1725  | active | SELECT 
to_char(b.pr
* 8357 |                               |    1,324.1356  | idle   | SELECT 
CAST(c.ecid*
 9016 | 2018-11-06 15:34:51.535476-05 |      215.8391  | active | SELECT 
to_char(b.pr
 9810 | 2018-11-06 15:35:00.483292-05 |      206.7676  | active | SELECT 
to_char(b.pr
*11260 |                               |      190.0814  | idle   | WITH
configs AS (SEL*
12800 | 2018-11-06 15:35:49.540631-05 |      157.9880  | active | SELECT 
to_char(b.pr
*11355 |                               |       42.9772  | idle   | SELECT
CASE WHEN typ*
22618 | 2018-11-06 15:38:02.317146-05 |       25.3219  | active | SELECT 
to_char(b.pr
23176 | 2018-11-06 15:38:12.90985-05  |       14.7325  | active | SELECT 
to_char(b.pr
23566 | 2018-11-06 15:38:28.802919-05 |         .6116  | active | select
tms.TRIGGER.T
23588 | 2018-11-06 15:38:29.207373-05 |         .2089  | active | select
cds.IMAGE_RPS
23590 | 2018-11-06 15:38:29.233724-05 |         .1814  | active | select
tms.TRIGGER.T
23584 | 2018-11-06 15:38:29.046393-05 |         .0442  | active | select
tms.MARK_SENS
23595 | 2018-11-06 15:38:29.403969-05 |         .0001  | active | select
JOB_STEP.JOB_
(16 rows)

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hellmuth Vargas 2018-11-06 20:53:22 Re: Idle query that's not "<IDLE>"?
Previous Message Ondřej Bouda 2018-11-06 20:36:08 Re: backend crash on DELETE, reproducible locally