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