When loading a view of all event types in Multimeter, the existing "(eventType, epoch)" key may not be useful.

After bringing secure back online, I identified a crawler scraping Multimeter and causing this query to issue:

SELECT *,
  count(*) AS N,
  SUM(sampleRate * resourceCost) AS totalCost,
  SUM(sampleRate * resourceCost) / SUM(sampleRate) AS averageCost
FROM `multimeter_event`
WHERE (epoch >= 1779800130 AND epoch <= 1779886530)
GROUP BY `eventType`
ORDER BY totalCost DESC, MAX(id) DESC
LIMIT 100;

This took 30+ seconds to resolve. This is partly because the GC for this table hasn't run in a while and the sample rate on this host is very high, but adding the epoch key made the query instantaneous.

(I also restricted Multimeter access to logged-in users.)

Static checks only, still bootstrapping secure and my local environment.