Re: current_query pg_stat_activity column - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: current_query pg_stat_activity column
Date
Msg-id 20080222153028.GD24680@crankycanuck.ca
Whole thread Raw
In response to current_query pg_stat_activity column  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
List pgsql-general
On Fri, Feb 22, 2008 at 11:50:51AM -0300, Carlos H. Reimer wrote:
> Hi,
>
> I´ve noticed in my Fedora Core 6 box running PG 8.2.3 that column
> current_query of pg_stat_activity view is not showing the complete query.

Yeah, it can't show very long queries.  I forget what the length restriction
is, but I know there is one.

BTW, you likely want to upgrade to the latest stable version in the 8.2
series, which is 8.2.6.

A


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: configure build flags
Next
From: Martijn van Oosterhout
Date:
Subject: Re: text and bytea