current_query in pg_stat_activity - Mailing list pgsql-novice

From Oliver Fromme
Subject current_query in pg_stat_activity
Date
Msg-id 200402241024.i1OAOKTg081543@lurza.secnetix.de
Whole thread Raw
Responses Re: current_query in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

The "current_query" column in the "pg_stat_activity" system
table seems to be limited to 255 characters.  Is there a way
to increase that limit, in order to see queries completely
which are longer than 255 characters?

Thanks in advance!

Best regards
   Oliver

(PS:  Using PostgreSQL 7.3.4.)

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"The scanf() function is a large and complex beast that often does
something almost but not quite entirely unlike what you desired."
        -- Chris Torek

pgsql-novice by date:

Previous
From: "Rajan Bhide"
Date:
Subject: Compilation issue with --enable-thread-safety
Next
From: stm23
Date:
Subject: installing pgsql