Untitled

Hash Join  (cost=223854.78..513237.75 rows=2747730 width=1273) (actual time=98622.205..98622.214 rows=0 loops=1)
  Hash Cond: ((p.reference_id)::text = (o.order_id)::text)
  ->  Append  (cost=0.00..244388.90 rows=5495460 width=1273) (actual time=0.010..0.012 rows=1 loops=1)
"        ->  Seq Scan on ""payment_2022-07"" p_1  (cost=0.00..145968.22 rows=3702422 width=1280) (actual time=0.010..0.010 rows=1 loops=1)"
"        ->  Seq Scan on ""payment_2022-08"" p_2  (cost=0.00..70882.78 rows=1792978 width=1258) (never executed)"
"        ->  Seq Scan on ""payment_2022-09"" p_3  (cost=0.00..10.10 rows=10 width=4303) (never executed)"
"        ->  Seq Scan on ""payment_2022-10"" p_4  (cost=0.00..10.10 rows=10 width=4303) (never executed)"
"        ->  Seq Scan on ""payment_2022-11"" p_5  (cost=0.00..10.10 rows=10 width=4303) (never executed)"
"        ->  Seq Scan on ""payment_2022-12"" p_6  (cost=0.00..10.10 rows=10 width=4303) (never executed)"
"        ->  Seq Scan on ""payment_2023-01"" p_7  (cost=0.00..10.10 rows=10 width=4303) (never executed)"
"        ->  Seq Scan on ""payment_2023-02"" p_8  (cost=0.00..10.10 rows=10 width=4303) (never executed)"
  ->  Hash  (cost=223852.28..223852.28 rows=200 width=37) (actual time=98622.186..98622.192 rows=0 loops=1)
        Buckets: 1024  Batches: 1  Memory Usage: 8kB
        ->  HashAggregate  (cost=223850.28..223852.28 rows=200 width=37) (actual time=98622.185..98622.191 rows=0 loops=1)
              Group Key: (o.order_id)::text
              Batches: 1  Memory Usage: 40kB
              ->  Nested Loop  (cost=216837.41..217252.50 rows=2639112 width=37) (actual time=98622.181..98622.186 rows=0 loops=1)
                    ->  HashAggregate  (cost=216836.98..216838.98 rows=200 width=16) (actual time=2744.169..6968.484 rows=5313710 loops=1)
                          Group Key: ov.uuid
                          Batches: 261  Memory Usage: 4161kB  Disk Usage: 215864kB
                          ->  Append  (cost=0.00..203552.55 rows=5313770 width=16) (actual time=0.002..1195.957 rows=5313710 loops=1)
"                                ->  Seq Scan on ""order_vendor_2022-07"" ov_1  (cost=0.00..119055.86 rows=3578686 width=16) (actual time=0.002..514.618 rows=3578686 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2022-08"" ov_2  (cost=0.00..57867.24 rows=1735024 width=16) (actual time=0.006..249.334 rows=1735024 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2022-09"" ov_3  (cost=0.00..10.10 rows=10 width=16) (actual time=0.004..0.004 rows=0 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2022-10"" ov_4  (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.002 rows=0 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2022-11"" ov_5  (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.001 rows=0 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2022-12"" ov_6  (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.001 rows=0 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2023-01"" ov_7  (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.001 rows=0 loops=1)"
"                                ->  Seq Scan on ""order_vendor_2023-02"" ov_8  (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.001 rows=0 loops=1)"
                    ->  Append  (cost=0.43..1.99 rows=8 width=53) (actual time=0.017..0.017 rows=0 loops=5313710)
"                          ->  Index Scan using ""orders_2022-07_pkey"" on ""orders_2022-07"" o_1  (cost=0.43..0.54 rows=1 width=53) (actual time=0.004..0.004 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2022-08_pkey"" on ""orders_2022-08"" o_2  (cost=0.43..0.49 rows=1 width=53) (actual time=0.003..0.003 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2022-09_pkey"" on ""orders_2022-09"" o_3  (cost=0.14..0.15 rows=1 width=532) (actual time=0.001..0.001 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2022-10_pkey"" on ""orders_2022-10"" o_4  (cost=0.14..0.15 rows=1 width=532) (actual time=0.001..0.001 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2022-11_pkey"" on ""orders_2022-11"" o_5  (cost=0.14..0.15 rows=1 width=532) (actual time=0.001..0.001 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2022-12_pkey"" on ""orders_2022-12"" o_6  (cost=0.14..0.15 rows=1 width=532) (actual time=0.001..0.001 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2023-01_pkey"" on ""orders_2023-01"" o_7  (cost=0.14..0.15 rows=1 width=532) (actual time=0.001..0.001 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
"                          ->  Index Scan using ""orders_2023-02_pkey"" on ""orders_2023-02"" o_8  (cost=0.14..0.15 rows=1 width=532) (actual time=0.001..0.001 rows=0 loops=5313710)"
                                Index Cond: (uuid = ov.uuid)
Planning Time: 1.309 ms
Execution Time: 98665.033 ms