Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4587

Add tools for improved analysis and understanding of query plans and execution statistics

    Details

      Description

      I think it would be great to see some work in the area of tools for helping
      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 resource
      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 lot
      of opportunity for designing higher-level tools which can process the query
      plan and execution statistics information and present it in a more
      comprehensible fashion.

        Attachments

        1. PostgreSQL license.jpg
          142 kB
          Nirmal Fernando
        2. Read_Me.txt
          1 kB
          Nirmal Fernando
        3. Source.rar
          5 kB
          Nirmal Fernando
        4. Derby_Query_Plan_Screen_Shot.jpg
          20 kB
          Nirmal Fernando
        5. Derby Query Plan Screen Shot 2.jpg
          117 kB
          Nirmal Fernando
        6. DERBY-4587-tool.diff
          9 kB
          Nirmal Fernando
        7. DERBY-4587-tool-2.diff
          9 kB
          Nirmal Fernando
        8. DERBY-4587-tool-3.diff
          9 kB
          Nirmal Fernando
        9. DERBY-4587-tool-4.diff
          16 kB
          Nirmal Fernando
        10. screenshot-1.jpg
          165 kB
          Nirmal Fernando
        11. screenshot-2.jpg
          149 kB
          Nirmal Fernando
        12. test4.xsl
          3 kB
          Nirmal Fernando
        13. test.xml
          1 kB
          Nirmal Fernando
        14. screenshot-3.jpg
          149 kB
          Nirmal Fernando
        15. DERBY-4587-tool-5.diff
          17 kB
          Nirmal Fernando
        16. Simple HTML View (Pure XSL).jpg
          91 kB
          Nirmal Fernando
        17. vanilla_html.xsl
          2 kB
          Nirmal Fernando
        18. xml_doc_screenshot.jpg
          111 kB
          Nirmal Fernando
        19. DERBY-4587-tool-6.diff
          17 kB
          Nirmal Fernando
        20. DERBY-4587-tool-test1.diff
          3 kB
          Nirmal Fernando
        21. basic_html-2.jpg
          75 kB
          Nirmal Fernando
        22. DERBY-4587-tool-7.diff
          18 kB
          Nirmal Fernando
        23. vanilla_html.xsl
          2 kB
          Nirmal Fernando
        24. basic_html-2.2.jpg
          90 kB
          Nirmal Fernando
        25. basic_html-3.jpg
          93 kB
          Nirmal Fernando
        26. DERBY-4587-tool-7-b.diff
          19 kB
          Nirmal Fernando
        27. DERBY-4587-tool-test2.diff
          3 kB
          Nirmal Fernando
        28. vanilla_html.xsl
          2 kB
          Nirmal Fernando
        29. basic_html-2.3.jpg
          73 kB
          Nirmal Fernando
        30. basic_html-4.1.jpg
          81 kB
          Nirmal Fernando
        31. basic_html-4.2.jpg
          74 kB
          Nirmal Fernando
        32. DERBY-4587-tool-8.diff
          25 kB
          Nirmal Fernando
        33. vanilla_html.xsl
          2 kB
          Nirmal Fernando
        34. xml_doc_screenshot.jpg
          118 kB
          Nirmal Fernando
        35. DERBY-4587-tool-9.diff
          73 kB
          Nirmal Fernando
        36. DERBY-4587-tool-9.1.diff
          72 kB
          Nirmal Fernando
        37. DERBY-4587-tool-9.2.diff
          72 kB
          Nirmal Fernando
        38. DERBY-4587-tool-9.3.diff
          78 kB
          Nirmal Fernando
        39. DERBY-4587-tool-9.4.diff
          82 kB
          Nirmal Fernando
        40. vanilla_html.xsl
          2 kB
          Nirmal Fernando
        41. derby-logo.png
          4 kB
          Nirmal Fernando
        42. DERBY-4587-tool-9.5.diff
          67 kB
          Nirmal Fernando
        43. DERBY-4587-tool-9.6.diff
          68 kB
          Nirmal Fernando
        44. advancedXSL-1.jpg
          65 kB
          Nirmal Fernando
        45. advancedXSL-2.jpg
          118 kB
          Nirmal Fernando
        46. advancedXSL-3.jpg
          138 kB
          Nirmal Fernando
        47. advancedViewXSL.xsl
          4 kB
          Nirmal Fernando
        48. AdavancedXSL-mouseover.jpg
          86 kB
          Nirmal Fernando
        49. advancedViewXSL.xsl
          4 kB
          Nirmal Fernando
        50. advancedViewXSL2.xsl
          4 kB
          Nirmal Fernando
        51. DERBY-4587-tool-9.7.diff
          81 kB
          Nirmal Fernando
        52. DERBY-4587-tool-9.7.diff
          82 kB
          Nirmal Fernando
        53. DERBY-4587-javadoc_fix.diff
          0.3 kB
          Nirmal Fernando
        54. DERBY-4587-tool-9.8.diff
          34 kB
          Nirmal Fernando
        55. DERBY-4587-tool-9.8-modified.diff
          33 kB
          Kristian Waagan
        56. DERBY-4587-tool-9.9-formatting.diff
          84 kB
          Kristian Waagan
        57. DERBY-4587-tool-9.10-eol_style_native.diff
          2 kB
          Kristian Waagan
        58. DERBY-4587-tool-9.11-license_header_inXSL.diff
          3 kB
          Nirmal Fernando
        59. DERBY-4587-tool-9.12.diff
          4 kB
          Nirmal Fernando
        60. DERBY-4587-tool-9.12.diff
          4 kB
          Nirmal Fernando
        61. DERBY-4587-tool-9.12.diff
          16 kB
          Nirmal Fernando

          Issue Links

            Activity

              People

              • Assignee:
                nirmal Nirmal Fernando
                Reporter:
                bryanpendleton Bryan Pendleton
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: