Re: [HACKERS] Reporting planning time with EXPLAIN
От
Andres Freund
Тема
Re: [HACKERS] Reporting planning time with EXPLAIN
Дата
Msg-id
20170106010219.na5hmc5c7hcudbz4@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
[HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Michael Banck <michael.banck@credativ.de>
Re: [HACKERS] Reporting planning time with EXPLAIN Michael Banck <michael.banck@credativ.de>
Re: [HACKERS] Reporting planning time with EXPLAIN Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Reporting planning time with EXPLAIN Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Reporting planning time with EXPLAIN Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Reporting planning time with EXPLAIN Andres Freund <andres@anarazel.de>
Re: [HACKERS] Reporting planning time with EXPLAIN Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Reporting planning time with EXPLAIN Amit Kapila <amit.kapila16@gmail.com>
On 2016-12-28 10:29:48 -0500, Tom Lane wrote: > How about just saying that the existing TIMING option turns this on, > if it's specified without ANALYZE? Right now that combination draws > an error: > > regression=# explain (timing on) select 1; > ERROR: EXPLAIN option TIMING requires ANALYZE > > so there's no existing usage that this would break. 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. Andres [1] http://archives.postgresql.org/message-id/20140603180548.GU24145%40awork2.anarazel.de
В списке pgsql-hackers по дате отправления