idth=23) (actual time=0.035..28.447 rows=2816 loops=1)
Filter: (asp = 6)
Total runtime: 464.337 ms
Have you advices to optimize the query please ?
Stan
2007/9/14, hubert depesz lubaczewski <[EMAIL PROTECTED]>:
> On Fri, Sep 14, 2007 at 03:02:59PM +0200, Stanislas
Hi,
I had errors in my last emails. sorry
I want to optimize my query sql (execution time : 2665 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_pa
schmer <[EMAIL PROTECTED]>:
> 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 st
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') G
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') G
