Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <43847.192151281057557976.JavaMail.jira@thor>
Date: Thu, 5 Aug 2010 21:19:17 -0400 (EDT)
From: "C.S. Nirmal J. Fernando (JIRA)" <jira@apache.org>
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


    [ https://issues.apache.org/jira/browse/DERBY-4587?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1289=
5908#action_12895908 ]=20

C.S. Nirmal J. Fernando commented on DERBY-4587:
------------------------------------------------

Hi Bryan,

If the earlier errors were not the reason, is it something to do with this =
warning:

[javadoc] /home/hudson/hudson-slave/workspace/Derby-trunk/trunk/java/testin=
g/org/apache/derbyTesting/functionTests/tests/lang/XplainStatisticsTest.jav=
a:621: warning - @param argument "s:" is not a parameter name.

I have accidentally put a "colon" there after s.

The final log at the end says following:

javadoc:

BUILD SUCCESSFUL
Total time: 2 minutes 11 seconds
[WARNINGS] Parsing warnings in console log...
[WARNINGS] Using set difference to compute new warnings
[WARNINGS] Found 1 new annotations (0 high, 1 normal, 0 low)
[WARNINGS] Found 1  annotations (0 high, 1 normal, 0 low)
[WARNINGS] Setting build status to FAILURE since total number of annotation=
s exceeds the threshold 0
Sending e-mails to: derby-dev@db.apache.org bpendleton@apache.org
Finished: FAILURE

I'm not quite sure what is this annotation refers to? You have any idea?

> 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-tool-2.diff, DERBY-4587-tool-3.diff, DER=
BY-4587-tool-4.diff, DERBY-4587-tool-5.diff, DERBY-4587-tool-6.diff, DERBY-=
4587-tool-7-b.diff, DERBY-4587-tool-7.diff, DERBY-4587-tool-8.diff, DERBY-4=
587-tool-9.1.diff, DERBY-4587-tool-9.2.diff, DERBY-4587-tool-9.3.diff, DERB=
Y-4587-tool-9.4.diff, DERBY-4587-tool-9.5.diff, DERBY-4587-tool-9.6.diff, D=
ERBY-4587-tool-9.7.diff, DERBY-4587-tool-9.diff, DERBY-4587-tool-test1.diff=
, DERBY-4587-tool-test2.diff, DERBY-4587-tool.diff, derby-logo.png, Derby_Q=
uery_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, vanilla_html.xsl, vanil=
la_html.xsl, vanilla_html.xsl, vanilla_html.xsl, xml_doc_screenshot.jpg, xm=
l_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.