Re: Question about pg_stat_activity

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
Cc: Pgsql-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question about pg_stat_activity
Date: 2005-01-13 06:38:37
Message-ID: 20050113063837.GA80515@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote:

> When I run the following on my server:
> SELECT * FROM pg_stat_activity
>
> I get back <command string not enabled> for the field current_query.
>
> I have stats enabled in my config file, is there some other setting that
> I missed so I can see the current query?

Is stats_command_string set to true? Did you restart the backend
after changing postgresql.conf?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-01-13 06:44:05 Re: Question about pg_stat_activity
Previous Message Michael Fuhr 2005-01-13 06:30:50 Re: vacuum vs open transactions