Uploaded image for project: 'Blazegraph (by SYSTAP)'
  1. Blazegraph (by SYSTAP)
  2. BLZG-205 Improved EXPLAIN page
  3. BLZG-1452

Add annotations to the AST to support EXPLAIN improvements that we will implement now.

    Details

    • Type: Sub-task
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: BLAZEGRAPH_RELEASE_1_5_3
    • Component/s: None
    • Labels:
      None

      Activity

      Hide
      michaelschmidt michaelschmidt added a comment -

      See pull request for branch improved-explain, please review @bryanthompson .

      Implemented first version of improved EXPLAIN, as documented at https://docs.google.com/spreadsheets/d/1EcpsimlsObw5fe3h7oCRF79EtG9TAmdaCfZ7KotvbCQ/edit#gid=1811786356. Currently, the explain output is rendered as part of the explain in a dedicated section, labelled "ExplainHints". The output is in the form of a simple table for now and might be further improved, in case you feel this is required it is something maginfo could take over as part of the explain page refactoring under discussion.

      Currently, explain hints are implemented for the following patterns (as sketched in the Google Doc above):

      • Variables that are not in scope due to bottom-up semantics
      • Unsatisfiable MINUS expressions
      • Possible problems with join group reordering

      The implementation contains a set of test cases covering these scenarios above. See the associated test cases for sample queries that cause such hints to be attached.

      Show
      michaelschmidt michaelschmidt added a comment - See pull request for branch improved-explain, please review @bryanthompson . Implemented first version of improved EXPLAIN, as documented at https://docs.google.com/spreadsheets/d/1EcpsimlsObw5fe3h7oCRF79EtG9TAmdaCfZ7KotvbCQ/edit#gid=1811786356 . Currently, the explain output is rendered as part of the explain in a dedicated section, labelled "ExplainHints". The output is in the form of a simple table for now and might be further improved, in case you feel this is required it is something maginfo could take over as part of the explain page refactoring under discussion. Currently, explain hints are implemented for the following patterns (as sketched in the Google Doc above): Variables that are not in scope due to bottom-up semantics Unsatisfiable MINUS expressions Possible problems with join group reordering The implementation contains a set of test cases covering these scenarios above. See the associated test cases for sample queries that cause such hints to be attached.
      Hide
      michaelschmidt michaelschmidt added a comment -

      Added links to a dedicated "Explain" page in the wiki (i.e., subsections of this page). Merging down into master (CI is clean).

      Show
      michaelschmidt michaelschmidt added a comment - Added links to a dedicated "Explain" page in the wiki (i.e., subsections of this page). Merging down into master (CI is clean).

        People

        • Assignee:
          michaelschmidt michaelschmidt
          Reporter:
          bryanthompson bryanthompson
        • Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

          Dates

          • Created:
            Updated:
            Resolved: