Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25956

SHOW EXPLAIN FOR should support FORMAT=JSON

Details

    Description

      EXPLAIN FORMAT=JSON and ANALYZE FORMAT=JSON contain a treasure trove of information that non-json output does not convey.

      I think it would be nice for SHOW EXPLAIN FOR to support FORMAT=JSON output for better feature parity with EXPLAIN.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-27021 Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON]

          • Major - Major loss of function.
          • Closed

          Activity

            psergei Sergei Petrunia added a comment -

            Ok, MDEV-27021 has been pushed into 10.9 tree and it includes support for SHOW EXPLAIN FORMAT=JSON (and for SHOW ANALYZE FORMAT=JSON).

            psergei Sergei Petrunia added a comment - Ok, MDEV-27021 has been pushed into 10.9 tree and it includes support for SHOW EXPLAIN FORMAT=JSON (and for SHOW ANALYZE FORMAT=JSON).

            People

              Unassigned Unassigned
              vpelletier_nxd Vincent Pelletier
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.