Re: Checking what is the current query running

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Checking what is the current query running
Дата
Msg-id 8300.1153829345@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Checking what is the current query running  ("Markus Wollny" <Markus.Wollny@computec.de>)
Список pgsql-admin
"Markus Wollny" <Markus.Wollny@computec.de> writes:
> pg_stat_activity has some limitations however; if you use a lot of
> dynamically generated complex queries, you might stumble over the 255
> character limit of current_query in pg_stat_activity, statement-strings
> longer than that are just cut off.

The limit has been ~1K, not 255, for a long time (since 8.0).

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Checking what is the current query running
Следующее
От: "JieJun Xu"
Дата:
Сообщение: Re: problem backup/restore PSQL DB