explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n7qq

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

Insert on contacts (cost=8.61..52,342.24 rows=1,324,095 width=76) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=8.61..52,342.24 rows=1,324,095 width=76) (actual rows= loops=)

  • Hash Cond: ((a.target_person_id = b.target_person_id) AND (a.period = b.period) AND (a.position_id = b.position_id))
3. 0.000 0.000 ↓ 0.0

Seq Scan on contacts_tmp_etl_20200210 a (cost=0.00..22,044.95 rows=1,324,095 width=72) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=8.60..8.60 rows=1 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using contacts_person_id_target_person_id_period_key on contacts b (cost=0.38..8.60 rows=1 width=12) (actual rows= loops=)