Re: The old "not using index" question

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
>
>