| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | "Thurber, Fred" <Fred(dot)Thurber(at)gdit(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Understanding the output of EXPLAIN ANALYSE |
| Date: | 2009-07-24 21:13:22 |
| Message-ID: | 3073cc9b0907241413s428fcf5focf048ede8b0bd9bc@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Jul 23, 2009 at 12:14 PM, Thurber, Fred<Fred(dot)Thurber(at)gdit(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2009-07-26 20:11:19 | total number of concurrent connections |
| Previous Message | Michael Wood | 2009-07-24 07:50:03 | Re: Question on Load balancing |