Re: Query Plan Columns

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: Query Plan Columns
Дата
Msg-id AANLkTinMQKpyzGt+1BdUcid4hfUgmthKtxKStrtj=x4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query Plan Columns  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: Query Plan Columns  ("David E. Wheeler" <david@kineticode.com>)
Список pgsql-hackers
On Sat, Nov 6, 2010 at 6:24 PM, David E. Wheeler <david@kineticode.com> wrote:
>
> Would I be right that "Node Type" is the only column can be NOT NULL?
>
> Also, I'm thinking of making the "Actual Startup Time" and ""Actual Total Time" columns into INTERVALs. The times are
expressedin milliseconds, yes? I'm wondering if INTERVAL would be more convenient for querying… 

Yes, but I am wondering whether you should just stick to what would
come out of a normal explain, for consistency sake. Maybe provide
another function, or parameter that would cast the results to
intervals?

Not sure.

Roberto


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

Предыдущее
От: Hitoshi Harada
Дата:
Сообщение: How to share the result data of separated plan
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to share the result data of separated plan