INSERT QUERY PLAN

EXPLAIN ANALYSE SELECT
        DISTINCT ON
        (A.uniquekey) A.codglacct,
        A.refusrno,
        A.key_priority_radcs,
        A.recon_created_date,
        A.dattxnposting,
        A.status,
        A.uniquekey,
        A.coddrcr,
        A.cbsacqiss,
        A.codacctno,
        A.amttxnlcy,
        A.acnotrim,
        A.priority_no,
        A.rrn,
        '2025-01-07 19:50:41' AS recon_updated_date,
        CASE
            WHEN C.key_priority_rtdps IS NOT NULL THEN '2025-01-07 19:50:41'
            ELSE NULL
        END::TIMESTAMP AS recon_date_1_to_2,
        CASE
            WHEN D.key_priority_ratrs IS NOT NULL THEN '2025-01-07 19:50:41'
            ELSE NULL
        END::TIMESTAMP AS recon_date_1_to_3,
        CASE
            WHEN (C.key_priority_rtdps IS NOT NULL
                AND D.key_priority_ratrs IS NOT NULL) THEN '2025-01-07 19:50:41'
            ELSE NULL
        END::TIMESTAMP AS reconciliation_date_time
    FROM
        cbsupi.source_cbsupi_tmp_details A
    LEFT JOIN switchupi.source_switchupi_tmp_details C ON
        (A.key_priority_radcs = C.key_priority_rtdps)
    LEFT JOIN npciupi.source_npciupi_tmp_details D ON
        (A.key_priority_radcs = D.key_priority_ratrs)
    WHERE
        A.is_processed IS NULL;




"QUERY PLAN"
Unique  (cost=10318614.20..18255562.30 rows=62910704 width=806) (actual time=129397.797..262774.560 rows=62910000 loops=1)
  ->  Gather Merge  (cost=10318614.20..18098285.54 rows=62910704 width=806) (actual time=129397.343..236727.386 rows=62910000 loops=1)
        Workers Planned: 8
        Workers Launched: 8
        ->  Sort  (cost=10318613.95..10338273.55 rows=7863838 width=806) (actual time=128122.113..138771.918 rows=6990000 loops=9)
              Sort Key: a.uniquekey
              Sort Method: external merge  Disk: 1347200kB
              Worker 0:  Sort Method: external merge  Disk: 1282520kB
              Worker 1:  Sort Method: external merge  Disk: 1257264kB
              Worker 2:  Sort Method: external merge  Disk: 1297056kB
              Worker 3:  Sort Method: external merge  Disk: 630408kB
              Worker 4:  Sort Method: external merge  Disk: 1296160kB
              Worker 5:  Sort Method: external merge  Disk: 1259704kB
              Worker 6:  Sort Method: external merge  Disk: 1283304kB
              Worker 7:  Sort Method: external merge  Disk: 1339736kB
              ->  Parallel Hash Left Join  (cost=1557448.90..7780659.45 rows=7863838 width=806) (actual time=83538.832..100539.640 rows=6990000 loops=9)
                    Hash Cond: (a.key_priority_radcs = d.key_priority_ratrs)
                    ->  Parallel Hash Left Join  (cost=760312.96..5198493.41 rows=7863838 width=766) (actual time=48900.312..61849.807 rows=6990000 loops=9)
                          Hash Cond: (a.key_priority_radcs = c.key_priority_rtdps)
                          ->  Parallel Seq Scan on source_cbsupi_tmp_details a  (cost=0.00..2813886.38 rows=7863838 width=750) (actual time=0.206..27053.837 rows=6990000 loops=9)
                                Filter: (is_processed IS NULL)
                          ->  Parallel Hash  (cost=629943.08..629943.08 rows=7499910 width=16) (actual time=11669.051..11669.657 rows=6666667 loops=9)
                                Buckets: 8388608  Batches: 16  Memory Usage: 241792kB
                                ->  Parallel Index Only Scan using source_switchupi_tmp_details_key_priority_rtdps_idx on source_switchupi_tmp_details c  (cost=0.56..629943.08 rows=7499910 width=16) (actual time=1.962..9533.735 rows=6666667 loops=9)
                                      Heap Fetches: 0
                    ->  Parallel Hash  (cost=660443.34..660443.34 rows=7863648 width=16) (actual time=13277.728..13278.002 rows=6990000 loops=9)
                          Buckets: 8388608  Batches: 16  Memory Usage: 250304kB
                          ->  Parallel Index Only Scan using source_npciupi_tmp_details_key_priority_ratrs_idx on source_npciupi_tmp_details d  (cost=0.56..660443.34 rows=7863648 width=16) (actual time=1.068..10753.917 rows=6990000 loops=9)
                                Heap Fetches: 0
Planning Time: 125.405 ms
JIT:
  Functions: 146
"  Options: Inlining true, Optimization true, Expressions true, Deforming true"
"  Timing: Generation 79.062 ms, Inlining 962.843 ms, Optimization 1375.806 ms, Emission 1317.260 ms, Total 3734.970 ms"
Execution Time: 265772.727 ms