Type:
Task
Priority:
Minor
Resolution:
Unresolved
Fix Version/s:
None
With MDEV-15777 , we are adding NOT NULL predicates for equi-join conditions, it would be good to print these conditions in the optimizer trace for each table
relates to
MDEV-15777
Use inferred IS NOT NULL predicates in the range optimizer
Closed
There are no comments yet on this issue.
{"report":{"fcp":703.7000007629395,"ttfb":166.5,"pageVisibility":"visible","entityId":76204,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"f97e42f7-b1a3-4468-a5e2-25da7dfbc95a","navigationType":0,"readyForUser":753.2000007629395,"redirectCount":0,"resourceLoadedEnd":701.2000007629395,"resourceLoadedStart":171.80000114440918,"resourceTiming":[{"duration":5.799999237060547,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":171.80000114440918,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.80000114440918,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":177.60000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":5.700000762939453,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":172.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":177.80000114440918,"responseStart":0,"secureConnectionStart":0},{"duration":80.5999984741211,"initiatorType":"script","name":"https://jira.mariadb.org/s/b09d0d077992e4331b5f9ec0d3ec448c-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":172.30000114440918,"connectEnd":172.30000114440918,"connectStart":172.30000114440918,"domainLookupEnd":172.30000114440918,"domainLookupStart":172.30000114440918,"fetchStart":172.30000114440918,"redirectEnd":0,"redirectStart":0,"requestStart":184,"responseEnd":252.89999961853027,"responseStart":207.30000114440918,"secureConnectionStart":172.30000114440918},{"duration":90.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/b47ab3df14096803b180217eb8482517-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":172.39999961853027,"connectEnd":172.39999961853027,"connectStart":172.39999961853027,"domainLookupEnd":172.39999961853027,"domainLookupStart":172.39999961853027,"fetchStart":172.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":184.5,"responseEnd":262.5,"responseStart":212.80000114440918,"secureConnectionStart":172.39999961853027},{"duration":34.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/s/6c569cbf8087ab04e40d0bef98627457-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":172.5,"connectEnd":172.5,"connectStart":172.5,"domainLookupEnd":172.5,"domainLookupStart":172.5,"fetchStart":172.5,"redirectEnd":0,"redirectStart":0,"requestStart":185,"responseEnd":207.20000076293945,"responseStart":206.60000038146973,"secureConnectionStart":172.5},{"duration":44.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":172.60000038146973,"connectEnd":172.60000038146973,"connectStart":172.60000038146973,"domainLookupEnd":172.60000038146973,"domainLookupStart":172.60000038146973,"fetchStart":172.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":186.39999961853027,"responseEnd":216.70000076293945,"responseStart":216.20000076293945,"secureConnectionStart":172.60000038146973},{"duration":13.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":172.80000114440918,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.80000114440918,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":186.30000114440918,"responseStart":0,"secureConnectionStart":0},{"duration":53.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":172.80000114440918,"connectEnd":172.80000114440918,"connectStart":172.80000114440918,"domainLookupEnd":172.80000114440918,"domainLookupStart":172.80000114440918,"fetchStart":172.80000114440918,"redirectEnd":0,"redirectStart":0,"requestStart":186.5,"responseEnd":226.70000076293945,"responseStart":226.10000038146973,"secureConnectionStart":172.80000114440918},{"duration":63.400001525878906,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":172.89999961853027,"connectEnd":172.89999961853027,"connectStart":172.89999961853027,"domainLookupEnd":172.89999961853027,"domainLookupStart":172.89999961853027,"fetchStart":172.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":188.30000114440918,"responseEnd":236.30000114440918,"responseStart":235.70000076293945,"secureConnectionStart":172.89999961853027},{"duration":14.80000114440918,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":173,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":187.80000114440918,"responseStart":0,"secureConnectionStart":0},{"duration":65.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":173.10000038146973,"connectEnd":173.10000038146973,"connectStart":173.10000038146973,"domainLookupEnd":173.10000038146973,"domainLookupStart":173.10000038146973,"fetchStart":173.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":189.5,"responseEnd":238.60000038146973,"responseStart":236.39999961853027,"secureConnectionStart":173.10000038146973},{"duration":518,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":180.89999961853027,"connectEnd":180.89999961853027,"connectStart":180.89999961853027,"domainLookupEnd":180.89999961853027,"domainLookupStart":180.89999961853027,"fetchStart":180.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":205.5,"responseEnd":698.8999996185303,"responseStart":692.3999996185303,"secureConnectionStart":180.89999961853027},{"duration":520.2000007629395,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":181,"connectEnd":181,"connectStart":181,"domainLookupEnd":181,"domainLookupStart":181,"fetchStart":181,"redirectEnd":0,"redirectStart":0,"requestStart":220.70000076293945,"responseEnd":701.2000007629395,"responseStart":693,"secureConnectionStart":181},{"duration":155.70000076293945,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":463.8999996185303,"connectEnd":463.8999996185303,"connectStart":463.8999996185303,"domainLookupEnd":463.8999996185303,"domainLookupStart":463.8999996185303,"fetchStart":463.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":584.2000007629395,"responseEnd":619.6000003814697,"responseStart":618.3999996185303,"secureConnectionStart":463.8999996185303},{"duration":25.299999237060547,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":676.7000007629395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":676.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":702,"responseStart":0,"secureConnectionStart":0},{"duration":59.79999923706055,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":694.7000007629395,"connectEnd":694.7000007629395,"connectStart":694.7000007629395,"domainLookupEnd":694.7000007629395,"domainLookupStart":694.7000007629395,"fetchStart":694.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":720.3999996185303,"responseEnd":754.5,"responseStart":753.7000007629395,"secureConnectionStart":694.7000007629395}],"fetchStart":0,"domainLookupStart":22,"domainLookupEnd":28,"connectStart":28,"connectEnd":47,"secureConnectionStart":36,"requestStart":47,"responseStart":166,"responseEnd":179,"domLoading":170,"domInteractive":800,"domContentLoadedEventStart":800,"domContentLoadedEventEnd":837,"domComplete":1075,"loadEventStart":1075,"loadEventEnd":1075,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":784.6000003814697},{"name":"bigPipe.sidebar-id.end","time":785.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":785.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":786},{"name":"activityTabFullyLoaded","time":847.6000003814697}],"measures":[],"correlationId":"6f808c97864c07","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":69,"dbReadsTimeInMs":12,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}