>
>
> On Sat, 15 Jun 2024 at 6:54 PM, sud wrote:
>
>> Hello All,
>>
>> Its postgres version 15.4. We are having a requirement in which
>> aggregated information for all the users has to be displayed on the UI
>> screen. It should show that information on the screen. So basically, it
>> would be sc
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,
