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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: