Index ot being used
| От | linux@alteeve.com | 
|---|---|
| Тема | Index ot being used | 
| Дата | |
| Msg-id | 1825.216.209.137.1.1118419819.squirrel@mail.alteeve.com обсуждение исходный текст | 
| Ответы | Re: Index ot being used Re: Index ot being used | 
| Список | 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
		
	В списке pgsql-performance по дате отправления: