search

certinia / debug-log-analyzer

Salesforce Apex debug log analyzer for Visual Studio Code - Visualize code execution via a Flame chart and identify performance and SOQL/DML problems via Method and Database analysis
https://marketplace.visualstudio.com/items?itemName=financialforce.lana
BSD 3-Clause "New" or "Revised" License
84 stars 18 forks source link

feat: improved handling of sub queries #173

Open lcottercertinia opened 2 years ago

lcottercertinia commented 2 years ago

Is your feature request related to a problem?

The rows included on a sub query count towards SOQL limits but are not shown on the DB tab. It would be great if they were for example SOQL_EXECUTE_EXPLAIN|[14]|Other on MYSObject__c : [], cardinality: 1000, sobjectCardinality: 4500000, relativeCost 0.004

Describe the solution you'd like

Use the SOQL explain to show sub query row counts. The problem this could cause is is the explain is not present or SF do not include it in the log for some reason. Can we get it some other way? What are the rules for it being included?

Sometimes we just get this SOQL_EXECUTE_EXPLAIN|[61]|No explain plan is available

jwoodwardcertinia commented 2 years ago

If you see No explain plan is available I think we should explain that the query rows value we show is a minimum and might be more. And then any totals we calculate from it. Perhaps you could do all that with the greater than symbol?