How to assemble the equivalent of the following request with an ORM?

Question

Django

select count(*) as total, count(distinct(uuid)) as uniq from visits;

With the help of orm, I can’t collect something - when using annotate, group by is added. I tried with union - I don't understand how to collect count()'s

Answer 1

So not annotate is needed, but aggregate