Determine current running query, but no query in pg_stat_activity

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Determine current running query, but no query in pg_stat_activity
Date: 2005-03-29 15:03:01
Message-ID: BE6F2CB5.4357B%awitney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

I have a process running and I am trying to work out what it is doing.
Supposedly it is running a SELECT

23093 ? R 6:35 postgres: lubrook bugasbase SELECT

However in pg_stat_activity, I get no current_query

bugasbase=# SELECT * from pg_stat_activity ;
datid | datname | procpid | usesysid | usename | current_query |
query_start
----------+-----------+---------+----------+---------+---------------+------
-------
80573819 | bugasbase | 23117 | 1 | pgsql | |
80573819 | bugasbase | 23093 | 109 | lubrook | |

Shouldn't there be something in current_query?

Thanks for any advice

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-03-29 15:27:03 Re: Determine current running query, but no query in pg_stat_activity
Previous Message Christopher Browne 2005-03-29 05:12:55 Re: is postgresql 8 is realy mature