Re: machine-readable explain output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: machine-readable explain output
Дата
Msg-id 16136.1245168270@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: machine-readable explain output  (Greg Stark <gsstark@mit.edu>)
Ответы Re: machine-readable explain output  (Andrew Dunstan <andrew@dunslane.net>)
Re: machine-readable explain output  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> I'm picturing adding a new tag, such as <iostats>, or actually I was
> thinking of <dtrace>. If we have separate tags for all the estimates
> and actual timings then any tags which come with the <iostat> or
> <dtrace> option would just get mixed up with the estimates and timing
> info.

FWIW, I like Greg's idea of subdividing the available data this way.
I'm no XML guru, so maybe there is a better way to do it --- but a
very large part of the reason for doing this at all is to have an
extensible format, and part of that IMHO is that client programs should
be able to have some rough idea of what things are even when they
don't know it exactly.

But I'd be just as happy with a naming convention, like
<planner:rowcount> versus <actual:rowcount>, etc.  I don't know
enough about XML usage to understand the benefits and costs of
different ways of providing that kind of structure.
        regards, tom lane


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

Предыдущее
От: "Czichy, Thoralf (NSN - FI/Helsinki)"
Дата:
Сообщение: Re: postmaster recovery and automatic restart suppression
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: machine-readable explain output