It will be nice to monitor the adaptive intervals of visits for all our origins.
The visits sorted by intervals are returned by the following query (on the softwareheritage-scheduler DB), see P58:
select current_interval, count(*) from task group by current_interval order by current_interval; softwareheritage-scheduler=> select current_interval, count(*) from task group by current_interval order by current_interval; current_interval | count ------------------+--------- 12:00:00 | 961 1 day | 51374 2 days | 61265 4 days | 527019 8 days | 8575817 16 days | 3228828 32 days | 1879803
and a sample munin plugin that can be used as template is at prado:/usr/local/bin/softwareheritage_objects_ (hat tip to @olasd).
Info on how to add the plugin when ready (from an IRC conversation):
(16:49:35) olasd: the trailing underscore means it's a "template" plugin (16:49:42) olasd: so you can have several instances of it (16:49:54) olasd: e.g. when you want to be able to monitor several databases (16:50:26) olasd: to add the plugin to munin, you add a /etc/munin/plugins/foo_<dbname> link to /usr/local/bin/foo_ (16:50:35) olasd: and restart munin-node (16:51:28) olasd: (stock munin plugins are in /usr/share/munin/plugins but I didn't really want to do /usr/local/share/munin/plugins, although that'd probably be clearer)