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=IuP35M0l9VsxaAFWgSD7SUpVSTsl2g8TjKUnYvlxUmZ5ulzD5wuJsunS4o0sSeUqttVVXTIzsXuKcZ2ZMtZ+66X9aNmYMM9h9WWe4e/6+mcHHkkHJKHenWVZYePeZrI6gGtnx92LiWDvxaPkYC92nGLyIcUUHOkHBsPC2F+tYwA=
Message-ID: <bc40d0a30709140131u3f23c6e1h17b8bf1f96235a91@mail.gmail.com>
Date: Fri, 14 Sep 2007 10:31:39 +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_dns_domaine=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 limit 20;
                                        Table =ABpublic.revendeur=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