On Thu, Jul 23, 2009 at 12:14 PM, Thurber, Fred<Fred.Thurber@gdit.com> wrote:
>
> So the cost was 101. We put indexes on the two tables that were being
> joined and re-ran EXPLAIN ANALYZE. The cost went way down, but the
> execution time went way up. What am I missing?
>
> "Nested Loop (cost=0.00..15.28 rows=1 width=256) (actual
> time=0.000..110.000 rows=2818 loops=1)"
> …
> "Total runtime: 110.000 ms"
>
run ANALYZE and rerun "explain analyze your_query"
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157