SELECT objtype
     , plans = COUNT_BIG(*)
     , size_mb = CAST(SUM(size_in_bytes) / 1024. / 1024 AS DECIMAL(18,2))
     , size1_mb = CAST(SUM((CASE WHEN usecounts = 1 THEN size_in_bytes ELSE 0 END)) / 1024. / 1024 AS DECIMAL(18,2))
     , plans1 = COUNT_BIG(CASE WHEN usecounts = 1 THEN 1 END)
FROM sys.dm_exec_cached_plans
GROUP BY objtype
ORDER BY size_mb DESC