* Joe Van Dyk (j...@tanga.com) wrote: > On Mon, Dec 16, 2013 at 4:14 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Yup, that's what I was just about to suggest. You might want to use > > 10 or 12 in case some of your queries are a bit more complex than > > this one --- but don't go overboard, or you may find yourself with > > unreasonable planning time. > > > > Is there a way to measure the planning time? It's not reported in 'explain > analyze' or 'explain analyze verbose', right?
You can just run 'explain' and that'll more-or-less get you there (turn
on \timing in psql). When reading this thread, I was thinking it might
be useful to add plan time somewhere in explain/explain analyze output
though..
Thanks,
Stephen
signature.asc
Description: Digital signature
