postgresql.conf for pg_stat_activity
The variable names in postgresql.conf have changed
in the last several releases. I'm now confused
about what variable(s) to set to show the query
in pg_stat_activity.
Hints?
--elein
============================================================
elein@varlena.com Varlena, LLC www.varlena.com
PostgreSQL Consulting, Support & Training
PostgreSQL General Bits http://www.varlena.com/GeneralBits/
=============================================================
I have always depended on the [QA] of strangers.
Thanks to dennisb on irc...
pg_stats_command=true
Show quoted text
On Tue, Jun 15, 2004 at 12:03:23PM -0700, elein wrote:
The variable names in postgresql.conf have changed
in the last several releases. I'm now confused
about what variable(s) to set to show the query
in pg_stat_activity.Hints?
--elein
============================================================
elein@varlena.com Varlena, LLC www.varlena.comPostgreSQL Consulting, Support & Training
PostgreSQL General Bits http://www.varlena.com/GeneralBits/
=============================================================
I have always depended on the [QA] of strangers.---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
elein <elein@varlena.com> writes:
The variable names in postgresql.conf have changed
in the last several releases. I'm now confused
about what variable(s) to set to show the query
in pg_stat_activity.
stats_command_string ... AFAIR this has never changed ...
regards, tom lane