Explain
От | JEANARTHUR@EUROVOX.FR |
---|---|
Тема | Explain |
Дата | |
Msg-id | 3F0998C1.11276.1652504@localhost обсуждение исходный текст |
Ответ на | Re: Renaming a DB (JEANARTHUR@EUROVOX.FR) |
Ответы |
Re: Explain
Re: Explain |
Список | pgsql-admin |
Hi, when I do an explain on a certain query, I have this answer : QUERY PLAN -------------------------------------------------------------------------------------- Aggregate (cost=100017927.48..100017927.48 rows=1 width=8) -> Seq Scan on stats_daily_2003 (cost=100000000.00..100017927.47 rows=1 width=8) Filter: ((id_compte = 29075) AND (periode = '07-07-2003'::date)) (3 rows) Well, I don"t really undestand the meaning of cost=100000000.00..100017927.47 and cost=100017927.48..100017927.48 I guess this result is relatively bad. The same query on a similar table but with an index give : QUERY PLAN -------------------------------------------------------------------------------------------- ---------------- Aggregate (cost=9.60..9.60 rows=1 width=8) -> Index Scan using ap_stats_daily_2003_save on stats_daily_2003_save (cost=0.00..9.59 rows=2 width=8) Index Cond: ((periode = '07-07-2003'::date) AND (id_compte = 29075)) (3 rows) Could you confirm me the second explain is "better" than the first one ? Jean-Arthur Silve EuroVox 4, Place Félix Eboué 75583 Paris Cedex 12 T : +33 1 44670505 F : +33 1 44670519
В списке pgsql-admin по дате отправления: