explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aqa1

Settings
# exclusive inclusive rows x rows loops node
1. 0.454 6,701.418 ↑ 117.7 1,912 1

Nested Loop (cost=470.98..578,210.46 rows=224,970 width=626) (actual time=17.578..6,701.418 rows=1,912 loops=1)

2.          

CTE name_cte

3. 0.168 0.395 ↑ 1.0 1 1

Aggregate (cost=192.09..192.10 rows=1 width=32) (actual time=0.395..0.395 rows=1 loops=1)

4. 0.038 0.227 ↑ 4.2 39 1

HashAggregate (cost=187.61..189.24 rows=163 width=32) (actual time=0.218..0.227 rows=39 loops=1)

  • Group Key: n.name2
5. 0.008 0.189 ↑ 3.1 52 1

Append (cost=0.56..187.20 rows=163 width=32) (actual time=0.063..0.189 rows=52 loops=1)

6. 0.106 0.106 ↑ 2.5 35 1

Index Scan using ix_nicknames_name1 on nicknames n (cost=0.56..101.32 rows=89 width=7) (actual time=0.062..0.106 rows=35 loops=1)

  • Index Cond: ((lower(name1) = 'scott'::text) AND (score < 30))
7. 0.074 0.074 ↑ 4.6 16 1

Index Scan using ix_nicknames_name2 on nicknames n_1 (cost=0.56..83.42 rows=73 width=8) (actual time=0.036..0.074 rows=16 loops=1)

  • Index Cond: ((lower(name2) = 'scott'::text) AND (score < 30))
8. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

9. 0.399 0.399 ↑ 1.0 1 1

CTE Scan on name_cte (cost=0.00..0.02 rows=1 width=32) (actual time=0.398..0.399 rows=1 loops=1)

10. 1.017 6,700.565 ↑ 131.8 1,912 1

Append (cost=278.88..575,497.79 rows=252,055 width=627) (actual time=17.105..6,700.565 rows=1,912 loops=1)

11. 0.054 17.141 ↑ 116.1 17 1

