Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id D47369F9B0B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 14 Sep 2007 05:49:59 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 58925-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 14 Sep 2007 05:49:55 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.188])
	by postgresql.org (Postfix) with ESMTP id E21FF9F9B0A
	for <pgsql-sql@postgresql.org>; Fri, 14 Sep 2007 05:49:54 -0300 (ADT)
Received: from [194.25.154.138] (helo=webserv.wug.de)
	by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis),
	id 0ML2xA-1IW6s51QFN-0002S2; Fri, 14 Sep 2007 10:49:53 +0200
Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1)
	id 1IW6s4-0003m4-00
	for pgsql-sql@postgresql.org; Fri, 14 Sep 2007 10:49:52 +0200
Date: Fri, 14 Sep 2007 10:49:52 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: Optimize querry sql
Message-ID: <20070914084952.GB7443@a-kretschmer.de>
References: <bc40d0a30709140131u3f23c6e1h17b8bf1f96235a91@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <bc40d0a30709140131u3f23c6e1h17b8bf1f96235a91@mail.gmail.com>
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the
	answer is "no"!
User-Agent: Mutt/1.5.9i
X-Provags-ID: V01U2FsdGVkX19G2YiekdopDAU40lT/b4Mv0Hp6Pg4nLpA3pmW
	0/QAYc2ZAJM6ijI7fElZOW9xBj78GayjPy6+f3F/soDMGevFOd
	sNk/a1TPgcSdOd/MN8b4RyDHuup7FHo
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/105
X-Sequence-Number: 29318

am  Fri, dem 14.09.2007, um 10:31:39 +0200 mailte Stanislas de Larocque folgendes:
> Hi,
> 
> I want to optimize my qerry sql (execution time : 2448 ms) :
> 
> SELECT b.idxreseller, sum(a.nbrq), b.namereseller from stat a
> ,reseller b where b.asp=6 and a.idxreseller=b.reseller and
> a.month=date_part('month',now() - interval '1 month') and
> a.year=date_part('year',now() - interval '1 month') GROUP BY
> b.idxreseller,b.namereseller limit 15;

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

My guess: you need at least an index in reseller.asp. Why do you have
columns such a.month and a.year? se a regular DATE or TIMESTAMPTZ field
instead and an index on this.
And use CURRENT_DATE instead now().

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net