Skip site navigation (1) Skip section navigation (2)

Re: Question about a CIDR based query

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: siganos(at)gmail(dot)com (George Siganos), pgsql-sql(at)postgresql(dot)org
Subject: Re: Question about a CIDR based query
Date: 2004-06-29 23:52:24
Message-ID: 200406291652.24900.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-sql
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


In response to

Responses

pgsql-sql by date

Next:From: Josh BerkusDate: 2004-06-30 03:49:06
Subject: Re: Question about a CIDR based query
Previous:From: Stephan SzaboDate: 2004-06-29 21:25:18
Subject: Re: OUTER JOIN problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group