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

Thanks to dennisb on irc...

pg_stats_command=true

On Tue, Jun 15, 2004 at 12:03:23PM -0700, elein wrote:[color=blue]
> 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[/color]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Thanks to dennisb on irc...

pg_stats_command=true

On Tue, Jun 15, 2004 at 12:03:23PM -0700, elein wrote:[color=blue]
> 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[/color]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

elein <elein@varlena.com> writes:[color=blue]
> 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.[/color]

stats_command_string ... AFAIR this has never changed ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

elein <elein@varlena.com> writes:[color=blue]
> 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.[/color]

stats_command_string ... AFAIR this has never changed ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match