Hide 'Execution time' in EXPLAIN (COSTS OFF)

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Hide 'Execution time' in EXPLAIN (COSTS OFF)
Дата
Msg-id 20140603180548.GU24145@awork2.anarazel.de
обсуждение исходный текст
Ответы Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)  (Noah Misch <noah@leadboat.com>)
Список pgsql-hackers
Hi,

In 9.4. COSTS OFF for EXPLAIN prevents 'Planning time' to be
printed. Should we perhaps do the same for 'Execution time'? That'd make
it possible to use EXPLAIN (ANALYZE, COSTS OFF, TIMING OFF) in
regression tests.

Currently the output for that is:
postgres=# EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF) SELECT 1;          QUERY PLAN
--------------------------------Result (actual rows=1 loops=1)Total runtime: 0.035 ms
(2 rows)

Leaving off the total runtime doesn't seem bad to me.

Greetings,

Andres Freund

--Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SP-GiST bug.
Следующее
От: David G Johnston
Дата:
Сообщение: Re: idle_in_transaction_timeout