EXPLAIN JSON output in slow query log
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
Aaditya Dubey April 2, 2024 at 7:12 AM
Hi
Thank you for the report and feedback.
Details
Details
Assignee
Unassigned
UnassignedReporter
Matthew Boehm
Matthew BoehmNeeds QA
Yes
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created April 1, 2024 at 5:01 PM
Updated April 2, 2024 at 7:12 AM
(Feature request opened on behalf of customer.)
Re: https://mariadb.com/kb/en/explain-in-the-slow-query-log/
Please port this feature to Percona Server. We would like to have the EXPLAIN JSON output for each query in the slow query log. Having the EXPLAIN output for every query would help us diagnose specific query issues, and even see historical query plans (ie: problem happened at 2AM, but running EXPLAIN at 9AM shows no issues).