George,
> Um, no, I need an EXPLAIN ANALYZE, not just an EXPLAIN. Thanks.
>
> > June_03=# explain select * from tmp where route >>='62.1.1.0/24';
> > QUERY PLAN
> > ----------------------------------------------------------------
> > Seq Scan on tmp (cost=0.00..606.60 rows=14544 width=33)
> > Filter: (route >>= '62.1.1.0/24'::cidr)
Oh, and also a SELECT VERSION(); would be nice.
--
Josh Berkus
Aglio Database Solutions
San Francisco