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

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

    XMLWordPrintableJSON

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

        Issue Links

          incorporates

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4766 Redesign the PlanExporter tool API for simplicity

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4768 Create template style sheets for PlanExporter tool and copy those templates into demo/templates as part of building a release

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4775 Allow exporting of multiple query plans in a single operation of PlanExporter Tool

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4783 Add all data in XPlain tables into the XML file generated by PlanExporter Tool

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • In Progress
          is depended upon by

          Sub-task - The sub-task of the issue DERBY-4758 Adding documentation about the PlanExporter Tool

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4902 Encoding problem in output from plan exporter

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          There are no Sub-Tasks for this issue.

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: