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