explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ImiR

Settings
# exclusive inclusive rows x rows loops node
1. 3,917.796 4,638.107 ↑ 93.6 137 1

Nested Loop (cost=1,567.07..596,019.41 rows=12,820 width=93) (actual time=171.663..4,638.107 rows=137 loops=1)

  • Join Filter: (lower((cc.original_name)::text) ~ (('\y'::text || lower((sn3.similar_name)::text)) || '\y'::text))
  • Rows Removed by Join Filter: 1998538
2. 47.786 47.786 ↑ 4.4 225 1

Function Scan on get_similar_names sn3 (cost=0.25..10.25 rows=1,000 width=32) (actual time=47.753..47.786 rows=225 loops=1)

3. 112.792 672.525 ↓ 3.5 8,883 225

Materialize (cost=1,566.82..531,915.57 rows=2,564 width=57) (actual time=0.143..2.989 rows=8,883 loops=225)

4. 91.359 559.733 ↓ 3.5 8,883 1

Nested Loop Left Join (cost=1,566.82..531,902.75 rows=2,564 width=57) (actual time=32.193..559.733 rows=8,883 loops=1)

  • Filter: ((ca.state IS NULL) OR (lower((ca.state)::text) = 'pa'::text))
  • Rows Removed by Filter: 96495
5. 133.527 152.240 ↑ 1.8 105,378 1

Bitmap Heap Scan on contributions_contributors cc (cost=1,566.38..211,950.72 rows=191,469 width=42) (actual time=30.831..152.240 rows=105,378 loops=1)

  • Recheck Cond: (to_tsvector('english'::regconfig, (original_name)::text) @@ '''johnson'''::tsquery)
  • Heap Blocks: exact=71679
6. 18.713 18.713 ↑ 1.8 105,378 1

Bitmap Index Scan on ix_contributions_contributors_original_name_tsv (cost=0.00..1,518.52 rows=191,469 width=0) (actual time=18.713..18.713 rows=105,378 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, (original_name)::text) @@ '''johnson'''::tsquery)
7. 316.134 316.134 ↑ 1.0 1 105,378

Index Scan using contributions_addresses_pkey on contributions_addresses ca (cost=0.44..1.66 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=105,378)

  • Index Cond: (cc.address_id = id)