explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MDlB : after index

Settings
# exclusive inclusive rows x rows loops node
1. 0.393 20.673 ↓ 19.0 19 1

Unique (cost=50.52..50.59 rows=1 width=10,372) (actual time=20.117..20.673 rows=19 loops=1)

2. 0.434 20.280 ↓ 19.0 19 1

Sort (cost=50.52..50.52 rows=1 width=10,372) (actual time=20.098..20.280 rows=19 loops=1)

  • Sort Key: c1.name, c1.id, c1."primaryPhone", c1."alternativePhone", c1.email, c1.address1, c1.address2, c1.city, c1.state, c1."zipCode", c1.recruiter, c1.worklist, c1."hiddenFromWorklist", c1."applicationDate", c1."lastUpdatedDat
  • Sort Method: quicksort Memory: 30kB
3. 9.688 19.846 ↓ 19.0 19 1

Nested Loop Semi Join (cost=0.00..50.51 rows=1 width=10,372) (actual time=1.773..19.846 rows=19 loops=1)

  • Join Filter: ((c1.id <> c2.id) AND (((c1."primaryPhone" IS NOT NULL) AND ((c1."primaryPhone")::text <> ''::text) AND (((c1."primaryPhone")::text = (c2."primaryPhone")::text) OR ((c1."primaryPhone")::text = (c2."alternativeP
  • Rows Removed by Join Filter: 859
4. 0.798 0.798 ↑ 1.0 39 1

Seq Scan on candidates c1 (cost=0.00..2.39 rows=39 width=10,368) (actual time=0.423..0.798 rows=39 loops=1)

5. 8.623 9.360 ↑ 1.7 23 39

Materialize (cost=0.00..2.58 rows=39 width=1,036) (actual time=0.019..0.240 rows=23 loops=39)

6. 0.737 0.737 ↑ 1.0 39 1

Seq Scan on candidates c2 (cost=0.00..2.39 rows=39 width=1,036) (actual time=0.360..0.737 rows=39 loops=1)

Planning time : 10.725 ms
Execution time : 21.031 ms