Columnar Format Export in Postgres

Hey Postgres team, I have been working on adding support for columnar format export to Postgres to speed up analytics queries. I've created an extension that achieves this functionality here . I"m looking to improve the performance of this extension to

Re: Design for dashboard query

Have you tried creating an index on the user ID column? Scanning the entire table to apply granular filters on a few attributes seems unnecessary. Materialised views make sense if you want to aggregate some columns and query a subset of the data but would recommend trying indexes first. Finally,