Re: auto_explain produces invalid JSON

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: auto_explain produces invalid JSON
Дата
Msg-id 4F36E3FF.90901@dunslane.net
обсуждение исходный текст
Ответ на Re: auto_explain produces invalid JSON  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: auto_explain produces invalid JSON  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

On 02/11/2012 03:22 PM, Tom Lane wrote:
> Andrew Dunstan<andrew@dunslane.net>  writes:
>> But ExplainBeginOutput says:
>>        case EXPLAIN_FORMAT_JSON:
>>             /* top-level structure is an array of plans */
>>             appendStringInfoChar(es->str, '[');
>> Now that's not true in the auto-explain case, which prints one query +
>> one plan.
> What about queries that expand to multiple plans because of rules?


... and the answer is it logs them in separate pieces of JSON.

>
>> Since this is an exposed API, I don't think we can just change it. We
>> probably need a new API that does the right thing for beginning and
>> ending auto_explain output. (ExplainBeginLabeledOutput?)
> I'm inclined to think that this is auto_explain's error, not that of
> the core code, ie we should be changing the output.
>
>


Well, maybe this is more to your taste, although it strikes me as more
than something of a kludge. At least it's short :-)

cheers

andrew


Вложения

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: auto_explain produces invalid JSON
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pl/python long-lived allocations in datum->dict transformation