Re: Bitmap Heap Scan takes a lot of time

<mateo21@siteduzero.com> writes:

> This is the result of an EXPLAIN:
>...
> I suppose that the problem comes from the Bitmap Heap Scan which costs
> a lot, but I can't be totally sure.
>
> Any idea on where I should be investigating ?

Try posting an EXPLAIN ANALYZE which will actually run the query and include
information to compare against the estimates.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!