explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PqvK8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=7,432,446.84..7,432,446.88 rows=1 width=229) (actual rows= loops=)

2.          

Initplan (for Unique)

3. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=65,258.27..65,258.28 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Gather (cost=65,258.05..65,258.26 rows=2 width=32) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=64,258.05..64,258.06 rows=1 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on p62_ct_erbegleitwert_stg stg (cost=0.00..62,571.64 rows=674,564 width=6) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=7,367,188.56..7,367,188.57 rows=1 width=229) (actual rows= loops=)

  • Sort Key: p62_ct_erbegleitwert_stg.hk_h_ereignis, p62_ct_erbegleitwert_stg.datumletzteaenderung, p62_ct_erbegleitwert_stg.version, p62_ct_erbegleitwert_stg.erbwid, p62_ct_erbegleitwert_stg.erbwbez, p62_ct_erbegleitwert_stg.erbwert, p62_ct_erbegleitwert_stg.erbwtext, p62_ct_erbegleitwert_stg.erbwzeitutc, p62_ct_erbegleitwert_stg.erbwzeit, p62_ct_erbegleitwert_stg."cscn$", p62_ct_erbegleitwert_stg.dss_change_hash_p62, p62_ct_erbegleitwert_stg.dss_record_source, ((p62_ct_erbegleitwert_stg.dss_load_date + (((p62_ct_erbegleitwert_stg."cscn$" - $1))::double precision * '00:00:00.000001'::interval))), ((COALESCE((max(ereignis_erbegleitwert_lvn_p62_ms_1.dss_version)), '0'::numeric) + '1'::numeric))
8. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=4,252,683.58..7,367,188.55 rows=1 width=229) (actual rows= loops=)

  • Merge Cond: ((ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis = p62_ct_erbegleitwert_stg.hk_h_ereignis) AND (ereignis_erbegleitwert_lvn_p62_ms_1.erbwid = p62_ct_erbegleitwert_stg.erbwid))
9. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=2,221,706.28..4,992,119.43 rows=22,939,452 width=87) (actual rows= loops=)

  • Group Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
10. 0.000 0.000 ↓ 0.0

Gather Merge (cost=2,221,706.28..4,619,353.33 rows=19,116,210 width=79) (actual rows= loops=)

  • Workers Planned: 2
11. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=2,220,706.26..2,411,868.36 rows=9,558,105 width=79) (actual rows= loops=)

  • Group Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
12. 0.000 0.000 ↓ 0.0

Sort (cost=2,220,706.26..2,244,601.52 rows=9,558,105 width=52) (actual rows= loops=)

  • Sort Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on ereignis_erbegleitwert_lvn_p62_ms ereignis_erbegleitwert_lvn_p62_ms_1 (cost=0.00..785,832.05 rows=9,558,105 width=52) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Sort (cost=2,030,977.30..2,030,977.31 rows=1 width=181) (actual rows= loops=)

  • Sort Key: p62_ct_erbegleitwert_stg.hk_h_ereignis, p62_ct_erbegleitwert_stg.erbwid
15. 0.000 0.000 ↓ 0.0

Gather (cost=1,578,363.30..2,030,977.29 rows=1 width=181) (actual rows= loops=)

  • Workers Planned: 2
16. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=1,577,363.30..2,029,977.19 rows=1 width=181) (actual rows= loops=)

  • Hash Cond: ((p62_ct_erbegleitwert_stg.hk_h_ereignis = ereignis_erbegleitwert_lvn_p62_ms.hk_h_ereignis) AND (p62_ct_erbegleitwert_stg.dss_change_hash_p62 = ereignis_erbegleitwert_lvn_p62_ms.dss_change_hash))
17. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on p62_ct_erbegleitwert_stg (cost=0.00..62,571.64 rows=674,564 width=181) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=919,645.52..919,645.52 rows=22,939,452 width=82) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on ereignis_erbegleitwert_lvn_p62_ms (cost=0.00..919,645.52 rows=22,939,452 width=82) (actual rows= loops=)