Re: see a current query

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: sad <sad(at)bankir(dot)ru>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: see a current query
Date: 2003-10-22 12:36:27
Message-ID: 1066826186.3004.10.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Gamache 2003-10-22 13:25:51 Query planner: current_* vs. explicit date
Previous Message Theodore Petrosky 2003-10-22 11:40:32 Re: Timestamp