log_planner_stats and prepared statements

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема log_planner_stats and prepared statements
Дата
Msg-id 20190417033307.gfyducmgzx6gz7wn@momjian.us
обсуждение исходный текст
Ответы Re: log_planner_stats and prepared statements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I have found that log_planner_stats only outputs stats until the generic
plan is chosen.  For example, if you run the following commands:

    SET client_min_messages = 'log';
    SET log_planner_stats = TRUE;
    
    PREPARE e AS SELECT relkind FROM pg_class WHERE relname = $1 ORDER BY 1;

    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');
    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');
    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');
    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');
    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');
    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');
-->    EXPLAIN ANALYZE VERBOSE EXECUTE e ('pg_class');

The last explain will _not_ show any log_planner_stats duration, though
it does show an EXPLAIN planning time:

     Planning Time: 0.012 ms

It this expected behavior?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Runtime pruning problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Runtime pruning problem