Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 15236 invoked from network); 13 Aug 2010 02:38:42 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 Aug 2010 02:38:42 -0000 Received: (qmail 81394 invoked by uid 500); 13 Aug 2010 02:38:42 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 81335 invoked by uid 500); 13 Aug 2010 02:38:41 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 81328 invoked by uid 99); 13 Aug 2010 02:38:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Aug 2010 02:38:41 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Aug 2010 02:38:38 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o7D2cG5t005528 for ; Fri, 13 Aug 2010 02:38:16 GMT Message-ID: <19375274.321231281667096647.JavaMail.jira@thor> Date: Thu, 12 Aug 2010 22:38:16 -0400 (EDT) From: "Bryan Pendleton (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4587) Add tools for improved analysis and understanding of query plans and execution statistics In-Reply-To: <1597970315.314791268837787263.JavaMail.jira@brutus.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4587?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1289= 8049#action_12898049 ]=20 Bryan Pendleton commented on DERBY-4587: ---------------------------------------- Committed patch 9.11 to the trunk as revision 985075. > Add tools for improved analysis and understanding of query plans and exec= ution statistics > -------------------------------------------------------------------------= ---------------- > > Key: DERBY-4587 > URL: https://issues.apache.org/jira/browse/DERBY-4587 > Project: Derby > Issue Type: Improvement > Components: SQL, Tools > Reporter: Bryan Pendleton > Assignee: C.S. Nirmal J. Fernando > Attachments: AdavancedXSL-mouseover.jpg, advancedViewXSL.xsl, adv= ancedViewXSL.xsl, advancedViewXSL2.xsl, advancedXSL-1.jpg, advancedXSL-2.jp= g, advancedXSL-3.jpg, basic_html-2.2.jpg, basic_html-2.3.jpg, basic_html-2.= jpg, basic_html-3.jpg, basic_html-4.1.jpg, basic_html-4.2.jpg, Derby Query = Plan Screen Shot 2.jpg, DERBY-4587-javadoc_fix.diff, DERBY-4587-tool-2.diff= , DERBY-4587-tool-3.diff, DERBY-4587-tool-4.diff, DERBY-4587-tool-5.diff, D= ERBY-4587-tool-6.diff, DERBY-4587-tool-7-b.diff, DERBY-4587-tool-7.diff, DE= RBY-4587-tool-8.diff, DERBY-4587-tool-9.1.diff, DERBY-4587-tool-9.10-eol_st= yle_native.diff, DERBY-4587-tool-9.11-license_header_inXSL.diff, DERBY-4587= -tool-9.2.diff, DERBY-4587-tool-9.3.diff, DERBY-4587-tool-9.4.diff, DERBY-4= 587-tool-9.5.diff, DERBY-4587-tool-9.6.diff, DERBY-4587-tool-9.7.diff, DERB= Y-4587-tool-9.7.diff, DERBY-4587-tool-9.8-modified.diff, DERBY-4587-tool-9.= 8.diff, DERBY-4587-tool-9.9-formatting.diff, DERBY-4587-tool-9.diff, DERBY-= 4587-tool-test1.diff, DERBY-4587-tool-test2.diff, DERBY-4587-tool.diff, der= by-logo.png, Derby_Query_Plan_Screen_Shot.jpg, PostgreSQL license.jpg, Read= _Me.txt, screenshot-1.jpg, screenshot-2.jpg, screenshot-3.jpg, Simple HTML = View (Pure XSL).jpg, Source.rar, test.xml, test4.xsl, vanilla_html.xsl, van= illa_html.xsl, vanilla_html.xsl, vanilla_html.xsl, vanilla_html.xsl, xml_do= c_screenshot.jpg, xml_doc_screenshot.jpg > > > I think it would be great to see some work in the area of tools for helpi= ng > with the analysis of complex query execution. Quite frequently, users of > Derby have trouble comprehending (a) how their query is being translated > into a query plan by the optimizer, and (b) what the execution-time resou= rce > usage of the various parts of the query is. > There are low-level features in Derby which capture this information and > record it, such as logQueryPlan, and the XPLAIN tables, but there is a lo= t > of opportunity for designing higher-level tools which can process the que= ry > plan and execution statistics information and present it in a more > comprehensible fashion.=20 --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.