GroupAggregate (cost=14206.02..16973.61 rows=8849 width=36) (actual time=16.239..41.215 rows=10000 loops=1) Output: accommodation_id, jsonb_agg(jsonb_build_object('date', date, 'price', price)) Group Key: overrides.accommodation_id Buffers: shared hit=6442 -> Gather Merge (cost=14206.02..16702.25 rows=21433 width=13) (actual time=16.215..18.136 rows=20000 loops=1) Output: accommodation_id, date, price Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=6442 -> Sort (cost=13206.00..13228.33 rows=8930 width=13) (actual time=14.416..14.629 rows=6667 loops=3) Output: accommodation_id, date, price Sort Key: overrides.accommodation_id Sort Method: quicksort Memory: 424kB Buffers: shared hit=6442 Worker 0: actual time=13.574..13.780 rows=6267 loops=1 Sort Method: quicksort Memory: 388kB Buffers: shared hit=2037 Worker 1: actual time=13.768..13.981 rows=6339 loops=1 Sort Method: quicksort Memory: 391kB Buffers: shared hit=2050 -> Parallel Seq Scan on public.overrides (cost=0.00..12619.99 rows=8930 width=13) (actual time=0.024..13.580 rows=6667 loops=3) Output: accommodation_id, date, price Filter: ((overrides.date >= '2025-07-01'::date) AND (overrides.date < '2025-07-08'::date)) Rows Removed by Filter: 326666 Buffers: shared hit=6370 Worker 0: actual time=0.011..12.728 rows=6267 loops=1 Buffers: shared hit=2001 Worker 1: actual time=0.051..12.968 rows=6339 loops=1 Buffers: shared hit=2014 Planning: Buffers: shared hit=129 Planning Time: 0.274 ms Execution Time: 41.571 ms