explain and index scan

From: psql(at)elbrief(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: explain and index scan
Date: 2012-02-24 10:04:30
Message-ID: 1330077870.B4dF5f0.5321@debian2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

PostgreSQL 9.1.2 on i686-pc-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit

id | integer | not null Vorgabewert nextval('a_id_seq'::regclass)
a | integer | not null
b | integer | not null
Indexe:
"a_pkey" PRIMARY KEY, btree (id)
"a_a_key" UNIQUE CONSTRAINT, btree (a, b)

explain select id from a where a = 1 and b = -90875 ;
QUERY PLAN
-------------------------------------------------------------------------------------------------
Index Scan using a_a_key on a (cost=0.00..2.37 rows=1 width=4)
Index Cond: ((a = 1) AND (b = (-90875)))

explain select id from a where b = -90875 ;
QUERY PLAN
---------------------------------------------------------------------------------------------------
Index Scan using a_a_key on a (cost=0.00..961.76 rows=1 width=4)
Index Cond: (b = (-90875))

Both select where shown as 'Index Scan'. But the second select is not a real index scan,
its more a seq scan on an index, i think. I think, it would be a good idea to show this in the
explain. Now you can see this only if you look at the cost.

Best regards and thank you for your work,
Andreas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2012-02-24 10:25:24 Re: Optimise PostgreSQL for fast testing
Previous Message Albe Laurenz 2012-02-24 09:59:24 Re: COPY TO File: Using dynamic file name in stored procedure