From: | linux(at)alteeve(dot)com |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Index ot being used |
Date: | 2005-06-10 16:10:19 |
Message-ID: | 1825.216.209.137.1.1118419819.squirrel@mail.alteeve.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi all,
I have an index on a table that doesn't seem to want to be used. I'm
hopig someone might be able to help point me in the right direction.
My index is (typed, not copied):
tle-bu=> \d file_info_7_display_idx;
Index "public.file_info_7_display_idx"
Column | Type
-----------------+----------------------
file_type | character varying(2)
file_parent_dir | text
file_name | text
btree, for table "public.file_info_7"
tle-bu=> EXPLAIN ANALYZE SELECT file_type, file_parent_dir, file_name FROM
file_info_7;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------
Seq Scan on file_info_7 (cost=0.00..11028.35 rows=294035 width=118)
(actual time=0.122..2707.764 rows=294035 loops=1)
Total runtime: 3717.862 ms
(2 rows)
Can anyone see what's wrong? Should I post the table schema? Thanks all!
Madison
From | Date | Subject | |
---|---|---|---|
Next Message | Clark Slater | 2005-06-10 17:45:05 | faster search |
Previous Message | Jacques Caron | 2005-06-10 15:57:01 | Re: Index ot being used |