DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=CCmBbk7wm3kV4LRLrrB9rL5dOu9saWClkCzfaoP3BeVnZhLEhSoeE+dRU/2Ai4MQcp0SsVNp7/cSWLiS727H7URHkm/HSX/JpxWEHHD4gc3Bh3NQDxnm8I4Z6dgkF7J+sd3NKe/qbx4igw9P7+eK+EVohW634fMXzI3Y5WtUx10=
Message-ID: <bc40d0a30709140132j7cf53073j9fd11ef259c06c48@mail.gmail.com>
Date: Fri, 14 Sep 2007 10:32:45 +0200
From: "Stanislas de Larocque" <dllstan@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Optimize querry sql
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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=3D6 and a.idxreseller=3Db.reseller and
a.month=3Ddate_part('month',now() - interval '1 month') and
a.year=3Ddate_part('year',now() - interval '1 month') GROUP BY
b.idxreseller,b.namereseller limit 15;


dns=3D> \d stat_dns_domaine;
                            Table =ABpublic.stat=BB

 idxdxreseller | integer | not null
 idxdo   | integer | not null
 idxd       | integer | not null
 nbrq         | integer | default 0
 month         | integer | default date_part('month'::text, (now() -
'1 mon'::interval))
 year        | integer | default date_part('year'::text, (now() - '1
mon'::interval))

Index :
    =ABstat_dns_domaine_idx_idxr_idxrevendeur=BB btree (idxrevendeur)
    =ABstat_dns_domaine_idx_mois_annee_idxrev=BB btree (mois, annee, idxrev=
endeur)


\d revendeur;
                                        Table =ABpublic.reseller=BB

 idxreseller    | integer | not null default
nextval(('idxrevendeur_seq'::text)::regclass)
 namereseller     | text    |
 asp              | integer |
Index :
    =ABreseller_pkey=BB PRIMARY KEY, btree (idxreseller)


Thank you

Stan