Re: Getting truncated queries from pg_stat_statements

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Getting truncated queries from pg_stat_statements
Дата
Msg-id CAEYLb_Vk-RR8_0_03Uq3pEuShjdSMEewJeDAVobV4dmdGm8guw@mail.gmail.com
обсуждение исходный текст
Ответ на Getting truncated queries from pg_stat_statements  (Tim Uckun <timuckun@gmail.com>)
Ответы Re: Getting truncated queries from pg_stat_statements  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
On Mon, Jan 19, 2015 at 2:37 PM, Tim Uckun <timuckun@gmail.com> wrote:
> I am trying to get some slow query information and the results from my query
> are truncated at 2047 characters.   Some of my queries are very long so they
> get truncated in the select. Is there a way around this?


Yes. This is fixed in PostgreSQL 9.4, so that query texts can be of
virtually unlimited size and still be stored. Otherwise, it depends on
your track_activity_query_size setting.

--
Regards,
Peter Geoghegan


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

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Getting truncated queries from pg_stat_statements
Следующее
От: Tim Uckun
Дата:
Сообщение: Re: Getting truncated queries from pg_stat_statements