explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hON

Settings
# exclusive inclusive rows x rows loops node
1. 14.360 2,410.713 ↑ 1.7 69,609 1

Nested Loop (cost=67.04..1,396,577.89 rows=118,240 width=168) (actual time=100.890..2,410.713 rows=69,609 loops=1)

2.          

CTE similar_names_cte

3. 21.041 21.041 ↑ 4.3 234 1

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

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

CTE Scan on similar_names_cte sn1 (cost=0.00..20.00 rows=1,000 width=32) (actual time=20.405..21.253 rows=234 loops=1)

5. 1,063.998 2,375.100 ↓ 2.5 297 234

Bitmap Heap Scan on contributions_fec_contributions fec (cost=54.29..1,395.37 rows=118 width=36) (actual time=5.940..10.150 rows=297 loops=234)

  • Recheck Cond: ((to_tsvector('english'::regconfig, (name)::text) @@ to_tsquery('english'::regconfig, regexp_replace(replace((sn1.name)::text, '&'::text, ''::text), '\s+'::text, ' & '::text, 'g'::text))) AND (to_tsvector('english'::regconfig, (name)::text) @@ '''elli'''::tsquery))
  • Filter: ((state IS NULL) OR (lower((state)::text) = 'ca'::text))
  • Rows Removed by Filter: 1907
  • Heap Blocks: exact=367702
6. 1,311.102 1,311.102 ↓ 3.2 2,374 234

Bitmap Index Scan on ix_contributions_fec_contributions_name_tsv (cost=0.00..54.26 rows=732 width=0) (actual time=5.603..5.603 rows=2,374 loops=234)

  • Index Cond: ((to_tsvector('english'::regconfig, (name)::text) @@ to_tsquery('english'::regconfig, regexp_replace(replace((sn1.name)::text, '&'::text, ''::text), '\s+'::text, ' & '::text, 'g'::text))) AND (to_tsvector('english'::regconfig, (name)::text) @@ '''elli'''::tsquery))
Planning time : 0.762 ms
Execution time : 2,413.573 ms