Re: The old "not using index" question
От | Jan-Philipp 'Thefly' Reining |
---|---|
Тема | Re: The old "not using index" question |
Дата | |
Msg-id | 047401c29a07$7f0d1e90$84c206d4@thefly обсуждение исходный текст |
Ответ на | The old "not using index" question ("Jan-Philipp 'Thefly' Reining" <jpr@turtle-entertainment.de>) |
Ответы |
Re: The old "not using index" question
Re: The old "not using index" question |
Список | pgsql-general |
EXPLAIN => explain analyze SELECT * -> FROM ttm_slots s -> WHERE s.peering = 72 -> AND s.ranking = 1050 -> ; NOTICE: QUERY PLAN: Index Scan using ranking_ttm_slots_key on ttm_slots s (cost=0.00..191.06 rows=8 width=62) (actual time=0.26..0.83 rows=7 loops=1) Total runtime: 1.02 msec EXPLAIN => explain analyze SELECT * -> FROM ttm_slots s -> WHERE s.peering = 72 -> AND s.ranking < 1050 -> AND s.ranking > 950 -> ; NOTICE: QUERY PLAN: Seq Scan on ttm_slots s (cost=0.00..1823.64 rows=7949 width=62) (actual time=0.08..361.12 rows=9840 loops=1) Total runtime: 379.47 msec // Jan-Philipp 'Thefly' Reining ----- Original Message ----- From: "Hubert depesz Lubaczewski" <depesz@depesz.pl> To: "Jan-Philipp 'Thefly' Reining" <jpr@turtle-entertainment.de>; <pgsql-general@postgresql.org> Sent: Monday, December 02, 2002 2:07 PM Subject: Re: [GENERAL] The old "not using index" question > On Mon, Dec 02, 2002 at 01:56:30PM +0100, Jan-Philipp 'Thefly' Reining wrote: > > > show us explain analyze output. > > explain: > > not explain. explain analyze. this information is much more valuable. > > depesz > > -- > hubert depesz lubaczewski http://www.depesz.pl/ > ------------------------------------------------------------------------ > Mój Boże, spraw abym milczał, dopóki się nie upewnię, że naprawdę mam > coś do powiedzenia. (c) 1998 depesz > >
В списке pgsql-general по дате отправления: