explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BwAJo

Settings
# exclusive inclusive rows x rows loops node
1. 0.427 37.567 ↑ 2.1 19 1

Sort (cost=62.22..62.32 rows=39 width=10,372) (actual time=37.385..37.567 rows=19 loops=1)

  • Sort Key: candidates.name
  • Sort Method: quicksort Memory: 30kB
2. 2.478 37.140 ↑ 2.1 19 1

HashAggregate (cost=60.80..61.19 rows=39 width=10,372) (actual time=36.938..37.140 rows=19 loops=1)

  • Group Key: candidates.name, candidates.id, candidates."primaryPhone", candidates."alternativePhone", candidates.email, candidates.address1, candidates.address2, candidates.city, candidates.state, candidates."zipCode", candidates.
3. 17.840 34.662 ↓ 1.3 190 1

Nested Loop (cost=0.00..50.51 rows=142 width=10,372) (actual time=1.915..34.662 rows=190 loops=1)

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

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

5. 15.172 15.951 ↑ 1.0 39 39

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

6. 0.779 0.779 ↑ 1.0 39 1

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

Planning time : 1.818 ms
Execution time : 37.935 ms