X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EF9C75284E for ; Fri, 20 May 2005 16:46:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72418-06 for ; Fri, 20 May 2005 19:46:22 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id EA8815283B for ; Fri, 20 May 2005 16:46:21 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id AEA50714; Fri, 20 May 2005 15:46:45 -0400 From: "Joel Fradkin" To: "PostgreSQL Perform" Subject: performance on a querry with many group by's any way to speed it up? Date: Fri, 20 May 2005 15:47:21 -0400 Message-ID: <005c01c55d74$bcd0b0b0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005D_01C55D53.35BF10B0" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.039 tagged_above=0 required=5 tests=AWL, HTML_60_70, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: ** X-Archive-Number: 200505/332 X-Sequence-Number: 12496 This is a multi-part message in MIME format. ------=_NextPart_000_005D_01C55D53.35BF10B0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable explain analyze SELECT audit , store , question , month , year , week , weekday , myaudittotalscore , active , auditnum , answer , quarter , y_n = , region , district , audittype , status , keyedby , questiondisplay , = qtext , qdescr , answerdisplay , answertext , customauditnum , dateaudittaken , datecompleted , dateauditkeyed , datekeyingcomplete , section , = createdby , division , auditscoredesc , locationnum , text_response , Sum(questionpointsavailable) , Sum(pointsscored)=20 from viwAuditCube where clientnum =3D'RSI'=20 GROUP BY audit, store, question, month, year, week, weekday, myaudittotalscore, active, auditnum, answer, quarter, y_n, region, = district, audittype, status, keyedby, questiondisplay, qtext, qdescr, = answerdisplay, answertext, customauditnum, dateaudittaken, datecompleted, = dateauditkeyed, datekeyingcomplete, section, createdby, division, auditscoredesc, locationnum, text_response ORDER BY audit, store, question, month, year, week, weekday, myaudittotalscore, active, auditnum, answer, quarter, = y_n, region, district, audittype, status, keyedby, questiondisplay, qtext, qdescr, answerdisplay, answertext, customauditnum, dateaudittaken, datecompleted, dateauditkeyed, datekeyingcomplete, section, createdby, division, auditscoredesc, locationnum, text_response =20 =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =20 =20 =20 ------=_NextPart_000_005D_01C55D53.35BF10B0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

explain analyze SELECT audit , store , question , = month , year , week , weekday , myaudittotalscore , active , auditnum , answer , quarter , y_n , region , district , audittype , status , keyedby , = questiondisplay , qtext , qdescr , answerdisplay , answertext , customauditnum , = dateaudittaken , datecompleted , dateauditkeyed , datekeyingcomplete , section , = createdby , division , auditscoredesc , locationnum , text_response , = Sum(questionpointsavailable) , Sum(pointsscored)

from viwAuditCube where clientnum =3D'RSI' =

GROUP BY audit, store, question, month, year, week, = weekday, myaudittotalscore, active, auditnum, answer, quarter, y_n, region, = district, audittype, status, keyedby, questiondisplay, qtext, qdescr, answerdisplay, = answertext, customauditnum, dateaudittaken, datecompleted, dateauditkeyed, datekeyingcomplete, = section, createdby, division, auditscoredesc, locationnum, text_response ORDER BY audit, = store, question, month, year, week, weekday, myaudittotalscore, active, = auditnum, answer, quarter, y_n, region, district, audittype, status, keyedby, = questiondisplay, qtext, qdescr, answerdisplay, answertext, customauditnum, = dateaudittaken, datecompleted, dateauditkeyed, datekeyingcomplete, section, createdby, division, = auditscoredesc, locationnum, text_response

 

 

Joel Fradkin

 

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida = 34243
Tel.  941-753-7111 ext 305

 

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information.  Any unauthorized = review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply email and delete = and destroy all copies of the original message, including = attachments.

 


 

 

------=_NextPart_000_005D_01C55D53.35BF10B0--