explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SiMd : Optimization for: Optimization for: plan #SweN; plan #aRbX

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.403 20.608 ↓ 19.0 19 1

Sort (cost=46.71..46.72 rows=1 width=10,368) (actual time=20.425..20.608 rows=19 loops=1)

  • Sort Key: c1.name
  • Sort Method: quicksort Memory: 30kB
2. 9.726 20.205 ↓ 19.0 19 1

Nested Loop Semi Join (cost=0.00..46.70 rows=1 width=10,368) (actual time=1.901..20.205 rows=19 loops=1)

  • Join Filter: ((c1.id <> c2.id) AND ((((c1."primaryPhone")::text <> ''::text) AND (((c1."primaryPhone")::text = (c2."primaryPhone")::text) OR ((c1."primaryPhone")::text = (c2."alternativePhone")::text))) OR (((c1."alternativePhone
  • Rows Removed by Join Filter: 859
3. 0.807 0.807 ↑ 1.0 39 1

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

4. 8.875 9.672 ↑ 1.7 23 39

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

5. 0.797 0.797 ↑ 1.0 39 1

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

Planning time : 6.279 ms
Execution time : 20.963 ms