Type:
Task
Priority:
Minor
Resolution:
Done
Development tasks:
MDEV-406 ANALYZE $stmt
MDEV-6388 ANALYZE $stmt output in the slow query log
MDEV-6382 ANALYZE $stmt and security
MDEV-6109 EXPLAIN JSON
Need to check also for
{"report":{"fcp":791.1999998092651,"ttfb":188,"pageVisibility":"visible","entityId":40301,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"44a3a11c-b6f7-4136-92ee-af8dcc3dacfe","navigationType":0,"readyForUser":867.0999999046326,"redirectCount":0,"resourceLoadedEnd":750,"resourceLoadedStart":194.40000009536743,"resourceTiming":[{"duration":147.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":194.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":341.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":147.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":194.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":341.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":155.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":194.80000019073486,"connectEnd":194.80000019073486,"connectStart":194.80000019073486,"domainLookupEnd":194.80000019073486,"domainLookupStart":194.80000019073486,"fetchStart":194.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":194.80000019073486,"responseEnd":350.59999990463257,"responseStart":350.59999990463257,"secureConnectionStart":194.80000019073486},{"duration":220.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":195,"connectEnd":195,"connectStart":195,"domainLookupEnd":195,"domainLookupStart":195,"fetchStart":195,"redirectEnd":0,"redirectStart":0,"requestStart":195,"responseEnd":415.5,"responseStart":415.5,"secureConnectionStart":195},{"duration":224,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":195.19999980926514,"connectEnd":195.19999980926514,"connectStart":195.19999980926514,"domainLookupEnd":195.19999980926514,"domainLookupStart":195.19999980926514,"fetchStart":195.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":195.19999980926514,"responseEnd":419.19999980926514,"responseStart":419.19999980926514,"secureConnectionStart":195.19999980926514},{"duration":224.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":195.40000009536743,"connectEnd":195.40000009536743,"connectStart":195.40000009536743,"domainLookupEnd":195.40000009536743,"domainLookupStart":195.40000009536743,"fetchStart":195.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":195.40000009536743,"responseEnd":419.69999980926514,"responseStart":419.69999980926514,"secureConnectionStart":195.40000009536743},{"duration":224.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":195.5,"connectEnd":195.5,"connectStart":195.5,"domainLookupEnd":195.5,"domainLookupStart":195.5,"fetchStart":195.5,"redirectEnd":0,"redirectStart":0,"requestStart":195.5,"responseEnd":420.09999990463257,"responseStart":420.09999990463257,"secureConnectionStart":195.5},{"duration":294.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":195.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":195.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":490.5,"responseStart":0,"secureConnectionStart":0},{"duration":224.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":195.90000009536743,"connectEnd":195.90000009536743,"connectStart":195.90000009536743,"domainLookupEnd":195.90000009536743,"domainLookupStart":195.90000009536743,"fetchStart":195.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":195.90000009536743,"responseEnd":420.69999980926514,"responseStart":420.69999980926514,"secureConnectionStart":195.90000009536743},{"duration":294.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":196.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":196.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":490.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":225.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":196.19999980926514,"connectEnd":196.19999980926514,"connectStart":196.19999980926514,"domainLookupEnd":196.19999980926514,"domainLookupStart":196.19999980926514,"fetchStart":196.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":196.19999980926514,"responseEnd":421.30000019073486,"responseStart":421.30000019073486,"secureConnectionStart":196.19999980926514},{"duration":295.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":198,"connectEnd":198,"connectStart":198,"domainLookupEnd":198,"domainLookupStart":198,"fetchStart":198,"redirectEnd":0,"redirectStart":0,"requestStart":198,"responseEnd":493.19999980926514,"responseStart":493.19999980926514,"secureConnectionStart":198},{"duration":298.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":198.09999990463257,"connectEnd":198.09999990463257,"connectStart":198.09999990463257,"domainLookupEnd":198.09999990463257,"domainLookupStart":198.09999990463257,"fetchStart":198.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":198.09999990463257,"responseEnd":496.59999990463257,"responseStart":496.59999990463257,"secureConnectionStart":198.09999990463257},{"duration":20.300000190734863,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":517.1999998092651,"connectEnd":517.1999998092651,"connectStart":517.1999998092651,"domainLookupEnd":517.1999998092651,"domainLookupStart":517.1999998092651,"fetchStart":517.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":517.1999998092651,"responseEnd":537.5,"responseStart":537.5,"secureConnectionStart":517.1999998092651},{"duration":209.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":540.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":540.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":750,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":17,"responseStart":188,"responseEnd":192,"domLoading":191,"domInteractive":921,"domContentLoadedEventStart":921,"domContentLoadedEventEnd":967,"domComplete":1883,"loadEventStart":1883,"loadEventEnd":1885,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":904.0999999046326},{"name":"bigPipe.sidebar-id.end","time":904.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":905.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":907.5},{"name":"activityTabFullyLoaded","time":974.0999999046326}],"measures":[],"correlationId":"6163609e84f706","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":115,"dbReadsTimeInMs":25,"dbConnsTimeInMs":36,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}