Hash Join  (cost=166′953.18..286′705.36 rows=201′855 width=19) (actual time=3′078.441..4′176.251 rows=198′552 loops=1)
  Hash Cond: (poi."OrderId" = o."OrderId")
  Buffers: shared hit=3 read=160′623
  ->  Seq Scan on processedorder_item poi  (cost=0.00..108′605.28 rows=2′434′228 width=23) (actual time=0.158..667.435 rows=2′434′228 loops=1)
        Buffers: shared read=84′263
  ->  Hash  (cost=164′773.85..164′773.85 rows=174′346 width=4) (actual time=3′077.990..3′077.991 rows=173′668 loops=1)
        Buckets: 262′144 (originally 262′144)  Batches: 1 (originally 1)  Memory Usage: 8154kB
        Buffers: shared read=76′360
        ->  Bitmap Heap Scan on processedorder o  (cost=3′703.48..164′773.85 rows=174′346 width=4) (actual time=27.285..3′028.721 rows=173′668 loops=1)
              Recheck Cond: (("ReceivedDate" >= '2020-09-01 00:00:00'::timestamp without time zone) AND ("ReceivedDate" <= '2021-01-01 00:00:00'::timestamp without time zone))
              Heap Blocks: exact=75′882
              Buffers: shared read=76′360
              ->  Bitmap Index Scan on ix_receiveddate  (cost=0.00..3′659.89 rows=174′346 width=0) (actual time=17.815..17.815 rows=173′668 loops=1)
                    Index Cond: (("ReceivedDate" >= '2020-09-01 00:00:00'::timestamp without time zone) AND ("ReceivedDate" <= '2021-01-01 00:00:00'::timestamp without time zone))
                    Buffers: shared read=478
Planning Time: 3.893 ms
Execution Time: 4′182.162 ms