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(at)depesz(dot)pl>
To: "Jan-Philipp 'Thefly' Reining" <jpr(at)turtle-entertainment(dot)de>;
<pgsql-general(at)postgresql(dot)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
>
>