current_query in pg_stat_activity

Поиск
Список
Период
Сортировка
От Oliver Fromme
Тема current_query in pg_stat_activity
Дата
Msg-id 200402241024.i1OAOKTg081543@lurza.secnetix.de
обсуждение исходный текст
Ответы Re: current_query in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Rajan Bhide"
Дата:
Сообщение: Compilation issue with --enable-thread-safety
Следующее
От: stm23
Дата:
Сообщение: installing pgsql