Postgres Pro
Downloads
Home   >   mailing lists

Re: Understanding the output of EXPLAIN ANALYSE - Mailing list pgsql-novice

From Andreas Wenk
Subject Re: Understanding the output of EXPLAIN ANALYSE
Date
Msg-id 4A6ECA02.5080909@netzmeister-st-pauli.de
Whole thread Raw
In response to Re: Understanding the output of EXPLAIN ANALYSE  ("Thurber, Fred" <Fred.Thurber@gdit.com>)
List pgsql-novice
Tree view 
Thurber, Fred schrieb:
>
> Now we added a couple of indexes, and it seemingly slowed down, but the estimated cost was lower:

which indexes did you add? As far as I can see, there is only bobs_grid_index used in both
plans. And just to mention it - did you run VACUUM and / or ANAYLZE?

Cheers

Andy

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Location of databases
Next
From: Andreas Wenk
Date:
Subject: Re: Location of databases