Free Post TIL PostgreSQL slow with million row aggregation (how to debug) I've refactored my stats aggregator three times now. First try was code-based transformations - 100'000 rows took longer than client browser could wait. Next I ported all the aggregations to