Re: see a current query - Mailing list pgsql-sql

On Wed, 2003-10-22 at 05:26, sad wrote:
> Hello
>
> i'am logged in as superuser (pgsql)
> trying to
> SELECT * FROM pg_stat_activity;
> and seeing NULLs instead of current_query column&

You need to change the stats settings in postgresql.conf.  By default
the current query is not enabled as it does cause a performance loss.