explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nh3R

Settings
# exclusive inclusive rows x rows loops node
1. 10,455.947 20,452.128 ↓ 0.0 0 1

Update on hmeorderversion (cost=10,368.52..31,872.55 rows=1,183,378 width=268) (actual time=20,452.128..20,452.128 rows=0 loops=1)

2. 84.428 9,996.181 ↑ 10.3 114,597 1

Merge Join (cost=10,368.52..31,872.55 rows=1,183,378 width=268) (actual time=8,720.451..9,996.181 rows=114,597 loops=1)

  • Merge Cond: (hmeorderversion.contact_id = duplicate_contacts.bad_cid)
3. 9,839.052 9,839.052 ↑ 9.0 283,045 1

Index Scan using hmeorderversion_contact_id_idx on hmeorderversion (cost=0.43..74,049.74 rows=2,558,954 width=258) (actual time=0.013..9,839.052 rows=283,045 loops=1)

4. 66.579 72.701 ↓ 2.9 158,775 1

Sort (cost=5,008.43..5,143.40 rows=53,988 width=22) (actual time=43.981..72.701 rows=158,775 loops=1)

  • Sort Key: duplicate_contacts.bad_cid
  • Sort Method: external sort Disk: 2016kB
5. 6.122 6.122 ↑ 1.0 53,988 1

Seq Scan on duplicate_contacts (cost=0.00..764.88 rows=53,988 width=22) (actual time=0.090..6.122 rows=53,988 loops=1)