2

While going through Execution Overview in Developer Console, I noticed a new kind of limit, called AGGS. It may not be new, but I never paid attention to it. I tried to find out more about it, but no luck. Even in the governor limits documentation, there is no mention of it. Basically there is no limit with 300 count in the whole set of limits.

I highlighted it in the below screenshots:

From Execution Overview:

enter image description here

In the raw log:

enter image description here

1 Answer 1

4

Seems to correspond to the Limits.getAggregateQueries() method.

See also: What does Limits.getAggregateQueries() represent?

Cross-referencing with A Deeper look at SOQL and Relationship Queries on Force.com, this limit counts the number of available Left Outer Joins.

I ran this snippet to confirm:

system.debug([
    SELECT 
        (SELECT Name FROM Opportunities),
        (SELECT Name FROM Contacts)
    FROM Account
]);

AGGS Limit

Removing either subquery reduced the limit usage accordingly.

3
  • 1
    That link to a previous question is helpful. 'Aggregate' queries is indeed a very misleading term for parent-child subqueries. I find it weird that it doesn't count if it's part of a semi-join (and probably anti-joins as well).
    – Derek F
    Commented Sep 9, 2016 at 23:16
  • I didn't know that these are counted as aggregate queries. I only think of aggregate soql functions and AggregateResult. Do you now about the 'used so far column'?
    – Avinash
    Commented Sep 9, 2016 at 23:18
  • @AdrianLarson Thank you, I'll create a new question for that. Can you please check the hyper link in the answer. Looks like there is no page.
    – Avinash
    Commented Sep 9, 2016 at 23:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .