Обсуждение: print cached SQL plans of a backend

Поиск

Рассылки

Список Везде pgsql-general pgsql-hackers buildfarm-members pgadmin-hackers pgadmin-support pgsql-admin pgsql-advocacy pgsql-announce pgsql-benchmarks pgsql-bugs pgsql-chat pgsql-cluster-hackers pgsql-committers pgsql-cygwin pgsql-docs pgsql-hackers-pitr pgsql-hackers-win32 pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-patches pgsql-performance pgsql-php pgsql-pkg-debian pgsql-pkg-yum pgsql-ports pgsql-rrreviewers pgsql-ru-general pgsql-sql pgsql-students pgsql-testers pgsql-translators pgsql-www psycopg

Период Все Вчера Неделя Месяц Полгода Год

Сортировка По дате, новые По дате, старые По релевантности

print cached SQL plans of a backend

От

James Pang

Дата:

22 февраля, 15:33:10

Hi,

   possible to print cached SQL plans of a backend , may a specific extension can help do that? 

Thanks,

James

Re: print cached SQL plans of a backend

От

srinivasan s

Дата:

22 февраля, 16:13:49

auto_explain may be helpful PostgreSQL: Documentation: 16: F.4. auto_explain — log execution plans of slow queries

Thanks,

Srini.

On Thu, Feb 22, 2024 at 6:03 PM James Pang <jamespang886@gmail.com> wrote:

Hi,

   possible to print cached SQL plans of a backend , may a specific extension can help do that? 

Thanks,

James

Re: print cached SQL plans of a backend

От

Julien Rouhaud

Дата:

23 февраля, 15:44:56

Hi

On Thu, 22 Feb 2024, 20:33 James Pang, <jamespang886@gmail.com> wrote:

Hi,

   possible to print cached SQL plans of a backend , may a specific extension can help do that?

I don't think that any extension exists for that 

that seems like a peculiar thing to ask, what problem exactly are you trying to solve?