Using stat collector for collecting long SQL

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Using stat collector for collecting long SQL
Дата
Msg-id CAFj8pRA=kdsqyKwYnEWXN7B6yontDfuQbAkgGh_9HDtVmhPKbg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Using stat collector for collecting long SQL  (legrand legrand <legrand_legrand@hotmail.com>)
Re: Using stat collector for collecting long SQL  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi

There is a often problem with taking source of long SQL strings. The pg_stat_activity field query is reduced to some short limit and is not too practical to increase this limit.

I have a idea to use for solution of this problem stat_collector process. When the query string is reduced, then full form of query string can be saved in stat_collector process. Maybe with execution plan. Then any process can read these information from this process.

What do you think about this idea? It can be base for implementation EXPLAIN PID ?

Notes, comments?

Regards

Pavel

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

Предыдущее
От: Sandro Santilli
Дата:
Сообщение: Re: [postgis-devel] About EXTENSION from UNPACKAGED on PostgreSQL 13
Следующее
От: Antonin Houska
Дата:
Сообщение: Re: WIP: Aggregation push-down