[postgis-users] No index usage on geography query plan?

[Mark Cave-Ayland]

Paragon Corporation wrote:

> Mark,
> 
> He did include it in an earlier email
> 
> wastac=> explain analyze select count(*) from wastac.t_tile_geometry where
> ST_Intersects(border, ST_GeographyFromText('SRID=4326;POLYGON((116.751709
> -31.381779,116.883545 -32.676373,114.741211 -32.796510,114.796143
> -31.316101,116.751709 -31.381779))'));
> 
> 
>  Aggregate  (cost=364056.80..364056.81 rows=1 width=0) (actual
> time=8854.932..8854.933 rows=1 loops=1)
>    ->  Seq Scan on t_tile_geometry  (cost=0.00..362993.14 rows=425463
> width=0) (actual time=2017.629..8854.879 rows=95 loops=1)
>          Filter: st_intersects(border,
> '0103000020E61000000100000005000000F8C610001C305D40B24CBF44BC613FC0D6E253008
> C385D40DE72F563935640C0DF1B430070AF5C40EE77280A
> F46540C01EFCC401F4B25C409F3BC1FEEB503FC0F8C610001C305D40B24CBF44BC613FC0'::g
> eography)
>  Total runtime: 8854.976 ms
> (4 rows)

Ooops - looks like I missed the query switch somewhere in the thread ;)


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs