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

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development