Received: from localhost (unknown [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 238339F9B58
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 14 Sep 2007 09:00:33 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 99005-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 14 Sep 2007 08:59:56 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from depesz.com (depesz.com [88.198.37.40])
	by postgresql.org (Postfix) with ESMTP id A760A9F9B77
	for <pgsql-sql@postgresql.org>; Fri, 14 Sep 2007 08:59:48 -0300 (ADT)
Received: from depesz by depesz.com with local (Exim 4.63)
	(envelope-from <depesz@depesz.com>)
	id 1IW9pc-0007z5-IB; Fri, 14 Sep 2007 13:59:32 +0200
Date: Fri, 14 Sep 2007 13:59:32 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Stanislas de Larocque <dllstan@gmail.com>
Cc: "A. Kretschmer" <andreas.kretschmer@schollglas.com>,
	pgsql-sql@postgresql.org
Subject: Re: Optimize querry sql
Message-ID: <20070914115932.GA30650@depesz.com>
Reply-To: depesz@depesz.com
References: <bc40d0a30709140131u3f23c6e1h17b8bf1f96235a91@mail.gmail.com>
	<20070914084952.GB7443@a-kretschmer.de>
	<bc40d0a30709140326m7210f895o5a5383c5670a9602@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <bc40d0a30709140326m7210f895o5a5383c5670a9602@mail.gmail.com>
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/108
X-Sequence-Number: 29321

On Fri, Sep 14, 2007 at 12:26:00PM +0200, Stanislas de Larocque wrote:
> Explain my sql querry :

did you notice, that andreas asked:

> > Show us the output from EXLAIN ANALYSE <your query>.

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)