Re: [HACKERS] Reporting planning time with EXPLAIN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Reporting planning time with EXPLAIN
Дата
Msg-id 24212.1483667499@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] Reporting planning time with EXPLAIN  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2016-12-28 10:29:48 -0500, Tom Lane wrote:
>> How about just saying that the existing TIMING option turns this on,

> I don't like this much - I'd like (as previously stated in [1]) to be
> able to have an actual EXPLAIN ANALYZE (COSTS off, TIMING OFF) in tests
> because that shows the number of loops, rechecks, etc.

Hmm ...

regression=# EXPLAIN (analyze, COSTS off, TIMING OFF) select * from tenk1;                 QUERY PLAN

-----------------------------------------------Seq Scan on tenk1 (actual rows=10000 loops=1)Planning time: 1.075
msExecutiontime: 2.723 ms
 
(3 rows)

I see your point.  OK, that's a use case not within the scope of the
original proposal, but it's a reasonable argument for having a SUMMARY OFF
option.
        regards, tom lane



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [HACKERS] DROP FUNCTION of multiple functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] T_Float morph to T_Integer after nodeRead