From 35 seconds to half a second: 70 faster dashboards in plain Postgres

From 35 seconds to half a second: 70× faster dashboards in plain Postgres Pick "Last 12 months" on an analytics dashboard and Postgres reads every event of the year, once for every panel. At scale, ours took 35 seconds. Now it takes half a second on the same database, thanks to one table and on...

Source: [Dev.to](https://dev.to/devon_theriault_85735c82a/from-35-seconds-to-half-a-second-70x-faster-dashboards-in-plain-postgres-513i)