explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XMXp

Settings
# exclusive inclusive rows x rows loops node
1. 25,774.225 26,221.929 ↑ 4.7 1,523 1

Nested Loop Left Join (cost=367.81..166,205.06 rows=7,130 width=93) (actual time=125.754..26,221.929 rows=1,523 loops=1)

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

CTE sname

3. 15.362 15.362 ↑ 4.3 234 1

Function Scan on get_similar_names (cost=0.25..12.75 rows=1,000 width=36) (actual time=15.125..15.362 rows=234 loops=1)

  • Filter: ((similar_name)::text !~~* 'Ellis'::text)
  • Rows Removed by Filter: 1
4. 19.581 377.646 ↓ 1.1 1,523 1

Nested Loop Left Join (cost=355.06..126,967.31 rows=1,426 width=57) (actual time=92.799..377.646 rows=1,523 loops=1)

  • Filter: ((ca.state IS NULL) OR (lower((ca.state)::text) = 'ca'::text))
  • Rows Removed by Filter: 12767
5. 197.684 286.615 ↑ 2.6 14,290 1

Bitmap Heap Scan on contributions_contributors cc (cost=354.62..39,353.95 rows=37,668 width=42) (actual time=91.840..286.615 rows=14,290 loops=1)

  • Recheck Cond: ((original_name)::text ~* '\yEllis\y'::text)
  • Rows Removed by Index Recheck: 7963
  • Heap Blocks: exact=19990
6. 88.931 88.931 ↑ 1.7 22,253 1

Bitmap Index Scan on ix_contributions_contributors_original_name_idx_t (cost=0.00..345.21 rows=37,668 width=0) (actual time=88.931..88.931 rows=22,253 loops=1)

  • Index Cond: ((original_name)::text ~* '\yEllis\y'::text)
7. 71.450 71.450 ↑ 1.0 1 14,290

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

  • Index Cond: (cc.address_id = id)
8. 70.058 70.058 ↑ 4.3 234 1,523

CTE Scan on sname sn1 (cost=0.00..20.00 rows=1,000 width=32) (actual time=0.010..0.046 rows=234 loops=1,523)