| From: | Roberto Mello <roberto(dot)mello(at)gmail(dot)com> |
|---|---|
| To: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Query Plan Columns |
| Date: | 2010-11-07 13:24:06 |
| Message-ID: | AANLkTinMQKpyzGt+1BdUcid4hfUgmthKtxKStrtj=x4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Nov 6, 2010 at 6:24 PM, David E. Wheeler <david(at)kineticode(dot)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 expressed in 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-11-07 16:23:46 | Re: How to share the result data of separated plan |
| Previous Message | Hitoshi Harada | 2010-11-07 13:02:21 | How to share the result data of separated plan |