| From: | Felipe Fernandez <danielfm(at)teleline(dot)es> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, postgresql <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Indices |
| Date: | 2004-08-02 03:58:59 |
| Message-ID: | 410DBC03.80100@teleline.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Esto es con un indice que agrupa provincia, localidad, nombre,apellido1.
Los tiempos son bastante pero que la anterior?
explain analyze select * from abonados where localidad = 38038;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------
Seq Scan on abonados (cost=0.00..236123.08 rows=13013 width=105)
(actual time=17.598..637110.190 rows=14475 loops=1)
Filter: (localidad = 38038)
Total runtime: 637644.316 ms
(3 rows)
explain analyze select * from abonados where provincia = 38;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------
Seq Scan on abonados (cost=0.00..236123.08 rows=95414 width=105)
(actual time=17.659..561143.309 rows=30104 loops=1)
Filter: (provincia = 38)
Total runtime: 561685.628 ms
(3 rows)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Marques | 2004-08-02 11:50:40 | Re: Indices |
| Previous Message | Alvaro Herrera | 2004-08-01 22:02:18 | Re: Indices |