explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wcI5

Settings
# exclusive inclusive rows x rows loops node
1. 3.496 14,436.475 ↓ 0.0 0 1

Nested Loop (cost=318.09..17,261,439.16 rows=9,152,410 width=795) (actual time=14,436.475..14,436.475 rows=0 loops=1)

2. 0.134 0.249 ↑ 4.2 39 1

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

  • Group Key: n.name2
3. 0.007 0.115 ↑ 3.1 52 1

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

4. 0.057 0.057 ↑ 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.041..0.057 rows=35 loops=1)

  • Index Cond: ((lower(name1) = 'scott'::text) AND (score < 30))
5. 0.050 0.050 ↑ 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.028..0.050 rows=16 loops=1)

  • Index Cond: ((lower(name2) = 'scott'::text) AND (score < 30))
6. 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)

7. 25.506 14,432.730 ↓ 0.0 0 39

Append (cost=130.48..105,335.19 rows=56,204 width=797) (actual time=370.070..370.070 rows=0 loops=39)

8. 0.429 240.786 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_alabama ct (cost=130.48..189.32 rows=28 width=648) (actual time=6.174..6.174 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
9. 2.574 240.357 ↓ 0.0 0 39

BitmapAnd (cost=130.48..130.48 rows=28 width=0) (actual time=6.163..6.163 rows=0 loops=39)

10. 0.039 15.600 ↓ 0.0 0 39

BitmapOr (cost=46.42..46.42 rows=2,810 width=0) (actual time=0.400..0.400 rows=0 loops=39)

11. 5.187 5.187 ↓ 1.0 1,744 39

Bitmap Index Scan on contributions_alabama_lower_idx (cost=0.00..27.61 rows=1,718 width=0) (actual time=0.133..0.133 rows=1,744 loops=39)

  • Index Cond: (lower(contributor_state) IS NULL)
12. 10.374 10.374 ↓ 1.6 1,745 39

Bitmap Index Scan on contributions_alabama_lower_idx1 (cost=0.00..17.41 rows=1,092 width=0) (actual time=0.266..0.266 rows=1,745 loops=39)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
13. 1.053 222.183 ↓ 0.0 0 39

BitmapOr (cost=83.81..83.81 rows=4,368 width=0) (actual time=5.697..5.697 rows=0 loops=39)

14. 145.119 145.119 ↓ 0.0 0 39

Bitmap Index Scan on contributions_alabama_to_tsvector_idx2 (cost=0.00..48.50 rows=2,184 width=0) (actual time=3.721..3.721 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
15. 76.011 76.011 ↓ 0.0 0 39

Bitmap Index Scan on contributions_alabama_to_tsvector_idx3 (cost=0.00..35.30 rows=2,184 width=0) (actual time=1.949..1.949 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
16. 0.039 1.755 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_alameda_county ct_1 (cost=5.37..559.32 rows=410 width=696) (actual time=0.045..0.045 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
17. 0.780 1.716 ↓ 0.0 0 39

BitmapOr (cost=5.37..5.37 rows=418 width=0) (actual time=0.044..0.044 rows=0 loops=39)

18. 0.507 0.507 ↓ 0.0 0 39

Bitmap Index Scan on contributions_alameda_county_to_tsvector_idx2 (cost=0.00..2.62 rows=209 width=0) (actual time=0.013..0.013 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
19. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_alameda_county_to_tsvector_idx3 (cost=0.00..2.54 rows=209 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
20. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_alaska ct_2 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
21. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

22. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_alaska_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
23. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_alaska_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
24. 0.117 75.036 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_anaheim_ca ct_3 (cost=17.21..208.55 rows=139 width=634) (actual time=1.924..1.924 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
25. 0.507 74.919 ↓ 0.0 0 39

BitmapOr (cost=17.21..17.21 rows=144 width=0) (actual time=1.921..1.921 rows=0 loops=39)

26. 42.198 42.198 ↓ 0.0 0 39

Bitmap Index Scan on contributions_anaheim_ca_to_tsvector_idx2 (cost=0.00..9.59 rows=72 width=0) (actual time=1.082..1.082 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
27. 32.214 32.214 ↓ 0.0 0 39

Bitmap Index Scan on contributions_anaheim_ca_to_tsvector_idx3 (cost=0.00..7.55 rows=72 width=0) (actual time=0.826..0.826 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
28. 0.078 0.975 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_arizona ct_4 (cost=1.08..3.23 rows=1 width=776) (actual time=0.025..0.025 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
29. 0.585 0.897 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.023..0.023 rows=0 loops=39)

30. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_arizona_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
31. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_arizona_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
32. 0.078 1.209 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_arkansas ct_5 (cost=1.17..3.31 rows=1 width=776) (actual time=0.031..0.031 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
33. 0.429 1.131 ↓ 0.0 0 39

BitmapOr (cost=1.17..1.17 rows=1 width=0) (actual time=0.029..0.029 rows=0 loops=39)

34. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_arkansas_to_tsvector_idx2 (cost=0.00..0.58 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
35. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_arkansas_to_tsvector_idx3 (cost=0.00..0.58 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
36. 0.039 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_austin ct_6 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
37. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

38. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_austin_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
39. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_austin_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
40. 0.039 1.248 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_barkeley_ca ct_7 (cost=4.19..358.56 rows=255 width=645) (actual time=0.032..0.032 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
41. 0.429 1.209 ↓ 0.0 0 39

BitmapOr (cost=4.19..4.19 rows=266 width=0) (actual time=0.031..0.031 rows=0 loops=39)

42. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_barkeley_ca_to_tsvector_idx2 (cost=0.00..2.06 rows=133 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
43. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_barkeley_ca_to_tsvector_idx3 (cost=0.00..2.01 rows=133 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
44. 0.078 2.067 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_burbank_ca ct_8 (cost=1.04..6.31 rows=4 width=715) (actual time=0.053..0.053 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
45. 0.429 1.989 ↓ 0.0 0 39

BitmapOr (cost=1.04..1.04 rows=4 width=0) (actual time=0.051..0.051 rows=0 loops=39)

46. 0.780 0.780 ↓ 0.0 0 39

Bitmap Index Scan on contributions_burbank_ca_to_tsvector_idx2 (cost=0.00..0.74 rows=2 width=0) (actual time=0.020..0.020 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
47. 0.780 0.780 ↓ 0.0 0 39

Bitmap Index Scan on contributions_burbank_ca_to_tsvector_idx3 (cost=0.00..0.30 rows=2 width=0) (actual time=0.020..0.020 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
48. 0.078 1.209 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_butte_county ct_9 (cost=1.87..57.65 rows=40 width=644) (actual time=0.031..0.031 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
49. 0.390 1.131 ↓ 0.0 0 39

BitmapOr (cost=1.87..1.87 rows=41 width=0) (actual time=0.029..0.029 rows=0 loops=39)

50. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_butte_county_to_tsvector_idx2 (cost=0.00..0.97 rows=20 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
51. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_butte_county_to_tsvector_idx3 (cost=0.00..0.87 rows=20 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
52. 0.117 672.321 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_california2 ct_10 (cost=312.19..25,469.83 rows=17,216 width=1,055) (actual time=17.239..17.239 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
53. 0.780 672.204 ↓ 0.0 0 39

BitmapOr (cost=312.19..312.19 rows=18,462 width=0) (actual time=17.236..17.236 rows=0 loops=39)

54. 340.665 340.665 ↓ 0.0 0 39

Bitmap Index Scan on contributions_california2_to_tsvector_idx2 (cost=0.00..156.88 rows=9,231 width=0) (actual time=8.735..8.735 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
55. 330.759 330.759 ↓ 0.0 0 39

Bitmap Index Scan on contributions_california2_to_tsvector_idx3 (cost=0.00..146.70 rows=9,231 width=0) (actual time=8.481..8.481 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
56. 0.117 1.326 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_capitola_ca ct_11 (cost=0.55..2.69 rows=1 width=684) (actual time=0.034..0.034 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
57. 0.741 1.209 ↓ 0.0 0 39

BitmapOr (cost=0.55..0.55 rows=1 width=0) (actual time=0.031..0.031 rows=0 loops=39)

58. 0.273 0.273 ↓ 0.0 0 39

Bitmap Index Scan on contributions_capitola_ca_to_tsvector_idx2 (cost=0.00..0.27 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
59. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_capitola_ca_to_tsvector_idx3 (cost=0.00..0.27 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
60. 0.039 1.326 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_carlsbad_ca ct_12 (cost=2.59..158.35 rows=107 width=732) (actual time=0.034..0.034 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
61. 0.429 1.287 ↓ 0.0 0 39

BitmapOr (cost=2.59..2.59 rows=115 width=0) (actual time=0.033..0.033 rows=0 loops=39)

62. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_carlsbad_ca_to_tsvector_idx2 (cost=0.00..1.25 rows=58 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
63. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_carlsbad_ca_to_tsvector_idx3 (cost=0.00..1.29 rows=58 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
64. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_carson_ca ct_13 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
65. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

66. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_carson_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
67. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_carson_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
68. 0.078 1.248 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_chico_ca ct_14 (cost=1.98..57.76 rows=41 width=667) (actual time=0.032..0.032 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
69. 0.429 1.170 ↓ 0.0 0 39

BitmapOr (cost=1.98..1.98 rows=41 width=0) (actual time=0.030..0.030 rows=0 loops=39)

70. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_chico_ca_to_tsvector_idx2 (cost=0.00..0.99 rows=21 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
71. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_chico_ca_to_tsvector_idx3 (cost=0.00..0.97 rows=21 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
72. 0.039 1.131 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_chulavista_ca ct_15 (cost=1.97..59.90 rows=41 width=732) (actual time=0.029..0.029 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
73. 0.390 1.092 ↓ 0.0 0 39

BitmapOr (cost=1.97..1.97 rows=42 width=0) (actual time=0.028..0.028 rows=0 loops=39)

74. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_chulavista_ca_to_tsvector_idx2 (cost=0.00..0.99 rows=21 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
75. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_chulavista_ca_to_tsvector_idx3 (cost=0.00..0.95 rows=21 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
76. 0.117 1.950 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_colorado ct_16 (cost=434.18..875.23 rows=218 width=635) (actual time=0.050..0.050 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
77. 0.039 1.833 ↓ 0.0 0 39

BitmapAnd (cost=434.18..434.18 rows=218 width=0) (actual time=0.047..0.047 rows=0 loops=39)

78. 0.390 1.794 ↓ 0.0 0 39

BitmapOr (cost=97.74..97.74 rows=11,517 width=0) (actual time=0.046..0.046 rows=0 loops=39)

79. 0.741 0.741 ↓ 0.0 0 39

Bitmap Index Scan on contributions_colorado_to_tsvector_idx2 (cost=0.00..49.21 rows=5,758 width=0) (actual time=0.019..0.019 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
80. 0.663 0.663 ↓ 0.0 0 39

Bitmap Index Scan on contributions_colorado_to_tsvector_idx3 (cost=0.00..48.42 rows=5,758 width=0) (actual time=0.017..0.017 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
81. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=336.19..336.19 rows=21,844 width=0) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_colorado_lower_idx (cost=0.00..22.08 rows=1,420 width=0) (never executed)

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

Bitmap Index Scan on contributions_colorado_lower_idx1 (cost=0.00..303.20 rows=20,423 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
84. 0.741 870.480 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_connecticut ct_17 (cost=346.49..479.14 rows=63 width=634) (actual time=22.320..22.320 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
85. 6.942 869.739 ↓ 0.0 0 39

BitmapAnd (cost=346.49..346.49 rows=63 width=0) (actual time=22.301..22.301 rows=0 loops=39)

86. 0.039 41.184 ↓ 0.0 0 39

BitmapOr (cost=99.85..99.85 rows=6,326 width=0) (actual time=1.056..1.056 rows=0 loops=39)

87. 20.046 20.046 ↓ 2.9 7,083 39

Bitmap Index Scan on contributions_connecticut_lower_idx (cost=0.00..37.43 rows=2,441 width=0) (actual time=0.514..0.514 rows=7,083 loops=39)

  • Index Cond: (lower(contributor_state) IS NULL)
88. 21.099 21.099 ↓ 1.2 4,694 39

Bitmap Index Scan on contributions_connecticut_lower_idx1 (cost=0.00..59.26 rows=3,885 width=0) (actual time=0.541..0.541 rows=4,694 loops=39)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
89. 1.053 821.613 ↓ 0.0 0 39

BitmapOr (cost=246.39..246.39 rows=10,314 width=0) (actual time=21.067..21.067 rows=0 loops=39)

90. 498.420 498.420 ↓ 0.0 0 39

Bitmap Index Scan on contributions_connecticut_to_tsvector_idx2 (cost=0.00..141.45 rows=5,157 width=0) (actual time=12.780..12.780 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
91. 322.140 322.140 ↓ 0.0 0 39

Bitmap Index Scan on contributions_connecticut_to_tsvector_idx3 (cost=0.00..104.91 rows=5,157 width=0) (actual time=8.260..8.260 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
92. 0.078 123.669 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_contra_consta_county ct_18 (cost=26.72..169.76 rows=105 width=657) (actual time=3.171..3.171 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
93. 1.053 123.591 ↓ 0.0 0 39

BitmapOr (cost=26.72..26.72 rows=107 width=0) (actual time=3.169..3.169 rows=0 loops=39)

94. 68.133 68.133 ↓ 0.0 0 39

Bitmap Index Scan on contributions_contra_consta_county_to_tsvector_idx2 (cost=0.00..14.59 rows=54 width=0) (actual time=1.747..1.747 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
95. 54.405 54.405 ↓ 0.0 0 39

Bitmap Index Scan on contributions_contra_consta_county_to_tsvector_idx3 (cost=0.00..12.08 rows=54 width=0) (actual time=1.395..1.395 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
96. 0.078 1.053 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_cotati_ca ct_19 (cost=1.08..3.23 rows=1 width=776) (actual time=0.027..0.027 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
97. 0.585 0.975 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=39)

98. 0.234 0.234 ↓ 0.0 0 39

Bitmap Index Scan on contributions_cotati_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
99. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_cotati_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
100. 0.078 0.780 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_dallas ct_20 (cost=1.08..3.23 rows=1 width=776) (actual time=0.020..0.020 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
101. 0.390 0.702 ↓ 0.0 0 39

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

102. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_dallas_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
103. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_dallas_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
104. 0.078 0.780 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_davis_ca ct_21 (cost=1.08..3.23 rows=1 width=776) (actual time=0.020..0.020 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
105. 0.390 0.702 ↓ 0.0 0 39

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

106. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_davis_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
107. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_davis_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
108. 0.195 292.656 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_delaware ct_22 (cost=167.83..274.38 rows=55 width=534) (actual time=7.504..7.504 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
109. 0.078 292.461 ↓ 0.0 0 39

BitmapAnd (cost=167.83..167.83 rows=56 width=0) (actual time=7.499..7.499 rows=0 loops=39)

110. 0.741 292.383 ↓ 0.0 0 39

BitmapOr (cost=75.90..75.90 rows=1,517 width=0) (actual time=7.497..7.497 rows=0 loops=39)

111. 175.968 175.968 ↓ 0.0 0 39

Bitmap Index Scan on contributions_delaware_to_tsvector_idx2 (cost=0.00..45.59 rows=758 width=0) (actual time=4.512..4.512 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
112. 115.674 115.674 ↓ 0.0 0 39

Bitmap Index Scan on contributions_delaware_to_tsvector_idx3 (cost=0.00..30.28 rows=758 width=0) (actual time=2.966..2.966 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
113. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=91.68..91.68 rows=5,582 width=0) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_delaware_lower_idx (cost=0.00..73.58 rows=4,621 width=0) (never executed)

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

Bitmap Index Scan on contributions_delaware_lower_idx1 (cost=0.00..15.33 rows=961 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
116. 0.117 2.028 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_district_of_columbia ct_23 (cost=50.10..93.86 rows=22 width=423) (actual time=0.052..0.052 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
117. 0.039 1.911 ↓ 0.0 0 39

BitmapAnd (cost=50.10..50.10 rows=22 width=0) (actual time=0.049..0.049 rows=0 loops=39)

118. 0.663 1.872 ↓ 0.0 0 39

BitmapOr (cost=19.64..19.64 rows=2,043 width=0) (actual time=0.048..0.048 rows=0 loops=39)

119. 0.624 0.624 ↓ 0.0 0 39

Bitmap Index Scan on contributions_district_of_columbia_to_tsvector_idx2 (cost=0.00..9.85 rows=1,021 width=0) (actual time=0.016..0.016 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
120. 0.585 0.585 ↓ 0.0 0 39

Bitmap Index Scan on contributions_district_of_columbia_to_tsvector_idx3 (cost=0.00..9.78 rows=1,021 width=0) (actual time=0.015..0.015 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
121. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=30.21..30.21 rows=2,159 width=0) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_district_of_columbia_lower_idx (cost=0.00..2.70 rows=157 width=0) (never executed)

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

Bitmap Index Scan on contributions_district_of_columbia_lower_idx1 (cost=0.00..26.44 rows=2,002 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
124. 0.078 6.279 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_dublin_ca ct_24 (cost=1.48..5.71 rows=3 width=688) (actual time=0.161..0.161 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
125. 0.468 6.201 ↓ 0.0 0 39

BitmapOr (cost=1.48..1.48 rows=3 width=0) (actual time=0.159..0.159 rows=0 loops=39)

126. 3.081 3.081 ↓ 0.0 0 39

Bitmap Index Scan on contributions_dublin_ca_to_tsvector_idx2 (cost=0.00..1.18 rows=1 width=0) (actual time=0.079..0.079 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
127. 2.652 2.652 ↓ 0.0 0 39

Bitmap Index Scan on contributions_dublin_ca_to_tsvector_idx3 (cost=0.00..0.30 rows=1 width=0) (actual time=0.068..0.068 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
128. 0.156 659.373 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_federal_api ct_25 (cost=4,590.84..10,706.83 rows=3,555 width=1,497) (actual time=16.907..16.907 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
129. 0.078 659.217 ↓ 0.0 0 39

BitmapAnd (cost=4,590.84..4,590.84 rows=3,564 width=0) (actual time=16.903..16.903 rows=0 loops=39)

130. 0.780 659.139 ↓ 0.0 0 39

BitmapOr (cost=333.51..333.51 rows=22,708 width=0) (actual time=16.901..16.901 rows=0 loops=39)

131. 439.491 439.491 ↓ 0.0 0 39

Bitmap Index Scan on contributions_federal_api_to_tsvector_idx2 (cost=0.00..188.71 rows=11,354 width=0) (actual time=11.269..11.269 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
132. 218.868 218.868 ↓ 0.0 0 39

Bitmap Index Scan on contributions_federal_api_to_tsvector_idx3 (cost=0.00..143.02 rows=11,354 width=0) (actual time=5.612..5.612 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
133. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=4,257.08..4,257.08 rows=356,444 width=0) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_federal_api_lower_idx (cost=0.00..6.04 rows=454 width=0) (never executed)

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

Bitmap Index Scan on contributions_federal_api_lower_idx (cost=0.00..4,072.85 rows=355,990 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
136. 0.078 1.326 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_florida ct_26 (cost=1.17..3.31 rows=1 width=776) (actual time=0.034..0.034 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
137. 0.741 1.248 ↓ 0.0 0 39

BitmapOr (cost=1.17..1.17 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=39)

138. 0.273 0.273 ↓ 0.0 0 39

Bitmap Index Scan on contributions_florida_to_tsvector_idx2 (cost=0.00..0.58 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
139. 0.234 0.234 ↓ 0.0 0 39

Bitmap Index Scan on contributions_florida_to_tsvector_idx3 (cost=0.00..0.58 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
140. 0.039 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_folsom_ca ct_27 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
141. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

142. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_folsom_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
143. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_folsom_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
144. 0.078 219.804 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_fresno_ca ct_28 (cost=47.90..406.69 rows=265 width=688) (actual time=5.636..5.636 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
145. 0.702 219.726 ↓ 0.0 0 39

BitmapOr (cost=47.90..47.90 rows=267 width=0) (actual time=5.634..5.634 rows=0 loops=39)

146. 120.978 120.978 ↓ 0.0 0 39

Bitmap Index Scan on contributions_fresno_ca_to_tsvector_idx2 (cost=0.00..26.55 rows=134 width=0) (actual time=3.102..3.102 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
147. 98.046 98.046 ↓ 0.0 0 39

Bitmap Index Scan on contributions_fresno_ca_to_tsvector_idx3 (cost=0.00..21.22 rows=134 width=0) (actual time=2.514..2.514 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
148. 0.078 1.053 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_fresno_county ct_29 (cost=1.08..3.23 rows=1 width=776) (actual time=0.027..0.027 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
149. 0.624 0.975 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=39)

150. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_fresno_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
151. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_fresno_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
152. 0.195 831.519 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_georgia ct_30 (cost=1,380.00..2,720.71 rows=806 width=543) (actual time=21.321..21.321 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
153. 0.039 831.324 ↓ 0.0 0 39

BitmapAnd (cost=1,380.00..1,380.00 rows=808 width=0) (actual time=21.316..21.316 rows=0 loops=39)

154. 0.819 831.285 ↓ 0.0 0 39

BitmapOr (cost=274.81..274.81 rows=15,908 width=0) (actual time=21.315..21.315 rows=0 loops=39)

155. 199.875 199.875 ↓ 0.0 0 39

Bitmap Index Scan on contributions_georgia_to_tsvector_idx2 (cost=0.00..85.91 rows=7,954 width=0) (actual time=5.125..5.125 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
156. 630.591 630.591 ↓ 0.0 0 39

Bitmap Index Scan on contributions_georgia_to_tsvector_idx3 (cost=0.00..188.49 rows=7,954 width=0) (actual time=16.169..16.169 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
157. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=1,104.94..1,104.94 rows=80,811 width=0) (never executed)

158. 0.000 0.000 ↓ 0.0 0

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

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

Bitmap Index Scan on contributions_georgia_lower_idx (cost=0.00..1,062.61 rows=80,758 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
160. 0.078 3.003 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_glendale_ca ct_31 (cost=2.08..26.26 rows=17 width=648) (actual time=0.077..0.077 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
161. 0.819 2.925 ↓ 0.0 0 39

BitmapOr (cost=2.08..2.08 rows=18 width=0) (actual time=0.075..0.075 rows=0 loops=39)

162. 1.170 1.170 ↓ 0.0 0 39

Bitmap Index Scan on contributions_glendale_ca_to_tsvector_idx2 (cost=0.00..1.06 rows=9 width=0) (actual time=0.030..0.030 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
163. 0.936 0.936 ↓ 0.0 0 39

Bitmap Index Scan on contributions_glendale_ca_to_tsvector_idx3 (cost=0.00..1.01 rows=9 width=0) (actual time=0.024..0.024 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
164. 0.078 0.897 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_hawaii ct_32 (cost=1.08..3.23 rows=1 width=776) (actual time=0.023..0.023 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
165. 0.468 0.819 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

166. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_hawaii_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
167. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_hawaii_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
168. 0.078 32.643 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_hayward_ca ct_33 (cost=6.75..35.16 rows=20 width=699) (actual time=0.837..0.837 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
169. 0.507 32.565 ↓ 0.0 0 39

BitmapOr (cost=6.75..6.75 rows=21 width=0) (actual time=0.835..0.835 rows=0 loops=39)

170. 16.653 16.653 ↓ 0.0 0 39

Bitmap Index Scan on contributions_hayward_ca_to_tsvector_idx2 (cost=0.00..3.19 rows=10 width=0) (actual time=0.427..0.427 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
171. 15.405 15.405 ↓ 0.0 0 39

Bitmap Index Scan on contributions_hayward_ca_to_tsvector_idx3 (cost=0.00..3.55 rows=10 width=0) (actual time=0.395..0.395 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
172. 0.078 3.315 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_hesperia_ca ct_34 (cost=0.56..2.70 rows=1 width=680) (actual time=0.085..0.085 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
173. 0.507 3.237 ↓ 0.0 0 39

BitmapOr (cost=0.56..0.56 rows=1 width=0) (actual time=0.083..0.083 rows=0 loops=39)

174. 1.794 1.794 ↓ 0.0 0 39

Bitmap Index Scan on contributions_hesperia_ca_to_tsvector_idx2 (cost=0.00..0.29 rows=1 width=0) (actual time=0.046..0.046 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
175. 0.936 0.936 ↓ 0.0 0 39

Bitmap Index Scan on contributions_hesperia_ca_to_tsvector_idx3 (cost=0.00..0.27 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
176. 0.351 985.218 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_houston ct_35 (cost=215.41..239.97 rows=12 width=550) (actual time=25.262..25.262 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
177. 1.794 984.867 ↓ 0.0 0 39

BitmapAnd (cost=215.41..215.41 rows=12 width=0) (actual time=25.253..25.253 rows=0 loops=39)

178. 0.000 10.374 ↓ 0.0 0 39

BitmapOr (cost=25.62..25.62 rows=1,173 width=0) (actual time=0.266..0.266 rows=0 loops=39)

179. 2.184 2.184 ↓ 2.2 498 39

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

  • Index Cond: (lower(contributor_state) IS NULL)
180. 8.190 8.190 ↓ 2.1 1,962 39

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
181. 0.936 972.699 ↓ 0.0 0 39

BitmapOr (cost=189.54..189.54 rows=561 width=0) (actual time=24.941..24.941 rows=0 loops=39)

182. 529.035 529.035 ↓ 0.0 0 39

Bitmap Index Scan on contributions_houston_to_tsvector_idx2 (cost=0.00..104.75 rows=281 width=0) (actual time=13.565..13.565 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
183. 442.728 442.728 ↓ 0.0 0 39

Bitmap Index Scan on contributions_houston_to_tsvector_idx3 (cost=0.00..84.79 rows=281 width=0) (actual time=11.352..11.352 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
184. 0.078 1.755 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_huntingtonbeach_ca ct_36 (cost=3.09..225.94 rows=166 width=661) (actual time=0.045..0.045 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
185. 0.819 1.677 ↓ 0.0 0 39

BitmapOr (cost=3.09..3.09 rows=168 width=0) (actual time=0.043..0.043 rows=0 loops=39)

186. 0.468 0.468 ↓ 0.0 0 39

Bitmap Index Scan on contributions_huntingtonbeach_ca_to_tsvector_idx2 (cost=0.00..1.52 rows=84 width=0) (actual time=0.012..0.012 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
187. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_huntingtonbeach_ca_to_tsvector_idx3 (cost=0.00..1.49 rows=84 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
188. 0.039 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_idaho ct_37 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
189. 0.468 0.819 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

190. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_idaho_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
191. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_idaho_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
192. 0.702 810.576 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_illinois ct_38 (cost=347.21..489.34 rows=69 width=485) (actual time=20.784..20.784 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
193. 5.733 809.874 ↓ 0.0 0 39

BitmapAnd (cost=347.21..347.21 rows=69 width=0) (actual time=20.766..20.766 rows=0 loops=39)

194. 0.000 31.317 ↓ 0.0 0 39

BitmapOr (cost=108.12..108.12 rows=6,947 width=0) (actual time=0.803..0.803 rows=0 loops=39)

195. 1.560 1.560 ↑ 1.4 338 39

Bitmap Index Scan on contributions_illinois_lower_idx (cost=0.00..8.40 rows=476 width=0) (actual time=0.040..0.040 rows=338 loops=39)

  • Index Cond: (lower(contributor_state) IS NULL)
196. 29.757 29.757 ↑ 1.1 5,954 39

Bitmap Index Scan on contributions_illinois_lower_idx (cost=0.00..96.25 rows=6,470 width=0) (actual time=0.763..0.763 rows=5,954 loops=39)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
197. 1.053 772.824 ↓ 0.0 0 39

BitmapOr (cost=238.85..238.85 rows=8,403 width=0) (actual time=19.816..19.816 rows=0 loops=39)

198. 441.363 441.363 ↓ 0.0 0 39

Bitmap Index Scan on contributions_illinois_to_tsvector_idx2 (cost=0.00..133.80 rows=4,202 width=0) (actual time=11.317..11.317 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
199. 330.408 330.408 ↓ 0.0 0 39

Bitmap Index Scan on contributions_illinois_to_tsvector_idx3 (cost=0.00..105.01 rows=4,202 width=0) (actual time=8.472..8.472 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
200. 0.156 2.145 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_indiana ct_39 (cost=384.09..818.72 rows=228 width=556) (actual time=0.055..0.055 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
201. 0.039 1.989 ↓ 0.0 0 39

BitmapAnd (cost=384.09..384.09 rows=230 width=0) (actual time=0.051..0.051 rows=0 loops=39)

202. 0.741 1.950 ↓ 0.0 0 39

BitmapOr (cost=77.27..77.27 rows=9,160 width=0) (actual time=0.050..0.050 rows=0 loops=39)

203. 0.663 0.663 ↓ 0.0 0 39

Bitmap Index Scan on contributions_indiana_to_tsvector_idx2 (cost=0.00..38.86 rows=4,580 width=0) (actual time=0.017..0.017 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
204. 0.546 0.546 ↓ 0.0 0 39

Bitmap Index Scan on contributions_indiana_to_tsvector_idx3 (cost=0.00..38.29 rows=4,580 width=0) (actual time=0.014..0.014 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
205. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=306.57..306.57 rows=22,961 width=0) (never executed)

206. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_indiana_lower_idx (cost=0.00..98.37 rows=7,633 width=0) (never executed)

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

Bitmap Index Scan on contributions_indiana_lower_idx1 (cost=0.00..196.79 rows=15,328 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
208. 0.078 0.975 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_iowa ct_40 (cost=1.08..3.23 rows=1 width=776) (actual time=0.025..0.025 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
209. 0.546 0.897 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.023..0.023 rows=0 loops=39)

210. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_iowa_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
211. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_iowa_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
212. 0.078 95.043 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_irvine_ca ct_41 (cost=19.57..145.81 rows=92 width=640) (actual time=2.437..2.437 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
213. 0.585 94.965 ↓ 0.0 0 39

BitmapOr (cost=19.57..19.57 rows=94 width=0) (actual time=2.435..2.435 rows=0 loops=39)

214. 49.335 49.335 ↓ 0.0 0 39

Bitmap Index Scan on contributions_irvine_ca_to_tsvector_idx2 (cost=0.00..10.28 rows=47 width=0) (actual time=1.265..1.265 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
215. 45.045 45.045 ↓ 0.0 0 39

Bitmap Index Scan on contributions_irvine_ca_to_tsvector_idx3 (cost=0.00..9.24 rows=47 width=0) (actual time=1.155..1.155 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
216. 0.156 1.950 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_kansas ct_42 (cost=91.50..180.64 rows=53 width=447) (actual time=0.050..0.050 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
217. 0.039 1.794 ↓ 0.0 0 39

BitmapAnd (cost=91.50..91.50 rows=53 width=0) (actual time=0.046..0.046 rows=0 loops=39)

218. 0.663 1.755 ↓ 0.0 0 39

BitmapOr (cost=11.44..11.44 rows=1,032 width=0) (actual time=0.045..0.045 rows=0 loops=39)

219. 0.546 0.546 ↓ 0.0 0 39

Bitmap Index Scan on contributions_kansas_to_tsvector_idx2 (cost=0.00..5.77 rows=516 width=0) (actual time=0.014..0.014 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
220. 0.546 0.546 ↓ 0.0 0 39

Bitmap Index Scan on contributions_kansas_to_tsvector_idx3 (cost=0.00..5.64 rows=516 width=0) (actual time=0.014..0.014 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
221. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=79.81..79.81 rows=5,334 width=0) (never executed)

222. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_kansas_lower_idx (cost=0.00..1.53 rows=1 width=0) (never executed)

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

Bitmap Index Scan on contributions_kansas_lower_idx1 (cost=0.00..75.62 rows=5,334 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
224. 0.117 1.599 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_kentucky ct_43 (cost=7.80..9.95 rows=1 width=550) (actual time=0.041..0.041 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
225. 0.039 1.482 ↓ 0.0 0 39

BitmapAnd (cost=7.80..7.80 rows=1 width=0) (actual time=0.038..0.038 rows=0 loops=39)

226. 0.507 1.443 ↓ 0.0 0 39

BitmapOr (cost=3.75..3.75 rows=229 width=0) (actual time=0.037..0.037 rows=0 loops=39)

227. 0.507 0.507 ↓ 0.0 0 39

Bitmap Index Scan on contributions_kentucky_to_tsvector_idx2 (cost=0.00..1.90 rows=115 width=0) (actual time=0.013..0.013 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
228. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_kentucky_to_tsvector_idx3 (cost=0.00..1.85 rows=115 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
229. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=3.81..3.81 rows=129 width=0) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_kentucky_lower_idx (cost=0.00..1.73 rows=45 width=0) (never executed)

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

Bitmap Index Scan on contributions_kentucky_lower_idx1 (cost=0.00..2.02 rows=84 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
232. 0.039 2.847 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_lakeforest_ca ct_44 (cost=0.61..6.94 rows=4 width=721) (actual time=0.073..0.073 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
233. 0.468 2.808 ↓ 0.0 0 39

BitmapOr (cost=0.61..0.61 rows=4 width=0) (actual time=0.072..0.072 rows=0 loops=39)

234. 1.365 1.365 ↓ 0.0 0 39

Bitmap Index Scan on contributions_lakeforest_ca_to_tsvector_idx2 (cost=0.00..0.31 rows=2 width=0) (actual time=0.035..0.035 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
235. 0.975 0.975 ↓ 0.0 0 39

Bitmap Index Scan on contributions_lakeforest_ca_to_tsvector_idx3 (cost=0.00..0.30 rows=2 width=0) (actual time=0.025..0.025 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
236. 0.039 1.131 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_livermore_ca ct_45 (cost=0.94..10.46 rows=6 width=635) (actual time=0.029..0.029 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
237. 0.429 1.092 ↓ 0.0 0 39

BitmapOr (cost=0.94..0.94 rows=6 width=0) (actual time=0.028..0.028 rows=0 loops=39)

238. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_livermore_ca_to_tsvector_idx2 (cost=0.00..0.46 rows=3 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
239. 0.312 0.312 ↓ 0.0 0 39

Bitmap Index Scan on contributions_livermore_ca_to_tsvector_idx3 (cost=0.00..0.47 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
240. 0.039 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_longbeach_ca ct_46 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
241. 0.468 0.819 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

242. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_longbeach_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
243. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_longbeach_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
244. 0.078 277.095 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_los_angeles ct_47 (cost=92.45..4,775.44 rows=3,323 width=399) (actual time=7.105..7.105 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
245. 0.663 277.017 ↓ 0.0 0 39

BitmapOr (cost=92.45..92.45 rows=3,598 width=0) (actual time=7.103..7.103 rows=0 loops=39)

246. 150.735 150.735 ↓ 0.0 0 39

Bitmap Index Scan on contributions_los_angeles_to_tsvector_idx2 (cost=0.00..48.21 rows=1,799 width=0) (actual time=3.865..3.865 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
247. 125.619 125.619 ↓ 0.0 0 39

Bitmap Index Scan on contributions_los_angeles_to_tsvector_idx3 (cost=0.00..42.58 rows=1,799 width=0) (actual time=3.221..3.221 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
248. 0.078 1.053 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_louisiana ct_48 (cost=1.08..3.23 rows=1 width=776) (actual time=0.027..0.027 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
249. 0.624 0.975 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=39)

250. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_louisiana_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
251. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_louisiana_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
252. 0.078 38.493 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_madera_county ct_49 (cost=7.98..36.39 rows=20 width=680) (actual time=0.987..0.987 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
253. 0.546 38.415 ↓ 0.0 0 39

BitmapOr (cost=7.98..7.98 rows=21 width=0) (actual time=0.985..0.985 rows=0 loops=39)

254. 22.893 22.893 ↓ 0.0 0 39

Bitmap Index Scan on contributions_madera_county_to_tsvector_idx2 (cost=0.00..4.73 rows=10 width=0) (actual time=0.587..0.587 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
255. 14.976 14.976 ↓ 0.0 0 39

Bitmap Index Scan on contributions_madera_county_to_tsvector_idx3 (cost=0.00..3.24 rows=10 width=0) (actual time=0.384..0.384 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
256. 0.156 2.106 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_maine ct_50 (cost=330.89..687.77 rows=205 width=564) (actual time=0.054..0.054 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
257. 0.078 1.950 ↓ 0.0 0 39

BitmapAnd (cost=330.89..330.89 rows=206 width=0) (actual time=0.050..0.050 rows=0 loops=39)

258. 0.585 1.872 ↓ 0.0 0 39

BitmapOr (cost=32.24..32.24 rows=3,400 width=0) (actual time=0.048..0.048 rows=0 loops=39)

259. 0.702 0.702 ↓ 0.0 0 39

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

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
260. 0.585 0.585 ↓ 0.0 0 39

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

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
261. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=298.41..298.41 rows=20,561 width=0) (never executed)

262. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_maine_lower_idx (cost=0.00..14.42 rows=986 width=0) (never executed)

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

Bitmap Index Scan on contributions_maine_lower_idx1 (cost=0.00..273.74 rows=19,575 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
264. 0.078 17.784 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_manhattanbeach_ca ct_51 (cost=3.56..13.08 rows=6 width=709) (actual time=0.456..0.456 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
265. 0.507 17.706 ↓ 0.0 0 39

BitmapOr (cost=3.56..3.56 rows=6 width=0) (actual time=0.454..0.454 rows=0 loops=39)

266. 8.775 8.775 ↓ 0.0 0 39

Bitmap Index Scan on contributions_manhattanbeach_ca_to_tsvector_idx2 (cost=0.00..1.78 rows=3 width=0) (actual time=0.225..0.225 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
267. 8.424 8.424 ↓ 0.0 0 39

Bitmap Index Scan on contributions_manhattanbeach_ca_to_tsvector_idx3 (cost=0.00..1.78 rows=3 width=0) (actual time=0.216..0.216 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
268. 0.078 7.293 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_manteca_ca ct_52 (cost=1.48..7.82 rows=4 width=689) (actual time=0.187..0.187 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
269. 0.507 7.215 ↓ 0.0 0 39

BitmapOr (cost=1.48..1.48 rows=4 width=0) (actual time=0.185..0.185 rows=0 loops=39)

270. 3.822 3.822 ↓ 0.0 0 39

Bitmap Index Scan on contributions_manteca_ca_to_tsvector_idx2 (cost=0.00..1.18 rows=2 width=0) (actual time=0.098..0.098 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
271. 2.886 2.886 ↓ 0.0 0 39

Bitmap Index Scan on contributions_manteca_ca_to_tsvector_idx3 (cost=0.00..0.30 rows=2 width=0) (actual time=0.074..0.074 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
272. 0.078 47.385 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_marin_county ct_53 (cost=10.89..148.55 rows=101 width=635) (actual time=1.215..1.215 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
273. 0.741 47.307 ↓ 0.0 0 39

BitmapOr (cost=10.89..10.89 rows=104 width=0) (actual time=1.213..1.213 rows=0 loops=39)

274. 25.272 25.272 ↓ 0.0 0 39

Bitmap Index Scan on contributions_marin_county_to_tsvector_idx2 (cost=0.00..5.76 rows=52 width=0) (actual time=0.648..0.648 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
275. 21.294 21.294 ↓ 0.0 0 39

Bitmap Index Scan on contributions_marin_county_to_tsvector_idx3 (cost=0.00..5.08 rows=52 width=0) (actual time=0.546..0.546 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
276. 0.039 2.340 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_maryland ct_54 (cost=0.56..2.70 rows=1 width=520) (actual time=0.060..0.060 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
277. 0.546 2.301 ↓ 0.0 0 39

BitmapOr (cost=0.56..0.56 rows=1 width=0) (actual time=0.059..0.059 rows=0 loops=39)

278. 0.936 0.936 ↓ 0.0 0 39

Bitmap Index Scan on contributions_maryland_to_tsvector_idx2 (cost=0.00..0.29 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
279. 0.819 0.819 ↓ 0.0 0 39

Bitmap Index Scan on contributions_maryland_to_tsvector_idx3 (cost=0.00..0.27 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
280. 0.039 0.897 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_massachusetts ct_55 (cost=1.08..3.23 rows=1 width=776) (actual time=0.023..0.023 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
281. 0.507 0.858 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=39)

282. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_massachusetts_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
283. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_massachusetts_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
284. 0.039 0.741 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_merced_county ct_56 (cost=1.08..3.23 rows=1 width=776) (actual time=0.019..0.019 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
285. 0.390 0.702 ↓ 0.0 0 39

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

286. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_merced_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
287. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_merced_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
288. 0.156 1,018.797 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_michigan ct_57 (cost=4,126.34..7,705.68 rows=1,755 width=523) (actual time=26.123..26.123 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
289. 0.039 1,018.641 ↓ 0.0 0 39

BitmapAnd (cost=4,126.34..4,126.34 rows=1,761 width=0) (actual time=26.119..26.119 rows=0 loops=39)

290. 0.858 1,018.602 ↓ 0.0 0 39

BitmapOr (cost=1,792.62..1,792.62 rows=196,341 width=0) (actual time=26.118..26.118 rows=0 loops=39)

291. 592.917 592.917 ↓ 0.0 0 39

Bitmap Index Scan on contributions_michigan_to_tsvector_idx2 (cost=0.00..913.18 rows=98,170 width=0) (actual time=15.203..15.203 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
292. 424.827 424.827 ↓ 0.0 0 39

Bitmap Index Scan on contributions_michigan_to_tsvector_idx3 (cost=0.00..878.56 rows=98,170 width=0) (actual time=10.893..10.893 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
293. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=2,333.47..2,333.47 rows=176,052 width=0) (never executed)

294. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_michigan_lower_idx (cost=0.00..243.01 rows=18,980 width=0) (never executed)

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

Bitmap Index Scan on contributions_michigan_lower_idx (cost=0.00..2,002.51 rows=157,073 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
296. 0.039 2.145 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_minnesota ct_58 (cost=38.61..5,267.92 rows=3,929 width=584) (actual time=0.055..0.055 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
297. 0.819 2.106 ↓ 0.0 0 39

BitmapOr (cost=38.61..38.61 rows=3,939 width=0) (actual time=0.054..0.054 rows=0 loops=39)

298. 0.702 0.702 ↓ 0.0 0 39

Bitmap Index Scan on contributions_minnesota_to_tsvector_idx2 (cost=0.00..18.43 rows=1,970 width=0) (actual time=0.018..0.018 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
299. 0.585 0.585 ↓ 0.0 0 39

Bitmap Index Scan on contributions_minnesota_to_tsvector_idx3 (cost=0.00..18.21 rows=1,970 width=0) (actual time=0.015..0.015 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
300. 0.195 307.788 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_mississippi ct_59 (cost=77.88..90.70 rows=6 width=519) (actual time=7.892..7.892 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
301. 0.897 307.593 ↓ 0.0 0 39

BitmapAnd (cost=77.88..77.88 rows=6 width=0) (actual time=7.887..7.887 rows=0 loops=39)

302. 0.039 5.265 ↓ 0.0 0 39

BitmapOr (cost=14.51..14.51 rows=641 width=0) (actual time=0.135..0.135 rows=0 loops=39)

303. 0.234 0.234 ↓ 0.0 0 39

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

  • Index Cond: (lower(contributor_state) IS NULL)
304. 4.992 4.992 ↓ 2.0 1,255 39

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
305. 0.780 301.431 ↓ 0.0 0 39

BitmapOr (cost=63.12..63.12 rows=232 width=0) (actual time=7.729..7.729 rows=0 loops=39)

306. 167.232 167.232 ↓ 0.0 0 39

Bitmap Index Scan on contributions_mississippi_to_tsvector_idx2 (cost=0.00..36.29 rows=116 width=0) (actual time=4.288..4.288 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
307. 133.419 133.419 ↓ 0.0 0 39

Bitmap Index Scan on contributions_mississippi_to_tsvector_idx3 (cost=0.00..26.82 rows=116 width=0) (actual time=3.421..3.421 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
308. 0.078 1.131 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_missouri ct_60 (cost=1.08..3.23 rows=1 width=776) (actual time=0.029..0.029 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
309. 0.663 1.053 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=39)

310. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_missouri_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
311. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_missouri_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
312. 0.195 45.162 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_montana ct_61 (cost=23.41..36.24 rows=6 width=533) (actual time=1.158..1.158 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
313. 0.702 44.967 ↓ 0.0 0 39

BitmapAnd (cost=23.41..23.41 rows=6 width=0) (actual time=1.153..1.153 rows=0 loops=39)

314. 0.000 3.666 ↓ 0.0 0 39

BitmapOr (cost=10.79..10.79 rows=590 width=0) (actual time=0.094..0.094 rows=0 loops=39)

315. 0.390 0.390 ↓ 1.0 31 39

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=39)

  • Index Cond: (lower(contributor_state) IS NULL)
316. 3.276 3.276 ↓ 1.2 680 39

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
317. 0.585 40.599 ↓ 0.0 0 39

BitmapOr (cost=12.37..12.37 rows=350 width=0) (actual time=1.041..1.041 rows=0 loops=39)

318. 21.021 21.021 ↓ 0.0 0 39

Bitmap Index Scan on contributions_montana_to_tsvector_idx2 (cost=0.00..6.47 rows=175 width=0) (actual time=0.539..0.539 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
319. 18.993 18.993 ↓ 0.0 0 39

Bitmap Index Scan on contributions_montana_to_tsvector_idx3 (cost=0.00..5.90 rows=175 width=0) (actual time=0.487..0.487 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
320. 0.078 121.017 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_monterey_county ct_62 (cost=26.99..185.76 rows=116 width=637) (actual time=3.103..3.103 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
321. 0.780 120.939 ↓ 0.0 0 39

BitmapOr (cost=26.99..26.99 rows=119 width=0) (actual time=3.101..3.101 rows=0 loops=39)

322. 65.676 65.676 ↓ 0.0 0 39

Bitmap Index Scan on contributions_monterey_county_to_tsvector_idx2 (cost=0.00..15.10 rows=60 width=0) (actual time=1.684..1.684 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
323. 54.483 54.483 ↓ 0.0 0 39

Bitmap Index Scan on contributions_monterey_county_to_tsvector_idx3 (cost=0.00..11.83 rows=60 width=0) (actual time=1.397..1.397 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
324. 0.078 7.800 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_morganhill_ca ct_63 (cost=1.47..5.70 rows=3 width=715) (actual time=0.200..0.200 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
325. 0.624 7.722 ↓ 0.0 0 39

BitmapOr (cost=1.47..1.47 rows=3 width=0) (actual time=0.198..0.198 rows=0 loops=39)

326. 4.134 4.134 ↓ 0.0 0 39

Bitmap Index Scan on contributions_morganhill_ca_to_tsvector_idx2 (cost=0.00..1.18 rows=1 width=0) (actual time=0.106..0.106 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
327. 2.964 2.964 ↓ 0.0 0 39

Bitmap Index Scan on contributions_morganhill_ca_to_tsvector_idx3 (cost=0.00..0.29 rows=1 width=0) (actual time=0.076..0.076 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
328. 0.039 16.926 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_mountainview_ca ct_64 (cost=3.75..21.65 rows=13 width=667) (actual time=0.434..0.434 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
329. 0.507 16.887 ↓ 0.0 0 39

BitmapOr (cost=3.75..3.75 rows=13 width=0) (actual time=0.433..0.433 rows=0 loops=39)

330. 8.892 8.892 ↓ 0.0 0 39

Bitmap Index Scan on contributions_mountainview_ca_to_tsvector_idx2 (cost=0.00..2.30 rows=7 width=0) (actual time=0.228..0.228 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
331. 7.488 7.488 ↓ 0.0 0 39

Bitmap Index Scan on contributions_mountainview_ca_to_tsvector_idx3 (cost=0.00..1.45 rows=7 width=0) (actual time=0.192..0.192 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
332. 0.078 3.666 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_murrieta_ca ct_65 (cost=1.16..8.54 rows=5 width=647) (actual time=0.094..0.094 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
333. 0.468 3.588 ↓ 0.0 0 39

BitmapOr (cost=1.16..1.16 rows=5 width=0) (actual time=0.092..0.092 rows=0 loops=39)

334. 1.950 1.950 ↓ 0.0 0 39

Bitmap Index Scan on contributions_murrieta_ca_to_tsvector_idx2 (cost=0.00..0.86 rows=2 width=0) (actual time=0.050..0.050 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
335. 1.170 1.170 ↓ 0.0 0 39

Bitmap Index Scan on contributions_murrieta_ca_to_tsvector_idx3 (cost=0.00..0.30 rows=2 width=0) (actual time=0.030..0.030 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
336. 0.078 0.897 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_nebraska ct_66 (cost=1.08..3.23 rows=1 width=776) (actual time=0.023..0.023 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
337. 0.468 0.819 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

338. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nebraska_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
339. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nebraska_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
340. 0.039 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_nebraska2 ct_67 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
341. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

342. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nebraska2_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
343. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nebraska2_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
344. 0.039 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_nevada ct_68 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
345. 0.468 0.819 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

346. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nevada_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
347. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nevada_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
348. 0.156 1.755 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_nevada2 ct_69 (cost=40.77..53.54 rows=7 width=510) (actual time=0.045..0.045 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
349. 0.042 1.599 ↓ 0.0 0 39

BitmapAnd (cost=40.77..40.77 rows=7 width=0) (actual time=0.041..0.041 rows=0 loops=39)

350. 0.429 1.287 ↓ 0.0 0 39

BitmapOr (cost=3.68..3.68 rows=143 width=0) (actual time=0.033..0.033 rows=0 loops=39)

351. 0.468 0.468 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nevada2_to_tsvector_idx2 (cost=0.00..1.90 rows=71 width=0) (actual time=0.012..0.012 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
352. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nevada2_to_tsvector_idx3 (cost=0.00..1.78 rows=71 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
353. 0.002 0.270 ↓ 0.0 0 2

BitmapOr (cost=36.84..36.84 rows=652 width=0) (actual time=0.135..0.135 rows=0 loops=2)

354. 0.022 0.022 ↓ 0.0 0 2

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

  • Index Cond: (lower(contributor_state) IS NULL)
355. 0.246 0.246 ↑ 1.0 652 2

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
356. 0.078 40.014 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_nevada_county ct_70 (cost=7.35..43.14 rows=26 width=638) (actual time=1.026..1.026 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
357. 0.546 39.936 ↓ 0.0 0 39

BitmapOr (cost=7.35..7.35 rows=26 width=0) (actual time=1.024..1.024 rows=0 loops=39)

358. 20.514 20.514 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nevada_county_to_tsvector_idx2 (cost=0.00..4.18 rows=13 width=0) (actual time=0.526..0.526 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
359. 18.876 18.876 ↓ 0.0 0 39

Bitmap Index Scan on contributions_nevada_county_to_tsvector_idx3 (cost=0.00..3.16 rows=13 width=0) (actual time=0.484..0.484 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
360. 0.156 1.443 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_new_hampshire ct_71 (cost=6.00..8.14 rows=1 width=641) (actual time=0.037..0.037 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
361. 0.039 1.287 ↓ 0.0 0 39

BitmapAnd (cost=6.00..6.00 rows=1 width=0) (actual time=0.033..0.033 rows=0 loops=39)

362. 0.507 1.248 ↓ 0.0 0 39

BitmapOr (cost=1.18..1.18 rows=18 width=0) (actual time=0.032..0.032 rows=0 loops=39)

363. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_hampshire_to_tsvector_idx2 (cost=0.00..0.62 rows=9 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
364. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_hampshire_to_tsvector_idx3 (cost=0.00..0.56 rows=9 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
365. 0.000 0.000 ↓ 0.0 0

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

366. 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)
367. 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)
368. 0.039 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_new_jersey ct_72 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
369. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

370. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_jersey_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
371. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_jersey_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
372. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_new_mexico ct_73 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
373. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

374. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_mexico_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
375. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_mexico_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
376. 0.078 65.013 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_newportbeach_ca ct_74 (cost=12.80..54.00 rows=28 width=690) (actual time=1.667..1.667 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
377. 0.507 64.935 ↓ 0.0 0 39

BitmapOr (cost=12.80..12.80 rows=28 width=0) (actual time=1.665..1.665 rows=0 loops=39)

378. 33.657 33.657 ↓ 0.0 0 39

Bitmap Index Scan on contributions_newportbeach_ca_to_tsvector_idx2 (cost=0.00..6.62 rows=14 width=0) (actual time=0.863..0.863 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
379. 30.771 30.771 ↓ 0.0 0 39

Bitmap Index Scan on contributions_newportbeach_ca_to_tsvector_idx3 (cost=0.00..6.17 rows=14 width=0) (actual time=0.789..0.789 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
380. 0.039 0.936 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_new_york ct_75 (cost=1.08..3.23 rows=1 width=776) (actual time=0.024..0.024 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
381. 0.546 0.897 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.023..0.023 rows=0 loops=39)

382. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_york_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
383. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_york_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
384. 0.039 0.780 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_new_york_campaign ct_76 (cost=1.08..3.23 rows=1 width=776) (actual time=0.020..0.020 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
385. 0.429 0.741 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=39)

386. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_york_campaign_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
387. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_new_york_campaign_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
388. 0.702 691.509 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_north_carolina ct_77 (cost=301.61..424.55 rows=59 width=449) (actual time=17.731..17.731 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
389. 6.669 690.807 ↓ 0.0 0 39

BitmapAnd (cost=301.61..301.61 rows=59 width=0) (actual time=17.713..17.713 rows=0 loops=39)

390. 0.039 33.618 ↓ 0.0 0 39

BitmapOr (cost=89.81..89.81 rows=5,894 width=0) (actual time=0.862..0.862 rows=0 loops=39)

391. 7.800 7.800 ↓ 1.1 1,878 39

Bitmap Index Scan on contributions_north_carolina_lower_idx (cost=0.00..25.09 rows=1,675 width=0) (actual time=0.200..0.200 rows=1,878 loops=39)

  • Index Cond: (lower(contributor_state) IS NULL)
392. 25.779 25.779 ↓ 1.2 5,190 39

Bitmap Index Scan on contributions_north_carolina_lower_idx (cost=0.00..61.77 rows=4,220 width=0) (actual time=0.661..0.661 rows=5,190 loops=39)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
393. 1.014 650.520 ↓ 0.0 0 39

BitmapOr (cost=211.55..211.55 rows=10,047 width=0) (actual time=16.680..16.680 rows=0 loops=39)

394. 308.256 308.256 ↓ 0.0 0 39

Bitmap Index Scan on contributions_north_carolina_to_tsvector_idx2 (cost=0.00..104.38 rows=5,024 width=0) (actual time=7.904..7.904 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
395. 341.250 341.250 ↓ 0.0 0 39

Bitmap Index Scan on contributions_north_carolina_to_tsvector_idx3 (cost=0.00..107.14 rows=5,024 width=0) (actual time=8.750..8.750 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
396. 0.078 1.287 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_north_dakota ct_78 (cost=1.08..3.23 rows=1 width=776) (actual time=0.033..0.033 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
397. 0.780 1.209 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.031..0.031 rows=0 loops=39)

398. 0.234 0.234 ↓ 0.0 0 39

Bitmap Index Scan on contributions_north_dakota_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
399. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_north_dakota_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
400. 0.078 1.404 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_oakland_ca ct_79 (cost=4.69..408.59 rows=286 width=655) (actual time=0.036..0.036 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
401. 0.429 1.326 ↓ 0.0 0 39

BitmapOr (cost=4.69..4.69 rows=302 width=0) (actual time=0.034..0.034 rows=0 loops=39)

402. 0.468 0.468 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oakland_ca_to_tsvector_idx2 (cost=0.00..2.33 rows=151 width=0) (actual time=0.012..0.012 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
403. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oakland_ca_to_tsvector_idx3 (cost=0.00..2.22 rows=151 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
404. 0.078 1.248 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_oceanside_ca ct_80 (cost=2.74..173.22 rows=125 width=647) (actual time=0.032..0.032 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
405. 0.390 1.170 ↓ 0.0 0 39

BitmapOr (cost=2.74..2.74 rows=126 width=0) (actual time=0.030..0.030 rows=0 loops=39)

406. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oceanside_ca_to_tsvector_idx2 (cost=0.00..1.34 rows=63 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
407. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oceanside_ca_to_tsvector_idx3 (cost=0.00..1.33 rows=63 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
408. 0.117 9.048 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_ohio ct_81 (cost=5.56..7.71 rows=1 width=572) (actual time=0.232..0.232 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
409. 0.039 8.931 ↓ 0.0 0 39

BitmapAnd (cost=5.56..5.56 rows=1 width=0) (actual time=0.229..0.229 rows=0 loops=39)

410. 0.429 8.892 ↓ 0.0 0 39

BitmapOr (cost=2.31..2.31 rows=10 width=0) (actual time=0.228..0.228 rows=0 loops=39)

411. 4.641 4.641 ↓ 0.0 0 39

Bitmap Index Scan on contributions_ohio_to_tsvector_idx2 (cost=0.00..1.24 rows=5 width=0) (actual time=0.119..0.119 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
412. 3.822 3.822 ↓ 0.0 0 39

Bitmap Index Scan on contributions_ohio_to_tsvector_idx3 (cost=0.00..1.06 rows=5 width=0) (actual time=0.098..0.098 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
413. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=3.01..3.01 rows=32 width=0) (never executed)

414. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_ohio_lower_idx (cost=0.00..1.54 rows=22 width=0) (never executed)

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

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
416. 0.195 2.886 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_oklahoma ct_82 (cost=14.19..16.33 rows=1 width=617) (actual time=0.074..0.074 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
417. 0.156 2.691 ↓ 0.0 0 39

BitmapAnd (cost=14.19..14.19 rows=1 width=0) (actual time=0.069..0.069 rows=0 loops=39)

418. 0.039 1.131 ↓ 0.0 0 39

BitmapOr (cost=3.75..3.75 rows=89 width=0) (actual time=0.029..0.029 rows=0 loops=39)

419. 0.429 0.429 ↑ 3.0 4 39

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

  • Index Cond: (lower(contributor_state) IS NULL)
420. 0.663 0.663 ↓ 1.2 89 39

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
421. 0.507 1.404 ↓ 0.0 0 39

BitmapOr (cost=10.19..10.19 rows=925 width=0) (actual time=0.036..0.036 rows=0 loops=39)

422. 0.468 0.468 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oklahoma_to_tsvector_idx2 (cost=0.00..5.16 rows=463 width=0) (actual time=0.012..0.012 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
423. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oklahoma_to_tsvector_idx3 (cost=0.00..5.03 rows=463 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
424. 0.195 6.279 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_oklahoma2 ct_83 (cost=48.37..61.22 rows=6 width=522) (actual time=0.161..0.161 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
425. 0.663 6.084 ↓ 0.0 0 39

BitmapAnd (cost=48.37..48.37 rows=6 width=0) (actual time=0.156..0.156 rows=0 loops=39)

426. 0.039 3.783 ↓ 0.0 0 39

BitmapOr (cost=14.30..14.30 rows=581 width=0) (actual time=0.097..0.097 rows=0 loops=39)

427. 0.195 0.195 ↑ 1.0 1 39

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

  • Index Cond: (lower(contributor_state) IS NULL)
428. 3.549 3.549 ↓ 1.1 635 39

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
429. 0.468 1.638 ↓ 0.0 0 39

BitmapOr (cost=33.82..33.82 rows=3,555 width=0) (actual time=0.042..0.042 rows=0 loops=39)

430. 0.624 0.624 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oklahoma2_to_tsvector_idx2 (cost=0.00..16.96 rows=1,778 width=0) (actual time=0.016..0.016 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
431. 0.546 0.546 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oklahoma2_to_tsvector_idx3 (cost=0.00..16.86 rows=1,778 width=0) (actual time=0.014..0.014 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
432. 0.078 37.713 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_orange_county ct_84 (cost=7.35..46.27 rows=28 width=638) (actual time=0.967..0.967 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
433. 0.507 37.635 ↓ 0.0 0 39

BitmapOr (cost=7.35..7.35 rows=29 width=0) (actual time=0.965..0.965 rows=0 loops=39)

434. 18.798 18.798 ↓ 0.0 0 39

Bitmap Index Scan on contributions_orange_county_to_tsvector_idx2 (cost=0.00..4.17 rows=14 width=0) (actual time=0.482..0.482 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
435. 18.330 18.330 ↓ 0.0 0 39

Bitmap Index Scan on contributions_orange_county_to_tsvector_idx3 (cost=0.00..3.17 rows=14 width=0) (actual time=0.470..0.470 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
436. 0.273 784.953 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_oregon ct_85 (cost=180.68..198.83 rows=8 width=517) (actual time=20.127..20.127 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
437. 1.404 784.680 ↓ 0.0 0 39

BitmapAnd (cost=180.68..180.68 rows=9 width=0) (actual time=20.120..20.120 rows=0 loops=39)

438. 0.039 7.800 ↓ 0.0 0 39

BitmapOr (cost=16.19..16.19 rows=851 width=0) (actual time=0.200..0.200 rows=0 loops=39)

439. 0.390 0.390 ↓ 1.9 56 39

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

  • Index Cond: (lower(contributor_state) IS NULL)
440. 7.371 7.371 ↓ 1.9 1,554 39

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

  • Index Cond: (lower(contributor_state) = 'ca'::text)
441. 0.936 775.476 ↓ 0.0 0 39

BitmapOr (cost=164.24..164.24 rows=533 width=0) (actual time=19.884..19.884 rows=0 loops=39)

442. 451.152 451.152 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oregon_to_tsvector_idx2 (cost=0.00..96.76 rows=266 width=0) (actual time=11.568..11.568 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
443. 323.388 323.388 ↓ 0.0 0 39

Bitmap Index Scan on contributions_oregon_to_tsvector_idx3 (cost=0.00..67.48 rows=266 width=0) (actual time=8.292..8.292 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
444. 0.078 25.428 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_paloalto_ca ct_86 (cost=6.36..46.31 rows=29 width=658) (actual time=0.652..0.652 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
445. 0.858 25.350 ↓ 0.0 0 39

BitmapOr (cost=6.36..6.36 rows=30 width=0) (actual time=0.650..0.650 rows=0 loops=39)

446. 12.870 12.870 ↓ 0.0 0 39

Bitmap Index Scan on contributions_paloalto_ca_to_tsvector_idx2 (cost=0.00..3.22 rows=15 width=0) (actual time=0.330..0.330 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
447. 11.622 11.622 ↓ 0.0 0 39

Bitmap Index Scan on contributions_paloalto_ca_to_tsvector_idx3 (cost=0.00..3.13 rows=15 width=0) (actual time=0.298..0.298 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
448. 0.039 1.287 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_pasadena_ca ct_87 (cost=2.03..85.14 rows=61 width=688) (actual time=0.033..0.033 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
449. 0.468 1.248 ↓ 0.0 0 39

BitmapOr (cost=2.03..2.03 rows=62 width=0) (actual time=0.032..0.032 rows=0 loops=39)

450. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_pasadena_ca_to_tsvector_idx2 (cost=0.00..1.05 rows=31 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
451. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_pasadena_ca_to_tsvector_idx3 (cost=0.00..0.95 rows=31 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
452. 0.039 0.897 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_patterson_ca ct_88 (cost=1.17..3.31 rows=1 width=776) (actual time=0.023..0.023 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
453. 0.468 0.858 ↓ 0.0 0 39

BitmapOr (cost=1.17..1.17 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=39)

454. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_patterson_ca_to_tsvector_idx2 (cost=0.00..0.58 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
455. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_patterson_ca_to_tsvector_idx3 (cost=0.00..0.58 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
456. 0.195 776.607 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_pennsylvania ct_89 (cost=5,643.77..12,174.33 rows=3,632 width=633) (actual time=19.913..19.913 rows=0 loops=39)

  • Recheck Cond: (((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))) AND ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)))
457. 0.039 776.412 ↓ 0.0 0 39

BitmapAnd (cost=5,643.77..5,643.77 rows=3,671 width=0) (actual time=19.908..19.908 rows=0 loops=39)

458. 0.819 776.373 ↓ 0.0 0 39

BitmapOr (cost=662.34..662.34 rows=60,381 width=0) (actual time=19.907..19.907 rows=0 loops=39)

459. 546.156 546.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_pennsylvania_to_tsvector_idx2 (cost=0.00..366.81 rows=30,190 width=0) (actual time=14.004..14.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
460. 229.398 229.398 ↓ 0.0 0 39

Bitmap Index Scan on contributions_pennsylvania_to_tsvector_idx3 (cost=0.00..293.72 rows=30,190 width=0) (actual time=5.882..5.882 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
461. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=4,981.18..4,981.18 rows=367,116 width=0) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on contributions_pennsylvania_lower_idx (cost=0.00..776.85 rows=59,375 width=0) (never executed)

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

Bitmap Index Scan on contributions_pennsylvania_lower_idx1 (cost=0.00..4,022.29 rows=307,741 width=0) (never executed)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
464. 0.078 2.886 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_perris_ca ct_90 (cost=0.55..2.69 rows=1 width=692) (actual time=0.074..0.074 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
465. 0.780 2.808 ↓ 0.0 0 39

BitmapOr (cost=0.55..0.55 rows=1 width=0) (actual time=0.072..0.072 rows=0 loops=39)

466. 1.209 1.209 ↓ 0.0 0 39

Bitmap Index Scan on contributions_perris_ca_to_tsvector_idx2 (cost=0.00..0.27 rows=1 width=0) (actual time=0.031..0.031 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
467. 0.819 0.819 ↓ 0.0 0 39

Bitmap Index Scan on contributions_perris_ca_to_tsvector_idx3 (cost=0.00..0.27 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
468. 0.078 20.124 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_placer_county ct_91 (cost=5.01..32.36 rows=19 width=696) (actual time=0.516..0.516 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
469. 0.585 20.046 ↓ 0.0 0 39

BitmapOr (cost=5.01..5.01 rows=20 width=0) (actual time=0.514..0.514 rows=0 loops=39)

470. 12.480 12.480 ↓ 0.0 0 39

Bitmap Index Scan on contributions_placer_county_to_tsvector_idx2 (cost=0.00..3.08 rows=10 width=0) (actual time=0.320..0.320 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
471. 6.981 6.981 ↓ 0.0 0 39

Bitmap Index Scan on contributions_placer_county_to_tsvector_idx3 (cost=0.00..1.91 rows=10 width=0) (actual time=0.179..0.179 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
472. 0.078 13.299 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_pleasanton_ca ct_92 (cost=4.58..67.67 rows=46 width=641) (actual time=0.341..0.341 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
473. 0.507 13.221 ↓ 0.0 0 39

BitmapOr (cost=4.58..4.58 rows=47 width=0) (actual time=0.339..0.339 rows=0 loops=39)

474. 6.981 6.981 ↓ 0.0 0 39

Bitmap Index Scan on contributions_pleasanton_ca_to_tsvector_idx2 (cost=0.00..2.44 rows=23 width=0) (actual time=0.179..0.179 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
475. 5.733 5.733 ↓ 0.0 0 39

Bitmap Index Scan on contributions_pleasanton_ca_to_tsvector_idx3 (cost=0.00..2.12 rows=23 width=0) (actual time=0.147..0.147 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
476. 0.117 24.726 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_redondobeach_ca ct_93 (cost=5.70..43.65 rows=26 width=688) (actual time=0.634..0.634 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
477. 0.546 24.609 ↓ 0.0 0 39

BitmapOr (cost=5.70..5.70 rows=27 width=0) (actual time=0.631..0.631 rows=0 loops=39)

478. 12.090 12.090 ↓ 0.0 0 39

Bitmap Index Scan on contributions_redondobeach_ca_to_tsvector_idx2 (cost=0.00..3.12 rows=14 width=0) (actual time=0.310..0.310 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
479. 11.973 11.973 ↓ 0.0 0 39

Bitmap Index Scan on contributions_redondobeach_ca_to_tsvector_idx3 (cost=0.00..2.57 rows=14 width=0) (actual time=0.307..0.307 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
480. 0.078 1.326 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_rhode_island ct_94 (cost=1.17..3.31 rows=1 width=776) (actual time=0.034..0.034 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
481. 0.507 1.248 ↓ 0.0 0 39

BitmapOr (cost=1.17..1.17 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=39)

482. 0.312 0.312 ↓ 0.0 0 39

Bitmap Index Scan on contributions_rhode_island_to_tsvector_idx2 (cost=0.00..0.58 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
483. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_rhode_island_to_tsvector_idx3 (cost=0.00..0.58 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
484. 0.078 1.248 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_richmond_ca ct_95 (cost=2.17..97.09 rows=67 width=753) (actual time=0.032..0.032 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
485. 0.468 1.170 ↓ 0.0 0 39

BitmapOr (cost=2.17..2.17 rows=67 width=0) (actual time=0.030..0.030 rows=0 loops=39)

486. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_richmond_ca_to_tsvector_idx2 (cost=0.00..1.05 rows=34 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
487. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_richmond_ca_to_tsvector_idx3 (cost=0.00..1.09 rows=34 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
488. 0.117 589.056 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_riverside_county ct_96 (cost=159.92..6,494.88 rows=4,788 width=645) (actual time=15.104..15.104 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
489. 0.546 588.939 ↓ 0.0 0 39

BitmapOr (cost=159.92..159.92 rows=4,822 width=0) (actual time=15.101..15.101 rows=0 loops=39)

490. 23.751 23.751 ↓ 0.0 0 39

Bitmap Index Scan on contributions_riverside_county_to_tsvector_idx2 (cost=0.00..24.64 rows=2,411 width=0) (actual time=0.609..0.609 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
491. 564.642 564.642 ↓ 0.0 0 39

Bitmap Index Scan on contributions_riverside_county_to_tsvector_idx3 (cost=0.00..132.89 rows=2,411 width=0) (actual time=14.478..14.478 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
492. 0.039 1.287 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_roseville_ca ct_97 (cost=1.08..3.23 rows=1 width=776) (actual time=0.033..0.033 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
493. 0.819 1.248 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=39)

494. 0.234 0.234 ↓ 0.0 0 39

Bitmap Index Scan on contributions_roseville_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
495. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_roseville_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
496. 0.039 1.326 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sacramento_ca ct_98 (cost=3.76..304.35 rows=215 width=659) (actual time=0.034..0.034 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
497. 0.429 1.287 ↓ 0.0 0 39

BitmapOr (cost=3.76..3.76 rows=227 width=0) (actual time=0.033..0.033 rows=0 loops=39)

498. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sacramento_ca_to_tsvector_idx2 (cost=0.00..1.88 rows=114 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
499. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sacramento_ca_to_tsvector_idx3 (cost=0.00..1.78 rows=114 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
500. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sacramento_county ct_99 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
501. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

502. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sacramento_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
503. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sacramento_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
504. 0.078 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_salinas_ca ct_100 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
505. 0.390 0.741 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=39)

506. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_salinas_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
507. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_salinas_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
508. 0.039 0.741 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_san_antonio ct_101 (cost=1.08..3.23 rows=1 width=776) (actual time=0.019..0.019 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
509. 0.390 0.702 ↓ 0.0 0 39

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

510. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_san_antonio_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
511. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_san_antonio_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
512. 0.039 0.780 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanbenito_county ct_102 (cost=1.08..3.23 rows=1 width=776) (actual time=0.020..0.020 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
513. 0.429 0.741 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=39)

514. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanbenito_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
515. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanbenito_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
516. 0.078 1.287 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanbernardino_ca ct_103 (cost=2.62..166.64 rows=121 width=691) (actual time=0.033..0.033 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
517. 0.390 1.209 ↓ 0.0 0 39

BitmapOr (cost=2.62..2.62 rows=123 width=0) (actual time=0.031..0.031 rows=0 loops=39)

518. 0.429 0.429 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanbernardino_ca_to_tsvector_idx2 (cost=0.00..1.29 rows=61 width=0) (actual time=0.011..0.011 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
519. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanbernardino_ca_to_tsvector_idx3 (cost=0.00..1.27 rows=61 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
520. 0.117 140.166 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanbernardino_county ct_104 (cost=46.78..2,629.44 rows=1,930 width=710) (actual time=3.594..3.594 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
521. 0.624 140.049 ↓ 0.0 0 39

BitmapOr (cost=46.78..46.78 rows=1,950 width=0) (actual time=3.591..3.591 rows=0 loops=39)

522. 121.329 121.329 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanbernardino_county_to_tsvector_idx2 (cost=0.00..33.18 rows=975 width=0) (actual time=3.111..3.111 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
523. 18.096 18.096 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanbernardino_county_to_tsvector_idx3 (cost=0.00..12.63 rows=975 width=0) (actual time=0.464..0.464 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
524. 0.078 354.159 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sandiego_ca ct_105 (cost=88.55..2,042.45 rows=1,433 width=654) (actual time=9.081..9.081 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
525. 0.858 354.081 ↓ 0.0 0 39

BitmapOr (cost=88.55..88.55 rows=1,477 width=0) (actual time=9.079..9.079 rows=0 loops=39)

526. 183.729 183.729 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sandiego_ca_to_tsvector_idx2 (cost=0.00..45.72 rows=738 width=0) (actual time=4.711..4.711 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
527. 169.494 169.494 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sandiego_ca_to_tsvector_idx3 (cost=0.00..42.11 rows=738 width=0) (actual time=4.346..4.346 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
528. 0.078 1.053 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sandiego_county ct_106 (cost=1.08..3.23 rows=1 width=776) (actual time=0.027..0.027 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
529. 0.663 0.975 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=39)

530. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sandiego_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
531. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sandiego_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
532. 0.117 648.297 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanfrancisco ct_107 (cost=157.57..4,104.42 rows=2,775 width=637) (actual time=16.623..16.623 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
533. 0.468 648.180 ↓ 0.0 0 39

BitmapOr (cost=157.57..157.57 rows=2,982 width=0) (actual time=16.620..16.620 rows=0 loops=39)

534. 7.839 7.839 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanfrancisco_to_tsvector_idx2 (cost=0.00..15.68 rows=1,491 width=0) (actual time=0.201..0.201 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
535. 639.873 639.873 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanfrancisco_to_tsvector_idx3 (cost=0.00..140.50 rows=1,491 width=0) (actual time=16.407..16.407 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
536. 0.117 237.471 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanfrancisco_ca ct_108 (cost=68.28..2,546.43 rows=1,708 width=644) (actual time=6.089..6.089 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
537. 1.053 237.354 ↓ 0.0 0 39

BitmapOr (cost=68.28..68.28 rows=1,840 width=0) (actual time=6.086..6.086 rows=0 loops=39)

538. 93.834 93.834 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanfrancisco_ca_to_tsvector_idx2 (cost=0.00..29.64 rows=920 width=0) (actual time=2.406..2.406 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
539. 142.467 142.467 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanfrancisco_ca_to_tsvector_idx3 (cost=0.00..37.79 rows=920 width=0) (actual time=3.653..3.653 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
540. 0.078 2.028 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanfrancisco_el ct_109 (cost=32.45..4,269.92 rows=3,056 width=572) (actual time=0.052..0.052 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
541. 0.624 1.950 ↓ 0.0 0 39

BitmapOr (cost=32.45..32.45 rows=3,224 width=0) (actual time=0.050..0.050 rows=0 loops=39)

542. 0.702 0.702 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanfrancisco_el_to_tsvector_idx2 (cost=0.00..15.56 rows=1,612 width=0) (actual time=0.018..0.018 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
543. 0.624 0.624 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanfrancisco_el_to_tsvector_idx3 (cost=0.00..15.36 rows=1,612 width=0) (actual time=0.016..0.016 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
544. 0.078 22.854 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanjoaquin_county ct_110 (cost=6.51..59.12 rows=38 width=651) (actual time=0.586..0.586 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
545. 0.468 22.776 ↓ 0.0 0 39

BitmapOr (cost=6.51..6.51 rows=39 width=0) (actual time=0.584..0.584 rows=0 loops=39)

546. 13.026 13.026 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanjoaquin_county_to_tsvector_idx2 (cost=0.00..3.57 rows=20 width=0) (actual time=0.334..0.334 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
547. 9.282 9.282 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanjoaquin_county_to_tsvector_idx3 (cost=0.00..2.92 rows=20 width=0) (actual time=0.238..0.238 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
548. 0.039 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanjose_ca ct_111 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
549. 0.468 0.819 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=39)

550. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanjose_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
551. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanjose_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
552. 0.078 159.627 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanluis_obispo_county ct_112 (cost=33.12..215.08 rows=133 width=646) (actual time=4.093..4.093 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
553. 0.624 159.549 ↓ 0.0 0 39

BitmapOr (cost=33.12..33.12 rows=136 width=0) (actual time=4.091..4.091 rows=0 loops=39)

554. 84.864 84.864 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanluis_obispo_county_to_tsvector_idx2 (cost=0.00..17.79 rows=68 width=0) (actual time=2.176..2.176 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
555. 74.061 74.061 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanluis_obispo_county_to_tsvector_idx3 (cost=0.00..15.27 rows=68 width=0) (actual time=1.899..1.899 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
556. 0.078 1.014 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanmateo_ca ct_113 (cost=1.08..3.23 rows=1 width=776) (actual time=0.026..0.026 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
557. 0.585 0.936 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=39)

558. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanmateo_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
559. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanmateo_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
560. 0.078 44.226 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sanmateo_county ct_114 (cost=10.60..54.84 rows=31 width=694) (actual time=1.134..1.134 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
561. 0.546 44.148 ↓ 0.0 0 39

BitmapOr (cost=10.60..10.60 rows=32 width=0) (actual time=1.132..1.132 rows=0 loops=39)

562. 24.531 24.531 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanmateo_county_to_tsvector_idx2 (cost=0.00..5.74 rows=16 width=0) (actual time=0.629..0.629 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
563. 19.071 19.071 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sanmateo_county_to_tsvector_idx3 (cost=0.00..4.84 rows=16 width=0) (actual time=0.489..0.489 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
564. 0.078 1.287 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santaana_ca ct_115 (cost=2.45..114.13 rows=79 width=684) (actual time=0.033..0.033 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
565. 0.468 1.209 ↓ 0.0 0 39

BitmapOr (cost=2.45..2.45 rows=81 width=0) (actual time=0.031..0.031 rows=0 loops=39)

566. 0.390 0.390 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaana_ca_to_tsvector_idx2 (cost=0.00..1.23 rows=40 width=0) (actual time=0.010..0.010 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
567. 0.351 0.351 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaana_ca_to_tsvector_idx3 (cost=0.00..1.18 rows=40 width=0) (actual time=0.009..0.009 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
568. 0.078 29.055 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santabarbara_ca ct_116 (cost=8.22..149.07 rows=103 width=650) (actual time=0.745..0.745 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
569. 0.507 28.977 ↓ 0.0 0 39

BitmapOr (cost=8.22..8.22 rows=106 width=0) (actual time=0.743..0.743 rows=0 loops=39)

570. 15.444 15.444 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santabarbara_ca_to_tsvector_idx2 (cost=0.00..4.27 rows=53 width=0) (actual time=0.396..0.396 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
571. 13.026 13.026 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santabarbara_ca_to_tsvector_idx3 (cost=0.00..3.90 rows=53 width=0) (actual time=0.334..0.334 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
572. 0.078 0.936 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santabarbara_county ct_117 (cost=1.08..3.23 rows=1 width=776) (actual time=0.024..0.024 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
573. 0.546 0.858 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=39)

574. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santabarbara_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
575. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santabarbara_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
576. 0.078 7.410 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santaclara_ca ct_118 (cost=2.14..10.56 rows=6 width=684) (actual time=0.190..0.190 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
577. 0.468 7.332 ↓ 0.0 0 39

BitmapOr (cost=2.14..2.14 rows=6 width=0) (actual time=0.188..0.188 rows=0 loops=39)

578. 3.861 3.861 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaclara_ca_to_tsvector_idx2 (cost=0.00..0.95 rows=3 width=0) (actual time=0.099..0.099 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
579. 3.003 3.003 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaclara_ca_to_tsvector_idx3 (cost=0.00..1.19 rows=3 width=0) (actual time=0.077..0.077 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
580. 0.117 416.208 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santaclara_county ct_119 (cost=97.80..1,371.70 rows=934 width=654) (actual time=10.672..10.672 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
581. 0.702 416.091 ↓ 0.0 0 39

BitmapOr (cost=97.80..97.80 rows=951 width=0) (actual time=10.669..10.669 rows=0 loops=39)

582. 236.769 236.769 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaclara_county_to_tsvector_idx2 (cost=0.00..54.18 rows=476 width=0) (actual time=6.071..6.071 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
583. 178.620 178.620 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaclara_county_to_tsvector_idx3 (cost=0.00..43.16 rows=476 width=0) (actual time=4.580..4.580 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
584. 0.078 1.131 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santaclarita_ca ct_120 (cost=1.08..3.23 rows=1 width=776) (actual time=0.029..0.029 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
585. 0.663 1.053 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=39)

586. 0.234 0.234 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaclarita_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
587. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santaclarita_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
588. 0.117 15.795 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santacruz_county ct_121 (cost=4.56..25.63 rows=14 width=683) (actual time=0.405..0.405 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
589. 0.468 15.678 ↓ 0.0 0 39

BitmapOr (cost=4.56..4.56 rows=15 width=0) (actual time=0.402..0.402 rows=0 loops=39)

590. 8.229 8.229 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santacruz_county_to_tsvector_idx2 (cost=0.00..2.49 rows=7 width=0) (actual time=0.211..0.211 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
591. 6.981 6.981 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santacruz_county_to_tsvector_idx3 (cost=0.00..2.06 rows=7 width=0) (actual time=0.179..0.179 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
592. 0.078 175.500 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santamonica_ca ct_122 (cost=38.81..450.69 rows=303 width=664) (actual time=4.500..4.500 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
593. 0.624 175.422 ↓ 0.0 0 39

BitmapOr (cost=38.81..38.81 rows=312 width=0) (actual time=4.498..4.498 rows=0 loops=39)

594. 89.193 89.193 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santamonica_ca_to_tsvector_idx2 (cost=0.00..20.52 rows=156 width=0) (actual time=2.287..2.287 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
595. 85.605 85.605 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santamonica_ca_to_tsvector_idx3 (cost=0.00..18.14 rows=156 width=0) (actual time=2.195..2.195 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
596. 0.078 25.779 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_santarosa_ca ct_123 (cost=7.07..53.39 rows=33 width=729) (actual time=0.661..0.661 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
597. 0.663 25.701 ↓ 0.0 0 39

BitmapOr (cost=7.07..7.07 rows=34 width=0) (actual time=0.659..0.659 rows=0 loops=39)

598. 14.937 14.937 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santarosa_ca_to_tsvector_idx2 (cost=0.00..3.91 rows=17 width=0) (actual time=0.383..0.383 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
599. 10.101 10.101 ↓ 0.0 0 39

Bitmap Index Scan on contributions_santarosa_ca_to_tsvector_idx3 (cost=0.00..3.14 rows=17 width=0) (actual time=0.259..0.259 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
600. 0.039 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_shafter_ca ct_124 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
601. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

602. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_shafter_ca_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
603. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_shafter_ca_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
604. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_shasta_county ct_125 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
605. 0.390 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

606. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_shasta_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
607. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_shasta_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
608. 0.039 0.780 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_solano_county ct_126 (cost=1.08..3.23 rows=1 width=776) (actual time=0.020..0.020 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
609. 0.429 0.741 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=39)

610. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_solano_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
611. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_solano_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
612. 0.039 0.780 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_south_carolina ct_127 (cost=1.08..3.23 rows=1 width=776) (actual time=0.020..0.020 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
613. 0.429 0.741 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=39)

614. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_carolina_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
615. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_carolina_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
616. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_south_carolina2 ct_128 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
617. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

618. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_carolina2_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
619. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_carolina2_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
620. 0.039 0.819 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_south_dakota2 ct_129 (cost=1.08..3.23 rows=1 width=776) (actual time=0.021..0.021 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
621. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

622. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_dakota2_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
623. 0.117 0.117 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_dakota2_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
624. 0.195 27.261 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_south_dakota_pdf ct_130 (cost=8.81..10.95 rows=1 width=534) (actual time=0.699..0.699 rows=0 loops=39)

  • Recheck Cond: (((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text)) AND ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))))
625. 0.117 27.066 ↓ 0.0 0 39

BitmapAnd (cost=8.81..8.81 rows=1 width=0) (actual time=0.694..0.694 rows=0 loops=39)

626. 0.000 0.741 ↓ 0.0 0 39

BitmapOr (cost=3.00..3.00 rows=30 width=0) (actual time=0.019..0.019 rows=0 loops=39)

627. 0.507 0.507 ↓ 2.0 59 39

Bitmap Index Scan on contributions_south_dakota_pdf_lower_idx (cost=0.00..1.60 rows=29 width=0) (actual time=0.013..0.013 rows=59 loops=39)

  • Index Cond: (lower(contributor_state) IS NULL)
628. 0.234 0.234 ↓ 2.0 2 39

Bitmap Index Scan on contributions_south_dakota_pdf_lower_idx1 (cost=0.00..1.39 rows=1 width=0) (actual time=0.006..0.006 rows=2 loops=39)

  • Index Cond: (lower(contributor_state) = 'ca'::text)
629. 0.546 26.208 ↓ 0.0 0 39

BitmapOr (cost=5.56..5.56 rows=14 width=0) (actual time=0.672..0.672 rows=0 loops=39)

630. 13.455 13.455 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_dakota_pdf_to_tsvector_idx2 (cost=0.00..2.77 rows=7 width=0) (actual time=0.345..0.345 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
631. 12.207 12.207 ↓ 0.0 0 39

Bitmap Index Scan on contributions_south_dakota_pdf_to_tsvector_idx3 (cost=0.00..2.79 rows=7 width=0) (actual time=0.313..0.313 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
632. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_stanislaus_county ct_131 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
633. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

634. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_stanislaus_county_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
635. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_stanislaus_county_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
636. 0.078 16.965 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_stockton_ca ct_132 (cost=5.25..45.26 rows=27 width=702) (actual time=0.435..0.435 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
637. 0.468 16.887 ↓ 0.0 0 39

BitmapOr (cost=5.25..5.25 rows=29 width=0) (actual time=0.433..0.433 rows=0 loops=39)

638. 9.984 9.984 ↓ 0.0 0 39

Bitmap Index Scan on contributions_stockton_ca_to_tsvector_idx2 (cost=0.00..3.15 rows=14 width=0) (actual time=0.256..0.256 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
639. 6.435 6.435 ↓ 0.0 0 39

Bitmap Index Scan on contributions_stockton_ca_to_tsvector_idx3 (cost=0.00..2.08 rows=14 width=0) (actual time=0.165..0.165 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
640. 0.039 14.664 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_sunnyvale_ca ct_133 (cost=3.45..30.80 rows=19 width=642) (actual time=0.376..0.376 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
641. 0.507 14.625 ↓ 0.0 0 39

BitmapOr (cost=3.45..3.45 rows=20 width=0) (actual time=0.375..0.375 rows=0 loops=39)

642. 7.956 7.956 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sunnyvale_ca_to_tsvector_idx2 (cost=0.00..1.75 rows=10 width=0) (actual time=0.204..0.204 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
643. 6.162 6.162 ↓ 0.0 0 39

Bitmap Index Scan on contributions_sunnyvale_ca_to_tsvector_idx3 (cost=0.00..1.69 rows=10 width=0) (actual time=0.158..0.158 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
644. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_tennessee ct_134 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
645. 0.468 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

646. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_tennessee_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
647. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_tennessee_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
648. 0.078 0.858 ↓ 0.0 0 39

Bitmap Heap Scan on contributions_texas ct_135 (cost=1.08..3.23 rows=1 width=776) (actual time=0.022..0.022 rows=0 loops=39)

  • Recheck Cond: ((to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))) OR (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text))))
  • Filter: ((lower(contributor_state) IS NULL) OR (lower(contributor_state) = 'ca'::text))
649. 0.429 0.780 ↓ 0.0 0 39

BitmapOr (cost=1.08..1.08 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=39)

650. 0.195 0.195 ↓ 0.0 0 39

Bitmap Index Scan on contributions_texas_to_tsvector_idx2 (cost=0.00..0.54 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(contributor_full_name)) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
651. 0.156 0.156 ↓ 0.0 0 39

Bitmap Index Scan on contributions_texas_to_tsvector_idx3 (cost=0.00..0.54 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=39)

  • Index Cond: (to_tsvector('english'::regconfig, lower(((contributor_first_name || ' '::text) || contributor_last_name))) @@ plainto_tsquery('english'::regconfig, ((n.name2 || ' '::text) || 'Birnbaum'::text)))
652. 0.156 175.03