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.