* Joe Van Dyk (joe@xxxxxxxxx) wrote: > On Mon, Dec 16, 2013 at 4:14 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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
Attachment:
signature.asc
Description: Digital signature
