explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ihz : gefaess

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 16.786 ↓ 0.0 0 1

Unique (cost=58.24..58.28 rows=1 width=749) (actual time=16.785..16.786 rows=0 loops=1)

2.          

Initplan (for Unique)

3. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=11.25..11.26 rows=1 width=32) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on p62_ct_gefaess_stg stg (cost=0.00..11.00 rows=100 width=5) (never executed)

5. 0.086 16.783 ↓ 0.0 0 1

Sort (cost=46.98..46.99 rows=1 width=749) (actual time=16.782..16.783 rows=0 loops=1)

  • Sort Key: p62_ct_gefaess_stg.hk_h_gefaess, p62_ct_gefaess_stg.gefnr, p62_ct_gefaess_stg.geftyp, p62_ct_gefaess_stg.gefverw, p62_ct_gefaess_stg.gefbem, p62_ct_gefaess_stg.einsatzbegutc, p62_ct_gefaess_stg.einsatzbeg, p62_ct_gefaess_stg.datumletzteaenderung, p62_ct_gefaess_stg.version, p62_ct_gefaess_stg."cscn$", p62_ct_gefaess_stg.dss_change_hash_p62, p62_ct_gefaess_stg.dss_record_source, ((p62_ct_gefaess_stg.dss_load_date + (((p62_ct_gefaess_stg."cscn$" - $0))::double precision * '00:00:00.000001'::interval))), ((COALESCE((max(gefaess_lvn_p62_s_1.dss_version)), '0'::numeric) + '1'::numeric))
  • Sort Method: quicksort Memory: 25kB
6. 0.017 16.697 ↓ 0.0 0 1

Hash Right Join (cost=43.04..46.97 rows=1 width=749) (actual time=16.696..16.697 rows=0 loops=1)

  • Hash Cond: (gefaess_lvn_p62_s_1.hk_h_gefaess = p62_ct_gefaess_stg.hk_h_gefaess)
7. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=13.98..15.62 rows=164 width=81) (never executed)

  • Group Key: gefaess_lvn_p62_s_1.hk_h_gefaess
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on gefaess_lvn_p62_s gefaess_lvn_p62_s_1 (cost=0.00..12.32 rows=332 width=46) (never executed)

9. 0.002 16.680 ↓ 0.0 0 1

Hash (cost=29.05..29.05 rows=1 width=701) (actual time=16.679..16.680 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
10. 0.314 16.678 ↓ 0.0 0 1

Hash Anti Join (cost=17.30..29.05 rows=1 width=701) (actual time=16.677..16.678 rows=0 loops=1)

  • Hash Cond: ((p62_ct_gefaess_stg.hk_h_gefaess = gefaess_lvn_p62_s.hk_h_gefaess) AND (p62_ct_gefaess_stg.dss_change_hash_p62 = gefaess_lvn_p62_s.dss_change_hash))
11. 13.960 13.960 ↓ 1.6 155 1

Seq Scan on p62_ct_gefaess_stg (cost=0.00..11.00 rows=100 width=701) (actual time=13.382..13.960 rows=155 loops=1)

12. 0.511 2.404 ↑ 1.1 301 1

Hash (cost=12.32..12.32 rows=332 width=82) (actual time=2.403..2.404 rows=301 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 42kB
13. 1.893 1.893 ↑ 1.1 301 1

Seq Scan on gefaess_lvn_p62_s (cost=0.00..12.32 rows=332 width=82) (actual time=1.264..1.893 rows=301 loops=1)

Planning time : 101.679 ms
Execution time : 17.127 ms