Re: track generic and custom plans in pg_stat_statements

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: track generic and custom plans in pg_stat_statements
Дата
Msg-id CAA5RZ0t6fHWd7haB-3F=NZvD22NKKAkdvDM4Y2-3uQJQ0EV9GQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: track generic and custom plans in pg_stat_statements  (Sami Imseih <samimseih@gmail.com>)
Список pgsql-hackers
> One option might be to use a local hash table, keyed the same way as the
> shared pgss hash (excluding dbid), to handle cases where a backend has
> more than one active cached plan. Then at ExecutorEnd, the local entry could
> be looked up and passed to pgss_store. Not sure if this is worth the effort vs
> what has been committed.

I should also add that making this information available in PlannedStmt allows
for EXPLAIN to also utilize this information. I am thinking we can add
this information
as part of core EXPLAIN or as an option in pg_overexplain.

--
Sami



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