Re: [PATCH] Add EXPLAIN (ALL) shorthand

Поиск
Список
Период
Сортировка
От David Christensen
Тема Re: [PATCH] Add EXPLAIN (ALL) shorthand
Дата
Msg-id C591816B-492C-4A75-84BF-F242873AFD5F@endpoint.com
обсуждение исходный текст
Ответ на Re: [PATCH] Add EXPLAIN (ALL) shorthand  (Евгений Шишкин <itparanoia@gmail.com>)
Ответы Re: [PATCH] Add EXPLAIN (ALL) shorthand  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
> On May 19, 2016, at 3:17 PM, Евгений Шишкин <itparanoia@gmail.com> wrote:
>
>
>> On 19 May 2016, at 22:59, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> David Christensen <david@endpoint.com> writes:
>>> This simple patch adds “ALL” as an EXPLAIN option as shorthand for “EXPLAIN (ANALYZE, VERBOSE, COSTS, TIMING,
BUFFERS)”for usability. 
>>
>> I'm not sure this is well thought out.  It would mean for example that
>> we could never implement EXPLAIN options that are mutually exclusive
>> ... at least, not without having to redefine ALL as all-except-something.
>> Non-boolean options would be problematic as well.
>>
>
> Maybe EVERYTHING would be ok.
> But it is kinda long word to type.

If it’s just a terminology issue, what about EXPLAIN (*); already a precedent with SELECT * to mean “everything”.
(MAX?LIKE_I’M_5?) Let the bikeshedding begin! 

In any case, I think a shorthand for “give me the most possible detail without me having to lookup/type/remember the
options”is a good tool. 

David
--
David Christensen
End Point Corporation
david@endpoint.com
785-727-1171






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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [PATCH] Add EXPLAIN (ALL) shorthand
Следующее
От: Andreas Karlsson
Дата:
Сообщение: Parallel safety tagging of extension functions