Re: track_activity_query_size max practical size?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: track_activity_query_size max practical size?
Дата
Msg-id 1a7063f7-1d7d-dbf4-a919-a55f733560f2@aklaver.com
обсуждение исходный текст
Ответ на track_activity_query_size max practical size?  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: track_activity_query_size max practical size?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: track_activity_query_size max practical size?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
On 7/7/23 07:42, Ron wrote:
> We've got some Very Large Queries that take a long time.  

An EXPLAIN(ANALYZE BUFFERS) would go a long way here.

>Even setting 
> taqs to 10KB isn't adequate, so I want to significantly bump it, but am

It is before coffee here, so you will need to spell out what taqs is?

> concerned about side effects of setting it to 48KB or even 64KB.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




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

Предыдущее
От: Ron
Дата:
Сообщение: track_activity_query_size max practical size?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: track_activity_query_size max practical size?