explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uEkk

Settings
# exclusive inclusive rows x rows loops node
1. 530.465 755.738 ↑ 1,381.4 7 1

Nested Loop (cost=1,832.14..101,078.78 rows=9,670 width=93) (actual time=351.725..755.738 rows=7 loops=1)

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

CTE similar_names2

3. 0.051 0.051 ↑ 5.8 234 1

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

4. 0.165 0.165 ↑ 5.8 234 1

CTE Scan on similar_names2 sn1 (cost=0.00..27.20 rows=1,360 width=32) (actual time=0.009..0.165 rows=234 loops=1)

5. 19.127 225.108 ↓ 1.1 1,526 234

Materialize (cost=1,808.54..62,353.13 rows=1,422 width=57) (actual time=0.438..0.962 rows=1,526 loops=234)

6. 9.494 205.981 ↓ 1.1 1,526 1

Gather (cost=1,808.54..62,346.02 rows=1,422 width=57) (actual time=102.427..205.981 rows=1,526 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
7. 48.445 196.487 ↑ 1.2 305 5

Nested Loop Left Join (cost=808.54..61,203.82 rows=356 width=57) (actual time=91.015..196.487 rows=305 loops=5)

  • Filter: ((ca.state IS NULL) OR (lower((ca.state)::text) = 'ca'::text))
  • Rows Removed by Filter: 2558
8. 56.622 148.026 ↑ 3.3 2,863 5

Parallel Bitmap Heap Scan on contributions_contributors cc (cost=808.10..39,353.24 rows=9,390 width=42) (actual time=86.256..148.026 rows=2,863 loops=5)

  • Recheck Cond: ((original_name)::text ~* '\yEllis\y'::text)
  • Rows Removed by Index Recheck: 1596
  • Heap Blocks: exact=4238
9. 91.404 91.404 ↑ 1.7 22,299 1

Bitmap Index Scan on ix_contributions_contributors_original_name_idx_t (cost=0.00..798.71 rows=37,561 width=0) (actual time=91.404..91.404 rows=22,299 loops=1)

  • Index Cond: ((original_name)::text ~* '\yEllis\y'::text)
10. 0.016 0.016 ↑ 1.0 1 14,317

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

  • Index Cond: (cc.address_id = id)
Planning time : 4.805 ms
Execution time : 756.538 ms