[10:03:29] <wikibugs>	 10DBA, 10Cloud-VPS, 10Data-Services, 10Tool-spacemedia: Queries of commonswiki_p.filearchive for fa_sha1 are slow - https://phabricator.wikimedia.org/T71088 (10Don-vip)
[10:40:54] <wikibugs>	 10DBA, 10Cloud-VPS, 10Data-Services, 10Tool-spacemedia: Queries of commonswiki_p.filearchive for fa_sha1 are slow - https://phabricator.wikimedia.org/T71088 (10Don-vip) Is there any way to quickly detect if a SHA-1 has been previously deleted? It's currently possible through the view replica, but it's pain...
[22:49:13] <wikibugs>	 10DBA, 10Cloud-VPS, 10Data-Services, 10Tool-spacemedia: Queries of commonswiki_p.filearchive for fa_sha1 are slow - https://phabricator.wikimedia.org/T71088 (10Platonides) There //is// an API which allows you to look up deleted files by hash: https://commons.wikimedia.org/w/api.php?action=query&list=filear...