viewing large queries in pg_stat_activity

Поиск
Список
Период
Сортировка
От David Kerr
Тема viewing large queries in pg_stat_activity
Дата
Msg-id 20100209004629.GA96095@mr-paradox.net
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: David Kerr
Дата:
Сообщение: vacuumdb ERROR: out of memory
Следующее
От: Fredric Fredricson
Дата:
Сообщение: Order by and strings