pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsee a current query
2+ messages / 2 participants
[nested] [flat]
* see a current query
@ 2003-10-22 09:26 sad <sad@bankir.ru>
0 siblings, 1 reply; 2+ messages in thread
From: sad @ 2003-10-22 09:26 UTC (permalink / raw)
To: pgsql-sql
Hello
i'am logged in as superuser (pgsql)
trying to
SELECT * FROM pg_stat_activity;
and seeing NULLs instead of current_query column&
What is it?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: see a current query
@ 2003-10-22 12:36 Rod Taylor <rbt@rbt.ca>
parent: sad <sad@bankir.ru>
0 siblings, 0 replies; 2+ messages in thread
From: Rod Taylor @ 2003-10-22 12:36 UTC (permalink / raw)
To: sad <sad@bankir.ru>; +Cc: 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.
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-10-22 12:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-22 09:26 see a current query sad <sad@bankir.ru>
2003-10-22 12:36 ` Rod Taylor <rbt@rbt.ca>
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