pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Stanislas de Larocque <dllstan@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Optimize querry sql
Date: Fri, 14 Sep 2007 10:32:45 +0200
Message-ID: <bc40d0a30709140132j7cf53073j9fd11ef259c06c48@mail.gmail.com> (raw)

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;



dns=> \d stat_dns_domaine;
                            Table «public.stat»

 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 :
    «stat_dns_domaine_idx_idxr_idxrevendeur» btree (idxrevendeur)
    «stat_dns_domaine_idx_mois_annee_idxrev» btree (mois, annee, idxrevendeur)




\d revendeur;
                                        Table «public.reseller»

 idxreseller    | integer | not null default
nextval(('idxrevendeur_seq'::text)::regclass)
 namereseller     | text    |
 asp              | integer |
Index :
    «reseller_pkey» PRIMARY KEY, btree (idxreseller)


Thank you

Stan

view thread (14+ messages)  latest in thread

Message-ID: <bc40d0a30709140132j7cf53073j9fd11ef259c06c48@mail.gmail.com>
Permalink:  ../bc40d0a30709140132j7cf53073j9fd11ef259c06c48@mail.gmail.com/
Also on:    postgresql.org/message-id/bc40d0a30709140132j7cf53073j9fd11ef259c06c48@mail.gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dllstan@gmail.com
  Subject: Re: Optimize querry sql
  In-Reply-To: <bc40d0a30709140132j7cf53073j9fd11ef259c06c48@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox