Fast, Flexible Summaries with Aggregate Filters in PostgreSQL(blog.crunchydata.com)

https://blog.crunchydata.com/blog/fast-flexible-summaries-with-aggregate-filters-and-windows