I'm sorry, they are in milliseconds, not seconds. The time used is quite same to the result of "explain analyze select ...." I pasted above, which was " Total runtime: 0.479 ms". Greetings, Ning On Thu, Jul 16, 2009 at 6:33 PM, Andres Freund<andres@xxxxxxxxxxx> wrote: > On Thursday 16 July 2009 11:30:00 ning wrote: >> Hi Andres, >> >> By executing >> #explain analyze execute test_query; >> >> the first execution cost 0.389 seconds >> the second cost 0.285 seconds > Seconds or milliseconds? > > If seconds that would be by far slower than the plain SELECT, right? > > Andres > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
