Object counters pipelinepergamonapache2momabelvederepostgresql/softwareheritagerest_api/var/www/stats.export.softwareheritage.org/history_counters.json/usr/local/share/swh-data/history_counters.munin.jsonexport from oldmunin monitoring/usr/local/bin/export_archive_counters.pyexecuted once a dayvia a crontabprometheusprometheus_serverstats.export.softwareheritage.orgwebappprometheus_sql_exportercron29 2-22/4 * * *psqlobject_countsobject_tablesobject_counts_bucketedswh_update_counters_from_bucketsupdate_counts_from_bucketedswh_update_counter_bucketedUpdate one bucket ata time, older firstswh_update_counter/stat/refreshbrowserLoad historical dataAggregate sql_swh_archive_object_countby 12h steps sincethe 11/12/2018 à 15:47:07read metrics includingsql_swh_archive_object_countread countersfor contents:directorydirectory_entry_dirdirectory_entry_filedirectory_entry_revoriginorigin_visitpersonreleaserevisionrevision_historyskipped_contentsnapshotfor existing counterssingle_update=trueinsert/updatecounts per objectselect count(*)per objecttrigger oninsert/updateeach 256 changesOverride all valuesfrom bucketsinfiniteloopupdate the bucketfor the rangecount objectsper range