Re: Optimize sub query with large group by

[Rick James]

select  person_id, count(id)
    from  
      ( SELECT  id, person_id
            from  events
            group by  object_id) as subquery
    group by  person_id;

Subqueries are not well optimized. But, before suggesting what to do in this case, let's dissect the subquery; it does not make sense:
SELECT id, person_id
from events
group by object_id
Normally on does a GROUP BY on one of the items in the SELECT list, and the rest of the fields in the SELECT list are 'aggregates' such as MIN(), COUNT(). This GROUP BY comes no where near that.