From: Rod Taylor <rbt@rbt.ca>
To: sad <sad@bankir.ru>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: see a current query
Date: Wed, 22 Oct 2003 08:36:27 -0400
Message-ID: <1066826186.3004.10.camel@jester> (raw)
In-Reply-To: <200310221326.41425.sad@bankir.ru>
References: <200310221326.41425.sad@bankir.ru>
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.
Attachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rbt@rbt.ca, sad@bankir.ru
Subject: Re: see a current query
In-Reply-To: <1066826186.3004.10.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox