Re: Determine current running query, but no query in pg_stat_activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Determine current running query, but no query in pg_stat_activity
Date: 2005-03-29 15:27:03
Message-ID: 21904.1112110023@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Adam Witney <awitney(at)sghms(dot)ac(dot)uk> writes:
> Shouldn't there be something in current_query?

Only if (a) you have stats_command_string turned on, *and* (b) you
are a superuser or the owner of the target process.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adam Witney 2005-03-29 15:50:27 Re: Determine current running query,
Previous Message Adam Witney 2005-03-29 15:03:01 Determine current running query, but no query in pg_stat_activity