[EMAIL PROTECTED] - Fri at 12:10:19PM -0400]
> 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)

As far as I can see, you are selecting everything from the table without any
sort order.  The only rational thing to do then is a sequential scan, it's
no point in an index scan.

Tobias Brox, +47-91700050

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to