Page MenuHomeSoftware Heritage
Paste P977

raw_extrinsic_metadata discrepancies
ActivePublic

Authored by olasd on Mar 17 2021, 7:46 PM.
softwareheritage=> select target, discovery_date from raw_extrinsic_metadata rem where not exists (select 1 from raw_extrinsic_metadata_new remn where date_trunc('second', remn.discovery_date) = date_trunc('second', rem.discovery_date) and remn.target = case when rem.target LIKE 'swh:1:%' then rem.target else 'swh:1:ori:' || encode(digest(rem.target, 'sha1'), 'hex') end) order by target;
target | discovery_date
----------------------------------------------------+-------------------------------
swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | 2021-03-16 00:03:03.765938+00
swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | 2021-03-16 16:41:37.093553+00
swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | 2021-03-17 08:35:08.951465+00
swh:1:emd:89db1bf13f0036d8f707549d8e5ec15454febf33 | 2021-03-17 08:35:08.951465+00
(4 lignes)
Durée : 42091,308 ms (00:42,091)