Thread: postgresql.conf for pg_stat_activity

postgresql.conf for pg_stat_activity

From

elein

Date:

15 June 2004, 19:03:49

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.

Re: postgresql.conf for pg_stat_activity

From

elein

Date:

15 June 2004, 22:00:41

Thanks to dennisb on irc...

pg_stats_command=true

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.com
>
>           PostgreSQL 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?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

Re: postgresql.conf for pg_stat_activity

From

Tom Lane

Date:

16 June 2004, 03:16:02

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