"Ashish Karalkar" <ashish_postgre@xxxxxxxxxxx> writes: > Thanks Richard for your replay, > > Richard Huxton <dev@xxxxxxxxxxxx> wrote: >> > Actually, this is the output from EXPLAIN not EXPLAIN ANALYSE. It > doesn't show what actually happened, just what the planner thought was > going to happen. > > Its from EXPLAIN ANALYSE No, it's not. Not unless you've removed all the added info explain analyse adds to the explain output. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
