22:07 guest@softwareheritage => select extid_type, count(distinct extid) from extid e1 where exists (select 1 from extid e2 where e1.extid = e2.extid and e1.extid_type = e2.extid_type and e1.target < e2.target) group by extid_type;
      extid_type       │  count  
───────────────────────┼─────────
 cran-sha256           │       7
 hg-nodeid             │ 2691404
 npm-archive-sha1      │   11362
 pypi-archive-sha256   │    4551
 subresource-integrity │      26
(5 lignes)

Durée : 318259,288 ms (05:18,259)