explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P73D : erbegleitwert nach anlayze

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 61,964.235 ↓ 0.0 0 1

Unique (cost=7,125,911.83..7,125,911.87 rows=1 width=229) (actual time=61,964.234..61,964.235 rows=0 loops=1)

2.          

Initplan (for Unique)

3. 0.000 0.000 ↓ 0.0 0

Finalize Aggregate (cost=64,912.46..64,912.47 rows=1 width=32) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Gather (cost=64,912.25..64,912.46 rows=2 width=32) (never executed)

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

Partial Aggregate (cost=63,912.25..63,912.26 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,323.60 rows=635,460 width=6) (never executed)

7. 0.029 61,964.233 ↓ 0.0 0 1

Sort (cost=7,060,999.36..7,060,999.36 rows=1 width=229) (actual time=61,964.232..61,964.233 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.008 61,964.204 ↓ 0.0 0 1

Merge Right Join (cost=4,241,999.78..7,060,999.35 rows=1 width=229) (actual time=61,964.203..61,964.204 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,328.047 ↑ 11,346,165.0 1 1

Finalize GroupAggregate (cost=2,218,258.92..4,867,065.97 rows=11,346,165 width=87) (actual time=30,328.046..30,328.047 rows=1 loops=1)

  • Group Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
10. 260.780 30,417.164 ↑ 9,536,765.0 2 1

Gather Merge (cost=2,218,258.92..4,610,552.85 rows=19,073,530 width=79) (actual time=30,328.013..30,417.164 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
11. 0.497 30,156.384 ↑ 18,922.2 504 3 / 3

Partial GroupAggregate (cost=2,217,258.90..2,407,994.20 rows=9,536,765 width=79) (actual time=30,155.571..30,156.384 rows=504 loops=3)

  • Group Key: ereignis_erbegleitwert_lvn_p62_ms_1.hk_h_ereignis, ereignis_erbegleitwert_lvn_p62_ms_1.erbwid
12. 12,871.085 30,155.887 ↑ 17,060.4 559 3 / 3

Sort (cost=2,217,258.90..2,241,100.81 rows=9,536,765 width=52) (actual time=30,155.557..30,155.887 rows=559 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: 461,624kB
13. 17,284.802 17,284.802 ↑ 1.2 7,629,762 3 / 3

Parallel Seq Scan on ereignis_erbegleitwert_lvn_p62_ms ereignis_erbegleitwert_lvn_p62_ms_1 (cost=0.00..785,740.65 rows=9,536,765 width=52) (actual time=4.144..17,284.802 rows=7,629,762 loops=3)

14. 0.000 31,636.149 ↓ 0.0 0 1

Sort (cost=2,023,740.86..2,023,740.86 rows=1 width=181) (actual time=31,636.148..31,636.149 rows=0 loops=1)

  • Sort Key: p62_ct_erbegleitwert_stg.hk_h_ereignis, p62_ct_erbegleitwert_stg.erbwid
  • Sort Method: quicksort Memory: 25kB
15. 79.845 31,636.201 ↓ 0.0 0 1

Gather (cost=1,576,504.90..2,023,740.85 rows=1 width=181) (actual time=31,636.126..31,636.201 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
16. 4,521.848 31,556.356 ↓ 0.0 0 3 / 3

Hash Anti Join (cost=1,575,504.90..2,022,740.75 rows=1 width=181) (actual time=31,556.356..31,556.356 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,096.320 1,096.320 ↑ 1.3 508,367 3 / 3

Parallel Seq Scan on p62_ct_erbegleitwert_stg (cost=0.00..62,323.60 rows=635,460 width=181) (actual time=0.057..1,096.320 rows=508,367 loops=3)

18. 13,686.373 25,938.188 ↓ 1.0 22,889,285 3 / 3

Hash (cost=919,255.36..919,255.36 rows=22,888,236 width=82) (actual time=25,938.188..25,938.188 rows=22,889,285 loops=3)

  • Buckets: 2,097,152 Batches: 16 Memory Usage: 175,654kB
19. 12,251.815 12,251.815 ↓ 1.0 22,889,285 3 / 3

Seq Scan on ereignis_erbegleitwert_lvn_p62_ms (cost=0.00..919,255.36 rows=22,888,236 width=82) (actual time=0.029..12,251.815 rows=22,889,285 loops=3)

Planning time : 92.892 ms
Execution time : 62,119.879 ms