explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6zOL

Settings
# exclusive inclusive rows x rows loops node
1. 529.163 925.070 ↑ 1,015.7 7 1

Nested Loop (cost=383.49..155,146.35 rows=7,110 width=93) (actual time=519.849..925.070 rows=7 loops=1)

  • Join Filter: ((cc.original_name)::text ~* (('\y'::text || (sn1.name)::text) || '\y'::text))
  • Rows Removed by Join Filter: 356843
2.          

CTE similar_names

3. 15.551 15.551 ↑ 4.3 234 1

Function Scan on get_similar_names (cost=0.25..12.75 rows=1,000 width=32) (actual time=15.274..15.551 rows=234 loops=1)

  • Filter: ((similar_name)::text !~~* 'Ellis'::text)
  • Rows Removed by Filter: 1
4. 15.657 15.657 ↑ 4.3 234 1

CTE Scan on similar_names sn1 (cost=0.00..20.00 rows=1,000 width=32) (actual time=15.276..15.657 rows=234 loops=1)

5. 18.049 380.250 ↓ 1.1 1,525 234

Materialize (cost=370.74..126,677.15 rows=1,422 width=57) (actual time=0.318..1.625 rows=1,525 loops=234)

6. 15.321 362.201 ↓ 1.1 1,525 1

Nested Loop Left Join (cost=370.74..126,670.04 rows=1,422 width=57) (actual time=74.340..362.201 rows=1,525 loops=1)

  • Filter: ((ca.state IS NULL) OR (lower((ca.state)::text) = 'ca'::text))
  • Rows Removed by Filter: 12784
7. 163.637 232.408 ↑ 2.6 14,309 1

Bitmap Heap Scan on contributions_contributors cc (cost=370.30..39,267.57 rows=37,561 width=42) (actual time=71.561..232.408 rows=14,309 loops=1)

  • Recheck Cond: ((original_name)::text ~* '\yEllis\y'::text)
  • Rows Removed by Index Recheck: 7976
  • Heap Blocks: exact=20022
8. 68.771 68.771 ↑ 1.7 22,285 1

Bitmap Index Scan on ix_contributions_contributors_original_name_idx_t (cost=0.00..360.91 rows=37,561 width=0) (actual time=68.771..68.771 rows=22,285 loops=1)

  • Index Cond: ((original_name)::text ~* '\yEllis\y'::text)
9. 114.472 114.472 ↑ 1.0 1 14,309

Index Scan using contributions_addresses_pkey on contributions_addresses ca (cost=0.44..2.31 rows=1 width=23) (actual time=0.008..0.008 rows=1 loops=14,309)

  • Index Cond: (cc.address_id = id)
Planning time : 11.609 ms
Execution time : 925.927 ms