Explain

Поиск
Список
Период
Сортировка
От JEANARTHUR@EUROVOX.FR
Тема Explain
Дата
Msg-id 3F0998C1.11276.1652504@localhost
обсуждение исходный текст
Ответ на Re: Renaming a DB  (JEANARTHUR@EUROVOX.FR)
Ответы Re: Explain  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
Re: Explain  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: "Mendola Gaetano"
Дата:
Сообщение: Re: Renaming a DB
Следующее
От: Sam Barnett-Cormack
Дата:
Сообщение: Re: Explain