Postgres Pro
Downloads
Home   >   mailing lists

Re: weird execution plan - Mailing list pgsql-performance

From David G Johnston
Subject Re: weird execution plan
Date
Msg-id 1410489905373-5818733.post@n5.nabble.com
Whole thread Raw
In response to weird execution plan  ("Huang, Suya" <Suya.Huang@au.experian.com>)
Responses Re: weird execution plan
List pgsql-performance
Tree view 
Huang, Suya wrote
> Can someone figure out why the first query runs so slow  comparing to the
> second one? They generate the same result...

Try: EXPLAIN (ANALYZE, BUFFERS)

I believe you are only seeing caching effects.

David J.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/weird-execution-plan-tp5818730p5818733.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: "Huang, Suya"
Date:
Subject: weird execution plan
Next
From: "Huang, Suya"
Date:
Subject: Re: how to change the provoke table in hash join