Re: Query Plan Columns - Mailing list pgsql-hackers

From Roberto Mello
Subject Re: Query Plan Columns
Date
Msg-id AANLkTinMQKpyzGt+1BdUcid4hfUgmthKtxKStrtj=x4g@mail.gmail.com
Whole thread Raw
In response to Re: Query Plan Columns  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Query Plan Columns
List 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 by date:

Previous
From: Hitoshi Harada
Date:
Subject: How to share the result data of separated plan
Next
From: Tom Lane
Date:
Subject: Re: How to share the result data of separated plan