We have some materialized views that crunch them periodically e.g. permalink to user_stats_days

This part of the project is relatively unapproachable tbh. There's a lot of implied context (bad) in the DB schema. I don't want to scare you, but in case you're confused, it's our fault.