viewing large queries in pg_stat_activity - Mailing list pgsql-general

From David Kerr
Subject viewing large queries in pg_stat_activity
Date
Msg-id 20100209004629.GA96095@mr-paradox.net
Whole thread Raw
Responses Re: viewing large queries in pg_stat_activity  (Magnus Hagander <magnus@hagander.net>)
Re: viewing large queries in pg_stat_activity  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
It seems like pg_stat_activity truncates the current_query to about 1024 characters.

The field is a text, so i'm wondering if there is a way to see the full query?

(I know i can turn on log_statement=all, or log_min_duration_statement) but i'd like
something that doesn't require a restart.

Thanks

Dave

pgsql-general by date:

Previous
From: David Kerr
Date:
Subject: vacuumdb ERROR: out of memory
Next
From: Fredric Fredricson
Date:
Subject: Order by and strings