current_query in pg_stat_activity

From: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: current_query in pg_stat_activity
Date: 2004-02-24 10:24:20
Message-ID: 200402241024.i1OAOKTg081543@lurza.secnetix.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message stm23 2004-02-24 10:44:16 installing pgsql
Previous Message Bulatovic Natasa 2004-02-23 12:58:45 PlPerl + sending emails from Postgres