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)

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to