explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gyRP : erbegleitwert

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 66,232.488 ↓ 0.0 0 1

Unique (cost=7,432,446.84..7,432,446.88 rows=1 width=229) (actual time=66,232.487..66,232.488 rows=0 loops=1)

2.          

Initplan (for Unique)

3. 0.000 0.000 ↓ 0.0 0

Finalize Aggregate (cost=65,258.27..65,258.28 rows=1 width=32) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Gather (cost=65,258.05..65,258.26 rows=2 width=32) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
5. 0.000 0.000 ↓ 0.0 0

Partial Aggregate (cost=64,258.05..64,258.06 rows=1 width=32) (never executed)

6. 0.000 0.000 ↓ 0.0 0

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

7. 0.040 66,232.487 ↓ 0.0 0 1

Sort (cost=7,367,188.56..7,367,188.57 rows=1 width=229) (actual time=66,232.486..66,232.487 rows=0 loops=1)

  • 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))
  • Sort Method: quicksort Memory: 25kB
8. 0.003 66,232.447 ↓ 0.0 0 1

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

  • 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 30,418.934 ↑ 22,939,452.0 1 1

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

  • Group Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
10. 414.788 30,475.997 ↑ 9,558,105.0 2 1

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

  • Workers Planned: 2
  • Workers Launched: 2
11. 0.495 30,061.209 ↑ 18,964.5 504 3 / 3

Partial GroupAggregate (cost=2,220,706.26..2,411,868.36 rows=9,558,105 width=79) (actual time=30,060.414..30,061.209 rows=504 loops=3)

  • Group Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
12. 12,788.720 30,060.714 ↑ 18,852.3 507 3 / 3

Sort (cost=2,220,706.26..2,244,601.52 rows=9,558,105 width=52) (actual time=30,060.402..30,060.714 rows=507 loops=3)

  • Sort Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
  • Sort Method: external merge Disk: 461368kB
13. 17,271.994 17,271.994 ↑ 1.3 7,628,456 3 / 3

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 time=0.041..17,271.994 rows=7,628,456 loops=3)

14. 0.000 35,813.510 ↓ 0.0 0 1

Sort (cost=2,030,977.30..2,030,977.31 rows=1 width=181) (actual time=35,813.509..35,813.510 rows=0 loops=1)

  • Sort Key: p62_ct_erbegleitwert_stg.hk_h_ereignis, p62_ct_erbegleitwert_stg.erbwid
  • Sort Method: quicksort Memory: 25kB
15. 436.777 35,813.583 ↓ 0.0 0 1

Gather (cost=1,578,363.30..2,030,977.29 rows=1 width=181) (actual time=35,813.496..35,813.583 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
16. 6,170.495 35,376.806 ↓ 0.0 0 3 / 3

Hash Anti Join (cost=1,577,363.30..2,029,977.19 rows=1 width=181) (actual time=35,376.805..35,376.806 rows=0 loops=3)

  • 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. 1,412.280 1,412.280 ↑ 1.3 507,061 3 / 3

Parallel Seq Scan on p62_ct_erbegleitwert_stg (cost=0.00..62,571.64 rows=674,564 width=181) (actual time=3.347..1,412.280 rows=507,061 loops=3)

18. 13,901.324 27,794.031 ↑ 1.0 22,885,368 3 / 3

Hash (cost=919,645.52..919,645.52 rows=22,939,452 width=82) (actual time=27,794.031..27,794.031 rows=22,885,368 loops=3)

  • Buckets: 2097152 Batches: 16 Memory Usage: 175626kB
19. 13,892.707 13,892.707 ↑ 1.0 22,885,368 3 / 3

Seq Scan on ereignis_erbegleitwert_lvn_p62_ms (cost=0.00..919,645.52 rows=22,939,452 width=82) (actual time=0.029..13,892.707 rows=22,885,368 loops=3)

Planning time : 2.392 ms
Execution time : 66,345.900 ms