From: | "Jan-Philipp 'Thefly' Reining" <jpr(at)turtle-entertainment(dot)de> |
---|---|
To: | <depesz(at)depesz(dot)pl>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: The old "not using index" question |
Date: | 2002-12-02 13:34:10 |
Message-ID: | 047401c29a07$7f0d1e90$84c206d4@thefly |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Barwick | 2002-12-02 14:10:23 | Re: German newspaper with PostgreSQL |
Previous Message | Tommi Maekitalo | 2002-12-02 13:20:03 | Re: --with-tcl |