Re: Planner ignoring to use INDEX SCAN - Mailing list pgsql-general

From Gregory Stark
Subject Re: Planner ignoring to use INDEX SCAN
Date
Msg-id 87d4t94d4z.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Planner ignoring to use INDEX SCAN  (Ashish Karalkar <ashish_postgre@yahoo.co.in>)
List pgsql-general
"Ashish Karalkar" <ashish_postgre@yahoo.co.in> writes:

> Thanks Richard for your replay,
>
> Richard Huxton <dev@archonet.com> 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!

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: rewrite pl/pgsql functions to c - remote job
Next
From: "Merlin Moncure"
Date:
Subject: Re: rewrite pl/pgsql functions to c - remote job