explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yX3k

Settings
# exclusive inclusive rows x rows loops node
1. 0.736 10.952 ↑ 1.1 37 1

Unique (cost=21.81..24.63 rows=39 width=10,368) (actual time=9.879..10.952 rows=37 loops=1)

2. 0.789 10.216 ↑ 1.1 37 1

Sort (cost=21.81..21.90 rows=39 width=10,368) (actual time=9.859..10.216 rows=37 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: 35kB
3. 4.300 9.427 ↑ 1.1 37 1

Nested Loop Semi Join (cost=0.00..20.78 rows=39 width=10,368) (actual time=0.739..9.427 rows=37 loops=1)

  • Join Filter: (((c1.id <> c2.id) AND (((c1."primaryPhone")::text = (c2."primaryPhone")::text) OR ((c1."primaryPhone")::text = (c2."alternativePhone")::text))) OR ((c1."alternativePhone")::text = (c2."primaryPhone")::text) OR
  • Rows Removed by Join Filter: 307
4. 0.720 0.720 ↑ 1.0 39 1

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

5. 3.674 4.407 ↑ 4.3 9 39

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

6. 0.733 0.733 ↑ 1.0 39 1

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

Planning time : 4.305 ms
Execution time : 11.463 ms