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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
