Re: running query - Mailing list pgsql-general

From Tom Lane
Subject Re: running query
Date
Msg-id 27663.1037374905@sss.pgh.pa.us
Whole thread Raw
In response to Re: running query  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-general
pginfo <pginfo@t1.unisoftbg.com> writes:
> I start  select * from pg_stat_activity;
> And as result I see
>   datid | datname | procpid | usesysid | usename  | current_query
> -------+---------+---------+----------+----------+---------------
>  16556 | mybase |    1162 |        2 | myuser  |
>  16556 | mybase |    1163 |        2 | myuser  |
>  16556 | mybase |    1164 |        2 | myuser  |
>  16556 | mybase |    1165 |        2 | myuser  |

You're not getting current_query, either because you haven't turned on
collection of current queries by the statistics monitor, or because
you are not superuser.

            regards, tom lane

pgsql-general by date:

Previous
From: Christoph Dalitz
Date:
Subject: Re: Data Transfer from Postgresql to Sybase
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: [SQL] Output of function into a file