Hide 'Execution time' in EXPLAIN (COSTS OFF) - Mailing list pgsql-hackers

From Andres Freund
Subject Hide 'Execution time' in EXPLAIN (COSTS OFF)
Date
Msg-id 20140603180548.GU24145@awork2.anarazel.de
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: SP-GiST bug.
Next
From: David G Johnston
Date:
Subject: Re: idle_in_transaction_timeout