explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QXfx

Settings
# exclusive inclusive rows x rows loops node
1. 24,745.582 24,845.215 ↑ 1,381.4 7 1

Nested Loop (cost=1,347.64..100,589.97 rows=9,670 width=93) (actual time=4,825.912..24,845.215 rows=7 loops=1)

  • Join Filter: ((cc.original_name)::text ~* (('\y'::text || (sn1.name)::text) || '\y'::text))
  • Rows Removed by Join Filter: 356843
2. 0.000 73.708 ↓ 1.1 1,525 1

Gather (cost=1,347.64..61,884.57 rows=1,422 width=57) (actual time=72.389..73.708 rows=1,525 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 44.581 160.609 ↑ 1.2 305 5

Nested Loop Left Join (cost=347.64..60,742.37 rows=356 width=57) (actual time=64.724..160.609 rows=305 loops=5)

  • Filter: ((ca.state IS NULL) OR (lower((ca.state)::text) = 'ca'::text))
  • Rows Removed by Filter: 2557
4. 51.501 116.013 ↑ 3.3 2,862 5

Parallel Bitmap Heap Scan on contributions_contributors cc (cost=347.20..38,892.34 rows=9,390 width=42) (actual time=61.006..116.013 rows=2,862 loops=5)

  • Recheck Cond: ((original_name)::text ~* '\yEllis\y'::text)
  • Rows Removed by Index Recheck: 1595
  • Heap Blocks: exact=112
5. 64.512 64.512 ↑ 1.7 22,285 1

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

  • Index Cond: ((original_name)::text ~* '\yEllis\y'::text)
6. 0.015 0.015 ↑ 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.015..0.015 rows=1 loops=14,309)

  • Index Cond: (cc.address_id = id)
7. 25.886 25.925 ↑ 5.8 234 1,525

Materialize (cost=0.00..30.40 rows=1,360 width=32) (actual time=0.000..0.017 rows=234 loops=1,525)

8. 0.039 0.039 ↑ 5.8 234 1

Seq Scan on similar_names sn1 (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.012..0.039 rows=234 loops=1)