X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id ECAF4D1B379
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Jul 2004 15:37:35 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 03730-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Jul 2004 18:37:35 +0000 (GMT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 38C72D1B34F
	for <pgsql-sql@postgresql.org>; Fri,  2 Jul 2004 15:37:33 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i62IbWZ3015262
	for <pgsql-sql@postgresql.org>; Fri, 2 Jul 2004 18:37:32 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i62HdMrR005546
	for pgsql-sql@postgresql.org; Fri, 2 Jul 2004 17:39:22 GMT
From: siganos@gmail.com (George Siganos)
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Question about a CIDR based query
Date: 2 Jul 2004 10:39:14 -0700
Organization: http://groups.google.com
Lines: 37
Message-ID: <ebba5a93.0407020939.3734121b@posting.google.com>
References: <ebba5a930406241343173046c7@mail.gmail.com>
	<ebba5a93.0406261506.7a0f7558@posting.google.com>
	<200406291652.24900.josh@agliodbs.com>
	<200406292049.06283.josh@agliodbs.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200407/16
X-Sequence-Number: 18268

Hi Josh,
Ok, first the explain analyze ....

June_03=# explain analyze 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) (actual
time=3.862..15.366 rows=1 loops=1)
   Filter: (route >>= '62.1.1.0/24'::cidr)
 Total runtime: 15.493 ms
(3 rows)

And the version of postgres

June_03=# select version();
                                                      version
--------------------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.2 20031022 (Gentoo Linux 3.3.2-r2, propolice)
(1 row)

Thanks,
Georgos

josh@agliodbs.com (Josh Berkus) wrote in message news:<200406292049.06283.josh@agliodbs.com>...
> 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.