[GENERAL] Limiting the amount of data in a variable when logging slow queries

Поиск
Список
Период
Сортировка
От Brett Delle Grazie
Тема [GENERAL] Limiting the amount of data in a variable when logging slow queries
Дата
Msg-id CACLD0=4i0ok16tfeCGsPujTM+nrQ-DGq+efPVKiWF6LjprwWAg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Limiting the amount of data in a variable when logging slow queries  (Brett Delle Grazie <brett.dellegrazie@gmail.com>)
Список pgsql-general
Hi,

We've enabled the slow query log and have a particular query that is executing an insert against a table containing a binary array column.

Given the content being stored is upwards of 100MB+ this leads to very long log messages for the slow query log.

Is there a way of having the slow query log only output the first 'n' bytes of a byte array and/or exempting this particular insert?

Thanks,

--
Kind regards,

Brett Delle Grazie

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

Предыдущее
От: Akshay Joshi
Дата:
Сообщение: Re: [GENERAL] pgAdmin4 needs information of v10 SCRAM authentication
Следующее
От: George Neuner
Дата:
Сообщение: Re: [GENERAL] full text search on hstore or json with materialized view?