X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 441C230DE6B for ; Wed, 18 Jun 2003 16:27:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 85906-01 for ; Wed, 18 Jun 2003 13:26:52 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 33AA830D1AC for ; Wed, 18 Jun 2003 13:26:52 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id CC87B1025E; Wed, 18 Jun 2003 12:20:37 -0400 (EDT) Received: from [10.0.2.11] (unknown [10.0.2.11]) by mailav.tor1.inquent.com (Postfix) with ESMTP id DA4C31024D; Wed, 18 Jun 2003 12:20:35 -0400 (EDT) Subject: Re: comparing querys From: Rod Taylor To: Lucas Lain Cc: pgsql-sql@postgresql.org In-Reply-To: <20030618132344.5dfeabd4.lainl@aconectarse.com> References: <3EEF6170.1040905@virginia.edu> <20030618132344.5dfeabd4.lainl@aconectarse.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-tpeR+rHWNhbbatWPDZfZ" Message-Id: <1055953625.48114.35.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.0 Date: 18 Jun 2003 16:27:06 +0000 X-Virus-Scanned: by AMaViS perl-11 X-Archive-Number: 200306/218 X-Sequence-Number: 13976 --=-tpeR+rHWNhbbatWPDZfZ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Take a look at EXPLAIN and EXPLAIN ANALYSE: http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Dsql-e= xplain.html On Wed, 2003-06-18 at 16:23, Lucas Lain wrote: > how can i compare two querys' eficiency??? >=20 > TIA, --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-tpeR+rHWNhbbatWPDZfZ Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+8JLZ6DETLow6vwwRAgTqAJ4srhmEAirfsae0yYYADQWg+PIJkwCfXmIy P3pE3QCfpZH5L5iRrqX+wDA= =26jj -----END PGP SIGNATURE----- --=-tpeR+rHWNhbbatWPDZfZ--