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 по дате отправления: