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.

      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

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development