Bitmap Heap Scan on contributions_alabama ct (cost=278.88..4,414.21 rows=1,973 width=648) (actual time=17.099..17.141 rows=17 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=17
12. 0.146 17.087 ↓ 0.0 0 1

BitmapOr (cost=278.88..278.88 rows=1,973 width=0) (actual time=17.086..17.087 rows=0 loops=1)

13. 0.241 9.930 ↓ 0.0 0 1

BitmapAnd (cost=259.03..259.03 rows=13 width=0) (actual time=9.930..9.930 rows=0 loops=1)

14. 9.144 9.144 ↑ 115.4 17 1

Bitmap Index Scan on contributions_alabama_to_tsvector_idx2 (cost=0.00..19.36 rows=1,961 width=0) (actual time=9.144..9.144 rows=17 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
15. 0.001 0.545 ↓ 0.0 0 1

BitmapOr (cost=238.93..238.93 rows=2,523 width=0) (actual time=0.545..0.545 rows=0 loops=1)

16. 0.283 0.283 ↓ 1.1 1,689 1

Bitmap Index Scan on contributions_alabama_lower_idx (cost=0.00..26.29 rows=1,542 width=0) (actual time=0.283..0.283 rows=1,689 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
17. 0.261 0.261 ↓ 1.2 1,207 1

Bitmap Index Scan on contributions_alabama_lower_idx1 (cost=0.00..16.57 rows=980 width=0) (actual time=0.261..0.261 rows=1,207 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
18. 7.011 7.011 ↑ 115.4 17 1

Bitmap Index Scan on contributions_alabama_to_tsvector_idx3 (cost=0.00..19.36 rows=1,961 width=0) (actual time=7.011..7.011 rows=17 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
19. 0.179 1.837 ↑ 413.0 1 1

Bitmap Heap Scan on contributions_alameda_county ct_1 (cost=10.44..870.02 rows=413 width=696) (actual time=1.836..1.837 rows=1 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=1
20. 0.273 1.658 ↓ 0.0 0 1

BitmapOr (cost=10.44..10.44 rows=418 width=0) (actual time=1.658..1.658 rows=0 loops=1)

21. 0.624 0.624 ↑ 209.0 1 1

Bitmap Index Scan on contributions_alameda_county_to_tsvector_idx2 (cost=0.00..5.12 rows=209 width=0) (actual time=0.624..0.624 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
22. 0.761 0.761 ↑ 209.0 1 1

Bitmap Index Scan on contributions_alameda_county_to_tsvector_idx3 (cost=0.00..5.12 rows=209 width=0) (actual time=0.761..0.761 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
23. 0.002 0.508 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_alaska ct_2 (cost=4.91..7.04 rows=1 width=776) (actual time=0.508..0.508 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
24. 0.226 0.506 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.506..0.506 rows=0 loops=1)

25. 0.140 0.140 ↓ 0.0 0 1

Bitmap Index Scan on contributions_alaska_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.140..0.140 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
26. 0.140 0.140 ↓ 0.0 0 1

Bitmap Index Scan on contributions_alaska_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.140..0.140 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
27. 0.003 1.093 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_anaheim_ca ct_3 (cost=8.25..304.70 rows=141 width=634) (actual time=1.093..1.093 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
28. 0.227 1.090 ↓ 0.0 0 1

BitmapOr (cost=8.25..8.25 rows=144 width=0) (actual time=1.090..1.090 rows=0 loops=1)

29. 0.455 0.455 ↓ 0.0 0 1

Bitmap Index Scan on contributions_anaheim_ca_to_tsvector_idx2 (cost=0.00..4.09 rows=72 width=0) (actual time=0.455..0.455 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
30. 0.408 0.408 ↓ 0.0 0 1

Bitmap Index Scan on contributions_anaheim_ca_to_tsvector_idx3 (cost=0.00..4.09 rows=72 width=0) (actual time=0.408..0.408 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
31. 0.008 0.504 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_arizona ct_4 (cost=4.91..7.04 rows=1 width=776) (actual time=0.504..0.504 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
32. 0.236 0.496 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.496..0.496 rows=0 loops=1)

33. 0.139 0.139 ↓ 0.0 0 1

Bitmap Index Scan on contributions_arizona_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.139..0.139 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
34. 0.121 0.121 ↓ 0.0 0 1

Bitmap Index Scan on contributions_arizona_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.121..0.121 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
35. 0.003 0.330 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_arkansas ct_5 (cost=6.10..10.28 rows=1 width=776) (actual time=0.330..0.330 rows=0 loops=1)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
36. 0.124 0.327 ↓ 0.0 0 1

BitmapOr (cost=6.10..6.10 rows=2 width=0) (actual time=0.327..0.327 rows=0 loops=1)

37. 0.000 0.013 ↓ 0.0 0 1

BitmapOr (cost=2.55..2.55 rows=2 width=0) (actual time=0.013..0.013 rows=0 loops=1)

38. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on contributions_arkansas_lower_idx (cost=0.00..1.25 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
39. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on contributions_arkansas_lower_idx1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
40. 0.190 0.190 ↓ 0.0 0 1

Bitmap Index Scan on contributions_arkansas_to_tsvector_idx3 (cost=0.00..3.55 rows=1 width=0) (actual time=0.190..0.190 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
41. 0.004 0.499 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_austin ct_6 (cost=4.91..7.04 rows=1 width=776) (actual time=0.499..0.499 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
42. 0.237 0.495 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.495..0.495 rows=0 loops=1)

43. 0.131 0.131 ↓ 0.0 0 1

Bitmap Index Scan on contributions_austin_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.131..0.131 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
44. 0.127 0.127 ↓ 0.0 0 1

Bitmap Index Scan on contributions_austin_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.127..0.127 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
45. 0.005 1.597 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_barkeley_ca ct_7 (cost=9.23..558.34 rows=260 width=645) (actual time=1.597..1.597 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
46. 0.245 1.592 ↓ 0.0 0 1

BitmapOr (cost=9.23..9.23 rows=266 width=0) (actual time=1.592..1.592 rows=0 loops=1)

47. 0.706 0.706 ↓ 0.0 0 1

Bitmap Index Scan on contributions_barkeley_ca_to_tsvector_idx2 (cost=0.00..4.55 rows=133 width=0) (actual time=0.706..0.706 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
48. 0.641 0.641 ↓ 0.0 0 1

Bitmap Index Scan on contributions_barkeley_ca_to_tsvector_idx3 (cost=0.00..4.55 rows=133 width=0) (actual time=0.641..0.641 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
49. 0.004 0.872 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_burbank_ca ct_8 (cost=7.13..15.54 rows=4 width=715) (actual time=0.872..0.872 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
50. 0.241 0.868 ↓ 0.0 0 1

BitmapOr (cost=7.13..7.13 rows=4 width=0) (actual time=0.868..0.868 rows=0 loops=1)

51. 0.348 0.348 ↓ 0.0 0 1

Bitmap Index Scan on contributions_burbank_ca_to_tsvector_idx2 (cost=0.00..3.56 rows=2 width=0) (actual time=0.348..0.348 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
52. 0.279 0.279 ↓ 0.0 0 1

Bitmap Index Scan on contributions_burbank_ca_to_tsvector_idx3 (cost=0.00..3.56 rows=2 width=0) (actual time=0.279..0.279 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
53. 0.002 0.751 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_butte_county ct_9 (cost=7.42..92.80 rows=40 width=644) (actual time=0.751..0.751 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
54. 0.236 0.749 ↓ 0.0 0 1

BitmapOr (cost=7.42..7.42 rows=41 width=0) (actual time=0.749..0.749 rows=0 loops=1)

55. 0.245 0.245 ↓ 0.0 0 1

Bitmap Index Scan on contributions_butte_county_to_tsvector_idx2 (cost=0.00..3.70 rows=20 width=0) (actual time=0.245..0.245 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
56. 0.268 0.268 ↓ 0.0 0 1

Bitmap Index Scan on contributions_butte_county_to_tsvector_idx3 (cost=0.00..3.70 rows=20 width=0) (actual time=0.268..0.268 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
57. 11.663 242.060 ↑ 183.6 105 1

Bitmap Heap Scan on contributions_california2 ct_10 (cost=486.66..42,179.09 rows=19,279 width=1,055) (actual time=230.597..242.060 rows=105 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=147
58. 0.257 230.397 ↓ 0.0 0 1

BitmapOr (cost=486.66..486.66 rows=19,976 width=0) (actual time=230.397..230.397 rows=0 loops=1)

59. 176.207 176.207 ↑ 59.5 168 1

Bitmap Index Scan on contributions_california2_to_tsvector_idx2 (cost=0.00..355.66 rows=9,988 width=0) (actual time=176.207..176.207 rows=168 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
60. 53.933 53.933 ↑ 65.7 152 1

Bitmap Index Scan on contributions_california2_to_tsvector_idx3 (cost=0.00..121.36 rows=9,988 width=0) (actual time=53.933..53.933 rows=152 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
61. 0.003 0.586 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_capitola_ca ct_11 (cost=4.91..7.04 rows=1 width=684) (actual time=0.586..0.586 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
62. 0.247 0.583 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.583..0.583 rows=0 loops=1)

63. 0.165 0.165 ↓ 0.0 0 1

Bitmap Index Scan on contributions_capitola_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.165..0.165 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
64. 0.171 0.171 ↓ 0.0 0 1

Bitmap Index Scan on contributions_capitola_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.171..0.171 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
65. 0.002 0.722 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_carlsbad_ca ct_12 (cost=8.02..247.31 rows=111 width=732) (actual time=0.722..0.722 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
66. 0.229 0.720 ↓ 0.0 0 1

BitmapOr (cost=8.02..8.02 rows=115 width=0) (actual time=0.720..0.720 rows=0 loops=1)

67. 0.242 0.242 ↓ 0.0 0 1

Bitmap Index Scan on contributions_carlsbad_ca_to_tsvector_idx2 (cost=0.00..3.98 rows=58 width=0) (actual time=0.242..0.242 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
68. 0.249 0.249 ↓ 0.0 0 1

Bitmap Index Scan on contributions_carlsbad_ca_to_tsvector_idx3 (cost=0.00..3.98 rows=58 width=0) (actual time=0.249..0.249 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
69. 0.006 0.479 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_carson_ca ct_13 (cost=4.91..7.04 rows=1 width=776) (actual time=0.479..0.479 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
70. 0.220 0.473 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.472..0.473 rows=0 loops=1)

71. 0.131 0.131 ↓ 0.0 0 1

Bitmap Index Scan on contributions_carson_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.131..0.131 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
72. 0.122 0.122 ↓ 0.0 0 1

Bitmap Index Scan on contributions_carson_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.122..0.122 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
73. 0.003 0.653 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_chico_ca ct_14 (cost=7.43..92.76 rows=41 width=667) (actual time=0.653..0.653 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
74. 0.235 0.650 ↓ 0.0 0 1

BitmapOr (cost=7.43..7.43 rows=41 width=0) (actual time=0.650..0.650 rows=0 loops=1)

75. 0.211 0.211 ↓ 0.0 0 1

Bitmap Index Scan on contributions_chico_ca_to_tsvector_idx2 (cost=0.00..3.70 rows=21 width=0) (actual time=0.211..0.211 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
76. 0.204 0.204 ↓ 0.0 0 1

Bitmap Index Scan on contributions_chico_ca_to_tsvector_idx3 (cost=0.00..3.70 rows=21 width=0) (actual time=0.204..0.204 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
77. 0.001 0.631 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_chulavista_ca ct_15 (cost=7.44..96.14 rows=41 width=732) (actual time=0.631..0.631 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
78. 0.221 0.630 ↓ 0.0 0 1

BitmapOr (cost=7.44..7.44 rows=42 width=0) (actual time=0.630..0.630 rows=0 loops=1)

79. 0.199 0.199 ↓ 0.0 0 1

Bitmap Index Scan on contributions_chulavista_ca_to_tsvector_idx2 (cost=0.00..3.71 rows=21 width=0) (actual time=0.199..0.199 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
80. 0.210 0.210 ↓ 0.0 0 1

Bitmap Index Scan on contributions_chulavista_ca_to_tsvector_idx3 (cost=0.00..3.71 rows=21 width=0) (actual time=0.210..0.210 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
81. 0.139 30.168 ↑ 244.5 24 1

Bitmap Heap Scan on contributions_colorado ct_16 (cost=1,004.38..13,278.63 rows=5,867 width=635) (actual time=30.041..30.168 rows=24 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=24
82. 0.206 30.029 ↓ 0.0 0 1

BitmapOr (cost=1,004.38..1,004.38 rows=5,868 width=0) (actual time=30.029..30.029 rows=0 loops=1)

83. 0.126 20.451 ↓ 0.0 0 1

BitmapAnd (cost=952.88..952.88 rows=109 width=0) (actual time=20.451..20.451 rows=0 loops=1)

84. 16.379 16.379 ↑ 125.2 46 1

Bitmap Index Scan on contributions_colorado_to_tsvector_idx2 (cost=0.00..50.04 rows=5,758 width=0) (actual time=16.379..16.379 rows=46 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
85. 0.001 3.946 ↓ 0.0 0 1

BitmapOr (cost=901.12..901.12 rows=21,844 width=0) (actual time=3.946..3.946 rows=0 loops=1)

86. 0.156 0.156 ↑ 1.1 1,285 1

Bitmap Index Scan on contributions_colorado_lower_idx (cost=0.00..22.08 rows=1,420 width=0) (actual time=0.156..0.156 rows=1,285 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
87. 3.789 3.789 ↑ 1.1 18,770 1

Bitmap Index Scan on contributions_colorado_lower_idx1 (cost=0.00..303.20 rows=20,423 width=0) (actual time=3.789..3.789 rows=18,770 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
88. 9.372 9.372 ↑ 239.9 24 1

Bitmap Index Scan on contributions_colorado_to_tsvector_idx3 (cost=0.00..50.04 rows=5,758 width=0) (actual time=9.372..9.372 rows=24 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
89. 0.107 156.545 ↑ 212.2 24 1

Bitmap Heap Scan on contributions_connecticut ct_17 (cost=936.21..11,613.64 rows=5,093 width=635) (actual time=156.457..156.545 rows=24 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=33
90. 0.136 156.438 ↓ 0.0 0 1

BitmapOr (cost=936.21..936.21 rows=5,094 width=0) (actual time=156.438..156.438 rows=0 loops=1)

91. 0.128 126.227 ↓ 0.0 0 1

BitmapAnd (cost=855.06..855.06 rows=49 width=0) (actual time=126.227..126.227 rows=0 loops=1)

92. 124.013 124.013 ↑ 152.8 33 1

Bitmap Index Scan on contributions_connecticut_to_tsvector_idx2 (cost=0.00..197.58 rows=5,044 width=0) (actual time=124.013..124.013 rows=33 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
93. 0.002 2.086 ↓ 0.0 0 1

BitmapOr (cost=655.95..655.95 rows=9,820 width=0) (actual time=2.086..2.086 rows=0 loops=1)

94. 0.912 0.912 ↓ 1.1 7,291 1

Bitmap Index Scan on contributions_connecticut_lower_idx (cost=0.00..103.67 rows=6,726 width=0) (actual time=0.912..0.912 rows=7,291 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
95. 1.172 1.172 ↓ 1.2 3,653 1

Bitmap Index Scan on contributions_connecticut_lower_idx (cost=0.00..47.83 rows=3,094 width=0) (actual time=1.172..1.172 rows=3,653 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
96. 30.075 30.075 ↑ 152.8 33 1

Bitmap Index Scan on contributions_connecticut_to_tsvector_idx3 (cost=0.00..79.88 rows=5,044 width=0) (actual time=30.075..30.075 rows=33 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
97. 0.323 1.207 ↑ 35.3 3 1

Bitmap Heap Scan on contributions_contra_consta_county ct_18 (cost=7.96..230.02 rows=106 width=657) (actual time=1.000..1.207 rows=3 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=3
98. 0.224 0.884 ↓ 0.0 0 1

BitmapOr (cost=7.96..7.96 rows=107 width=0) (actual time=0.884..0.884 rows=0 loops=1)

99. 0.335 0.335 ↑ 18.0 3 1

Bitmap Index Scan on contributions_contra_consta_county_to_tsvector_idx2 (cost=0.00..3.95 rows=54 width=0) (actual time=0.335..0.335 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
100. 0.325 0.325 ↑ 18.0 3 1

Bitmap Index Scan on contributions_contra_consta_county_to_tsvector_idx3 (cost=0.00..3.95 rows=54 width=0) (actual time=0.325..0.325 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
101. 0.001 0.401 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_cotati_ca ct_19 (cost=4.91..7.04 rows=1 width=776) (actual time=0.401..0.401 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
102. 0.197 0.400 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.400..0.400 rows=0 loops=1)

103. 0.094 0.094 ↓ 0.0 0 1

Bitmap Index Scan on contributions_cotati_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.094..0.094 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
104. 0.109 0.109 ↓ 0.0 0 1

Bitmap Index Scan on contributions_cotati_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
105. 0.002 0.409 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_dallas ct_20 (cost=4.91..7.04 rows=1 width=776) (actual time=0.409..0.409 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
106. 0.217 0.407 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.407..0.407 rows=0 loops=1)

107. 0.100 0.100 ↓ 0.0 0 1

Bitmap Index Scan on contributions_dallas_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.100..0.100 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
108. 0.090 0.090 ↓ 0.0 0 1

Bitmap Index Scan on contributions_dallas_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.090..0.090 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
109. 0.002 0.440 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_davis_ca ct_21 (cost=4.91..7.04 rows=1 width=776) (actual time=0.440..0.440 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
110. 0.215 0.438 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.438..0.438 rows=0 loops=1)

111. 0.109 0.109 ↓ 0.0 0 1

Bitmap Index Scan on contributions_davis_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
112. 0.114 0.114 ↓ 0.0 0 1

Bitmap Index Scan on contributions_davis_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.114..0.114 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
113. 0.033 128.824 ↑ 786.0 1 1

Bitmap Heap Scan on contributions_delaware ct_22 (cost=448.97..2,088.54 rows=786 width=534) (actual time=128.824..128.824 rows=1 loops=1)

  • Recheck Cond: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=1
114. 0.129 128.791 ↓ 0.0 0 1

BitmapOr (cost=448.97..448.97 rows=786 width=0) (actual time=128.791..128.791 rows=0 loops=1)

115. 0.225 79.383 ↓ 0.0 0 1

BitmapAnd (cost=339.43..339.43 rows=28 width=0) (actual time=79.383..79.383 rows=0 loops=1)

116. 0.001 0.798 ↓ 0.0 0 1

BitmapOr (cost=164.75..164.75 rows=5,582 width=0) (actual time=0.798..0.798 rows=0 loops=1)

117. 0.683 0.683 ↓ 1.4 6,423 1

Bitmap Index Scan on contributions_delaware_lower_idx (cost=0.00..73.58 rows=4,621 width=0) (actual time=0.683..0.683 rows=6,423 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
118. 0.114 0.114 ↓ 1.0 967 1

Bitmap Index Scan on contributions_delaware_lower_idx1 (cost=0.00..15.33 rows=961 width=0) (actual time=0.114..0.114 rows=967 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
119. 78.360 78.360 ↑ 379.0 2 1

Bitmap Index Scan on contributions_delaware_to_tsvector_idx2 (cost=0.00..174.24 rows=758 width=0) (actual time=78.360..78.360 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
120. 49.279 49.279 ↑ 758.0 1 1

Bitmap Index Scan on contributions_delaware_to_tsvector_idx3 (cost=0.00..109.34 rows=758 width=0) (actual time=49.279..49.279 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
121. 0.012 6.240 ↑ 1,032.0 1 1

Bitmap Heap Scan on contributions_district_of_columbia ct_23 (cost=154.46..2,273.72 rows=1,032 width=423) (actual time=6.238..6.240 rows=1 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=2
122. 0.122 6.228 ↓ 0.0 0 1

BitmapOr (cost=154.46..154.46 rows=1,032 width=0) (actual time=6.228..6.228 rows=0 loops=1)

123. 0.142 3.837 ↓ 0.0 0 1

BitmapAnd (cost=142.99..142.99 rows=11 width=0) (actual time=3.837..3.837 rows=0 loops=1)

124. 3.302 3.302 ↑ 340.3 3 1

Bitmap Index Scan on contributions_district_of_columbia_to_tsvector_idx2 (cost=0.00..11.21 rows=1,021 width=0) (actual time=3.302..3.302 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
125. 0.001 0.393 ↓ 0.0 0 1

BitmapOr (cost=131.27..131.27 rows=2,159 width=0) (actual time=0.393..0.393 rows=0 loops=1)

126. 0.028 0.028 ↓ 1.2 187 1

Bitmap Index Scan on contributions_district_of_columbia_lower_idx (cost=0.00..2.70 rows=157 width=0) (actual time=0.028..0.028 rows=187 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
127. 0.364 0.364 ↓ 1.3 2,529 1

Bitmap Index Scan on contributions_district_of_columbia_lower_idx1 (cost=0.00..26.44 rows=2,002 width=0) (actual time=0.364..0.364 rows=2,529 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
128. 2.269 2.269 ↑ 510.5 2 1

Bitmap Index Scan on contributions_district_of_columbia_to_tsvector_idx3 (cost=0.00..11.21 rows=1,021 width=0) (actual time=2.269..2.269 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
129. 0.002 0.532 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_dublin_ca ct_24 (cost=4.92..11.25 rows=3 width=688) (actual time=0.532..0.532 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
130. 0.221 0.530 ↓ 0.0 0 1

BitmapOr (cost=4.92..4.92 rows=3 width=0) (actual time=0.530..0.530 rows=0 loops=1)

131. 0.162 0.162 ↓ 0.0 0 1

Bitmap Index Scan on contributions_dublin_ca_to_tsvector_idx2 (cost=0.00..2.46 rows=1 width=0) (actual time=0.162..0.162 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
132. 0.147 0.147 ↓ 0.0 0 1

Bitmap Index Scan on contributions_dublin_ca_to_tsvector_idx3 (cost=0.00..2.46 rows=1 width=0) (actual time=0.147..0.147 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
133. 3.477 317.477 ↑ 226.7 63 1

Bitmap Heap Scan on contributions_federal_api ct_25 (cost=6,223.20..36,248.08 rows=14,282 width=1,497) (actual time=314.111..317.477 rows=63 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Rows Removed by Index Recheck: 2
  • Heap Blocks: exact=112
134. 0.139 314.000 ↓ 0.0 0 1

BitmapOr (cost=6,223.20..6,223.20 rows=14,292 width=0) (actual time=314.000..314.000 rows=0 loops=1)

135. 1.353 156.496 ↓ 0.0 0 1

BitmapAnd (cost=5,842.94..5,842.94 rows=1,939 width=0) (actual time=156.496..156.496 rows=0 loops=1)

136. 64.218 64.218 ↑ 94.3 131 1

Bitmap Index Scan on contributions_federal_api_to_tsvector_idx2 (cost=0.00..166.60 rows=12,353 width=0) (actual time=64.218..64.218 rows=131 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
137. 0.002 90.925 ↓ 0.0 0 1

BitmapOr (cost=5,672.52..5,672.52 rows=387,797 width=0) (actual time=90.925..90.925 rows=0 loops=1)

138. 0.147 0.147 ↓ 2.0 976 1

Bitmap Index Scan on contributions_federal_api_lower_idx (cost=0.00..6.33 rows=494 width=0) (actual time=0.147..0.147 rows=976 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
139. 90.776 90.776 ↑ 1.1 368,724 1

Bitmap Index Scan on contributions_federal_api_lower_idx (cost=0.00..4,430.90 rows=387,303 width=0) (actual time=90.776..90.776 rows=368,724 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
140. 157.365 157.365 ↑ 101.3 122 1

Bitmap Index Scan on contributions_federal_api_to_tsvector_idx3 (cost=0.00..376.70 rows=12,353 width=0) (actual time=157.365..157.365 rows=122 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
141. 0.004 0.245 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_florida ct_26 (cost=6.10..10.28 rows=1 width=776) (actual time=0.245..0.245 rows=0 loops=1)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
142. 0.108 0.241 ↓ 0.0 0 1

BitmapOr (cost=6.10..6.10 rows=2 width=0) (actual time=0.241..0.241 rows=0 loops=1)

143. 0.000 0.015 ↓ 0.0 0 1

BitmapOr (cost=2.55..2.55 rows=2 width=0) (actual time=0.015..0.015 rows=0 loops=1)

144. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on contributions_florida_lower_idx (cost=0.00..1.25 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
145. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on contributions_florida_lower_idx1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
146. 0.118 0.118 ↓ 0.0 0 1

Bitmap Index Scan on contributions_florida_to_tsvector_idx3 (cost=0.00..3.55 rows=1 width=0) (actual time=0.118..0.118 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
147. 0.001 0.377 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_folsom_ca ct_27 (cost=4.91..7.04 rows=1 width=776) (actual time=0.377..0.377 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
148. 0.185 0.376 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.376..0.376 rows=0 loops=1)

149. 0.092 0.092 ↓ 0.0 0 1

Bitmap Index Scan on contributions_folsom_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.092..0.092 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
150. 0.099 0.099 ↓ 0.0 0 1

Bitmap Index Scan on contributions_folsom_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.099..0.099 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
151. 0.002 1.030 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_fresno_ca ct_28 (cost=9.24..564.60 rows=266 width=688) (actual time=1.030..1.030 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
152. 0.213 1.028 ↓ 0.0 0 1

BitmapOr (cost=9.24..9.24 rows=267 width=0) (actual time=1.028..1.028 rows=0 loops=1)

153. 0.406 0.406 ↓ 0.0 0 1

Bitmap Index Scan on contributions_fresno_ca_to_tsvector_idx2 (cost=0.00..4.55 rows=134 width=0) (actual time=0.406..0.406 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
154. 0.409 0.409 ↓ 0.0 0 1

Bitmap Index Scan on contributions_fresno_ca_to_tsvector_idx3 (cost=0.00..4.55 rows=134 width=0) (actual time=0.409..0.409 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
155. 0.001 0.414 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_fresno_county ct_29 (cost=4.91..7.04 rows=1 width=776) (actual time=0.414..0.414 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
156. 0.213 0.413 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.413..0.413 rows=0 loops=1)

157. 0.097 0.097 ↓ 0.0 0 1

Bitmap Index Scan on contributions_fresno_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.097..0.097 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
158. 0.103 0.103 ↓ 0.0 0 1

Bitmap Index Scan on contributions_fresno_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.103..0.103 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
159. 0.869 223.791 ↑ 31.9 274 1

Bitmap Heap Scan on contributions_georgia ct_30 (cost=2,629.56..20,590.37 rows=8,734 width=543) (actual time=222.967..223.791 rows=274 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=302
160. 0.131 222.922 ↓ 0.0 0 1

BitmapOr (cost=2,629.56..2,629.56 rows=8,736 width=0) (actual time=222.922..222.922 rows=0 loops=1)

161. 0.102 3.792 ↓ 0.0 0 1

BitmapAnd (cost=2,140.17..2,140.17 rows=422 width=0) (actual time=3.792..3.792 rows=0 loops=1)

162. 3.690 3.690 ↓ 0.0 0 1

Bitmap Index Scan on contributions_georgia_to_tsvector_idx2 (cost=0.00..199.00 rows=8,314 width=0) (actual time=3.690..3.690 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
163. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=1,938.73..1,938.73 rows=84,468 width=0) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_georgia_lower_idx (cost=0.00..1.94 rows=55 width=0) (never executed)

  • Index Cond: (lower(contributor_state) IS NULL)
165. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_georgia_lower_idx (cost=0.00..1,105.42 rows=84,412 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
166. 218.999 218.999 ↑ 26.8 310 1

Bitmap Index Scan on contributions_georgia_to_tsvector_idx3 (cost=0.00..487.20 rows=8,314 width=0) (actual time=218.999..218.999 rows=310 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
167. 0.001 1.110 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_glendale_ca ct_31 (cost=9.44..47.26 rows=17 width=648) (actual time=1.110..1.110 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
168. 0.231 1.109 ↓ 0.0 0 1

BitmapOr (cost=9.44..9.44 rows=18 width=0) (actual time=1.109..1.109 rows=0 loops=1)

169. 0.514 0.514 ↓ 0.0 0 1

Bitmap Index Scan on contributions_glendale_ca_to_tsvector_idx2 (cost=0.00..4.72 rows=9 width=0) (actual time=0.514..0.514 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
170. 0.364 0.364 ↓ 0.0 0 1

Bitmap Index Scan on contributions_glendale_ca_to_tsvector_idx3 (cost=0.00..4.72 rows=9 width=0) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
171. 0.002 0.389 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_hawaii ct_32 (cost=4.91..7.04 rows=1 width=776) (actual time=0.389..0.389 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
172. 0.191 0.387 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.386..0.387 rows=0 loops=1)

173. 0.097 0.097 ↓ 0.0 0 1

Bitmap Index Scan on contributions_hawaii_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.097..0.097 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
174. 0.099 0.099 ↓ 0.0 0 1

Bitmap Index Scan on contributions_hawaii_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.099..0.099 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
175. 0.002 13.623 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_hayward_ca ct_33 (cost=32.56..76.81 rows=20 width=699) (actual time=13.623..13.623 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
176. 0.203 13.621 ↓ 0.0 0 1

BitmapOr (cost=32.56..32.56 rows=21 width=0) (actual time=13.621..13.621 rows=0 loops=1)

177. 6.968 6.968 ↓ 0.0 0 1

Bitmap Index Scan on contributions_hayward_ca_to_tsvector_idx2 (cost=0.00..16.83 rows=10 width=0) (actual time=6.968..6.968 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
178. 6.450 6.450 ↓ 0.0 0 1

Bitmap Index Scan on contributions_hayward_ca_to_tsvector_idx3 (cost=0.00..15.73 rows=10 width=0) (actual time=6.450..6.450 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
179. 0.002 1.293 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_hesperia_ca ct_34 (cost=8.21..10.34 rows=1 width=680) (actual time=1.293..1.293 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
180. 0.230 1.291 ↓ 0.0 0 1

BitmapOr (cost=8.21..8.21 rows=1 width=0) (actual time=1.291..1.291 rows=0 loops=1)

181. 0.697 0.697 ↓ 0.0 0 1

Bitmap Index Scan on contributions_hesperia_ca_to_tsvector_idx2 (cost=0.00..4.66 rows=1 width=0) (actual time=0.696..0.697 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
182. 0.364 0.364 ↓ 0.0 0 1

Bitmap Index Scan on contributions_hesperia_ca_to_tsvector_idx3 (cost=0.00..3.56 rows=1 width=0) (actual time=0.364..0.364 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
183. 0.015 426.771 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_houston ct_35 (cost=875.50..1,475.05 rows=286 width=550) (actual time=426.771..426.771 rows=0 loops=1)

  • Recheck Cond: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
184. 0.121 426.756 ↓ 0.0 0 1

BitmapOr (cost=875.50..875.50 rows=287 width=0) (actual time=426.756..426.756 rows=0 loops=1)

185. 0.149 237.542 ↓ 0.0 0 1

BitmapAnd (cost=507.88..507.88 rows=6 width=0) (actual time=237.542..237.542 rows=0 loops=1)

186. 0.001 0.281 ↓ 0.0 0 1

BitmapOr (cost=53.10..53.10 rows=1,173 width=0) (actual time=0.281..0.281 rows=0 loops=1)

187. 0.063 0.063 ↓ 2.2 498 1

Bitmap Index Scan on contributions_houston_lower_idx (cost=0.00..5.39 rows=223 width=0) (actual time=0.063..0.063 rows=498 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
188. 0.217 0.217 ↓ 2.1 1,962 1

Bitmap Index Scan on contributions_houston_lower_idx1 (cost=0.00..19.65 rows=951 width=0) (actual time=0.217..0.217 rows=1,962 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
189. 237.112 237.112 ↑ 70.2 4 1

Bitmap Index Scan on contributions_houston_to_tsvector_idx2 (cost=0.00..454.45 rows=281 width=0) (actual time=237.112..237.112 rows=4 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
190. 189.093 189.093 ↓ 0.0 0 1

Bitmap Index Scan on contributions_houston_to_tsvector_idx3 (cost=0.00..367.55 rows=281 width=0) (actual time=189.093..189.093 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
191. 0.813 2.252 ↑ 23.9 7 1

Bitmap Heap Scan on contributions_huntingtonbeach_ca ct_36 (cost=8.45..354.15 rows=167 width=661) (actual time=1.586..2.252 rows=7 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=6
192. 0.253 1.439 ↓ 0.0 0 1

BitmapOr (cost=8.45..8.45 rows=168 width=0) (actual time=1.439..1.439 rows=0 loops=1)

193. 0.631 0.631 ↑ 12.0 7 1

Bitmap Index Scan on contributions_huntingtonbeach_ca_to_tsvector_idx2 (cost=0.00..4.18 rows=84 width=0) (actual time=0.631..0.631 rows=7 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
194. 0.555 0.555 ↑ 12.0 7 1

Bitmap Index Scan on contributions_huntingtonbeach_ca_to_tsvector_idx3 (cost=0.00..4.18 rows=84 width=0) (actual time=0.555..0.555 rows=7 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
195. 0.003 0.457 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_idaho ct_37 (cost=4.91..7.04 rows=1 width=776) (actual time=0.456..0.457 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
196. 0.215 0.454 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.454..0.454 rows=0 loops=1)

197. 0.122 0.122 ↓ 0.0 0 1

Bitmap Index Scan on contributions_idaho_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.122..0.122 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
198. 0.117 0.117 ↓ 0.0 0 1

Bitmap Index Scan on contributions_idaho_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.117..0.117 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
199. 0.047 278.899 ↑ 542.4 8 1

Bitmap Heap Scan on contributions_illinois ct_38 (cost=1,187.87..10,184.41 rows=4,339 width=485) (actual time=278.865..278.899 rows=8 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=8
200. 0.137 278.852 ↓ 0.0 0 1

BitmapOr (cost=1,187.87..1,187.87 rows=4,339 width=0) (actual time=278.852..278.852 rows=0 loops=1)

201. 0.114 70.351 ↓ 0.0 0 1

BitmapAnd (cost=695.56..695.56 rows=36 width=0) (actual time=70.351..70.351 rows=0 loops=1)

202. 68.392 68.392 ↑ 269.0 16 1

Bitmap Index Scan on contributions_illinois_to_tsvector_idx2 (cost=0.00..156.83 rows=4,304 width=0) (actual time=68.392..68.392 rows=16 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
203. 0.002 1.845 ↓ 0.0 0 1

BitmapOr (cost=537.40..537.40 rows=7,116 width=0) (actual time=1.845..1.845 rows=0 loops=1)

204. 0.067 0.067 ↑ 1.4 339 1

Bitmap Index Scan on contributions_illinois_lower_idx (cost=0.00..8.49 rows=488 width=0) (actual time=0.067..0.067 rows=339 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
205. 1.776 1.776 ↑ 1.1 6,075 1

Bitmap Index Scan on contributions_illinois_lower_idx (cost=0.00..98.54 rows=6,628 width=0) (actual time=1.776..1.776 rows=6,075 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
206. 208.364 208.364 ↑ 391.3 11 1

Bitmap Index Scan on contributions_illinois_to_tsvector_idx3 (cost=0.00..491.23 rows=4,304 width=0) (actual time=208.364..208.364 rows=11 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
207. 0.119 28.904 ↑ 120.4 39 1

Bitmap Heap Scan on contributions_indiana ct_39 (cost=835.96..10,541.81 rows=4,694 width=556) (actual time=28.806..28.904 rows=39 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=27
208. 0.141 28.785 ↓ 0.0 0 1

BitmapOr (cost=835.96..835.96 rows=4,695 width=0) (actual time=28.784..28.785 rows=0 loops=1)

209. 0.142 17.346 ↓ 0.0 0 1

BitmapAnd (cost=794.68..794.68 rows=115 width=0) (actual time=17.346..17.346 rows=0 loops=1)

210. 13.940 13.940 ↑ 97.4 47 1

Bitmap Index Scan on contributions_indiana_to_tsvector_idx2 (cost=0.00..40.10 rows=4,580 width=0) (actual time=13.940..13.940 rows=47 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
211. 0.001 3.264 ↓ 0.0 0 1

BitmapOr (cost=753.16..753.16 rows=22,961 width=0) (actual time=3.264..3.264 rows=0 loops=1)

212. 0.855 0.855 ↓ 1.2 9,346 1

Bitmap Index Scan on contributions_indiana_lower_idx (cost=0.00..98.37 rows=7,633 width=0) (actual time=0.855..0.855 rows=9,346 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
213. 2.408 2.408 ↓ 1.1 16,100 1

Bitmap Index Scan on contributions_indiana_lower_idx1 (cost=0.00..196.79 rows=15,328 width=0) (actual time=2.408..2.408 rows=16,100 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
214. 11.298 11.298 ↑ 97.4 47 1

Bitmap Index Scan on contributions_indiana_to_tsvector_idx3 (cost=0.00..40.10 rows=4,580 width=0) (actual time=11.298..11.298 rows=47 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
215. 0.002 0.436 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_iowa ct_40 (cost=4.91..7.04 rows=1 width=776) (actual time=0.436..0.436 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
216. 0.232 0.434 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.434..0.434 rows=0 loops=1)

217. 0.104 0.104 ↓ 0.0 0 1

Bitmap Index Scan on contributions_iowa_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.104..0.104 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
218. 0.098 0.098 ↓ 0.0 0 1

Bitmap Index Scan on contributions_iowa_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.098..0.098 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
219. 0.005 40.438 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_irvine_ca ct_41 (cost=87.05..281.86 rows=93 width=640) (actual time=40.438..40.438 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
220. 0.204 40.433 ↓ 0.0 0 1

BitmapOr (cost=87.05..87.05 rows=94 width=0) (actual time=40.433..40.433 rows=0 loops=1)

221. 20.961 20.961 ↓ 0.0 0 1

Bitmap Index Scan on contributions_irvine_ca_to_tsvector_idx2 (cost=0.00..45.70 rows=47 width=0) (actual time=20.961..20.961 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
222. 19.268 19.268 ↓ 0.0 0 1

Bitmap Index Scan on contributions_irvine_ca_to_tsvector_idx3 (cost=0.00..41.30 rows=47 width=0) (actual time=19.268..19.268 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
223. 0.013 3.789 ↑ 543.0 1 1

Bitmap Heap Scan on contributions_kansas ct_42 (cost=144.13..1,262.84 rows=543 width=447) (actual time=3.789..3.789 rows=1 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=1
224. 0.122 3.776 ↓ 0.0 0 1

BitmapOr (cost=144.13..144.13 rows=543 width=0) (actual time=3.776..3.776 rows=0 loops=1)

225. 0.137 2.447 ↓ 0.0 0 1

BitmapAnd (cost=136.57..136.57 rows=27 width=0) (actual time=2.447..2.447 rows=0 loops=1)

226. 1.414 1.414 ↑ 258.0 2 1

Bitmap Index Scan on contributions_kansas_to_tsvector_idx2 (cost=0.00..7.42 rows=516 width=0) (actual time=1.414..1.414 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
227. 0.001 0.896 ↓ 0.0 0 1

BitmapOr (cost=128.76..128.76 rows=5,334 width=0) (actual time=0.896..0.896 rows=0 loops=1)

228. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on contributions_kansas_lower_idx (cost=0.00..1.53 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
229. 0.881 0.881 ↓ 1.0 5,372 1

Bitmap Index Scan on contributions_kansas_lower_idx1 (cost=0.00..75.62 rows=5,334 width=0) (actual time=0.881..0.881 rows=5,372 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
230. 1.207 1.207 ↑ 516.0 1 1

Bitmap Index Scan on contributions_kansas_to_tsvector_idx3 (cost=0.00..7.42 rows=516 width=0) (actual time=1.207..1.207 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
231. 0.021 1.713 ↑ 57.5 2 1

Bitmap Heap Scan on contributions_kentucky ct_43 (cost=24.32..264.85 rows=115 width=550) (actual time=1.706..1.713 rows=2 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=2
232. 0.122 1.692 ↓ 0.0 0 1

BitmapOr (cost=24.32..24.32 rows=115 width=0) (actual time=1.692..1.692 rows=0 loops=1)

233. 0.137 0.952 ↓ 0.0 0 1

BitmapAnd (cost=19.88..19.88 rows=1 width=0) (actual time=0.952..0.952 rows=0 loops=1)

234. 0.740 0.740 ↑ 57.5 2 1

Bitmap Index Scan on contributions_kentucky_to_tsvector_idx2 (cost=0.00..4.41 rows=115 width=0) (actual time=0.739..0.740 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
235. 0.001 0.075 ↓ 0.0 0 1

BitmapOr (cost=15.19..15.19 rows=129 width=0) (actual time=0.075..0.075 rows=0 loops=1)

236. 0.045 0.045 ↑ 1.0 45 1

Bitmap Index Scan on contributions_kentucky_lower_idx (cost=0.00..1.73 rows=45 width=0) (actual time=0.045..0.045 rows=45 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
237. 0.029 0.029 ↑ 1.0 84 1

Bitmap Index Scan on contributions_kentucky_lower_idx1 (cost=0.00..2.02 rows=84 width=0) (actual time=0.029..0.029 rows=84 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
238. 0.618 0.618 ↑ 57.5 2 1

Bitmap Index Scan on contributions_kentucky_to_tsvector_idx3 (cost=0.00..4.41 rows=115 width=0) (actual time=0.618..0.618 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
239. 0.002 1.209 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_lakeforest_ca ct_44 (cost=7.14..15.55 rows=4 width=721) (actual time=1.209..1.209 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
240. 0.227 1.207 ↓ 0.0 0 1

BitmapOr (cost=7.14..7.14 rows=4 width=0) (actual time=1.207..1.207 rows=0 loops=1)

241. 0.595 0.595 ↓ 0.0 0 1

Bitmap Index Scan on contributions_lakeforest_ca_to_tsvector_idx2 (cost=0.00..3.57 rows=2 width=0) (actual time=0.595..0.595 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
242. 0.385 0.385 ↓ 0.0 0 1

Bitmap Index Scan on contributions_lakeforest_ca_to_tsvector_idx3 (cost=0.00..3.57 rows=2 width=0) (actual time=0.385..0.385 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
243. 0.001 0.556 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_livermore_ca ct_45 (cost=4.95..17.66 rows=6 width=635) (actual time=0.556..0.556 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
244. 0.243 0.555 ↓ 0.0 0 1

BitmapOr (cost=4.95..4.95 rows=6 width=0) (actual time=0.555..0.555 rows=0 loops=1)

245. 0.160 0.160 ↓ 0.0 0 1

Bitmap Index Scan on contributions_livermore_ca_to_tsvector_idx2 (cost=0.00..2.47 rows=3 width=0) (actual time=0.160..0.160 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
246. 0.152 0.152 ↓ 0.0 0 1

Bitmap Index Scan on contributions_livermore_ca_to_tsvector_idx3 (cost=0.00..2.47 rows=3 width=0) (actual time=0.152..0.152 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
247. 0.001 0.434 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_longbeach_ca ct_46 (cost=4.91..7.04 rows=1 width=776) (actual time=0.434..0.434 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
248. 0.203 0.433 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.433..0.433 rows=0 loops=1)

249. 0.125 0.125 ↓ 0.0 0 1

Bitmap Index Scan on contributions_longbeach_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.125..0.125 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
250. 0.105 0.105 ↓ 0.0 0 1

Bitmap Index Scan on contributions_longbeach_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
251. 0.407 120.577 ↑ 1,152.0 3 1

Bitmap Heap Scan on contributions_los_angeles ct_47 (cost=280.01..7,392.89 rows=3,456 width=399) (actual time=120.356..120.577 rows=3 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=3
252. 0.224 120.170 ↓ 0.0 0 1

BitmapOr (cost=280.01..280.01 rows=3,598 width=0) (actual time=120.170..120.170 rows=0 loops=1)

253. 65.703 65.703 ↑ 599.7 3 1

Bitmap Index Scan on contributions_los_angeles_to_tsvector_idx2 (cost=0.00..151.24 rows=1,799 width=0) (actual time=65.703..65.703 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
254. 54.243 54.243 ↑ 599.7 3 1

Bitmap Index Scan on contributions_los_angeles_to_tsvector_idx3 (cost=0.00..127.04 rows=1,799 width=0) (actual time=54.243..54.243 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
255. 0.003 0.507 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_louisiana ct_48 (cost=4.91..7.04 rows=1 width=776) (actual time=0.506..0.507 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
256. 0.223 0.504 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.504..0.504 rows=0 loops=1)

257. 0.136 0.136 ↓ 0.0 0 1

Bitmap Index Scan on contributions_louisiana_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.136..0.136 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
258. 0.145 0.145 ↓ 0.0 0 1

Bitmap Index Scan on contributions_louisiana_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.145..0.145 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
259. 0.004 15.952 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_madera_county ct_49 (cost=40.27..84.51 rows=21 width=680) (actual time=15.952..15.952 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
260. 0.291 15.948 ↓ 0.0 0 1

BitmapOr (cost=40.27..40.27 rows=21 width=0) (actual time=15.948..15.948 rows=0 loops=1)

261. 10.070 10.070 ↓ 0.0 0 1

Bitmap Index Scan on contributions_madera_county_to_tsvector_idx2 (cost=0.00..24.53 rows=10 width=0) (actual time=10.070..10.070 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
262. 5.587 5.587 ↓ 0.0 0 1

Bitmap Index Scan on contributions_madera_county_to_tsvector_idx3 (cost=0.00..15.73 rows=10 width=0) (actual time=5.587..5.587 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
263. 0.014 10.344 ↑ 1,802.0 1 1

Bitmap Heap Scan on contributions_maine ct_50 (cost=494.13..4,235.32 rows=1,802 width=564) (actual time=10.343..10.344 rows=1 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=1
264. 0.125 10.330 ↓ 0.0 0 1

BitmapOr (cost=494.13..494.13 rows=1,803 width=0) (actual time=10.330..10.330 rows=0 loops=1)

265. 0.118 6.931 ↓ 0.0 0 1

BitmapAnd (cost=476.28..476.28 rows=103 width=0) (actual time=6.931..6.931 rows=0 loops=1)

266. 3.819 3.819 ↑ 1,700.0 1 1

Bitmap Index Scan on contributions_maine_to_tsvector_idx2 (cost=0.00..17.40 rows=1,700 width=0) (actual time=3.819..3.819 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
267. 0.001 2.994 ↓ 0.0 0 1

BitmapOr (cost=458.18..458.18 rows=20,561 width=0) (actual time=2.994..2.994 rows=0 loops=1)

268. 0.096 0.096 ↓ 1.1 1,081 1

Bitmap Index Scan on contributions_maine_lower_idx (cost=0.00..14.42 rows=986 width=0) (actual time=0.096..0.096 rows=1,081 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
269. 2.897 2.897 ↓ 1.0 19,735 1

Bitmap Index Scan on contributions_maine_lower_idx1 (cost=0.00..273.74 rows=19,575 width=0) (actual time=2.897..2.897 rows=19,735 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
270. 3.274 3.274 ↑ 1,700.0 1 1

Bitmap Index Scan on contributions_maine_to_tsvector_idx3 (cost=0.00..17.40 rows=1,700 width=0) (actual time=3.274..3.274 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
271. 0.002 7.356 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_manhattanbeach_ca ct_51 (cost=20.35..33.05 rows=6 width=709) (actual time=7.356..7.356 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
272. 0.221 7.354 ↓ 0.0 0 1

BitmapOr (cost=20.35..20.35 rows=6 width=0) (actual time=7.354..7.354 rows=0 loops=1)

273. 3.604 3.604 ↓ 0.0 0 1

Bitmap Index Scan on contributions_manhattanbeach_ca_to_tsvector_idx2 (cost=0.00..10.17 rows=3 width=0) (actual time=3.604..3.604 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
274. 3.529 3.529 ↓ 0.0 0 1

Bitmap Index Scan on contributions_manhattanbeach_ca_to_tsvector_idx3 (cost=0.00..10.17 rows=3 width=0) (actual time=3.529..3.529 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
275. 0.004 2.683 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_manteca_ca ct_52 (cost=10.43..18.86 rows=4 width=689) (actual time=2.683..2.683 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
276. 0.200 2.679 ↓ 0.0 0 1

BitmapOr (cost=10.43..10.43 rows=4 width=0) (actual time=2.679..2.679 rows=0 loops=1)

277. 1.524 1.524 ↓ 0.0 0 1

Bitmap Index Scan on contributions_manteca_ca_to_tsvector_idx2 (cost=0.00..5.77 rows=2 width=0) (actual time=1.524..1.524 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
278. 0.955 0.955 ↓ 0.0 0 1

Bitmap Index Scan on contributions_manteca_ca_to_tsvector_idx3 (cost=0.00..4.67 rows=2 width=0) (actual time=0.955..0.955 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
279. 0.004 20.874 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_marin_county ct_53 (cost=48.63..261.66 rows=103 width=635) (actual time=20.873..20.874 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
280. 0.217 20.870 ↓ 0.0 0 1

BitmapOr (cost=48.63..48.63 rows=104 width=0) (actual time=20.870..20.870 rows=0 loops=1)

281. 10.867 10.867 ↓ 0.0 0 1

Bitmap Index Scan on contributions_marin_county_to_tsvector_idx2 (cost=0.00..25.94 rows=52 width=0) (actual time=10.867..10.867 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
282. 9.786 9.786 ↓ 0.0 0 1

Bitmap Index Scan on contributions_marin_county_to_tsvector_idx3 (cost=0.00..22.64 rows=52 width=0) (actual time=9.786..9.786 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
283. 0.013 0.498 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_maryland ct_54 (cost=6.39..10.60 rows=1 width=520) (actual time=0.498..0.498 rows=0 loops=1)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
284. 0.114 0.485 ↓ 0.0 0 1

BitmapOr (cost=6.39..6.39 rows=2 width=0) (actual time=0.485..0.485 rows=0 loops=1)

285. 0.000 0.018 ↓ 0.0 0 1

BitmapOr (cost=2.83..2.83 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

286. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on contributions_maryland_lower_idx (cost=0.00..1.38 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
287. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on contributions_maryland_lower_idx1 (cost=0.00..1.38 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
288. 0.353 0.353 ↓ 0.0 0 1

Bitmap Index Scan on contributions_maryland_to_tsvector_idx3 (cost=0.00..3.56 rows=1 width=0) (actual time=0.353..0.353 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
289. 0.002 0.417 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_massachusetts ct_55 (cost=4.91..7.04 rows=1 width=776) (actual time=0.417..0.417 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
290. 0.218 0.415 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.415..0.415 rows=0 loops=1)

291. 0.103 0.103 ↓ 0.0 0 1

Bitmap Index Scan on contributions_massachusetts_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.103..0.103 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
292. 0.094 0.094 ↓ 0.0 0 1

Bitmap Index Scan on contributions_massachusetts_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.094..0.094 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
293. 0.002 0.397 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_merced_county ct_56 (cost=4.91..7.04 rows=1 width=776) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
294. 0.208 0.395 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.395..0.395 rows=0 loops=1)

295. 0.096 0.096 ↓ 0.0 0 1

Bitmap Index Scan on contributions_merced_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
296. 0.091 0.091 ↓ 0.0 0 1

Bitmap Index Scan on contributions_merced_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.091..0.091 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
297. 4.387 1,122.052 ↑ 116.4 898 1

Bitmap Heap Scan on contributions_michigan ct_57 (cost=14,899.51..230,950.91 rows=104,516 width=523) (actual time=1,117.875..1,122.052 rows=898 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=1754
298. 0.146 1,117.665 ↓ 0.0 0 1

BitmapOr (cost=14,899.51..14,899.51 rows=104,522 width=0) (actual time=1,117.665..1,117.665 rows=0 loops=1)

299. 0.271 542.890 ↓ 0.0 0 1

BitmapAnd (cost=13,729.88..13,729.88 rows=929 width=0) (actual time=542.890..542.890 rows=0 loops=1)

300. 509.346 509.346 ↑ 51.9 1,997 1

Bitmap Index Scan on contributions_michigan_to_tsvector_idx2 (cost=0.00..980.69 rows=103,593 width=0) (actual time=509.346..509.346 rows=1,997 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
301. 0.002 33.273 ↓ 0.0 0 1

BitmapOr (cost=12,722.81..12,722.81 rows=185,776 width=0) (actual time=33.273..33.273 rows=0 loops=1)

302. 3.923 3.923 ↓ 2.3 46,737 1

Bitmap Index Scan on contributions_michigan_lower_idx (cost=0.00..255.27 rows=20,028 width=0) (actual time=3.923..3.923 rows=46,737 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
303. 29.348 29.348 ↓ 1.2 205,759 1

Bitmap Index Scan on contributions_michigan_lower_idx (cost=0.00..2,108.27 rows=165,748 width=0) (actual time=29.348..29.348 rows=205,759 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
304. 574.629 574.629 ↑ 52.0 1,993 1

Bitmap Index Scan on contributions_michigan_to_tsvector_idx3 (cost=0.00..1,143.49 rows=103,593 width=0) (actual time=574.629..574.629 rows=1,993 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
305. 3.270 12.502 ↑ 126.7 31 1

Bitmap Heap Scan on contributions_minnesota ct_58 (cost=40.81..8,152.70 rows=3,929 width=584) (actual time=9.368..12.502 rows=31 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=28
306. 0.268 9.232 ↓ 0.0 0 1

BitmapOr (cost=40.81..40.81 rows=3,939 width=0) (actual time=9.232..9.232 rows=0 loops=1)

307. 4.753 4.753 ↑ 40.2 49 1

Bitmap Index Scan on contributions_minnesota_to_tsvector_idx2 (cost=0.00..19.42 rows=1,970 width=0) (actual time=4.753..4.753 rows=49 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
308. 4.211 4.211 ↑ 46.9 42 1

Bitmap Index Scan on contributions_minnesota_to_tsvector_idx3 (cost=0.00..19.42 rows=1,970 width=0) (actual time=4.211..4.211 rows=42 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
309. 0.022 134.613 ↑ 59.5 2 1

Bitmap Heap Scan on contributions_mississippi ct_59 (cost=305.53..554.62 rows=119 width=519) (actual time=134.610..134.613 rows=2 loops=1)

  • Recheck Cond: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=3
310. 0.134 134.591 ↓ 0.0 0 1

BitmapOr (cost=305.53..305.53 rows=119 width=0) (actual time=134.590..134.591 rows=0 loops=1)

311. 0.159 76.335 ↓ 0.0 0 1

BitmapAnd (cost=182.28..182.28 rows=3 width=0) (actual time=76.335..76.335 rows=0 loops=1)

312. 0.004 0.143 ↓ 0.0 0 1

BitmapOr (cost=25.78..25.78 rows=641 width=0) (actual time=0.143..0.143 rows=0 loops=1)

313. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on contributions_mississippi_lower_idx (cost=0.00..1.40 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
314. 0.127 0.127 ↓ 2.0 1,255 1

Bitmap Index Scan on contributions_mississippi_lower_idx1 (cost=0.00..12.79 rows=641 width=0) (actual time=0.127..0.127 rows=1,255 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
315. 76.033 76.033 ↑ 29.0 4 1

Bitmap Index Scan on contributions_mississippi_to_tsvector_idx2 (cost=0.00..156.22 rows=116 width=0) (actual time=76.033..76.033 rows=4 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
316. 58.122 58.122 ↑ 29.0 4 1

Bitmap Index Scan on contributions_mississippi_to_tsvector_idx3 (cost=0.00..123.22 rows=116 width=0) (actual time=58.122..58.122 rows=4 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
317. 0.003 0.518 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_missouri ct_60 (cost=4.91..7.04 rows=1 width=776) (actual time=0.518..0.518 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
318. 0.261 0.515 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.515..0.515 rows=0 loops=1)

319. 0.111 0.111 ↓ 0.0 0 1

Bitmap Index Scan on contributions_missouri_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.111..0.111 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
320. 0.143 0.143 ↓ 0.0 0 1

Bitmap Index Scan on contributions_missouri_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.143..0.143 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
321. 0.023 18.635 ↑ 59.3 3 1

Bitmap Heap Scan on contributions_montana ct_61 (cost=71.08..442.37 rows=178 width=533) (actual time=18.626..18.635 rows=3 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=3
322. 0.147 18.612 ↓ 0.0 0 1

BitmapOr (cost=71.08..71.08 rows=178 width=0) (actual time=18.612..18.612 rows=0 loops=1)

323. 0.100 10.038 ↓ 0.0 0 1

BitmapAnd (cost=50.77..50.77 rows=3 width=0) (actual time=10.038..10.038 rows=0 loops=1)

324. 9.851 9.851 ↑ 58.3 3 1

Bitmap Index Scan on contributions_montana_to_tsvector_idx2 (cost=0.00..22.46 rows=175 width=0) (actual time=9.851..9.851 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
325. 0.001 0.087 ↓ 0.0 0 1

BitmapOr (cost=28.01..28.01 rows=590 width=0) (actual time=0.087..0.087 rows=0 loops=1)

326. 0.010 0.010 ↓ 1.0 31 1

Bitmap Index Scan on contributions_montana_lower_idx (cost=0.00..1.62 rows=30 width=0) (actual time=0.010..0.010 rows=31 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
327. 0.076 0.076 ↓ 1.2 680 1

Bitmap Index Scan on contributions_montana_lower_idx (cost=0.00..8.88 rows=559 width=0) (actual time=0.076..0.076 rows=680 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
328. 8.427 8.427 ↑ 58.3 3 1

Bitmap Index Scan on contributions_montana_to_tsvector_idx3 (cost=0.00..20.26 rows=175 width=0) (actual time=8.427..8.427 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
329. 0.011 51.341 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_monterey_county ct_62 (cost=115.85..361.92 rows=118 width=637) (actual time=51.341..51.341 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
330. 0.257 51.330 ↓ 0.0 0 1

BitmapOr (cost=115.85..115.85 rows=119 width=0) (actual time=51.330..51.330 rows=0 loops=1)

331. 29.327 29.327 ↓ 0.0 0 1

Bitmap Index Scan on contributions_monterey_county_to_tsvector_idx2 (cost=0.00..64.50 rows=60 width=0) (actual time=29.327..29.327 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
332. 21.746 21.746 ↓ 0.0 0 1

Bitmap Index Scan on contributions_monterey_county_to_tsvector_idx3 (cost=0.00..51.30 rows=60 width=0) (actual time=21.746..21.746 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
333. 0.010 3.191 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_morganhill_ca ct_63 (cost=11.52..17.86 rows=3 width=715) (actual time=3.190..3.191 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
334. 0.229 3.181 ↓ 0.0 0 1

BitmapOr (cost=11.52..11.52 rows=3 width=0) (actual time=3.181..3.181 rows=0 loops=1)

335. 1.610 1.610 ↓ 0.0 0 1

Bitmap Index Scan on contributions_morganhill_ca_to_tsvector_idx2 (cost=0.00..5.76 rows=1 width=0) (actual time=1.610..1.610 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
336. 1.342 1.342 ↓ 0.0 0 1

Bitmap Index Scan on contributions_morganhill_ca_to_tsvector_idx3 (cost=0.00..5.76 rows=1 width=0) (actual time=1.342..1.342 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
337. 0.003 7.247 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_mountainview_ca ct_64 (cost=19.31..46.70 rows=13 width=667) (actual time=7.247..7.247 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
338. 0.247 7.244 ↓ 0.0 0 1

BitmapOr (cost=19.31..19.31 rows=13 width=0) (actual time=7.244..7.244 rows=0 loops=1)

339. 3.810 3.810 ↓ 0.0 0 1

Bitmap Index Scan on contributions_mountainview_ca_to_tsvector_idx2 (cost=0.00..10.20 rows=7 width=0) (actual time=3.810..3.810 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
340. 3.187 3.187 ↓ 0.0 0 1

Bitmap Index Scan on contributions_mountainview_ca_to_tsvector_idx3 (cost=0.00..9.10 rows=7 width=0) (actual time=3.187..3.187 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
341. 0.004 1.556 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_murrieta_ca ct_65 (cost=8.24..18.75 rows=5 width=647) (actual time=1.556..1.556 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
342. 0.248 1.552 ↓ 0.0 0 1

BitmapOr (cost=8.24..8.24 rows=5 width=0) (actual time=1.552..1.552 rows=0 loops=1)

343. 0.852 0.852 ↓ 0.0 0 1

Bitmap Index Scan on contributions_murrieta_ca_to_tsvector_idx2 (cost=0.00..4.67 rows=2 width=0) (actual time=0.852..0.852 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
344. 0.452 0.452 ↓ 0.0 0 1

Bitmap Index Scan on contributions_murrieta_ca_to_tsvector_idx3 (cost=0.00..3.57 rows=2 width=0) (actual time=0.452..0.452 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
345. 0.002 0.467 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_nebraska ct_66 (cost=4.91..7.04 rows=1 width=776) (actual time=0.467..0.467 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
346. 0.213 0.465 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.465..0.465 rows=0 loops=1)

347. 0.147 0.147 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nebraska_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.147..0.147 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
348. 0.105 0.105 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nebraska_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
349. 0.002 0.425 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_nebraska2 ct_67 (cost=4.91..7.04 rows=1 width=776) (actual time=0.425..0.425 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
350. 0.207 0.423 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.423..0.423 rows=0 loops=1)

351. 0.109 0.109 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nebraska2_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
352. 0.107 0.107 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nebraska2_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.107..0.107 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
353. 0.001 0.416 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_nevada ct_68 (cost=4.91..7.04 rows=1 width=776) (actual time=0.416..0.416 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
354. 0.210 0.415 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.415..0.415 rows=0 loops=1)

355. 0.109 0.109 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nevada_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
356. 0.096 0.096 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nevada_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
357. 0.010 1.099 ↑ 75.0 1 1

Bitmap Heap Scan on contributions_nevada2 ct_69 (cost=52.11..209.24 rows=75 width=510) (actual time=1.099..1.099 rows=1 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=1
358. 0.126 1.089 ↓ 0.0 0 1

BitmapOr (cost=52.11..52.11 rows=75 width=0) (actual time=1.089..1.089 rows=0 loops=1)

359. 0.131 0.663 ↓ 0.0 0 1

BitmapAnd (cost=48.00..48.00 rows=3 width=0) (actual time=0.663..0.663 rows=0 loops=1)

360. 0.381 0.381 ↑ 35.5 2 1

Bitmap Index Scan on contributions_nevada2_to_tsvector_idx2 (cost=0.00..4.08 rows=71 width=0) (actual time=0.381..0.381 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
361. 0.000 0.151 ↓ 0.0 0 1

BitmapOr (cost=43.65..43.65 rows=652 width=0) (actual time=0.151..0.151 rows=0 loops=1)

362. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nevada2_lower_idx (cost=0.00..1.52 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
363. 0.139 0.139 ↑ 1.0 652 1

Bitmap Index Scan on contributions_nevada2_lower_idx1 (cost=0.00..35.00 rows=652 width=0) (actual time=0.139..0.139 rows=652 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
364. 0.300 0.300 ↑ 71.0 1 1

Bitmap Index Scan on contributions_nevada2_to_tsvector_idx3 (cost=0.00..4.08 rows=71 width=0) (actual time=0.300..0.300 rows=1 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
365. 0.010 16.671 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_nevada_county ct_70 (cost=37.01..91.77 rows=26 width=638) (actual time=16.671..16.671 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
366. 0.213 16.661 ↓ 0.0 0 1

BitmapOr (cost=37.01..37.01 rows=26 width=0) (actual time=16.661..16.661 rows=0 loops=1)

367. 8.806 8.806 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nevada_county_to_tsvector_idx2 (cost=0.00..19.05 rows=13 width=0) (actual time=8.806..8.806 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
368. 7.642 7.642 ↓ 0.0 0 1

Bitmap Index Scan on contributions_nevada_county_to_tsvector_idx3 (cost=0.00..17.95 rows=13 width=0) (actual time=7.642..7.642 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
369. 0.002 0.532 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_new_hampshire ct_71 (cost=10.71..29.76 rows=9 width=641) (actual time=0.532..0.532 rows=0 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
370. 0.131 0.530 ↓ 0.0 0 1

BitmapOr (cost=10.71..10.71 rows=9 width=0) (actual time=0.530..0.530 rows=0 loops=1)

371. 0.107 0.253 ↓ 0.0 0 1

BitmapAnd (cost=8.19..8.19 rows=1 width=0) (actual time=0.253..0.253 rows=0 loops=1)

372. 0.146 0.146 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_hampshire_to_tsvector_idx2 (cost=0.00..2.52 rows=9 width=0) (actual time=0.146..0.146 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
373. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=5.42..5.42 rows=90 width=0) (never executed)

374. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_new_hampshire_lower_idx (cost=0.00..3.08 rows=80 width=0) (never executed)

  • Index Cond: (lower(contributor_state) IS NULL)
375. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_new_hampshire_lower_idx1 (cost=0.00..1.45 rows=10 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
376. 0.146 0.146 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_hampshire_to_tsvector_idx3 (cost=0.00..2.52 rows=9 width=0) (actual time=0.146..0.146 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
377. 0.002 0.417 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_new_jersey ct_72 (cost=4.91..7.04 rows=1 width=776) (actual time=0.416..0.417 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
378. 0.211 0.415 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.415..0.415 rows=0 loops=1)

379. 0.102 0.102 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_jersey_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
380. 0.102 0.102 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_jersey_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
381. 0.009 0.483 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_new_mexico ct_73 (cost=4.91..7.04 rows=1 width=776) (actual time=0.483..0.483 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
382. 0.242 0.474 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.474..0.474 rows=0 loops=1)

383. 0.109 0.109 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_mexico_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
384. 0.123 0.123 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_mexico_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.123..0.123 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
385. 0.008 27.077 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_newportbeach_ca ct_74 (cost=62.33..121.65 rows=28 width=690) (actual time=27.077..27.077 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
386. 0.257 27.069 ↓ 0.0 0 1

BitmapOr (cost=62.33..62.33 rows=28 width=0) (actual time=27.069..27.069 rows=0 loops=1)

387. 14.226 14.226 ↓ 0.0 0 1

Bitmap Index Scan on contributions_newportbeach_ca_to_tsvector_idx2 (cost=0.00..32.26 rows=14 width=0) (actual time=14.226..14.226 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
388. 12.586 12.586 ↓ 0.0 0 1

Bitmap Index Scan on contributions_newportbeach_ca_to_tsvector_idx3 (cost=0.00..30.06 rows=14 width=0) (actual time=12.586..12.586 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
389. 0.002 0.397 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_new_york ct_75 (cost=4.91..7.04 rows=1 width=776) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
390. 0.202 0.395 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.395..0.395 rows=0 loops=1)

391. 0.095 0.095 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_york_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.095..0.095 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
392. 0.098 0.098 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_york_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.098..0.098 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
393. 0.003 0.397 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_new_york_campaign ct_76 (cost=4.91..7.04 rows=1 width=776) (actual time=0.397..0.397 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
394. 0.193 0.394 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.394..0.394 rows=0 loops=1)

395. 0.105 0.105 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_york_campaign_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
396. 0.096 0.096 ↓ 0.0 0 1

Bitmap Index Scan on contributions_new_york_campaign_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
397. 0.125 203.670 ↑ 339.9 19 1

Bitmap Heap Scan on contributions_north_carolina ct_77 (cost=1,192.36..14,535.97 rows=6,458 width=449) (actual time=203.582..203.670 rows=19 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=25
398. 0.125 203.545 ↓ 0.0 0 1

BitmapOr (cost=1,192.36..1,192.36 rows=6,458 width=0) (actual time=203.545..203.545 rows=0 loops=1)

399. 0.119 112.758 ↓ 0.0 0 1

BitmapAnd (cost=979.54..979.54 rows=38 width=0) (actual time=112.758..112.758 rows=0 loops=1)

400. 111.456 111.456 ↑ 164.6 39 1

Bitmap Index Scan on contributions_north_carolina_to_tsvector_idx2 (cost=0.00..229.90 rows=6,420 width=0) (actual time=111.456..111.456 rows=39 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
401. 0.001 1.183 ↓ 0.0 0 1

BitmapOr (cost=747.78..747.78 rows=7,533 width=0) (actual time=1.183..1.183 rows=0 loops=1)

402. 0.281 0.281 ↓ 1.1 2,341 1

Bitmap Index Scan on contributions_north_carolina_lower_idx (cost=0.00..30.78 rows=2,140 width=0) (actual time=0.281..0.281 rows=2,341 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
403. 0.901 0.901 ↓ 1.3 6,753 1

Bitmap Index Scan on contributions_north_carolina_lower_idx (cost=0.00..74.97 rows=5,393 width=0) (actual time=0.901..0.901 rows=6,753 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
404. 90.662 90.662 ↑ 214.0 30 1

Bitmap Index Scan on contributions_north_carolina_to_tsvector_idx3 (cost=0.00..211.20 rows=6,420 width=0) (actual time=90.662..90.662 rows=30 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
405. 0.003 0.472 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_north_dakota ct_78 (cost=4.91..7.04 rows=1 width=776) (actual time=0.472..0.472 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
406. 0.252 0.469 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.469..0.469 rows=0 loops=1)

407. 0.111 0.111 ↓ 0.0 0 1

Bitmap Index Scan on contributions_north_dakota_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.111..0.111 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
408. 0.106 0.106 ↓ 0.0 0 1

Bitmap Index Scan on contributions_north_dakota_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.106..0.106 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
409. 0.008 1.320 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_oakland_ca ct_79 (cost=9.51..634.90 rows=294 width=655) (actual time=1.320..1.320 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
410. 0.214 1.312 ↓ 0.0 0 1

BitmapOr (cost=9.51..9.51 rows=302 width=0) (actual time=1.312..1.312 rows=0 loops=1)

411. 0.588 0.588 ↓ 0.0 0 1

Bitmap Index Scan on contributions_oakland_ca_to_tsvector_idx2 (cost=0.00..4.68 rows=151 width=0) (actual time=0.588..0.588 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
412. 0.510 0.510 ↓ 0.0 0 1

Bitmap Index Scan on contributions_oakland_ca_to_tsvector_idx3 (cost=0.00..4.68 rows=151 width=0) (actual time=0.510..0.510 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
413. 0.001 0.524 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_oceanside_ca ct_80 (cost=8.11..270.55 rows=125 width=647) (actual time=0.524..0.524 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
414. 0.218 0.523 ↓ 0.0 0 1

BitmapOr (cost=8.11..8.11 rows=126 width=0) (actual time=0.523..0.523 rows=0 loops=1)

415. 0.157 0.157 ↓ 0.0 0 1

Bitmap Index Scan on contributions_oceanside_ca_to_tsvector_idx2 (cost=0.00..4.02 rows=63 width=0) (actual time=0.157..0.157 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
416. 0.148 0.148 ↓ 0.0 0 1

Bitmap Index Scan on contributions_oceanside_ca_to_tsvector_idx3 (cost=0.00..4.02 rows=63 width=0) (actual time=0.148..0.148 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
417. 0.005 3.618 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_ohio ct_81 (cost=16.42..26.94 rows=5 width=572) (actual time=3.618..3.618 rows=0 loops=1)

  • Recheck Cond: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
418. 0.109 3.613 ↓ 0.0 0 1

BitmapOr (cost=16.42..16.42 rows=5 width=0) (actual time=3.613..3.613 rows=0 loops=1)

419. 0.108 2.035 ↓ 0.0 0 1

BitmapAnd (cost=10.63..10.63 rows=1 width=0) (actual time=2.035..2.035 rows=0 loops=1)

420. 0.000 0.023 ↓ 0.0 0 1

BitmapOr (cost=3.50..3.50 rows=32 width=0) (actual time=0.023..0.023 rows=0 loops=1)

421. 0.013 0.013 ↑ 1.0 22 1

Bitmap Index Scan on contributions_ohio_lower_idx (cost=0.00..1.54 rows=22 width=0) (actual time=0.013..0.013 rows=22 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
422. 0.010 0.010 ↑ 1.0 10 1

Bitmap Index Scan on contributions_ohio_lower_idx1 (cost=0.00..1.45 rows=10 width=0) (actual time=0.010..0.010 rows=10 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
423. 1.904 1.904 ↓ 0.0 0 1

Bitmap Index Scan on contributions_ohio_to_tsvector_idx2 (cost=0.00..6.89 rows=5 width=0) (actual time=1.904..1.904 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
424. 1.469 1.469 ↓ 0.0 0 1

Bitmap Index Scan on contributions_ohio_to_tsvector_idx3 (cost=0.00..5.79 rows=5 width=0) (actual time=1.469..1.469 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
425. 0.017 3.897 ↑ 231.5 2 1

Bitmap Heap Scan on contributions_oklahoma ct_82 (cost=64.50..1,025.14 rows=463 width=617) (actual time=3.894..3.897 rows=2 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=2
426. 0.118 3.880 ↓ 0.0 0 1

BitmapOr (cost=64.50..64.50 rows=463 width=0) (actual time=3.880..3.880 rows=0 loops=1)

427. 0.126 2.086 ↓ 0.0 0 1

BitmapAnd (cost=57.36..57.36 rows=1 width=0) (actual time=2.086..2.086 rows=0 loops=1)

428. 1.922 1.922 ↑ 231.5 2 1

Bitmap Index Scan on contributions_oklahoma_to_tsvector_idx2 (cost=0.00..7.02 rows=463 width=0) (actual time=1.922..1.922 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
429. 0.000 0.038 ↓ 0.0 0 1

BitmapOr (cost=49.97..49.97 rows=89 width=0) (actual time=0.038..0.038 rows=0 loops=1)

430. 0.015 0.015 ↑ 3.0 4 1

Bitmap Index Scan on contributions_oklahoma_lower_idx (cost=0.00..1.61 rows=12 width=0) (actual time=0.015..0.015 rows=4 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
431. 0.023 0.023 ↓ 1.2 89 1

Bitmap Index Scan on contributions_oklahoma_lower_idx1 (cost=0.00..2.10 rows=77 width=0) (actual time=0.023..0.023 rows=89 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
432. 1.676 1.676 ↑ 231.5 2 1

Bitmap Index Scan on contributions_oklahoma_to_tsvector_idx3 (cost=0.00..7.02 rows=463 width=0) (actual time=1.676..1.676 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
433. 0.024 12.738 ↑ 593.7 3 1

Bitmap Heap Scan on contributions_oklahoma2 ct_83 (cost=228.88..3,956.74 rows=1,781 width=522) (actual time=12.728..12.738 rows=3 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=3
434. 0.147 12.714 ↓ 0.0 0 1

BitmapOr (cost=228.88..228.88 rows=1,781 width=0) (actual time=12.714..12.714 rows=0 loops=1)

435. 0.121 6.525 ↓ 0.0 0 1

BitmapAnd (cost=210.46..210.46 rows=3 width=0) (actual time=6.525..6.525 rows=0 loops=1)

436. 6.297 6.297 ↑ 355.6 5 1

Bitmap Index Scan on contributions_oklahoma2_to_tsvector_idx2 (cost=0.00..17.98 rows=1,778 width=0) (actual time=6.297..6.297 rows=5 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
437. 0.001 0.107 ↓ 0.0 0 1

BitmapOr (cost=191.78..191.78 rows=581 width=0) (actual time=0.107..0.107 rows=0 loops=1)

438. 0.014 0.014 ↑ 1.0 1 1

Bitmap Index Scan on contributions_oklahoma2_lower_idx (cost=0.00..1.53 rows=1 width=0) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
439. 0.092 0.092 ↓ 1.1 635 1

Bitmap Index Scan on contributions_oklahoma2_lower_idx1 (cost=0.00..12.48 rows=581 width=0) (actual time=0.092..0.092 rows=635 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
440. 6.042 6.042 ↑ 592.7 3 1

Bitmap Index Scan on contributions_oklahoma2_to_tsvector_idx3 (cost=0.00..17.98 rows=1,778 width=0) (actual time=6.042..6.042 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
441. 0.005 17.108 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_orange_county ct_84 (cost=38.13..98.10 rows=28 width=638) (actual time=17.108..17.108 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
442. 0.240 17.103 ↓ 0.0 0 1

BitmapOr (cost=38.13..38.13 rows=29 width=0) (actual time=17.103..17.103 rows=0 loops=1)

443. 9.001 9.001 ↓ 0.0 0 1

Bitmap Index Scan on contributions_orange_county_to_tsvector_idx2 (cost=0.00..20.16 rows=14 width=0) (actual time=9.001..9.001 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
444. 7.862 7.862 ↓ 0.0 0 1

Bitmap Index Scan on contributions_orange_county_to_tsvector_idx3 (cost=0.00..17.96 rows=14 width=0) (actual time=7.862..7.862 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
445. 0.048 322.598 ↑ 135.5 2 1

Bitmap Heap Scan on contributions_oregon ct_85 (cost=757.89..1,323.52 rows=271 width=517) (actual time=322.587..322.598 rows=2 loops=1)

  • Recheck Cond: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=4
446. 0.141 322.550 ↓ 0.0 0 1

BitmapOr (cost=757.89..757.89 rows=271 width=0) (actual time=322.550..322.550 rows=0 loops=1)

447. 0.147 194.538 ↓ 0.0 0 1

BitmapAnd (cost=465.18..465.18 rows=4 width=0) (actual time=194.538..194.538 rows=0 loops=1)

448. 0.000 0.193 ↓ 0.0 0 1

BitmapOr (cost=42.41..42.41 rows=851 width=0) (actual time=0.193..0.193 rows=0 loops=1)

449. 0.014 0.014 ↓ 1.9 56 1

Bitmap Index Scan on contributions_oregon_lower_idx (cost=0.00..1.62 rows=30 width=0) (actual time=0.014..0.014 rows=56 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
450. 0.179 0.179 ↓ 1.9 1,554 1

Bitmap Index Scan on contributions_oregon_lower_idx (cost=0.00..14.15 rows=821 width=0) (actual time=0.179..0.179 rows=1,554 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
451. 194.198 194.198 ↑ 66.5 4 1

Bitmap Index Scan on contributions_oregon_to_tsvector_idx2 (cost=0.00..422.45 rows=266 width=0) (actual time=194.198..194.198 rows=4 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
452. 127.871 127.871 ↑ 66.5 4 1

Bitmap Index Scan on contributions_oregon_to_tsvector_idx3 (cost=0.00..292.65 rows=266 width=0) (actual time=127.871..127.871 rows=4 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
453. 0.005 11.435 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_paloalto_ca ct_86 (cost=28.24..90.24 rows=29 width=658) (actual time=11.435..11.435 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
454. 0.289 11.430 ↓ 0.0 0 1

BitmapOr (cost=28.24..28.24 rows=30 width=0) (actual time=11.430..11.430 rows=0 loops=1)

455. 5.967 5.967 ↓ 0.0 0 1

Bitmap Index Scan on contributions_paloalto_ca_to_tsvector_idx2 (cost=0.00..14.66 rows=15 width=0) (actual time=5.967..5.967 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
456. 5.174 5.174 ↓ 0.0 0 1

Bitmap Index Scan on contributions_paloalto_ca_to_tsvector_idx3 (cost=0.00..13.56 rows=15 width=0) (actual time=5.174..5.174 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
457. 0.004 0.808 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_pasadena_ca ct_87 (cost=7.60..137.15 rows=62 width=688) (actual time=0.808..0.808 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
458. 0.273 0.804 ↓ 0.0 0 1

BitmapOr (cost=7.60..7.60 rows=62 width=0) (actual time=0.803..0.804 rows=0 loops=1)

459. 0.293 0.293 ↓ 0.0 0 1

Bitmap Index Scan on contributions_pasadena_ca_to_tsvector_idx2 (cost=0.00..3.78 rows=31 width=0) (actual time=0.293..0.293 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
460. 0.238 0.238 ↓ 0.0 0 1

Bitmap Index Scan on contributions_pasadena_ca_to_tsvector_idx3 (cost=0.00..3.78 rows=31 width=0) (actual time=0.238..0.238 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
461. 0.452 0.705 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_patterson_ca ct_88 (cost=6.10..10.28 rows=1 width=776) (actual time=0.705..0.705 rows=0 loops=1)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
462. 0.116 0.253 ↓ 0.0 0 1

BitmapOr (cost=6.10..6.10 rows=2 width=0) (actual time=0.253..0.253 rows=0 loops=1)

463. 0.000 0.014 ↓ 0.0 0 1

BitmapOr (cost=2.55..2.55 rows=2 width=0) (actual time=0.014..0.014 rows=0 loops=1)

464. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on contributions_patterson_ca_lower_idx (cost=0.00..1.25 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
465. 0.007 0.007 ↓ 2.0 2 1

Bitmap Index Scan on contributions_patterson_ca_lower_idx1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.007..0.007 rows=2 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
466. 0.123 0.123 ↓ 0.0 0 1

Bitmap Index Scan on contributions_patterson_ca_to_tsvector_idx3 (cost=0.00..3.55 rows=1 width=0) (actual time=0.123..0.123 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
467. 6.119 625.871 ↑ 102.7 299 1

Bitmap Heap Scan on contributions_pennsylvania ct_89 (cost=8,753.60..72,803.07 rows=30,708 width=629) (actual time=619.793..625.871 rows=299 loops=1)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Rows Removed by Index Recheck: 2
  • Heap Blocks: exact=272
468. 0.141 619.752 ↓ 0.0 0 1

BitmapOr (cost=8,753.60..8,753.60 rows=30,729 width=0) (actual time=619.752..619.752 rows=0 loops=1)

469. 0.129 324.330 ↓ 0.0 0 1

BitmapAnd (cost=8,097.78..8,097.78 rows=1,689 width=0) (actual time=324.330..324.330 rows=0 loops=1)

470. 266.860 266.860 ↑ 73.0 398 1

Bitmap Index Scan on contributions_pennsylvania_to_tsvector_idx2 (cost=0.00..617.35 rows=29,040 width=0) (actual time=266.860..266.860 rows=398 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
471. 0.003 57.341 ↓ 0.0 0 1

BitmapOr (cost=7,472.50..7,472.50 rows=337,831 width=0) (actual time=57.341..57.341 rows=0 loops=1)

472. 5.308 5.308 ↓ 1.1 55,014 1

Bitmap Index Scan on contributions_pennsylvania_lower_idx (cost=0.00..700.17 rows=51,498 width=0) (actual time=5.308..5.308 rows=55,014 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
473. 52.030 52.030 ↓ 1.4 399,433 1

Bitmap Index Scan on contributions_pennsylvania_lower_idx1 (cost=0.00..3,868.34 rows=286,334 width=0) (actual time=52.030..52.030 rows=399,433 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
474. 295.281 295.281 ↑ 78.1 372 1

Bitmap Index Scan on contributions_pennsylvania_to_tsvector_idx3 (cost=0.00..648.15 rows=29,040 width=0) (actual time=295.281..295.281 rows=372 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
475. 0.002 1.077 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_perris_ca ct_90 (cost=7.11..9.24 rows=1 width=692) (actual time=1.077..1.077 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
476. 0.224 1.075 ↓ 0.0 0 1

BitmapOr (cost=7.11..7.11 rows=1 width=0) (actual time=1.075..1.075 rows=0 loops=1)

477. 0.513 0.513 ↓ 0.0 0 1

Bitmap Index Scan on contributions_perris_ca_to_tsvector_idx2 (cost=0.00..3.55 rows=1 width=0) (actual time=0.513..0.513 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
478. 0.338 0.338 ↓ 0.0 0 1

Bitmap Index Scan on contributions_perris_ca_to_tsvector_idx3 (cost=0.00..3.55 rows=1 width=0) (actual time=0.338..0.338 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
479. 0.003 7.745 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_placer_county ct_91 (cost=24.86..66.95 rows=19 width=696) (actual time=7.745..7.745 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
480. 0.199 7.742 ↓ 0.0 0 1

BitmapOr (cost=24.86..24.86 rows=20 width=0) (actual time=7.742..7.742 rows=0 loops=1)

481. 5.068 5.068 ↓ 0.0 0 1

Bitmap Index Scan on contributions_placer_county_to_tsvector_idx2 (cost=0.00..15.72 rows=10 width=0) (actual time=5.068..5.068 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
482. 2.475 2.475 ↓ 0.0 0 1

Bitmap Index Scan on contributions_placer_county_to_tsvector_idx3 (cost=0.00..9.12 rows=10 width=0) (actual time=2.475..2.475 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
483. 0.203 5.404 ↑ 23.0 2 1

Bitmap Heap Scan on contributions_pleasanton_ca ct_92 (cost=19.57..116.22 rows=46 width=641) (actual time=5.314..5.404 rows=2 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=2
484. 0.197 5.201 ↓ 0.0 0 1

BitmapOr (cost=19.57..19.57 rows=47 width=0) (actual time=5.201..5.201 rows=0 loops=1)

485. 2.665 2.665 ↑ 11.5 2 1

Bitmap Index Scan on contributions_pleasanton_ca_to_tsvector_idx2 (cost=0.00..10.33 rows=23 width=0) (actual time=2.665..2.665 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
486. 2.339 2.339 ↑ 11.5 2 1

Bitmap Index Scan on contributions_pleasanton_ca_to_tsvector_idx3 (cost=0.00..9.23 rows=23 width=0) (actual time=2.339..2.339 rows=2 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
487. 0.002 9.565 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_redondobeach_ca ct_93 (cost=27.12..84.17 rows=27 width=688) (actual time=9.565..9.565 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
488. 0.188 9.563 ↓ 0.0 0 1

BitmapOr (cost=27.12..27.12 rows=27 width=0) (actual time=9.563..9.563 rows=0 loops=1)

489. 4.889 4.889 ↓ 0.0 0 1

Bitmap Index Scan on contributions_redondobeach_ca_to_tsvector_idx2 (cost=0.00..13.55 rows=14 width=0) (actual time=4.889..4.889 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
490. 4.486 4.486 ↓ 0.0 0 1

Bitmap Index Scan on contributions_redondobeach_ca_to_tsvector_idx3 (cost=0.00..13.55 rows=14 width=0) (actual time=4.486..4.486 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
491. 0.943 1.227 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_rhode_island ct_94 (cost=6.10..10.28 rows=1 width=776) (actual time=1.227..1.227 rows=0 loops=1)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=1
492. 0.096 0.284 ↓ 0.0 0 1

BitmapOr (cost=6.10..6.10 rows=2 width=0) (actual time=0.284..0.284 rows=0 loops=1)

493. 0.001 0.013 ↓ 0.0 0 1

BitmapOr (cost=2.55..2.55 rows=2 width=0) (actual time=0.013..0.013 rows=0 loops=1)

494. 0.005 0.005 ↓ 20.0 20 1

Bitmap Index Scan on contributions_rhode_island_lower_idx (cost=0.00..1.25 rows=1 width=0) (actual time=0.005..0.005 rows=20 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
495. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on contributions_rhode_island_lower_idx1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
496. 0.175 0.175 ↓ 0.0 0 1

Bitmap Index Scan on contributions_rhode_island_to_tsvector_idx3 (cost=0.00..3.55 rows=1 width=0) (actual time=0.174..0.175 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
497. 0.002 0.628 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_richmond_ca ct_95 (cost=7.64..149.39 rows=67 width=753) (actual time=0.628..0.628 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
498. 0.176 0.626 ↓ 0.0 0 1

BitmapOr (cost=7.64..7.64 rows=67 width=0) (actual time=0.626..0.626 rows=0 loops=1)

499. 0.225 0.225 ↓ 0.0 0 1

Bitmap Index Scan on contributions_richmond_ca_to_tsvector_idx2 (cost=0.00..3.80 rows=34 width=0) (actual time=0.225..0.225 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
500. 0.225 0.225 ↓ 0.0 0 1

Bitmap Index Scan on contributions_richmond_ca_to_tsvector_idx3 (cost=0.00..3.80 rows=34 width=0) (actual time=0.225..0.225 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
501. 0.004 276.069 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_riverside_county ct_96 (cost=612.59..11,356.96 rows=5,262 width=645) (actual time=276.069..276.069 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
502. 0.244 276.065 ↓ 0.0 0 1

BitmapOr (cost=612.59..612.59 rows=5,287 width=0) (actual time=276.065..276.065 rows=0 loops=1)

503. 147.655 147.655 ↓ 0.0 0 1

Bitmap Index Scan on contributions_riverside_county_to_tsvector_idx2 (cost=0.00..346.78 rows=2,644 width=0) (actual time=147.655..147.655 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
504. 128.166 128.166 ↓ 0.0 0 1

Bitmap Index Scan on contributions_riverside_county_to_tsvector_idx3 (cost=0.00..263.18 rows=2,644 width=0) (actual time=128.166..128.166 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
505. 0.013 0.600 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_roseville_ca ct_97 (cost=4.91..7.04 rows=1 width=776) (actual time=0.600..0.600 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
506. 0.314 0.587 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.587..0.587 rows=0 loops=1)

507. 0.153 0.153 ↓ 0.0 0 1

Bitmap Index Scan on contributions_roseville_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.153..0.153 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
508. 0.120 0.120 ↓ 0.0 0 1

Bitmap Index Scan on contributions_roseville_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.120..0.120 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
509. 0.005 1.337 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sacramento_ca ct_98 (cost=8.92..474.16 rows=221 width=659) (actual time=1.337..1.337 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
510. 0.217 1.332 ↓ 0.0 0 1

BitmapOr (cost=8.92..8.92 rows=227 width=0) (actual time=1.332..1.332 rows=0 loops=1)

511. 0.474 0.474 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sacramento_ca_to_tsvector_idx2 (cost=0.00..4.40 rows=114 width=0) (actual time=0.474..0.474 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
512. 0.641 0.641 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sacramento_ca_to_tsvector_idx3 (cost=0.00..4.40 rows=114 width=0) (actual time=0.641..0.641 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
513. 0.002 0.432 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sacramento_county ct_99 (cost=4.91..7.04 rows=1 width=776) (actual time=0.432..0.432 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
514. 0.218 0.430 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.430..0.430 rows=0 loops=1)

515. 0.106 0.106 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sacramento_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.106..0.106 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
516. 0.106 0.106 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sacramento_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.106..0.106 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
517. 0.004 0.387 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_salinas_ca ct_100 (cost=4.91..7.04 rows=1 width=776) (actual time=0.387..0.387 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
518. 0.189 0.383 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.383..0.383 rows=0 loops=1)

519. 0.099 0.099 ↓ 0.0 0 1

Bitmap Index Scan on contributions_salinas_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.099..0.099 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
520. 0.095 0.095 ↓ 0.0 0 1

Bitmap Index Scan on contributions_salinas_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.095..0.095 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
521. 0.002 0.395 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_san_antonio ct_101 (cost=4.91..7.04 rows=1 width=776) (actual time=0.395..0.395 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
522. 0.198 0.393 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.393..0.393 rows=0 loops=1)

523. 0.099 0.099 ↓ 0.0 0 1

Bitmap Index Scan on contributions_san_antonio_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.099..0.099 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
524. 0.096 0.096 ↓ 0.0 0 1

Bitmap Index Scan on contributions_san_antonio_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.096..0.096 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
525. 0.005 0.396 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanbenito_county ct_102 (cost=4.91..7.04 rows=1 width=776) (actual time=0.396..0.396 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
526. 0.191 0.391 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.391..0.391 rows=0 loops=1)

527. 0.100 0.100 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanbenito_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.100..0.100 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
528. 0.100 0.100 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanbenito_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.100..0.100 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
529. 0.007 0.945 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanbernardino_ca ct_103 (cost=8.08..261.44 rows=122 width=691) (actual time=0.945..0.945 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
530. 0.196 0.938 ↓ 0.0 0 1

BitmapOr (cost=8.08..8.08 rows=123 width=0) (actual time=0.938..0.938 rows=0 loops=1)

531. 0.390 0.390 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanbernardino_ca_to_tsvector_idx2 (cost=0.00..4.01 rows=61 width=0) (actual time=0.390..0.390 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
532. 0.352 0.352 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanbernardino_ca_to_tsvector_idx3 (cost=0.00..4.01 rows=61 width=0) (actual time=0.352..0.352 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
533. 0.249 66.759 ↑ 968.5 2 1

Bitmap Heap Scan on contributions_sanbernardino_county ct_104 (cost=145.89..4,152.86 rows=1,937 width=710) (actual time=66.655..66.759 rows=2 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=3
534. 0.218 66.510 ↓ 0.0 0 1

BitmapOr (cost=145.89..145.89 rows=1,950 width=0) (actual time=66.510..66.510 rows=0 loops=1)

535. 56.096 56.096 ↑ 325.0 3 1

Bitmap Index Scan on contributions_sanbernardino_county_to_tsvector_idx2 (cost=0.00..117.56 rows=975 width=0) (actual time=56.096..56.096 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
536. 10.196 10.196 ↑ 325.0 3 1

Bitmap Index Scan on contributions_sanbernardino_county_to_tsvector_idx3 (cost=0.00..27.36 rows=975 width=0) (actual time=10.196..10.196 rows=3 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
537. 0.441 154.761 ↑ 363.2 4 1

Bitmap Heap Scan on contributions_sandiego_ca ct_105 (cost=340.10..3,372.03 rows=1,453 width=654) (actual time=154.467..154.761 rows=4 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=5
538. 0.231 154.320 ↓ 0.0 0 1

BitmapOr (cost=340.10..340.10 rows=1,477 width=0) (actual time=154.320..154.320 rows=0 loops=1)

539. 78.553 78.553 ↑ 147.6 5 1

Bitmap Index Scan on contributions_sandiego_ca_to_tsvector_idx2 (cost=0.00..178.49 rows=738 width=0) (actual time=78.553..78.553 rows=5 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
540. 75.536 75.536 ↑ 147.6 5 1

Bitmap Index Scan on contributions_sandiego_ca_to_tsvector_idx3 (cost=0.00..160.89 rows=738 width=0) (actual time=75.536..75.536 rows=5 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
541. 0.003 0.391 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sandiego_county ct_106 (cost=4.91..7.04 rows=1 width=776) (actual time=0.391..0.391 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
542. 0.186 0.388 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.388..0.388 rows=0 loops=1)

543. 0.098 0.098 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sandiego_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.098..0.098 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
544. 0.104 0.104 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sandiego_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.104..0.104 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
545. 0.636 197.923 ↑ 474.2 6 1

Bitmap Heap Scan on contributions_sanfrancisco ct_107 (cost=461.64..6,487.47 rows=2,845 width=643) (actual time=197.465..197.923 rows=6 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=6
546. 0.234 197.287 ↓ 0.0 0 1

BitmapOr (cost=461.64..461.64 rows=2,922 width=0) (actual time=197.287..197.287 rows=0 loops=1)

547. 112.809 112.809 ↑ 243.5 6 1

Bitmap Index Scan on contributions_sanfrancisco_to_tsvector_idx2 (cost=0.00..259.81 rows=1,461 width=0) (actual time=112.809..112.809 rows=6 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
548. 84.244 84.244 ↑ 243.5 6 1

Bitmap Index Scan on contributions_sanfrancisco_to_tsvector_idx3 (cost=0.00..200.41 rows=1,461 width=0) (actual time=84.244..84.244 rows=6 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
549. 1.328 40.385 ↑ 171.9 12 1

Bitmap Heap Scan on contributions_sanfrancisco_ca ct_108 (cost=95.70..4,550.26 rows=2,063 width=644) (actual time=39.227..40.385 rows=12 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=17
550. 0.221 39.057 ↓ 0.0 0 1

BitmapOr (cost=95.70..95.70 rows=2,143 width=0) (actual time=39.057..39.057 rows=0 loops=1)

551. 27.401 27.401 ↑ 59.5 18 1

Bitmap Index Scan on contributions_sanfrancisco_ca_to_tsvector_idx2 (cost=0.00..67.69 rows=1,071 width=0) (actual time=27.401..27.401 rows=18 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
552. 11.435 11.435 ↑ 59.5 18 1

Bitmap Index Scan on contributions_sanfrancisco_ca_to_tsvector_idx3 (cost=0.00..26.99 rows=1,071 width=0) (actual time=11.435..11.435 rows=18 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
553. 1.285 7.066 ↑ 285.1 11 1

Bitmap Heap Scan on contributions_sanfrancisco_el ct_109 (cost=35.05..6,591.61 rows=3,136 width=572) (actual time=5.934..7.066 rows=11 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Heap Blocks: exact=11
554. 0.222 5.781 ↓ 0.0 0 1

BitmapOr (cost=35.05..35.05 rows=3,224 width=0) (actual time=5.781..5.781 rows=0 loops=1)

555. 3.000 3.000 ↑ 146.5 11 1

Bitmap Index Scan on contributions_sanfrancisco_el_to_tsvector_idx2 (cost=0.00..16.74 rows=1,612 width=0) (actual time=3.000..3.000 rows=11 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
556. 2.559 2.559 ↑ 146.5 11 1

Bitmap Index Scan on contributions_sanfrancisco_el_to_tsvector_idx3 (cost=0.00..16.74 rows=1,612 width=0) (actual time=2.559..2.559 rows=11 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
557. 0.005 9.923 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanjoaquin_county ct_110 (cost=28.32..109.42 rows=39 width=651) (actual time=9.923..9.923 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
558. 0.217 9.918 ↓ 0.0 0 1

BitmapOr (cost=28.32..28.32 rows=39 width=0) (actual time=9.918..9.918 rows=0 loops=1)

559. 5.752 5.752 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanjoaquin_county_to_tsvector_idx2 (cost=0.00..15.80 rows=20 width=0) (actual time=5.752..5.752 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
560. 3.949 3.949 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanjoaquin_county_to_tsvector_idx3 (cost=0.00..12.50 rows=20 width=0) (actual time=3.949..3.949 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
561. 0.003 0.421 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanjose_ca ct_111 (cost=4.91..7.04 rows=1 width=776) (actual time=0.421..0.421 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
562. 0.217 0.418 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.418..0.418 rows=0 loops=1)

563. 0.104 0.104 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanjose_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.104..0.104 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
564. 0.097 0.097 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanjose_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.097..0.097 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
565. 0.004 72.272 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanluis_obispo_county ct_112 (cost=150.09..432.20 rows=134 width=646) (actual time=72.272..72.272 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
566. 0.225 72.268 ↓ 0.0 0 1

BitmapOr (cost=150.09..150.09 rows=136 width=0) (actual time=72.268..72.268 rows=0 loops=1)

567. 38.134 38.134 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanluis_obispo_county_to_tsvector_idx2 (cost=0.00..79.96 rows=68 width=0) (actual time=38.134..38.134 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
568. 33.909 33.909 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanluis_obispo_county_to_tsvector_idx3 (cost=0.00..70.06 rows=68 width=0) (actual time=33.909..33.909 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
569. 0.005 0.449 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanmateo_ca ct_113 (cost=4.91..7.04 rows=1 width=776) (actual time=0.449..0.449 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
570. 0.240 0.444 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.444..0.444 rows=0 loops=1)

571. 0.106 0.106 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanmateo_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.106..0.106 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
572. 0.098 0.098 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanmateo_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.098..0.098 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
573. 0.002 18.377 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_sanmateo_county ct_114 (cost=48.06..115.61 rows=32 width=694) (actual time=18.377..18.377 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
574. 0.214 18.375 ↓ 0.0 0 1

BitmapOr (cost=48.06..48.06 rows=32 width=0) (actual time=18.375..18.375 rows=0 loops=1)

575. 10.369 10.369 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanmateo_county_to_tsvector_idx2 (cost=0.00..26.77 rows=16 width=0) (actual time=10.369..10.369 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
576. 7.792 7.792 ↓ 0.0 0 1

Bitmap Index Scan on contributions_sanmateo_county_to_tsvector_idx3 (cost=0.00..21.27 rows=16 width=0) (actual time=7.792..7.792 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
577. 0.006 0.810 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santaana_ca ct_115 (cost=7.75..177.84 rows=80 width=684) (actual time=0.810..0.810 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
578. 0.209 0.804 ↓ 0.0 0 1

BitmapOr (cost=7.75..7.75 rows=81 width=0) (actual time=0.804..0.804 rows=0 loops=1)

579. 0.261 0.261 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaana_ca_to_tsvector_idx2 (cost=0.00..3.85 rows=40 width=0) (actual time=0.261..0.261 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
580. 0.334 0.334 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaana_ca_to_tsvector_idx3 (cost=0.00..3.85 rows=40 width=0) (actual time=0.334..0.334 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
581. 0.002 12.189 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santabarbara_ca ct_116 (cost=34.34..252.85 rows=104 width=650) (actual time=12.189..12.189 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
582. 0.246 12.187 ↓ 0.0 0 1

BitmapOr (cost=34.34..34.34 rows=106 width=0) (actual time=12.187..12.187 rows=0 loops=1)

583. 6.504 6.504 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santabarbara_ca_to_tsvector_idx2 (cost=0.00..18.25 rows=53 width=0) (actual time=6.504..6.504 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
584. 5.437 5.437 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santabarbara_ca_to_tsvector_idx3 (cost=0.00..16.05 rows=53 width=0) (actual time=5.437..5.437 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
585. 0.004 0.421 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santabarbara_county ct_117 (cost=4.91..7.04 rows=1 width=776) (actual time=0.421..0.421 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
586. 0.201 0.417 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.417..0.417 rows=0 loops=1)

587. 0.111 0.111 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santabarbara_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.111..0.111 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
588. 0.105 0.105 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santabarbara_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
589. 0.004 2.954 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santaclara_ca ct_118 (cost=11.55..24.18 rows=6 width=684) (actual time=2.954..2.954 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
590. 0.216 2.950 ↓ 0.0 0 1

BitmapOr (cost=11.55..11.55 rows=6 width=0) (actual time=2.950..2.950 rows=0 loops=1)

591. 1.602 1.602 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaclara_ca_to_tsvector_idx2 (cost=0.00..5.77 rows=3 width=0) (actual time=1.602..1.602 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
592. 1.132 1.132 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaclara_ca_to_tsvector_idx3 (cost=0.00..5.77 rows=3 width=0) (actual time=1.132..1.132 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
593. 0.003 462.976 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santaclara_county ct_119 (cost=961.08..3,316.00 rows=1,125 width=654) (actual time=462.975..462.976 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
594. 0.263 462.973 ↓ 0.0 0 1

BitmapOr (cost=961.08..961.08 rows=1,136 width=0) (actual time=462.973..462.973 rows=0 loops=1)

595. 245.949 245.949 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaclara_county_to_tsvector_idx2 (cost=0.00..516.01 rows=568 width=0) (actual time=245.949..245.949 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
596. 216.761 216.761 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaclara_county_to_tsvector_idx3 (cost=0.00..444.51 rows=568 width=0) (actual time=216.761..216.761 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
597. 0.010 0.468 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santaclarita_ca ct_120 (cost=4.91..7.04 rows=1 width=776) (actual time=0.468..0.468 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
598. 0.245 0.458 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.458..0.458 rows=0 loops=1)

599. 0.110 0.110 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaclarita_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.110..0.110 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
600. 0.103 0.103 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santaclarita_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.103..0.103 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
601. 0.005 7.681 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santacruz_county ct_121 (cost=20.42..52.07 rows=14 width=683) (actual time=7.681..7.681 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
602. 0.223 7.676 ↓ 0.0 0 1

BitmapOr (cost=20.42..20.42 rows=15 width=0) (actual time=7.676..7.676 rows=0 loops=1)

603. 4.014 4.014 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santacruz_county_to_tsvector_idx2 (cost=0.00..11.30 rows=7 width=0) (actual time=4.014..4.014 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
604. 3.439 3.439 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santacruz_county_to_tsvector_idx3 (cost=0.00..9.10 rows=7 width=0) (actual time=3.438..3.439 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
605. 0.005 81.095 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santamonica_ca ct_122 (cost=166.90..804.88 rows=307 width=664) (actual time=81.095..81.095 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
606. 0.251 81.090 ↓ 0.0 0 1

BitmapOr (cost=166.90..166.90 rows=312 width=0) (actual time=81.090..81.090 rows=0 loops=1)

607. 43.614 43.614 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santamonica_ca_to_tsvector_idx2 (cost=0.00..86.12 rows=156 width=0) (actual time=43.614..43.614 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
608. 37.225 37.225 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santamonica_ca_to_tsvector_idx3 (cost=0.00..80.62 rows=156 width=0) (actual time=37.225..37.225 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
609. 0.010 12.455 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_santarosa_ca ct_123 (cost=31.57..103.31 rows=33 width=729) (actual time=12.454..12.455 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
610. 0.286 12.445 ↓ 0.0 0 1

BitmapOr (cost=31.57..31.57 rows=34 width=0) (actual time=12.445..12.445 rows=0 loops=1)

611. 6.814 6.814 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santarosa_ca_to_tsvector_idx2 (cost=0.00..17.98 rows=17 width=0) (actual time=6.814..6.814 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
612. 5.345 5.345 ↓ 0.0 0 1

Bitmap Index Scan on contributions_santarosa_ca_to_tsvector_idx3 (cost=0.00..13.58 rows=17 width=0) (actual time=5.345..5.345 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
613. 0.006 0.643 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_shafter_ca ct_124 (cost=4.91..7.04 rows=1 width=776) (actual time=0.643..0.643 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
614. 0.320 0.637 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.637..0.637 rows=0 loops=1)

615. 0.197 0.197 ↓ 0.0 0 1

Bitmap Index Scan on contributions_shafter_ca_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.197..0.197 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
616. 0.120 0.120 ↓ 0.0 0 1

Bitmap Index Scan on contributions_shafter_ca_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.120..0.120 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
617. 0.002 0.432 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_shasta_county ct_125 (cost=4.91..7.04 rows=1 width=776) (actual time=0.432..0.432 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
618. 0.209 0.430 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.430..0.430 rows=0 loops=1)

619. 0.116 0.116 ↓ 0.0 0 1

Bitmap Index Scan on contributions_shasta_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.116..0.116 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
620. 0.105 0.105 ↓ 0.0 0 1

Bitmap Index Scan on contributions_shasta_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.105..0.105 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
621. 0.008 0.495 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_solano_county ct_126 (cost=4.91..7.04 rows=1 width=776) (actual time=0.495..0.495 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
622. 0.243 0.487 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.487..0.487 rows=0 loops=1)

623. 0.129 0.129 ↓ 0.0 0 1

Bitmap Index Scan on contributions_solano_county_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.129..0.129 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
624. 0.115 0.115 ↓ 0.0 0 1

Bitmap Index Scan on contributions_solano_county_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.115..0.115 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
625. 0.001 0.408 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_south_carolina ct_127 (cost=4.91..7.04 rows=1 width=776) (actual time=0.408..0.408 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
626. 0.196 0.407 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.407..0.407 rows=0 loops=1)

627. 0.111 0.111 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_carolina_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.111..0.111 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
628. 0.100 0.100 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_carolina_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.100..0.100 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
629. 0.002 0.394 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_south_carolina2 ct_128 (cost=4.91..7.04 rows=1 width=776) (actual time=0.394..0.394 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
630. 0.193 0.392 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.392..0.392 rows=0 loops=1)

631. 0.102 0.102 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_carolina2_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
632. 0.097 0.097 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_carolina2_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.097..0.097 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
633. 0.002 0.376 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_south_dakota2 ct_129 (cost=4.91..7.04 rows=1 width=776) (actual time=0.376..0.376 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
  • Filter: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
634. 0.184 0.374 ↓ 0.0 0 1

BitmapOr (cost=4.91..4.91 rows=1 width=0) (actual time=0.374..0.374 rows=0 loops=1)

635. 0.097 0.097 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_dakota2_to_tsvector_idx2 (cost=0.00..2.45 rows=1 width=0) (actual time=0.097..0.097 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
636. 0.093 0.093 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_dakota2_to_tsvector_idx3 (cost=0.00..2.45 rows=1 width=0) (actual time=0.093..0.093 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
637. 0.003 11.473 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_south_dakota_pdf ct_130 (cost=32.06..46.82 rows=7 width=534) (actual time=11.473..11.473 rows=0 loops=1)

  • Recheck Cond: ((((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery)))
638. 0.109 11.470 ↓ 0.0 0 1

BitmapOr (cost=32.06..32.06 rows=7 width=0) (actual time=11.470..11.470 rows=0 loops=1)

639. 0.097 6.110 ↓ 0.0 0 1

BitmapAnd (cost=18.56..18.56 rows=1 width=0) (actual time=6.110..6.110 rows=0 loops=1)

640. 0.003 0.027 ↓ 0.0 0 1

BitmapOr (cost=3.70..3.70 rows=31 width=0) (actual time=0.027..0.027 rows=0 loops=1)

641. 0.017 0.017 ↓ 2.2 63 1

Bitmap Index Scan on contributions_south_dakota_pdf_lower_idx (cost=0.00..1.60 rows=29 width=0) (actual time=0.017..0.017 rows=63 loops=1)

  • Index Cond: (lower(contributor_state) IS NULL)
642. 0.007 0.007 ↓ 2.0 2 1

Bitmap Index Scan on contributions_south_dakota_pdf_lower_idx1 (cost=0.00..1.39 rows=1 width=0) (actual time=0.007..0.007 rows=2 loops=1)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
643. 5.986 5.986 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_dakota_pdf_to_tsvector_idx2 (cost=0.00..14.60 rows=7 width=0) (actual time=5.986..5.986 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
644. 5.251 5.251 ↓ 0.0 0 1

Bitmap Index Scan on contributions_south_dakota_pdf_to_tsvector_idx3 (cost=0.00..13.50 rows=7 width=0) (actual time=5.251..5.251 rows=0 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ to_tsquery('english'::regconfig, name_cte.tsquery))
645. 0.002 0.445 ↓ 0.0 0 1

Bitmap Heap Scan on contributions_stanislaus_county ct_131 (cost=4.91..7.04 rows=1 width=776) (actual time=0.445..0.445 rows=0 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ to_tsquery('english'::regconfig, name_cte.tsquery)) OR (to_