latest_status | count  
---------------+--------
               | 251755
 partial       |  18004
 full          | 232641
 ongoing       |   1110

select origin_type, count(*) from bitbucket_repo group by origin_type;

with origin_latest_visit as (
  select
    origin.url,
    (select status
     from origin_visit
     where
       origin_visit.origin = origin.id 
       and origin_visit.type = 'hg'
     order by date desc 
     limit 1) as latest_status
  from origin
  where origin.url like 'https://bitbucket.org/%'
) select latest_status, count(*)
  from origin_latest_visit
  where latest_status is not null  -- filter out non-mercurial origins
  group by rollup(latest_status);  -- rollup adds a row with a null latest_status containing the sum of all rows