explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YRh5 : un14

Settings
# exclusive inclusive rows x rows loops node
1. 791.225 96,998.550 ↑ 16.6 39,557 1

Nested Loop Left Join (cost=4,947,650.27..378,974,279.41 rows=656,249 width=1,892) (actual time=54,505.890..96,998.550 rows=39,557 loops=1)

2. 57.799 69,981.034 ↑ 16.6 39,557 1

Hash Left Join (cost=4,947,649.71..285,864,299.32 rows=656,249 width=1,668) (actual time=54,503.214..69,981.034 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (property_to_permit_persisted_1.geoid)::text) AND (lpj.internal_property_id = property_to_permit_persisted_1.internal_property_id))
3. 62.167 69,914.658 ↑ 16.6 39,557 1

Hash Left Join (cost=4,928,556.48..285,807,378.23 rows=656,249 width=1,659) (actual time=54,494.596..69,914.658 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (property_to_permit_persisted.geoid)::text) AND (lpj.internal_property_id = property_to_permit_persisted.internal_property_id))
4. 55.238 69,832.220 ↑ 16.6 39,557 1

Nested Loop Left Join (cost=4,890,843.33..285,731,427.36 rows=656,249 width=1,634) (actual time=54,474.192..69,832.220 rows=39,557 loops=1)

5. 92.715 68,590.272 ↑ 16.6 39,557 1

Nested Loop Left Join (cost=4,890,842.91..284,357,376.87 rows=656,249 width=1,529) (actual time=54,474.167..68,590.272 rows=39,557 loops=1)

6. 95.966 66,796.606 ↑ 16.6 39,557 1

Nested Loop (cost=4,890,842.35..283,163,011.70 rows=656,249 width=1,513) (actual time=54,473.296..66,796.606 rows=39,557 loops=1)

  • Join Filter: (lpj.internal_listing_id = listing.internal_listing_id)
7. 71.577 66,107.285 ↑ 16.6 39,557 1

Nested Loop (cost=4,890,841.79..281,941,045.40 rows=656,249 width=1,379) (actual time=54,473.267..66,107.285 rows=39,557 loops=1)

  • Join Filter: (lpj.internal_listing_id = level1_listing.internal_listing_id)
8. 2,972.863 65,402.796 ↑ 16.6 39,557 1

Hash Left Join (cost=4,890,841.23..280,734,698.57 rows=656,249 width=1,218) (actual time=54,473.213..65,402.796 rows=39,557 loops=1)

  • Hash Cond: ((property.assessor_source = (assessor_master.source)::text) AND ((property.parcel_number)::text = (assessor_master.parcel_number)::text))
9. 63.826 33,238.555 ↑ 16.6 39,557 1

Nested Loop (cost=1,869,210.01..274,595,332.46 rows=656,249 width=202) (actual time=25,281.755..33,238.555 rows=39,557 loops=1)

  • Join Filter: (lpj.internal_property_id = property.internal_property_id)
10. 144.004 32,660.488 ↑ 16.6 39,557 1

Hash Join (cost=1,869,209.45..273,393,751.92 rows=656,249 width=158) (actual time=25,281.723..32,660.488 rows=39,557 loops=1)

  • Hash Cond: (CASE WHEN (((lpj.geoid)::text = ANY ('{16000US0611250,16000US0650258}'::text[])) AND ("left"(lpj.internal_listing_id, 3) = 'bkg'::text) AND l1.internal_is_active AND ((SubPlan 6) IS NULL)) THEN 15 WHEN (((lpj.geoid)::text = ANY ('{16000US0645246,05000US36027,05000US06057u,05000US37063,05000US06109u,16000US0677000}'::text[])) AND ("left"(lpj.internal_listing_id, 3) = 'air'::text)) THEN 14 WHEN (((lpj.geoid)::text = '16000US0636294'::text) AND (NOT CASE WHEN (NOT plp.meets_str_definition) THEN false WHEN ((count(*)) > 0) THEN false WHEN (((lpj.geoid)::text = '16000US4123850'::text) AND ((l1.internal_site_id)::text = 'air'::text)) THEN false WHEN (((lpj.geoid)::text = '99999US01'::text) AND (COALESCE(pt.internal_property_category, 'SF'::text) <> 'SF'::text)) THEN false ELSE (COALESCE(l.listing_min_nights, 1) < COALESCE(jsp.min_nights_less_than, 30)) END) AND (COALESCE(pp.permit_type, pp3.permit_type) ~~ '%business_license%'::text)) THEN 1 WHEN (((lpj.geoid)::text = '16000US0636294'::text) AND (NOT CASE WHEN (NOT plp.meets_str_definition) THEN false WHEN ((count(*)) > 0) THEN false WHEN (((lpj.geoid)::text = '16000US4123850'::text) AND ((l1.internal_site_id)::text = 'air'::text)) THEN false WHEN (((lpj.geoid)::text = '99999US01'::text) AND (COALESCE(pt.internal_property_category, 'SF'::text) <> 'SF'::text)) THEN false ELSE (COALESCE(l.listing_min_nights, 1) < COALESCE(jsp.min_nights_less_than, 30)) END) AND ((COALESCE(pp.permit_type, pp3.permit_type) IS NULL) OR (COALESCE(pp.permit_type, pp3.permit_type) !~~ '%business_license%'::text))) THEN 5 WHEN (NOT l1.internal_is_active) THEN 2 WHEN (NOT CASE WHEN (NOT plp.meets_str_definition) THEN false WHEN ((count(*)) > 0) THEN false WHEN (((lpj.geoid)::text = '16000US4123850'::text) AND ((l1.internal_site_id)::text = 'air'::text)) THEN false WHEN (((lpj.geoid)::text = '99999US01'::text) AND (COALESCE(pt.internal_property_category, 'SF'::text) <> 'SF'::text)) THEN false ELSE (COALESCE(l.listing_min_nights, 1) < COALESCE(jsp.min_nights_less_than, 30)) END) THEN 3 WHEN (((lpj.geoid)::text = '99999US05'::text) AND (COALESCE(l.listing_room_type, 'Entire home/apt'::text) <> 'Entire home/apt'::text) AND (pp.internal_property_id IS NULL) AND (pp3.internal_property_id IS NULL) AND (placercounty_registrations.parcel_number IS NULL)) THEN 6 WHEN (((lpj.geoid)::text = '16000US1253000'::text) AND (a.vacation_rental_district IS NOT NULL) AND ((a.vacation_rental_district)::text = ANY ('{R-1,R-1A,R-1AA,R-2A,R-2B,R-3A,R-3B,R-3C,R-3D,MXD-1}'::text[])) AND (COALESCE(l.listing_room_type, 'Entire home/apt'::text) = 'Entire home/apt'::text)) THEN 8 WHEN (((lpj.geoid)::text = '99999US38'::text) AND (a.vacation_rental_district IS NOT NULL) AND ((a.vacation_rental_district)::text = 'TRU Overlay Zone'::text) AND (pp.internal_property_id IS NULL) AND (pp3.internal_property_id IS NULL) AND (placercounty_registrations.parcel_number IS NULL) AND (COALESCE(l.listing_room_type, 'Entire home/apt'::text) = 'Entire home/apt'::text)) THEN 8 WHEN ((lpj.geoid)::text = '16000US0651182'::text) THEN CASE WHEN ((COALESCE(pp.permit_type, pp3.permit_type) ~~ '%str_permit%'::text) AND (COALESCE(pp.permit_type, pp3.permit_type) ~~ '%business_license%'::text)) THEN 1 ELSE 5 END WHEN (((lpj.geoid)::text = '16000US0636294'::text) AND ((a.str_policy)::text = 'allowed'::text)) THEN 1 WHEN (((lpj.geoid)::text = '16000US0636294'::text) AND (a.str_policy IS NULL) AND (COALESCE(pp.permit_type, pp3.permit_type) ~~ '%tax_registration%'::text)) THEN 1 WHEN (((lpj.geoid)::text = ANY ('{16000US4752006,05000US47037}'::text[])) AND ((a.str_policy)::text ~~ '%(GSD)'::text) AND (COALESCE(pp.permit_type, pp3.permit_type) ~~ '%tax_registration%'::text)) THEN 1 WHEN (((lpj.geoid)::text = ANY ('{16000US4752006,05000US47037}'::text[])) AND ((a.str_policy)::text !~~ '%(GSD)'::text) AND (COALESCE(pp.permit_type, pp3.permit_type) ~~ '%tax_registration%'::text) AND (COALESCE(pp.permit_type, pp3.permit_type) ~~ '%str_permit%'::text)) THEN 1 WHEN (((lpj.geoid)::text = '99999US73'::text) AND (COALESCE(l.listing_room_type, 'Entire home/apt'::text) = ANY ('{"Shared room","Private room"}'::text[]))) THEN 17 WHEN (((lpj.geoid)::text = ANY ('{16000US0666000,99999US73}'::text[])) AND COALESCE((pp.is_pending OR (pp3.is_pending AND (NOT COALESCE(jsp.requires_exact_registration_match, false))) OR ((pp.internal_property_id IS NULL) AND (jsp.requires_exact_registration_match OR (pp3.internal_property_id IS NULL)) AND (alternatives: SubPlan 7 or hashed SubPlan 8))), false)) THEN 16 WHEN (CASE WHEN COALESCE(jsp.requires_exact_registration_match, false) THEN ((pp.internal_property_id IS NOT NULL) OR (placercounty_registrations.parcel_number IS NOT NULL)) ELSE ((pp.internal_property_id IS NOT NULL) OR (pp3.internal_property_id IS NOT NULL) OR (placercounty_registrations.parcel_number IS NOT NULL)) END AND ((lpj.geoid)::text <> ALL ('{16000US4752006,05000US47037,16000US0636294}'::text[]))) THEN 1 WHEN COALESCE(jsp.full_ban, false) THEN 7 WHEN ((a.str_policy)::text ~~ '%disallowed%'::text) THEN 8 WHEN (COALESCE(jsp.requires_registration, true) AND (a.parcel_number IS NOT NULL) AND (pr.geoid IS NOT NULL)) THEN 5 WHEN (((lpj.geoid)::text = ANY ('{16000US4752006,05000US47037}'::text[])) AND ((a.str_policy)::text !~~ '%(GSD)'::text) AND (COALESCE(pp.permit_type, pp3.permit_type) !~~ '%str_permit%'::text)) THEN 5 WHEN (((lpj.geoid)::text = '16000US0636294'::text) AND (a.str_policy IS NULL) AND (COALESCE(pp.permit_type, pp3.permit_type) !~~ '%tax_registration%'::text)) THEN 9 WHEN (COALESCE(jsp.requires_registration, true) AND (a.parcel_number IS NULL)) THEN 10 WHEN (COALESCE(jsp.requires_registration, true) AND (NOT (alternatives: SubPlan 9 or hashed SubPlan 10))) THEN 11 WHEN (COALESCE(jsp.use_str_policy, false) AND (a.parcel_number IS NULL)) THEN 12 WHEN (COALESCE(jsp.use_str_policy, false) AND (a.str_policy IS NULL)) THEN 13 ELSE 4 END = compliance_status.id)
11. 33.043 32,516.458 ↑ 195.2 39,557 1

Hash Left Join (cost=1,869,208.07..2,972,658.72 rows=7,720,580 width=444) (actual time=25,281.621..32,516.458 rows=39,557 loops=1)

  • Hash Cond: ((lpj.geoid)::text = (pr.geoid)::text)
12. 28.572 32,475.666 ↑ 9.8 39,557 1

Hash Left Join (cost=1,868,204.03..2,893,001.27 rows=386,029 width=431) (actual time=25,273.851..32,475.666 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (plp.geoid)::text) AND ((p.parcel_number)::text = plp.parcel_number))
13. 27.823 32,446.406 ↑ 9.8 39,557 1

Hash Left Join (cost=1,868,174.70..2,890,073.56 rows=386,029 width=442) (actual time=25,273.152..32,446.406 rows=39,557 loops=1)

  • Hash Cond: ((p.parcel_number)::text = placercounty_registrations.parcel_number)
  • Join Filter: (((lpj.geoid)::text = '05000US06061u'::text) AND (p.assessor_source = 'placer_county_ca'::text))
14. 27.648 32,417.822 ↑ 9.8 39,557 1

Hash Left Join (cost=1,868,129.19..2,888,477.36 rows=386,029 width=445) (actual time=25,272.377..32,417.822 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (excluded_property.geoid)::text) AND ((p.parcel_number)::text = excluded_property.parcel_number))
15. 31.789 32,390.161 ↑ 9.8 39,557 1

Hash Left Join (cost=1,868,126.79..2,885,579.61 rows=386,029 width=437) (actual time=25,272.347..32,390.161 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (pp4.geoid)::text) AND (lpj.internal_property_id = pp4.internal_property_id))
16. 31.246 32,352.319 ↑ 9.8 39,557 1

Hash Left Join (cost=1,854,945.85..2,850,191.89 rows=386,029 width=437) (actual time=25,266.278..32,352.319 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (pp3.geoid)::text) AND (lpj.internal_property_id = pp3.internal_property_id))
17. 36.010 32,315.191 ↑ 9.8 39,557 1

Hash Left Join (cost=1,835,962.69..2,808,957.60 rows=386,029 width=407) (actual time=25,260.359..32,315.191 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (pp2.geoid)::text) AND (lpj.internal_property_id = pp2.internal_property_id))
18. 40.751 32,264.040 ↑ 9.8 39,557 1

Hash Left Join (cost=1,821,158.86..2,771,902.07 rows=386,029 width=407) (actual time=25,245.183..32,264.040 rows=39,557 loops=1)

  • Hash Cond: (((l.internal_site_id)::text = pt.internal_site_id) AND (l.listing_property_type = pt.listing_property_type))
19. 38.069 32,222.943 ↑ 1.2 39,557 1

Hash Left Join (cost=1,820,969.98..2,761,356.96 rows=49,026 width=417) (actual time=25,244.780..32,222.943 rows=39,557 loops=1)

  • Hash Cond: (((lpj.geoid)::text = (pp.geoid)::text) AND (lpj.internal_property_id = pp.internal_property_id))
20. 35.298 32,076.827 ↑ 1.2 39,557 1

Hash Left Join (cost=1,783,256.83..2,720,787.21 rows=49,026 width=387) (actual time=25,136.607..32,076.827 rows=39,557 loops=1)

  • Hash Cond: ((lpj.geoid)::text = (jsp.geoid)::text)
21. 72.610 32,041.502 ↑ 1.2 39,557 1

Nested Loop (cost=1,783,254.46..2,720,110.73 rows=49,026 width=379) (actual time=25,136.562..32,041.502 rows=39,557 loops=1)

  • Join Filter: (lpj.internal_listing_id = l1.internal_listing_id)
22. 62.539 31,335.980 ↑ 1.2 39,557 1

Nested Loop (cost=1,783,253.90..2,629,835.06 rows=49,026 width=361) (actual time=25,136.523..31,335.980 rows=39,557 loops=1)

23. 1,326.852 30,470.001 ↑ 1.2 40,172 1

Hash Left Join (cost=1,783,253.34..2,503,463.38 rows=49,026 width=316) (actual time=25,136.493..30,470.001 rows=40,172 loops=1)

  • Hash Cond: (((p.parcel_number)::text = (a.parcel_number)::text) AND (p.assessor_source = (a.source)::text))
24. 59.863 4,009.064 ↑ 1.2 40,172 1

Nested Loop (cost=1.12..176,142.52 rows=49,026 width=82) (actual time=2.212..4,009.064 rows=40,172 loops=1)

25. 3,185.933 3,185.933 ↑ 1.2 40,172 1

Index Scan using listing_property_jurisdiction_persisted_pkey on listing_property_jurisdiction_persisted lpj (cost=0.56..51,481.34 rows=49,026 width=40) (actual time=2.181..3,185.933 rows=40,172 loops=1)

  • Index Cond: ((geoid)::text = '99999US09'::text)
26. 763.268 763.268 ↑ 1.0 1 40,172

Index Scan using property_pkey on property p (cost=0.56..2.53 rows=1 width=42) (actual time=0.018..0.019 rows=1 loops=40,172)

  • Index Cond: (internal_property_id = lpj.internal_property_id)
27. 6,516.435 25,134.085 ↑ 1.0 12,683,380 1

Hash (cost=1,153,304.88..1,153,304.88 rows=12,809,089 width=251) (actual time=25,134.085..25,134.085 rows=12,683,380 loops=1)

  • Buckets: 65536 Batches: 256 Memory Usage: 3522kB
28. 4,792.295 18,617.650 ↑ 1.0 12,683,383 1

Append (cost=0.00..1,153,304.88 rows=12,809,089 width=251) (actual time=0.014..18,617.650 rows=12,683,383 loops=1)

29. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on assessor_master a (cost=0.00..0.00 rows=1 width=890) (actual time=0.000..0.000 rows=0 loops=1)

30. 24.946 24.946 ↑ 1.0 28,880 1

Seq Scan on assessor_alameda_county_ca_2140fc0a90d54c01 a_1 (cost=0.00..1,774.80 rows=28,880 width=323) (actual time=0.013..24.946 rows=28,880 loops=1)

31. 63.244 63.244 ↑ 1.0 69,325 1

Seq Scan on assessor_arlington_county_va_3262dfdd743a4445 a_2 (cost=0.00..4,658.25 rows=69,325 width=179) (actual time=0.011..63.244 rows=69,325 loops=1)

32. 275.684 275.684 ↑ 1.0 352,327 1

Seq Scan on assessor_arlington_tx_19f9d48f80174876 a_3 (cost=0.00..19,054.27 rows=352,327 width=314) (actual time=0.011..275.684 rows=352,327 loops=1)

33. 4.825 4.825 ↑ 1.0 5,268 1

Seq Scan on assessor_beaufort_sc_fc802e02137b44fa a_4 (cost=0.00..359.68 rows=5,268 width=43) (actual time=0.014..4.825 rows=5,268 loops=1)

34. 36.950 36.950 ↑ 1.0 45,561 1

Seq Scan on assessor_buena_park_ca_aa42f34398dd474a a_5 (cost=0.00..2,685.61 rows=45,561 width=314) (actual time=0.009..36.950 rows=45,561 loops=1)

35. 3.530 3.530 ↑ 1.0 4,182 1

Seq Scan on assessor_casco_mi_5113ae42336e427d a_6 (cost=0.00..257.82 rows=4,182 width=173) (actual time=0.012..3.530 rows=4,182 loops=1)

36. 21.056 21.056 ↑ 1.0 25,061 1

Seq Scan on assessor_contra_costa_county_ca_3c0ba605a1ef405b a_7 (cost=0.00..1,539.61 rows=25,061 width=324) (actual time=0.011..21.056 rows=25,061 loops=1)

37. 11.290 11.290 ↑ 1.0 12,699 1

Seq Scan on assessor_coppell_tx_6782d465eae9445d a_8 (cost=0.00..842.99 rows=12,699 width=320) (actual time=0.009..11.290 rows=12,699 loops=1)

38. 19.984 19.984 ↑ 1.0 23,540 1

Seq Scan on assessor_dana_point_ca_d39664795202410f a_9 (cost=0.00..1,459.40 rows=23,540 width=315) (actual time=0.010..19.984 rows=23,540 loops=1)

39. 109.282 109.282 ↑ 1.0 109,900 1

Seq Scan on assessor_durham_county_nc_aa6110175fac41ec a_10 (cost=0.00..6,733.10 rows=111,710 width=316) (actual time=0.010..109.282 rows=109,900 loops=1)

40. 97.469 97.469 ↑ 1.0 110,788 1

Seq Scan on assessor_dutchess_county_ny_a3c286fd2d7644b1 a_11 (cost=0.00..7,318.88 rows=110,788 width=334) (actual time=0.011..97.469 rows=110,788 loops=1)

41. 52.449 52.449 ↑ 1.0 39,638 1

Seq Scan on assessor_eagle_county_co_58b9e20bd0f4414b a_12 (cost=0.00..5,037.38 rows=39,638 width=184) (actual time=0.007..52.449 rows=39,638 loops=1)

42. 2.600 2.600 ↑ 1.0 2,825 1

Seq Scan on assessor_el_paso_county_co_51247c7b1bfb477d a_13 (cost=0.00..202.25 rows=2,825 width=321) (actual time=0.010..2.600 rows=2,825 loops=1)

43. 315.798 315.798 ↑ 1.0 346,693 1

Seq Scan on assessor_fairfax_county_va_bc2c864d9db4492b a_14 (cost=0.00..23,272.93 rows=346,693 width=321) (actual time=0.011..315.798 rows=346,693 loops=1)

44. 24.187 24.187 ↑ 1.0 27,315 1

Seq Scan on assessor_flathead_county_mt_ff793f07bbde4c61 a_15 (cost=0.00..1,770.15 rows=27,315 width=319) (actual time=0.011..24.187 rows=27,315 loops=1)

45. 0.044 0.044 ↑ 1.0 37 1

Seq Scan on assessor_glynn_county_ga_15730844c7b641ea a_16 (cost=0.00..3.37 rows=37 width=316) (actual time=0.010..0.044 rows=37 loops=1)

46. 23.499 23.499 ↑ 1.0 27,502 1

Seq Scan on assessor_grapevine_tx_ba7f7ab9c9294c97 a_17 (cost=0.00..1,721.02 rows=27,502 width=314) (actual time=0.010..23.499 rows=27,502 loops=1)

47. 12.275 12.275 ↑ 1.0 13,497 1

Seq Scan on assessor_holland_mi_ea53583e81014141 a_18 (cost=0.00..904.97 rows=13,497 width=316) (actual time=0.011..12.275 rows=13,497 loops=1)

48. 124.294 124.294 ↑ 1.0 170,270 1

Seq Scan on assessor_honolulu_county_hi_a3e1407380c0451b a_19 (cost=0.00..8,331.70 rows=170,270 width=319) (actual time=0.011..124.294 rows=170,270 loops=1)

49. 4.218 4.218 ↑ 1.0 4,291 1

Seq Scan on assessor_indian_harbour_beach_fl_132d04726c164566 a_20 (cost=0.00..330.91 rows=4,291 width=324) (actual time=0.010..4.218 rows=4,291 loops=1)

50. 91.857 91.857 ↑ 1.0 90,597 1

Seq Scan on assessor_indian_river_county_fl_5cd05d8e82144ac2 a_21 (cost=0.00..6,513.97 rows=90,597 width=337) (actual time=0.011..91.857 rows=90,597 loops=1)

51. 60.260 60.260 ↑ 1.0 71,550 1

Seq Scan on assessor_knoxville_tn_4051c459fd784e31 a_22 (cost=0.00..4,447.50 rows=71,550 width=34) (actual time=0.010..60.260 rows=71,550 loops=1)

52. 9.459 9.459 ↑ 1.0 10,419 1

Seq Scan on assessor_lake_bluff_il_fe7c7f48d18e486b a_23 (cost=0.00..717.19 rows=10,419 width=317) (actual time=0.012..9.459 rows=10,419 loops=1)

53. 86.255 86.255 ↑ 1.0 105,844 1

Seq Scan on assessor_lane_county_or_fbfe09929d584acd a_24 (cost=0.00..6,049.08 rows=105,908 width=315) (actual time=0.010..86.255 rows=105,844 loops=1)

54. 21.380 21.380 ↑ 1.0 26,200 1

Seq Scan on assessor_la_plata_county_co_161e0885636e4666 a_25 (cost=0.00..1,488.43 rows=26,243 width=323) (actual time=0.010..21.380 rows=26,200 loops=1)

55. 104.815 104.815 ↑ 1.0 115,672 1

Seq Scan on assessor_larimer_county_co_4691458b1e694e5e a_26 (cost=0.00..7,539.72 rows=115,672 width=183) (actual time=0.008..104.815 rows=115,672 loops=1)

56. 318.306 318.306 ↑ 1.0 382,198 1

Seq Scan on assessor_las_vegas_nv_f951bd5dc54f495b a_27 (cost=0.00..23,122.38 rows=382,238 width=316) (actual time=0.010..318.306 rows=382,198 loops=1)

57. 2.856 2.856 ↑ 1.0 3,788 1

Seq Scan on assessor_lenox_ma_c59abe06e5544030 a_28 (cost=0.00..200.88 rows=3,788 width=311) (actual time=0.011..2.856 rows=3,788 loops=1)

58. 70.781 70.781 ↑ 1.0 83,234 1

Seq Scan on assessor_los_angeles_county_ca_a0ba9f83a3a74c7b a_29 (cost=0.00..5,140.34 rows=83,234 width=189) (actual time=0.010..70.781 rows=83,234 loops=1)

59. 48.480 48.480 ↑ 1.0 59,338 1

Seq Scan on assessor_madera_county_ca_793fa2de6d8d4f28 a_30 (cost=0.00..3,510.38 rows=59,338 width=322) (actual time=0.011..48.480 rows=59,338 loops=1)

60. 6.327 6.327 ↑ 1.0 7,109 1

Seq Scan on assessor_malibu_ca_0845a6fcbb9c4cd7 a_31 (cost=0.00..464.09 rows=7,109 width=313) (actual time=0.012..6.327 rows=7,109 loops=1)

61. 2.843 2.843 ↑ 1.0 3,112 1

Seq Scan on assessor_maplewood_mo_f6a496c371b948d5 a_32 (cost=0.00..215.12 rows=3,112 width=57) (actual time=0.012..2.843 rows=3,112 loops=1)

62. 137.264 137.264 ↑ 1.0 168,360 1

Seq Scan on assessor_maricopa_county_az_1310d115da1e401e a_33 (cost=0.00..9,923.01 rows=168,401 width=320) (actual time=0.010..137.264 rows=168,360 loops=1)

63. 58.465 58.465 ↑ 1.0 67,490 1

Seq Scan on assessor_marin_county_ca_5e9be0dfb41b4b69 a_34 (cost=0.00..4,137.27 rows=67,627 width=317) (actual time=0.011..58.465 rows=67,490 loops=1)

64. 12.604 12.604 ↑ 1.0 14,286 1

Seq Scan on assessor_mariposa_county_ca_adf688d000c946f6 a_35 (cost=0.00..930.86 rows=14,286 width=321) (actual time=0.010..12.604 rows=14,286 loops=1)

65. 67.080 67.080 ↑ 1.0 78,456 1

Seq Scan on assessor_martin_county_fl_d39775dc28f54bae a_36 (cost=0.00..4,957.56 rows=78,456 width=331) (actual time=0.010..67.080 rows=78,456 loops=1)

66. 37.316 37.316 ↑ 1.0 46,811 1

Seq Scan on assessor_maui_county_hi_ab040cda4b2e4d48 a_37 (cost=0.00..2,615.11 rows=46,811 width=320) (actual time=0.011..37.316 rows=46,811 loops=1)

67. 58.465 58.465 ↑ 1.0 71,959 1

Seq Scan on assessor_mendocino_county_ca_eebd45525e244e9e a_38 (cost=0.00..4,193.59 rows=71,959 width=323) (actual time=0.011..58.465 rows=71,959 loops=1)

68. 81.270 81.270 ↑ 1.0 79,696 1

Seq Scan on assessor_miami_dade_county_fl_c11f3ae1c6aa45f1 a_39 (cost=0.00..6,291.96 rows=79,696 width=327) (actual time=0.010..81.270 rows=79,696 loops=1)

69. 4.106 4.106 ↑ 1.0 4,667 1

Seq Scan on assessor_monmouth_county_nj_d1e2578feb474e0a a_40 (cost=0.00..294.67 rows=4,667 width=321) (actual time=0.012..4.106 rows=4,667 loops=1)

70. 18.616 18.616 ↑ 1.0 20,392 1

Seq Scan on assessor_mono_county_ca_48e87d96928e4012 a_41 (cost=0.00..1,386.92 rows=20,392 width=39) (actual time=0.010..18.616 rows=20,392 loops=1)

71. 80.444 80.444 ↑ 1.0 89,259 1

Seq Scan on assessor_monroe_county_fl_3869d98d04d34e23 a_42 (cost=0.00..5,851.59 rows=89,259 width=45) (actual time=0.020..80.444 rows=89,259 loops=1)

72. 20.105 20.105 ↑ 1.0 25,019 1

Seq Scan on assessor_napa_ca_6121cc9120de42a4 a_43 (cost=0.00..1,415.19 rows=25,019 width=312) (actual time=0.011..20.105 rows=25,019 loops=1)

73. 16.783 16.783 ↑ 1.0 19,184 1

Seq Scan on assessor_napa_county_ca_cbfa387c66264992 a_44 (cost=0.00..1,211.84 rows=19,184 width=320) (actual time=0.010..16.783 rows=19,184 loops=1)

74. 3.343 3.343 ↑ 1.0 4,006 1

Seq Scan on assessor_nelson_bc_ec1e1aea81364882 a_45 (cost=0.00..243.26 rows=4,026 width=316) (actual time=0.011..3.343 rows=4,006 loops=1)

75. 30.333 30.333 ↑ 1.0 36,064 1

Seq Scan on assessor_newport_beach_ca_0aa2254bb33e4817 a_46 (cost=0.00..2,184.64 rows=36,064 width=181) (actual time=0.011..30.333 rows=36,064 loops=1)

76. 13.205 13.205 ↑ 1.0 14,052 1

Seq Scan on assessor_oakland_park_fl_6e32bc7de7554f8d a_47 (cost=0.00..984.52 rows=14,052 width=321) (actual time=0.011..13.205 rows=14,052 loops=1)

77. 107.364 107.364 ↑ 1.0 131,975 1

Seq Scan on assessor_orange_county_fl_37f421a34ff74bdf a_48 (cost=0.00..7,777.39 rows=132,139 width=325) (actual time=0.009..107.364 rows=131,975 loops=1)

78. 107.327 107.327 ↑ 1.0 116,667 1

Seq Scan on assessor_orlando_fl_17493e7181d748af a_49 (cost=0.00..7,847.67 rows=116,667 width=177) (actual time=0.011..107.327 rows=116,667 loops=1)

79. 39.113 39.113 ↑ 1.0 39,447 1

Seq Scan on assessor_pasadena_ca_1fd922b2e9de424b a_50 (cost=0.00..2,990.47 rows=39,447 width=315) (actual time=0.012..39.113 rows=39,447 loops=1)

80. 26.844 26.844 ↑ 1.0 26,761 1

Seq Scan on assessor_petaluma_ca_9c0e4b4b78dd48c8 a_51 (cost=0.00..2,209.61 rows=26,761 width=317) (actual time=0.011..26.844 rows=26,761 loops=1)

81. 3.365 3.365 ↑ 1.0 3,868 1

Seq Scan on assessor_piedmont_ca_ffea2b3f783e411a a_52 (cost=0.00..253.68 rows=3,868 width=179) (actual time=0.010..3.365 rows=3,868 loops=1)

82. 21.093 21.093 ↑ 1.0 24,092 1

Seq Scan on assessor_portland_me_1023e1af508947b0 a_53 (cost=0.00..1,526.92 rows=24,092 width=315) (actual time=0.010..21.093 rows=24,092 loops=1)

83. 36.777 36.777 ↑ 1.0 45,378 1

Seq Scan on assessor_prescott_az_f10ad646895148bb a_54 (cost=0.00..2,649.78 rows=45,378 width=313) (actual time=0.010..36.777 rows=45,378 loops=1)

84. 2.884 2.884 ↑ 1.0 3,263 1

Seq Scan on assessor_revelstoke_bc_777586092eec4145 a_55 (cost=0.00..214.63 rows=3,263 width=41) (actual time=0.009..2.884 rows=3,263 loops=1)

85. 73.686 73.686 ↑ 1.0 82,865 1

Seq Scan on assessor_riverside_county_ca_6e4b1d7145f24ac9 a_56 (cost=0.00..5,444.01 rows=84,201 width=322) (actual time=0.011..73.686 rows=82,865 loops=1)

86. 2.293 2.293 ↑ 1.0 2,742 1

Seq Scan on assessor_rossland_bc_8713f203bb3642b1 a_57 (cost=0.00..165.42 rows=2,742 width=318) (actual time=0.012..2.293 rows=2,742 loops=1)

87. 15.858 15.858 ↑ 1.0 17,581 1

Seq Scan on assessor_san_marcos_tx_96b2bad78d42444f a_58 (cost=0.00..1,178.81 rows=17,581 width=171) (actual time=0.010..15.858 rows=17,581 loops=1)

88. 6.926 6.926 ↑ 1.0 7,307 1

Seq Scan on assessor_san_mateo_county_ca_ef8b46ccc8414877 a_59 (cost=0.00..521.07 rows=7,307 width=42) (actual time=0.008..6.926 rows=7,307 loops=1)

89. 98.086 98.086 ↑ 1.0 99,648 1

Seq Scan on assessor_santa_cruz_county_ca_d0e3f0d1a6e6404b a_60 (cost=0.00..7,829.48 rows=99,648 width=322) (actual time=0.011..98.086 rows=99,648 loops=1)

90. 57.832 57.832 ↑ 1.0 61,266 1

Seq Scan on assessor_sarasota_county_fl_db132f6b066f4ba1 a_61 (cost=0.00..4,247.66 rows=61,266 width=180) (actual time=0.010..57.832 rows=61,266 loops=1)

91. 33.331 33.331 ↑ 1.0 40,644 1

Seq Scan on assessor_sawyer_county_wi_81016738c88e49ac a_62 (cost=0.00..2,326.44 rows=40,644 width=322) (actual time=0.010..33.331 rows=40,644 loops=1)

92. 24.708 24.708 ↑ 1.0 11,292 1

Seq Scan on assessor_solano_county_ca_82192e65550b43e0 a_63 (cost=0.00..2,822.92 rows=11,292 width=319) (actual time=0.013..24.708 rows=11,292 loops=1)

93. 4.306 4.306 ↑ 1.0 4,632 1

Seq Scan on assessor_sonoma_county_ca_3eeb161470914f73 a_64 (cost=0.00..319.32 rows=4,632 width=322) (actual time=0.010..4.306 rows=4,632 loops=1)

94. 14.511 14.511 ↑ 1.0 15,219 1

Seq Scan on assessor_south_lake_tahoe_ca_37c5e13796674bef a_65 (cost=0.00..1,092.19 rows=15,219 width=177) (actual time=0.012..14.511 rows=15,219 loops=1)

95. 123.352 123.352 ↑ 1.0 139,025 1

Seq Scan on assessor_st_johns_county_fl_9bc627b9355f4b15 a_66 (cost=0.00..9,198.25 rows=139,025 width=322) (actual time=0.011..123.352 rows=139,025 loops=1)

96. 8.650 8.650 ↑ 1.0 12,530 1

Seq Scan on assessor_sun_peaks_bc_1bdb590dd315404e a_67 (cost=0.00..546.30 rows=12,530 width=319) (actual time=0.011..8.650 rows=12,530 loops=1)

97. 1.903 1.903 ↑ 1.0 1,946 1

Seq Scan on assessor_suttons_bay_mi_4fae44266331495b a_68 (cost=0.00..141.46 rows=1,946 width=319) (actual time=0.011..1.903 rows=1,946 loops=1)

98. 31.513 31.513 ↑ 1.0 32,890 1

Seq Scan on assessor_tamarac_fl_ebc06a52caea48ea a_69 (cost=0.00..2,349.90 rows=32,890 width=316) (actual time=0.011..31.513 rows=32,890 loops=1)

99. 5.168 5.168 ↑ 1.0 4,667 1

Seq Scan on assessor_taos_county_nm_2b15473860264850 a_70 (cost=0.00..403.67 rows=4,667 width=42) (actual time=0.011..5.168 rows=4,667 loops=1)

100. 4.141 4.141 ↑ 1.0 4,862 1

Seq Scan on assessor_teton_county_wy_08c55071ca944f14 a_71 (cost=0.00..307.62 rows=4,862 width=187) (actual time=0.012..4.141 rows=4,862 loops=1)

101. 12.656 12.656 ↑ 1.0 14,550 1

Seq Scan on assessor_tofino_bc_9d44fa4331d849cd a_72 (cost=0.00..919.50 rows=14,550 width=315) (actual time=0.012..12.656 rows=14,550 loops=1)

102. 18.562 18.562 ↑ 1.0 21,987 1

Seq Scan on assessor_ucluelet_bc_e6251e82ee8044ec a_73 (cost=0.00..1,366.87 rows=21,987 width=181) (actual time=0.010..18.562 rows=21,987 loops=1)

103. 35.092 35.092 ↑ 1.0 46,584 1

Seq Scan on assessor_vermont_bbddb672dfb8473e a_74 (cost=0.00..2,355.84 rows=46,584 width=312) (actual time=0.011..35.092 rows=46,584 loops=1)

104. 23.249 23.249 ↑ 1.0 28,931 1

Seq Scan on assessor_victoria_bc_52ef0b03daf748c1 a_75 (cost=0.00..1,705.31 rows=28,931 width=318) (actual time=0.011..23.249 rows=28,931 loops=1)

105. 181.935 181.935 ↑ 1.0 161,286 1

Seq Scan on assessor_virginia_beach_va_7ac246f385914a1d a_76 (cost=0.00..14,972.86 rows=161,286 width=325) (actual time=0.011..181.935 rows=161,286 loops=1)

106. 37.010 37.010 ↑ 1.0 42,905 1

Seq Scan on assessor_walton_county_fl_fcb628587c614a48 a_77 (cost=0.00..3,122.05 rows=42,905 width=328) (actual time=0.010..37.010 rows=42,905 loops=1)

107. 10.342 10.342 ↑ 1.0 9,657 1

Seq Scan on assessor_west_hollywood_ca_0ad80d9e052d49bf a_78 (cost=0.00..818.57 rows=9,657 width=321) (actual time=0.011..10.342 rows=9,657 loops=1)

108. 23.302 23.302 ↑ 1.0 23,391 1

Seq Scan on assessor_yorba_linda_ca_601b0e9dbd6741a3 a_79 (cost=0.00..1,780.91 rows=23,391 width=316) (actual time=0.009..23.302 rows=23,391 loops=1)

109. 11.979 11.979 ↑ 1.0 13,350 1

Seq Scan on assessor_yucca_valley_ca_991b980d76e5478f a_80 (cost=0.00..898.50 rows=13,350 width=321) (actual time=0.012..11.979 rows=13,350 loops=1)

110. 8.611 8.611 ↑ 1.0 6,509 1

Seq Scan on assessor_marquette_county_mi_0cbee586637f4332 a_81 (cost=0.00..825.09 rows=6,509 width=324) (actual time=0.050..8.611 rows=6,509 loops=1)

111. 295.409 295.409 ↑ 1.0 230,669 1

Seq Scan on assessor_denver_co_6e0a991a8fb7435d a_82 (cost=0.00..27,528.69 rows=230,669 width=182) (actual time=0.010..295.409 rows=230,669 loops=1)

112. 177.956 177.956 ↑ 1.0 132,268 1

Seq Scan on assessor_santa_barbara_county_ca_d44970aa7bb94eb0 a_83 (cost=0.00..17,078.68 rows=132,268 width=49) (actual time=0.494..177.956 rows=132,268 loops=1)

113. 72.016 72.016 ↑ 1.0 52,599 1

Seq Scan on assessor_lee_county_fl_18fc47cddcad4743 a_84 (cost=0.00..6,984.99 rows=52,599 width=181) (actual time=0.010..72.016 rows=52,599 loops=1)

114. 10.513 10.513 ↑ 1.0 7,958 1

Seq Scan on assessor_east_bay_township_mi_c0b85928790f4246 a_85 (cost=0.00..1,014.58 rows=7,958 width=324) (actual time=3.058..10.513 rows=7,958 loops=1)

115. 2.682 2.682 ↑ 1.0 2,344 1

Seq Scan on assessor_driggs_id_2ebfbebfc56149aa a_86 (cost=0.00..248.44 rows=2,344 width=317) (actual time=0.737..2.682 rows=2,344 loops=1)

116. 142.280 142.280 ↑ 1.0 121,104 1

Seq Scan on assessor_asheville_nc_f813d3c87eb34adb a_87 (cost=0.00..13,284.04 rows=121,104 width=316) (actual time=0.122..142.280 rows=121,104 loops=1)

117. 39.320 39.320 ↑ 1.0 25,966 1

Seq Scan on assessor_douglas_county_nv_bd00177a8b504c95 a_88 (cost=0.00..3,984.66 rows=25,966 width=54) (actual time=0.011..39.320 rows=25,966 loops=1)

118. 12.894 12.894 ↑ 1.0 15,369 1

Seq Scan on assessor_del_norte_county_ca_510c4787ef0041c4 a_89 (cost=0.00..966.69 rows=15,369 width=325) (actual time=0.011..12.894 rows=15,369 loops=1)

119. 198.730 198.730 ↑ 1.0 121,306 1

Seq Scan on assessor_monterey_county_ca_155b4757b2fb483f a_90 (cost=0.00..21,015.06 rows=121,306 width=188) (actual time=43.512..198.730 rows=121,306 loops=1)

120. 0.212 0.212 ↑ 1.0 147 1

Seq Scan on assessor_boston_ma_e1479ec6e26c412c a_91 (cost=0.00..21.47 rows=147 width=313) (actual time=0.085..0.212 rows=147 loops=1)

121. 390.635 390.635 ↑ 1.0 171,609 1

Seq Scan on assessor_placer_county_ca_f2273f13841c4e48 a_92 (cost=0.00..39,511.25 rows=172,025 width=322) (actual time=0.009..390.635 rows=171,609 loops=1)

122. 349.965 349.965 ↓ 1.0 255,371 1

Seq Scan on assessor_nashville_tn_39405bcc5d0b4771 a_93 (cost=0.00..32,981.78 rows=255,178 width=195) (actual time=0.011..349.965 rows=255,371 loops=1)

123. 13.117 13.117 ↑ 1.0 10,655 1

Seq Scan on assessor_ventura_county_ca_ccc24a0684b043f3 a_94 (cost=0.00..1,142.55 rows=10,655 width=190) (actual time=0.084..13.117 rows=10,655 loops=1)

124. 55.855 55.855 ↑ 1.0 48,137 1

Seq Scan on assessor_rockingham_county_va_cffd52fe180645af a_95 (cost=0.00..5,004.37 rows=48,137 width=178) (actual time=1.500..55.855 rows=48,137 loops=1)

125. 3.634 3.634 ↑ 1.0 2,901 1

Seq Scan on assessor_collegedale_tn_6aa970dc665e4bef a_96 (cost=0.00..349.01 rows=2,901 width=316) (actual time=1.043..3.634 rows=2,901 loops=1)

126. 42.146 42.146 ↑ 1.0 33,015 1

Seq Scan on assessor_sunnyvale_ca_bfaee40a08e540cb a_97 (cost=0.00..3,817.15 rows=33,015 width=314) (actual time=0.552..42.146 rows=33,015 loops=1)

127. 40.157 40.157 ↑ 1.0 30,485 1

Seq Scan on assessor_new_braunfels_tx_7184eb6576fa462d a_98 (cost=0.00..3,860.85 rows=30,485 width=37) (actual time=0.390..40.157 rows=30,485 loops=1)

128. 5.035 5.035 ↑ 1.0 4,445 1

Seq Scan on assessor_los_altos_hills_ca_eba63a5a5af64615 a_99 (cost=0.00..477.45 rows=4,445 width=320) (actual time=0.052..5.035 rows=4,445 loops=1)

129. 7.542 7.542 ↑ 1.0 5,967 1

Seq Scan on assessor_holmes_beach_fl_eee3440dbcb6413e a_100 (cost=0.00..760.67 rows=5,967 width=318) (actual time=2.198..7.542 rows=5,967 loops=1)

130. 12.204 12.204 ↑ 1.0 9,328 1

Seq Scan on assessor_south_portland_me_d474fc2830eb4772 a_101 (cost=0.00..1,217.28 rows=9,328 width=177) (actual time=0.010..12.204 rows=9,328 loops=1)

131. 26.924 26.924 ↑ 1.0 20,814 1

Seq Scan on assessor_redwood_city_ca_7cea3cc128ce4727 a_102 (cost=0.00..2,681.14 rows=20,814 width=318) (actual time=0.043..26.924 rows=20,814 loops=1)

132. 158.217 158.217 ↑ 1.0 124,214 1

Seq Scan on assessor_boulder_county_co_91fb110cd94043c8 a_103 (cost=0.00..14,475.14 rows=124,214 width=185) (actual time=6.310..158.217 rows=124,214 loops=1)

133. 35.817 35.817 ↑ 1.0 41,282 1

Seq Scan on assessor_tuolumne_county_ca_cdd383fb4e9449d9 a_104 (cost=0.00..2,592.82 rows=41,282 width=324) (actual time=0.012..35.817 rows=41,282 loops=1)

134. 6.679 6.679 ↑ 1.0 5,739 1

Seq Scan on assessor_albany_ca_65e90507932c419b a_105 (cost=0.00..594.39 rows=5,739 width=311) (actual time=1.837..6.679 rows=5,739 loops=1)

135. 6.965 6.965 ↑ 1.0 5,064 1

Seq Scan on assessor_hood_river_county_or_5c35f0da0b3541ce a_106 (cost=0.00..648.64 rows=5,064 width=328) (actual time=2.049..6.965 rows=5,064 loops=1)

136. 13.328 13.328 ↑ 1.0 15,174 1

Seq Scan on assessor_penticton_bc_0ba5a823796f4b42 a_107 (cost=0.00..970.74 rows=15,174 width=315) (actual time=0.011..13.328 rows=15,174 loops=1)

137. 3.255 3.255 ↑ 1.0 2,503 1

Seq Scan on assessor_williams_bay_wi_dfab8a075b5544aa a_108 (cost=0.00..303.03 rows=2,503 width=317) (actual time=0.971..3.255 rows=2,503 loops=1)

138. 1.602 1.602 ↑ 1.0 1,357 1

Seq Scan on assessor_connestee_falls_nc_305175fcd5a643e5 a_109 (cost=0.00..147.57 rows=1,357 width=325) (actual time=0.008..1.602 rows=1,357 loops=1)

139. 42.593 42.593 ↑ 1.0 32,371 1

Seq Scan on assessor_garden_grove_ca_416b5aa8ac2442d8 a_110 (cost=0.00..3,554.71 rows=32,371 width=173) (actual time=0.501..42.593 rows=32,371 loops=1)

140. 177.039 177.039 ↑ 1.0 118,825 1

Seq Scan on assessor_loudoun_county_va_ce6c1d66f0274472 a_111 (cost=0.00..16,572.25 rows=118,825 width=323) (actual time=14.508..177.039 rows=118,825 loops=1)

141. 107.188 107.188 ↑ 1.9 76,463 1

Seq Scan on assessor_hall_county_ga_unincorporated_1aca2434ca314a97 a_112 (cost=0.00..11,053.68 rows=141,668 width=54) (actual time=0.013..107.188 rows=76,463 loops=1)

142. 84.345 84.345 ↑ 1.0 63,525 1

Seq Scan on assessor_nevada_county_ca_e708945e3e7b4b1b a_113 (cost=0.00..8,012.25 rows=63,525 width=49) (actual time=0.011..84.345 rows=63,525 loops=1)

143. 4.103 4.103 ↑ 1.0 3,058 1

Seq Scan on assessor_sausalito_ca_276099f310e34338 a_114 (cost=0.00..387.58 rows=3,058 width=313) (actual time=0.553..4.103 rows=3,058 loops=1)

144. 948.223 948.223 ↑ 1.0 694,688 1

Seq Scan on assessor_san_antonio_tx_8147f36cb4b04c99 a_115 (cost=0.00..86,930.76 rows=695,876 width=172) (actual time=0.008..948.223 rows=694,688 loops=1)

145. 5.609 5.609 ↑ 1.0 3,389 1

Seq Scan on assessor_indian_wells_ca_e74205b7cf374d0f a_116 (cost=0.00..581.89 rows=3,389 width=318) (actual time=1.370..5.609 rows=3,389 loops=1)

146. 595.791 595.791 ↑ 1.0 424,544 1

Seq Scan on assessor_broward_county_fl_54568cf8aec1441c a_117 (cost=0.00..57,197.22 rows=440,922 width=323) (actual time=3.978..595.791 rows=424,544 loops=1)

147. 5.264 5.264 ↑ 1.0 3,468 1

Seq Scan on assessor_frisco_co_33a2c6fd3ff04245 a_118 (cost=0.00..427.68 rows=3,468 width=170) (actual time=1.169..5.264 rows=3,468 loops=1)

148. 7.984 7.984 ↑ 1.0 8,239 1

Seq Scan on assessor_breckenridge_co_8a74ce3e128c4548 a_119 (cost=0.00..583.39 rows=8,239 width=315) (actual time=0.011..7.984 rows=8,239 loops=1)

149. 27.816 27.816 ↑ 1.0 33,155 1

Seq Scan on assessor_redding_ca_a960c2a6977d47b8 a_120 (cost=0.00..2,111.05 rows=33,305 width=178) (actual time=0.011..27.816 rows=33,155 loops=1)

150. 8.563 8.563 ↑ 1.0 9,413 1

Seq Scan on assessor_newport_county_ri_6c0661dbb60e44d2 a_121 (cost=0.00..619.13 rows=9,413 width=183) (actual time=0.011..8.563 rows=9,413 loops=1)

151. 123.211 123.211 ↑ 1.0 103,087 1

Seq Scan on assessor_alachua_county_fl_1a46db0573604880 a_122 (cost=0.00..11,664.87 rows=103,087 width=322) (actual time=0.012..123.211 rows=103,087 loops=1)

152. 90.743 90.743 ↑ 1.0 76,301 1

Seq Scan on assessor_page_az_b494526f192e40ff a_123 (cost=0.00..8,438.01 rows=76,301 width=309) (actual time=2.543..90.743 rows=76,301 loops=1)

153. 66.571 66.571 ↑ 1.0 47,754 1

Seq Scan on assessor_wilmington_nc_f5f27c9dab984c06 a_124 (cost=0.00..5,691.54 rows=47,754 width=179) (actual time=0.102..66.571 rows=47,754 loops=1)

154. 5.373 5.373 ↑ 1.0 4,347 1

Seq Scan on assessor_hailey_id_5a4d3d75f8b94e26 a_125 (cost=0.00..501.47 rows=4,347 width=317) (actual time=1.526..5.373 rows=4,347 loops=1)

155. 32.491 32.491 ↑ 1.0 25,644 1

Seq Scan on assessor_alexandria_va_5efbeca77575478d a_126 (cost=0.00..3,045.44 rows=25,644 width=174) (actual time=0.809..32.491 rows=25,644 loops=1)

156. 106.496 106.496 ↑ 1.0 79,753 1

Seq Scan on assessor_madison_wi_37c3f18db22f4b9a a_127 (cost=0.00..10,063.53 rows=79,753 width=176) (actual time=0.011..106.496 rows=79,753 loops=1)

157. 5.194 5.194 ↑ 1.0 1,469 1

Seq Scan on assessor_gearhart_or_d32e1239534a4186 a_128 (cost=0.00..182.69 rows=1,469 width=174) (actual time=0.544..5.194 rows=1,469 loops=1)

158. 5.580 5.580 ↑ 1.0 1,209 1

Seq Scan on assessor_garden_city_ut_eb914c2128bc422e a_129 (cost=0.00..160.09 rows=1,209 width=317) (actual time=0.484..5.580 rows=1,209 loops=1)

159. 5.100 5.100 ↑ 1.0 2,262 1

Seq Scan on assessor_moab_ut_808fc2566da84170 a_130 (cost=0.00..249.62 rows=2,262 width=168) (actual time=0.716..5.100 rows=2,262 loops=1)

160. 390.189 390.189 ↑ 1.0 209,212 1

Seq Scan on assessor_austin_tx_f6572d91c36f4e9f a_131 (cost=0.00..24,314.12 rows=209,212 width=309) (actual time=4.782..390.189 rows=209,212 loops=1)

161. 176.709 176.709 ↑ 1.0 156,345 1

Seq Scan on assessor_tulare_county_ca_25c67a45378648fd a_132 (cost=0.00..16,906.45 rows=156,345 width=322) (actual time=29.117..176.709 rows=156,345 loops=1)

162. 45.808 45.808 ↑ 1.0 41,085 1

Seq Scan on assessor_summit_county_ut_df245175543640ca a_133 (cost=0.00..4,209.85 rows=41,085 width=316) (actual time=3.303..45.808 rows=41,085 loops=1)

163. 1,097.532 1,097.532 ↑ 1.0 909,757 1

Seq Scan on assessor_san_diego_county_ca_5c3d607356664645 a_134 (cost=0.00..114,170.57 rows=909,757 width=185) (actual time=0.771..1,097.532 rows=909,757 loops=1)

164. 75.880 75.880 ↑ 1.0 64,137 1

Seq Scan on assessor_lake_county_ca_7c3b5d982a5d4b25 a_135 (cost=0.00..7,402.37 rows=64,137 width=320) (actual time=0.173..75.880 rows=64,137 loops=1)

165. 32.505 32.505 ↑ 1.0 28,400 1

Seq Scan on assessor_marin_county_ca_unincorporated_20c395697d0e4470 a_136 (cost=0.00..3,949.00 rows=28,400 width=332) (actual time=2.027..32.505 rows=28,400 loops=1)

166. 13.765 13.765 ↑ 1.0 5,292 1

Seq Scan on assessor_kane_county_ut_cc31fab012c54796 a_137 (cost=0.00..630.92 rows=5,292 width=169) (actual time=0.041..13.765 rows=5,292 loops=1)

167. 11.215 11.215 ↑ 1.0 10,819 1

Seq Scan on assessor_lehman_township_pa_bf800d907ffc47af a_138 (cost=0.00..1,301.19 rows=10,819 width=179) (actual time=0.879..11.215 rows=10,819 loops=1)

168. 1.825 1.825 ↑ 1.0 1,626 1

Seq Scan on assessor_anna_maria_fl_c0b4b797a8f14296 a_139 (cost=0.00..213.26 rows=1,626 width=202) (actual time=0.505..1.825 rows=1,626 loops=1)

169. 2.921 2.921 ↑ 1.0 2,673 1

Seq Scan on assessor_silverthorne_co_10fc3895b1bf4a62 a_140 (cost=0.00..345.73 rows=2,673 width=183) (actual time=0.765..2.921 rows=2,673 loops=1)

170. 10.691 10.691 ↑ 1.0 9,705 1

Seq Scan on assessor_big_bear_lake_ca_8f097e18cb894ab4 a_141 (cost=0.00..1,275.05 rows=9,705 width=180) (actual time=0.971..10.691 rows=9,705 loops=1)

171. 51.149 51.149 ↑ 1.0 47,214 1

Seq Scan on assessor_roseville_ca_4d670f6793f74f1c a_142 (cost=0.00..6,041.14 rows=47,214 width=200) (actual time=13.004..51.149 rows=47,214 loops=1)

172. 78.546 78.546 ↑ 1.0 75,727 1

Seq Scan on assessor_chattanooga_tn_38e262c7baa04eda a_143 (cost=0.00..8,385.27 rows=75,727 width=179) (actual time=0.011..78.546 rows=75,727 loops=1)

173. 8.403 8.403 ↑ 1.0 2,424 1

Seq Scan on assessor_angel_fire_nm_be382a82b81043fa a_144 (cost=0.00..190.50 rows=2,450 width=192) (actual time=0.010..8.403 rows=2,424 loops=1)

174. 12.717 12.717 ↑ 1.0 4,240 1

Seq Scan on assessor_beech_mountain_nc_43d5f02f856740ca a_145 (cost=0.00..310.40 rows=4,240 width=323) (actual time=0.008..12.717 rows=4,240 loops=1)

175. 3.293 3.293 ↑ 1.0 1,401 1

Seq Scan on assessor_dillon_co_3373607f8c4b4c1b a_146 (cost=0.00..99.01 rows=1,401 width=170) (actual time=0.009..3.293 rows=1,401 loops=1)

176. 4.852 4.852 ↑ 1.0 2,027 1

Seq Scan on assessor_blowing_rock_nc_edddaaba07554aea a_147 (cost=0.00..137.99 rows=2,099 width=321) (actual time=0.011..4.852 rows=2,027 loops=1)

177. 11.526 11.526 ↑ 1.0 2,538 1

Seq Scan on assessor_folly_beach_sc_46310055eddd40f1 a_148 (cost=0.00..215.38 rows=2,538 width=318) (actual time=0.008..11.526 rows=2,538 loops=1)

178. 12.301 12.301 ↑ 1.0 10,919 1

Seq Scan on assessor_bozeman_mt_e52b17bcbf034652 a_149 (cost=0.00..702.65 rows=11,165 width=319) (actual time=0.010..12.301 rows=10,919 loops=1)

179. 2.485 2.485 ↑ 1.0 1,408 1

Seq Scan on assessor_fraser_co_6efcb0645b5048d1 a_150 (cost=0.00..102.08 rows=1,408 width=310) (actual time=0.009..2.485 rows=1,408 loops=1)

180. 21.724 21.724 ↑ 1.0 25,954 1

Seq Scan on assessor_chico_ca_fb1090c1d58c4085 a_151 (cost=0.00..1,589.73 rows=26,473 width=314) (actual time=0.008..21.724 rows=25,954 loops=1)

181. 17.346 17.346 ↑ 1.0 14,001 1

Seq Scan on assessor_franklin_county_ny_97c569a37fa44e4a a_152 (cost=0.00..869.36 rows=14,236 width=323) (actual time=0.008..17.346 rows=14,001 loops=1)

182. 43.785 43.785 ↑ 1.0 57,092 1

Seq Scan on assessor_columbus_ga_84044eecc9a94b1c a_153 (cost=0.00..3,455.91 rows=57,291 width=172) (actual time=0.022..43.785 rows=57,092 loops=1)

183. 106.704 106.704 ↑ 1.0 134,278 1

Seq Scan on assessor_aurora_co_8f3892a814af408c a_154 (cost=0.00..8,483.59 rows=134,959 width=315) (actual time=0.017..106.704 rows=134,278 loops=1)

184. 69.015 69.015 ↑ 1.0 85,795 1

Seq Scan on assessor_brown_county_wi_2b1ecc33486f4f36 a_155 (cost=0.00..5,252.86 rows=86,986 width=315) (actual time=0.018..69.015 rows=85,795 loops=1)

185. 213.310 213.310 ↑ 1.0 135,027 1

Seq Scan on assessor_charleston_county_sc_ac9aabfe8acb4d62 a_156 (cost=0.00..9,290.43 rows=141,343 width=323) (actual time=0.021..213.310 rows=135,027 loops=1)

186. 164.236 164.236 ↑ 1.0 193,250 1

Seq Scan on assessor_kansas_city_mo_8547276bea12463e a_157 (cost=0.00..12,480.18 rows=199,018 width=172) (actual time=0.022..164.236 rows=193,250 loops=1)

187. 39.759 39.759 ↑ 1.0 39,700 1

Seq Scan on assessor_irvine_ca_ffd0d45df0a3446c a_158 (cost=0.00..4,154.00 rows=39,700 width=169) (actual time=0.022..39.759 rows=39,700 loops=1)

188. 128.852 128.852 ↑ 1.0 69,643 1

Seq Scan on assessor_wyandotte_county_ks_0820e3e49a0d42d8 a_159 (cost=0.00..8,095.45 rows=69,645 width=319) (actual time=0.104..128.852 rows=69,643 loops=1)

189. 108.828 108.828 ↑ 1.0 124,106 1

Seq Scan on assessor_minneapolis_mn_a2207af2b038487c a_160 (cost=0.00..8,388.35 rows=127,735 width=178) (actual time=0.025..108.828 rows=124,106 loops=1)

190. 23.371 23.371 ↑ 1.0 29,290 1

Seq Scan on assessor_fulton_county_ga_aa62ce4711444df2 a_161 (cost=0.00..1,933.97 rows=29,597 width=323) (actual time=0.021..23.371 rows=29,290 loops=1)

191. 92.994 92.994 ↑ 1.0 120,728 1

Seq Scan on assessor_san_luis_obispo_county_ca_cd71eef6b94b43dd a_162 (cost=0.00..7,467.65 rows=123,665 width=71) (actual time=0.016..92.994 rows=120,728 loops=1)

192. 12.766 12.766 ↑ 1.0 12,977 1

Seq Scan on assessor_normal_il_91f7a10acd0f48f2 a_163 (cost=0.00..1,389.77 rows=12,977 width=313) (actual time=0.635..12.766 rows=12,977 loops=1)

193. 20.140 20.140 ↑ 1.0 24,864 1

Seq Scan on assessor_wasatch_county_ut_46e3c895c61a45ce a_164 (cost=0.00..1,820.36 rows=25,136 width=177) (actual time=0.015..20.140 rows=24,864 loops=1)

194. 7.288 7.288 ↑ 1.0 8,672 1

Seq Scan on assessor_dania_beach_fl_05c9b4122e93412b a_165 (cost=0.00..586.42 rows=8,942 width=320) (actual time=0.016..7.288 rows=8,672 loops=1)

195. 22.180 22.180 ↑ 1.0 19,324 1

Seq Scan on assessor_bonner_county_id_d28e1b8800b942f6 a_166 (cost=0.00..1,294.56 rows=19,756 width=324) (actual time=0.019..22.180 rows=19,324 loops=1)

196. 5.182 5.182 ↑ 1.0 3,979 1

Seq Scan on assessor_half_moon_bay_ca_8b25445193a24cd5 a_167 (cost=0.00..279.81 rows=4,081 width=319) (actual time=0.014..5.182 rows=3,979 loops=1)

197. 2.010 2.010 ↑ 1.0 2,766 1

Seq Scan on assessor_ojai_ca_b671f1045b114aaf a_168 (cost=0.00..162.08 rows=2,808 width=310) (actual time=0.014..2.010 rows=2,766 loops=1)

198. 5.522 5.522 ↑ 1.0 6,387 1

Seq Scan on assessor_port_hueneme_ca_47dbdb2fb5c94f18 a_169 (cost=0.00..422.41 rows=6,441 width=319) (actual time=0.012..5.522 rows=6,387 loops=1)

199. 110.522 110.522 ↑ 1.0 93,027 1

Seq Scan on assessor_new_hanover_county_nc_b9abd9021823452f a_170 (cost=0.00..6,276.64 rows=95,764 width=188) (actual time=0.014..110.522 rows=93,027 loops=1)

200. 4.788 4.788 ↑ 1.0 2,370 1

Seq Scan on assessor_shleter_island_ny_fd4f0ad7aed346a7 a_171 (cost=0.00..178.70 rows=2,370 width=171) (actual time=0.022..4.788 rows=2,370 loops=1)

201. 23.078 23.078 ↑ 1.0 8,002 1

Seq Scan on assessor_port_angeles_wa_5619274c051544c4 a_172 (cost=0.00..967.03 rows=8,003 width=321) (actual time=2.198..23.078 rows=8,002 loops=1)

202. 22.556 22.556 ↑ 1.0 24,214 1

Seq Scan on assessor_santa_cruz_ca_09bd2134cb674d61 a_173 (cost=0.00..1,690.11 rows=24,711 width=192) (actual time=0.015..22.556 rows=24,214 loops=1)

203. 20.895 20.895 ↑ 1.0 23,474 1

Seq Scan on assessor_lake_forest_ca_470ef5d1c54d4ef3 a_174 (cost=0.00..1,547.82 rows=23,582 width=175) (actual time=0.016..20.895 rows=23,474 loops=1)

204. 18.290 18.290 ↑ 1.0 22,443 1

Seq Scan on assessor_weston_fl_847c1ebec8164c3f a_175 (cost=0.00..1,419.75 rows=22,575 width=171) (actual time=0.017..18.290 rows=22,443 loops=1)

205. 16.854 16.854 ↑ 1.0 13,916 1

Seq Scan on assessor_gunnison_co_ad214efdfbd94db1 a_176 (cost=0.00..956.33 rows=13,933 width=317) (actual time=0.015..16.854 rows=13,916 loops=1)

206. 43.028 43.028 ↑ 1.0 28,160 1

Seq Scan on assessor_san_mateo_ca_1f786549df054b15 a_177 (cost=0.00..1,796.92 rows=28,692 width=314) (actual time=0.015..43.028 rows=28,160 loops=1)

207. 59.546 59.546 ↑ 1.0 57,864 1

Seq Scan on assessor_bay_county_fl_986cd275334b4ace a_178 (cost=0.00..4,107.64 rows=57,864 width=318) (actual time=0.021..59.546 rows=57,864 loops=1)

208. 75.032 75.032 ↑ 1.1 29,203 1

Seq Scan on assessor_indio_ca_0335078219e64bd4 a_179 (cost=0.00..1,796.09 rows=30,709 width=311) (actual time=0.023..75.032 rows=29,203 loops=1)

209. 3.840 3.840 ↑ 1.0 1,895 1

Seq Scan on assessor_cannon_beach_or_b58348aa8eb943f8 a_180 (cost=0.00..139.95 rows=1,895 width=177) (actual time=0.019..3.840 rows=1,895 loops=1)

210. 2.211 2.211 ↑ 1.0 2,787 1

Seq Scan on assessor_grand_county_ut_525180824a4847e8 a_181 (cost=0.00..192.93 rows=2,793 width=179) (actual time=0.016..2.211 rows=2,787 loops=1)

211. 3.251 3.251 ↑ 1.0 1,182 1

Seq Scan on assessor_grand_lake_co_cfc8a6ad0fd64c4b a_182 (cost=0.00..87.82 rows=1,182 width=314) (actual time=0.015..3.251 rows=1,182 loops=1)

212. 8.460 8.460 ↑ 1.0 6,113 1

Seq Scan on assessor_golden_co_632c53189af04663 a_183 (cost=0.00..392.07 rows=6,207 width=174) (actual time=0.017..8.460 rows=6,113 loops=1)

213. 5.991 5.991 ↑ 1.0 4,383 1

Seq Scan on assessor_healdsburg_ca_fea3b5eece5b4cd0 a_184 (cost=0.00..274.02 rows=4,402 width=316) (actual time=0.011..5.991 rows=4,383 loops=1)

214. 14.490 14.490 ↑ 1.0 7,688 1

Seq Scan on assessor_grand_county_co_344c6772a11942cb a_185 (cost=0.00..554.19 rows=7,719 width=316) (actual time=0.010..14.490 rows=7,688 loops=1)

215. 21.691 21.691 ↑ 1.0 16,554 1

Seq Scan on assessor_hot_springs_ar_ac466d44f29c41d0 a_186 (cost=0.00..1,125.82 rows=16,782 width=182) (actual time=0.011..21.691 rows=16,554 loops=1)

216. 6.449 6.449 ↑ 1.0 6,043 1

Seq Scan on assessor_twentynine_palms_ca_5371804d41dd40d7 a_187 (cost=0.00..404.69 rows=6,169 width=180) (actual time=0.009..6.449 rows=6,043 loops=1)

217. 17.165 17.165 ↑ 1.0 22,328 1

Seq Scan on assessor_iron_county_ut_043608fabca94286 a_188 (cost=0.00..1,509.27 rows=22,827 width=321) (actual time=0.009..17.165 rows=22,328 loops=1)

218. 82.626 82.626 ↑ 1.0 108,765 1

Seq Scan on assessor_henrico_county_va_e4cc95db69d04dd9 a_189 (cost=0.00..6,934.89 rows=108,989 width=179) (actual time=0.008..82.626 rows=108,765 loops=1)

219. 11.540 11.540 ↑ 1.0 11,094 1

Seq Scan on assessor_ruidoso_nm_6e8345a4bf974788 a_190 (cost=0.00..1,276.94 rows=11,094 width=323) (actual time=0.009..11.540 rows=11,094 loops=1)

220. 47.117 47.117 ↑ 1.0 43,532 1

Seq Scan on assessor_norman_ok_22572b23caa74b80 a_191 (cost=0.00..5,282.32 rows=43,532 width=167) (actual time=1.386..47.117 rows=43,532 loops=1)

221. 13.827 13.827 ↑ 1.0 15,203 1

Seq Scan on assessor_baldwin_park_ca_740deb8eb465474a a_192 (cost=0.00..1,506.03 rows=15,203 width=319) (actual time=0.042..13.827 rows=15,203 loops=1)

222. 29.080 29.080 ↑ 1.0 38,338 1

Seq Scan on assessor_oconee_county_sc_2330900e5cf4408d a_193 (cost=0.00..2,477.40 rows=38,840 width=320) (actual time=0.009..29.080 rows=38,338 loops=1)

223. 94.629 94.629 ↑ 1.0 70,302 1

Seq Scan on assessor_ulster_county_ny_059968e3b55140b0 a_194 (cost=0.00..4,323.11 rows=72,311 width=178) (actual time=0.010..94.629 rows=70,302 loops=1)

224. 4.247 4.247 ↑ 1.0 1,585 1

Seq Scan on assessor_pagosa_springs_co_b39a0b95e1eb4162 a_195 (cost=0.00..111.37 rows=1,637 width=322) (actual time=0.011..4.247 rows=1,585 loops=1)

225. 18.999 18.999 ↑ 1.0 13,763 1

Seq Scan on assessor_lake_oswego_or_b8f686e77a3a49e4 a_196 (cost=0.00..914.70 rows=13,870 width=320) (actual time=0.011..18.999 rows=13,763 loops=1)

226. 7.817 7.817 ↑ 1.0 1,961 1

Seq Scan on assessor_rockaway_beach_or_b607d279faca4812 a_197 (cost=0.00..150.61 rows=1,961 width=183) (actual time=0.013..7.817 rows=1,961 loops=1)

227. 20.213 20.213 ↑ 1.0 13,850 1

Seq Scan on assessor_kerrville_tx_63b2994366754851 a_198 (cost=0.00..907.60 rows=14,260 width=168) (actual time=0.008..20.213 rows=13,850 loops=1)

228. 2.805 2.805 ↑ 1.0 3,591 1

Seq Scan on assessor_rich_county_ut_b037e5ba9b434bf8 a_199 (cost=0.00..240.63 rows=3,663 width=317) (actual time=0.009..2.805 rows=3,591 loops=1)

229. 15.250 15.250 ↑ 1.0 18,378 1

Seq Scan on assessor_lodi_ca_196ed6af0c8c458b a_200 (cost=0.00..1,048.42 rows=18,442 width=164) (actual time=0.011..15.250 rows=18,378 loops=1)

230. 15.680 15.680 ↑ 1.0 6,078 1

Seq Scan on assessor_rancho_mirage_ca_97a210244f5a4e11 a_201 (cost=0.00..439.78 rows=6,078 width=175) (actual time=0.009..15.680 rows=6,078 loops=1)

231. 8.603 8.603 ↑ 1.1 3,673 1

Seq Scan on assessor_lake_placid_ny_41e6bdf037344c22 a_202 (cost=0.00..260.95 rows=4,095 width=178) (actual time=0.010..8.603 rows=3,673 loops=1)

232. 80.134 80.134 ↑ 1.1 29,546 1

Seq Scan on assessor_palm_desert_ca_3a03a87b1ae44ddb a_203 (cost=0.00..1,946.08 rows=31,208 width=317) (actual time=0.009..80.134 rows=29,546 loops=1)

233. 6.258 6.258 ↑ 1.0 7,977 1

Seq Scan on assessor_garfield_county_ut_2a9d0370f3d043fe a_204 (cost=0.00..524.00 rows=8,200 width=178) (actual time=0.012..6.258 rows=7,977 loops=1)

234. 600.489 600.489 ↑ 1.0 799,686 1

Seq Scan on assessor_los_angeles_ca_58e6d7cf3ef14eed a_205 (cost=0.00..45,814.41 rows=799,741 width=318) (actual time=0.009..600.489 rows=799,686 loops=1)

235. 2.747 2.747 ↑ 1.0 3,386 1

Seq Scan on assessor_sandpoint_id_b839f4f274ed4fef a_206 (cost=0.00..232.11 rows=3,511 width=190) (actual time=0.009..2.747 rows=3,386 loops=1)

236. 18.435 18.435 ↑ 1.0 16,757 1

Seq Scan on assessor_summit_county_co_2e3f848939b349ee a_207 (cost=0.00..2,073.23 rows=16,823 width=183) (actual time=0.009..18.435 rows=16,757 loops=1)

237. 2.330 2.330 ↑ 1.0 3,053 1

Seq Scan on assessor_sonoma_ca_f04bdafeb7464c3a a_208 (cost=0.00..188.53 rows=3,053 width=171) (actual time=0.010..2.330 rows=3,053 loops=1)

238. 6.141 6.141 ↑ 1.0 7,243 1

Seq Scan on assessor_south_padre_tx_94dbf12c0dea42ab a_209 (cost=0.00..561.43 rows=7,243 width=195) (actual time=0.008..6.141 rows=7,243 loops=1)

239. 2.659 2.659 ↑ 1.0 3,334 1

Seq Scan on assessor_talbot_county_md_662cb28e9bda4449 a_210 (cost=0.00..223.34 rows=3,334 width=176) (actual time=0.008..2.659 rows=3,334 loops=1)

240. 3.487 3.487 ↑ 1.0 4,338 1

Seq Scan on assessor_seaside_or_bd06677ada184238 a_211 (cost=0.00..287.38 rows=4,338 width=190) (actual time=0.011..3.487 rows=4,338 loops=1)

241. 19.938 19.938 ↑ 1.0 25,329 1

Seq Scan on assessor_rutherford_county_nc_7417df36ec264c35 a_212 (cost=0.00..1,679.78 rows=26,178 width=320) (actual time=0.009..19.938 rows=25,329 loops=1)

242. 70.940 70.940 ↑ 1.0 95,796 1

Seq Scan on assessor_wimberley_tx_eaa0f84cf646438a a_213 (cost=0.00..5,649.45 rows=96,145 width=312) (actual time=0.009..70.940 rows=95,796 loops=1)

243. 0.532 0.532 ↑ 1.0 680 1

Seq Scan on assessor_holland_wi_6e4bd9fb57ca4210 a_214 (cost=0.00..45.80 rows=680 width=315) (actual time=0.009..0.532 rows=680 loops=1)

244. 1.132 1.132 ↑ 1.0 1,484 1

Seq Scan on assessor_wayne_county_ut_32e9d616cf644ceb a_215 (cost=0.00..94.84 rows=1,484 width=175) (actual time=0.009..1.132 rows=1,484 loops=1)

245. 6.504 6.504 ↑ 1.0 8,372 1

Seq Scan on assessor_vail_co_84a792b22e2e4026 a_216 (cost=0.00..539.19 rows=8,619 width=313) (actual time=0.010..6.504 rows=8,372 loops=1)

246. 1.898 1.898 ↑ 1.1 2,501 1

Seq Scan on assessor_lake_george_ny_f9a95a00f0224d9e a_217 (cost=0.00..161.38 rows=2,638 width=36) (actual time=0.011..1.898 rows=2,501 loops=1)

247. 3.931 3.931 ↑ 1.0 5,023 1

Seq Scan on assessor_whitefish_mt_7fa8277bc971411d a_218 (cost=0.00..331.71 rows=5,171 width=173) (actual time=0.010..3.931 rows=5,023 loops=1)

248. 10.075 10.075 ↑ 1.0 12,705 1

Seq Scan on assessor_sedona_az_238b9f8d94034ad0 a_219 (cost=0.00..850.05 rows=12,705 width=172) (actual time=0.009..10.075 rows=12,705 loops=1)

249. 15.728 15.728 ↑ 1.0 18,419 1

Seq Scan on assessor_tillamook_county_or_15df87eb92934879 a_220 (cost=0.00..1,264.19 rows=18,419 width=185) (actual time=0.009..15.728 rows=18,419 loops=1)

250. 3.313 3.313 ↑ 1.0 4,650 1

Seq Scan on assessor_south_haven_mi_4059e48320ff45cc a_221 (cost=0.00..270.79 rows=4,779 width=320) (actual time=0.011..3.313 rows=4,650 loops=1)

251. 113.118 113.118 ↑ 1.0 145,235 1

Seq Scan on assessor_sacramento_ca_563f8f139d6b403e a_222 (cost=0.00..9,490.62 rows=145,962 width=179) (actual time=0.009..113.118 rows=145,235 loops=1)

252. 15.661 15.661 ↑ 1.0 20,421 1

Seq Scan on assessor_rocklin_ca_e23f296c4a844110 a_223 (cost=0.00..1,310.56 rows=20,856 width=175) (actual time=0.009..15.661 rows=20,421 loops=1)

253. 355.234 355.234 ↑ 1.0 322,075 1

Seq Scan on assessor_montgomery_county_md_5283463c77a0409c a_224 (cost=0.00..41,041.34 rows=322,134 width=176) (actual time=4.143..355.234 rows=322,075 loops=1)

254. 803.440 803.440 ↑ 1.0 1 40,172

Index Scan using listing_pkey on listing l (cost=0.56..2.57 rows=1 width=45) (actual time=0.019..0.020 rows=1 loops=40,172)

  • Index Cond: (internal_listing_id = lpj.internal_listing_id)
255. 632.912 632.912 ↑ 1.0 1 39,557

Index Scan using level1_listing_pkey on level1_listing l1 (cost=0.56..1.83 rows=1 width=18) (actual time=0.016..0.016 rows=1 loops=39,557)

  • Index Cond: (internal_listing_id = l.internal_listing_id)
256. 0.011 0.027 ↑ 1.0 1 1

Hash (cost=2.36..2.36 rows=1 width=22) (actual time=0.027..0.027 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
257. 0.016 0.016 ↑ 1.0 1 1

Index Scan using jurisdiction_str_policy_pkey on jurisdiction_str_policy jsp (cost=0.14..2.36 rows=1 width=22) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((geoid)::text = '99999US09'::text)
258. 4.326 108.047 ↑ 2.8 8,902 1

Hash (cost=37,340.67..37,340.67 rows=24,832 width=43) (actual time=108.047..108.047 rows=8,902 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 764kB
259. 103.721 103.721 ↑ 2.8 8,902 1

Index Scan using property_to_permit_persisted_key on property_to_permit_persisted pp (cost=0.55..37,340.67 rows=24,832 width=43) (actual time=0.031..103.721 rows=8,902 loops=1)

  • Index Cond: (((geoid)::text = '99999US09'::text) AND (is_active = true) AND (exact_match = true))
  • Filter: (is_active AND exact_match)
260. 0.108 0.346 ↑ 16.9 244 1

Hash (cost=127.15..127.15 rows=4,115 width=15) (actual time=0.346..0.346 rows=244 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 76kB
261. 0.238 0.238 ↑ 16.9 244 1

Seq Scan on property_types pt (cost=0.00..127.15 rows=4,115 width=15) (actual time=0.011..0.238 rows=244 loops=1)

262. 2.533 15.141 ↓ 1.4 6,448 1

Hash (cost=14,734.63..14,734.63 rows=4,614 width=26) (actual time=15.141..15.141 rows=6,448 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 426kB
263. 12.608 12.608 ↓ 1.4 6,448 1

Index Only Scan using property_to_permit_persisted_key on property_to_permit_persisted pp2 (cost=0.55..14,734.63 rows=4,614 width=26) (actual time=0.045..12.608 rows=6,448 loops=1)

  • Index Cond: ((geoid = '99999US09'::text) AND (is_active = false) AND (exact_match = true))
  • Filter: ((NOT is_active) AND exact_match)
  • Heap Fetches: 36
264. 0.589 5.882 ↑ 3.0 1,509 1

Hash (cost=18,914.64..18,914.64 rows=4,568 width=43) (actual time=5.882..5.882 rows=1,509 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 150kB
265. 1.104 5.293 ↑ 3.0 1,509 1

Bitmap Heap Scan on property_to_permit_persisted pp3 (cost=13,238.58..18,914.64 rows=4,568 width=43) (actual time=4.215..5.293 rows=1,509 loops=1)

  • Recheck Cond: ((geoid)::text = '99999US09'::text)
  • Filter: (is_active AND (NOT exact_match))
  • Rows Removed by Filter: 874
  • Heap Blocks: exact=197
266. 0.099 4.189 ↓ 0.0 0 1

BitmapAnd (cost=13,238.58..13,238.58 rows=5,416 width=0) (actual time=4.189..4.189 rows=0 loops=1)

267. 1.983 1.983 ↑ 1.6 15,075 1

Bitmap Index Scan on property_to_permit_persisted_exact_match (cost=0.00..4,545.96 rows=24,245 width=0) (actual time=1.983..1.983 rows=15,075 loops=1)

  • Index Cond: (exact_match = false)
268. 2.107 2.107 ↑ 2.0 17,733 1

Bitmap Index Scan on property_to_permit_persisted_geoid_idx (cost=0.00..8,690.09 rows=34,862 width=0) (actual time=2.107..2.107 rows=17,733 loops=1)

  • Index Cond: ((geoid)::text = '99999US09'::text)
269. 0.321 6.053 ↓ 1.0 874 1

Hash (cost=13,168.20..13,168.20 rows=849 width=26) (actual time=6.053..6.053 rows=874 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
270. 3.151 5.732 ↓ 1.0 874 1

Bitmap Heap Scan on property_to_permit_persisted pp4 (cost=9,129.36..13,168.20 rows=849 width=26) (actual time=2.748..5.732 rows=874 loops=1)

  • Filter: ((NOT is_active) AND (NOT exact_match) AND ((geoid)::text = '99999US09'::text))
  • Rows Removed by Filter: 1112
  • Heap Blocks: exact=427
271. 0.098 2.581 ↓ 0.0 0 1

BitmapAnd (cost=9,129.36..9,129.36 rows=3,799 width=0) (actual time=2.581..2.581 rows=0 loops=1)

272. 1.023 1.023 ↑ 1.6 15,075 1

Bitmap Index Scan on property_to_permit_persisted_exact_match (cost=0.00..4,545.96 rows=24,245 width=0) (actual time=1.023..1.023 rows=15,075 loops=1)

  • Index Cond: (exact_match = false)
273. 1.460 1.460 ↑ 2.0 12,432 1

Bitmap Index Scan on property_to_permit_is_active_idx (cost=0.00..4,582.73 rows=24,454 width=0) (actual time=1.460..1.460 rows=12,432 loops=1)

  • Index Cond: (is_active = false)
274. 0.001 0.013 ↓ 0.0 0 1

Hash (cost=2.39..2.39 rows=1 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
275. 0.002 0.012 ↓ 0.0 0 1

HashAggregate (cost=2.37..2.38 rows=1 width=28) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: excluded_property.parcel_number, excluded_property.geoid
276. 0.010 0.010 ↓ 0.0 0 1

Index Scan using excluded_property_geoid on excluded_property (cost=0.14..2.36 rows=1 width=28) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((geoid)::text = '99999US09'::text)
277. 0.170 0.761 ↑ 1.0 543 1

Hash (cost=38.72..38.72 rows=543 width=13) (actual time=0.761..0.761 rows=543 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
278. 0.359 0.591 ↑ 1.0 543 1

HashAggregate (cost=27.86..33.29 rows=543 width=13) (actual time=0.449..0.591 rows=543 loops=1)

  • Group Key: placercounty_registrations.parcel_number
279. 0.232 0.232 ↑ 1.0 549 1

Seq Scan on placercounty_registrations (cost=0.00..26.49 rows=549 width=13) (actual time=0.003..0.232 rows=549 loops=1)

280. 0.001 0.688 ↓ 0.0 0 1

Hash (cost=28.95..28.95 rows=25 width=24) (actual time=0.688..0.688 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
281. 0.002 0.687 ↓ 0.0 0 1

Subquery Scan on plp (cost=28.49..28.95 rows=25 width=24) (actual time=0.687..0.687 rows=0 loops=1)

282. 0.000 0.685 ↓ 0.0 0 1

Unique (cost=28.49..28.70 rows=25 width=24) (actual time=0.685..0.685 rows=0 loops=1)

283. 0.010 0.685 ↓ 0.0 0 1

Sort (cost=28.49..28.56 rows=28 width=24) (actual time=0.685..0.685 rows=0 loops=1)

  • Sort Key: parcel_level_policy.parcel_number
  • Sort Method: quicksort Memory: 25kB
284. 0.675 0.675 ↓ 0.0 0 1

Index Scan using parcel_level_policy_geoid_idx on parcel_level_policy (cost=0.29..27.82 rows=28 width=24) (actual time=0.675..0.675 rows=0 loops=1)

  • Index Cond: ((geoid)::text = '99999US09'::text)
285. 0.003 7.749 ↑ 20.0 1 1

Hash (cost=1,003.79..1,003.79 rows=20 width=13) (actual time=7.749..7.749 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
286. 2.898 7.746 ↑ 20.0 1 1

Unique (cost=0.42..1,003.59 rows=20 width=13) (actual time=0.067..7.746 rows=1 loops=1)

287. 4.848 4.848 ↑ 2.4 13,276 1

Index Only Scan using permit_registrations_geoid_status_idx on permit_registrations pr (cost=0.42..924.76 rows=31,532 width=13) (actual time=0.065..4.848 rows=13,276 loops=1)

  • Index Cond: ((geoid = '99999US09'::text) AND (status = 'active'::text))
  • Heap Fetches: 0
288. 0.008 0.026 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=58) (actual time=0.026..0.026 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
289. 0.018 0.018 ↑ 1.0 17 1

Seq Scan on compliance_status (cost=0.00..1.17 rows=17 width=58) (actual time=0.010..0.018 rows=17 loops=1)

290.          

SubPlan (forHash Join)

291. 0.000 0.000 ↓ 0.0 0

Index Scan using listing_pkey on listing listing_1 (cost=0.56..2.78 rows=1 width=4) (never executed)

  • Index Cond: (internal_listing_id = lpj.internal_listing_id)
292. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..66.65 rows=1 width=0) (never executed)

  • Join Filter: ((NOT ((p_1.parcel_number)::text IS DISTINCT FROM l_1.parcel_number)) AND (NOT (p_1.unit_number IS DISTINCT FROM l_1.unit_number)) AND (((lt.geoid)::text <> '16000US0666000'::text) OR ("left"(p_1.address, 3) = "left"(l_1.property_address, 3))))
293. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..37.08 rows=1 width=97) (never executed)

  • Join Filter: (NOT (p_1.assessor_source IS DISTINCT FROM (lt.assessor_source)::text))
294. 0.000 0.000 ↓ 0.0 0

Index Scan using property_pkey on property p_1 (cost=0.56..2.78 rows=1 width=65) (never executed)

  • Index Cond: (internal_property_id = lpj.internal_property_id)
295. 0.000 0.000 ↓ 0.0 0

Seq Scan on letter_template lt (cost=0.00..30.80 rows=280 width=65) (never executed)

296. 0.000 0.000 ↓ 0.0 0

Index Scan using letter_letter_id_hash on letter l_1 (cost=0.00..24.27 rows=212 width=83) (never executed)

  • Index Cond: (letter_id = (lt.id)::text)
297. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=34.30..13,583,160,349.40 rows=34,163 width=13) (never executed)

  • Join Filter: ((NOT (p_2.assessor_source IS DISTINCT FROM (lt_1.assessor_source)::text)) AND (NOT ((p_2.parcel_number)::text IS DISTINCT FROM l_2.parcel_number)) AND (NOT (p_2.unit_number IS DISTINCT FROM l_2.unit_number)) AND (((lt_1.geoid)::text <> '16000US0666000'::text) OR ("left"(p_2.address, 3) = "left"(l_2.property_address, 3))))
298. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=34.30..5,753.67 rows=34,163 width=82) (never executed)

  • Hash Cond: (l_2.letter_id = (lt_1.id)::text)
299. 0.000 0.000 ↓ 0.0 0

Seq Scan on letter l_2 (cost=0.00..5,249.63 rows=34,163 width=83) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Hash (cost=30.80..30.80 rows=280 width=65) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Seq Scan on letter_template lt_1 (cost=0.00..30.80 rows=280 width=65) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..791,394.20 rows=9,312,013 width=78) (never executed)

303. 0.000 0.000 ↓ 0.0 0

Seq Scan on property p_2 (cost=0.00..626,615.13 rows=9,312,013 width=78) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Index Only Scan using permit_registrations_geoid_status_idx on permit_registrations pr_1 (cost=0.42..41.64 rows=1,401 width=0) (never executed)

  • Index Cond: ((geoid = (lpj.geoid)::text) AND (status = 'active'::text))
  • Heap Fetches: 0
305. 0.000 0.000 ↓ 0.0 0

Index Only Scan using permit_registrations_geoid_status_idx on permit_registrations pr_2 (cost=0.42..5,308.56 rows=182,128 width=13) (never executed)

  • Index Cond: (status = 'active'::text)
  • Heap Fetches: 0
306. 514.241 514.241 ↑ 1.0 1 39,557

Index Scan using property_pkey on property (cost=0.56..1.82 rows=1 width=57) (actual time=0.013..0.013 rows=1 loops=39,557)

  • Index Cond: (internal_property_id = p.internal_property_id)
307. 13,632.880 29,191.378 ↑ 1.0 12,683,380 1

Hash (cost=1,153,304.88..1,153,304.88 rows=12,809,089 width=1,048) (actual time=29,191.378..29,191.378 rows=12,683,380 loops=1)

  • Buckets: 16384 Batches: 1024 Memory Usage: 2250kB
308. 4,894.340 15,558.498 ↑ 1.0 12,683,383 1

Append (cost=0.00..1,153,304.88 rows=12,809,089 width=1,048) (actual time=0.013..15,558.498 rows=12,683,383 loops=1)

309. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on assessor_master (cost=0.00..0.00 rows=1 width=1,871) (actual time=0.000..0.000 rows=0 loops=1)

310. 23.961 23.961 ↑ 1.0 28,880 1

Seq Scan on assessor_alameda_county_ca_2140fc0a90d54c01 (cost=0.00..1,774.80 rows=28,880 width=1,114) (actual time=0.009..23.961 rows=28,880 loops=1)

311. 58.865 58.865 ↑ 1.0 69,325 1

Seq Scan on assessor_arlington_county_va_3262dfdd743a4445 (cost=0.00..4,658.25 rows=69,325 width=726) (actual time=0.018..58.865 rows=69,325 loops=1)

312. 258.597 258.597 ↑ 1.0 352,327 1

Seq Scan on assessor_arlington_tx_19f9d48f80174876 (cost=0.00..19,054.27 rows=352,327 width=1,145) (actual time=0.012..258.597 rows=352,327 loops=1)

313. 4.391 4.391 ↑ 1.0 5,268 1

Seq Scan on assessor_beaufort_sc_fc802e02137b44fa (cost=0.00..359.68 rows=5,268 width=595) (actual time=0.012..4.391 rows=5,268 loops=1)

314. 36.946 36.946 ↑ 1.0 45,561 1

Seq Scan on assessor_buena_park_ca_aa42f34398dd474a (cost=0.00..2,685.61 rows=45,561 width=1,131) (actual time=0.013..36.946 rows=45,561 loops=1)

315. 4.592 4.592 ↑ 1.0 4,182 1

Seq Scan on assessor_casco_mi_5113ae42336e427d (cost=0.00..257.82 rows=4,182 width=963) (actual time=0.023..4.592 rows=4,182 loops=1)

316. 26.067 26.067 ↑ 1.0 25,061 1

Seq Scan on assessor_contra_costa_county_ca_3c0ba605a1ef405b (cost=0.00..1,539.61 rows=25,061 width=1,136) (actual time=0.014..26.067 rows=25,061 loops=1)

317. 12.152 12.152 ↑ 1.0 12,699 1

Seq Scan on assessor_coppell_tx_6782d465eae9445d (cost=0.00..842.99 rows=12,699 width=1,138) (actual time=0.015..12.152 rows=12,699 loops=1)

318. 19.104 19.104 ↑ 1.0 23,540 1

Seq Scan on assessor_dana_point_ca_d39664795202410f (cost=0.00..1,459.40 rows=23,540 width=1,141) (actual time=0.013..19.104 rows=23,540 loops=1)

319. 118.274 118.274 ↑ 1.0 109,900 1

Seq Scan on assessor_durham_county_nc_aa6110175fac41ec (cost=0.00..6,733.10 rows=111,710 width=1,117) (actual time=0.014..118.274 rows=109,900 loops=1)

320. 92.060 92.060 ↑ 1.0 110,788 1

Seq Scan on assessor_dutchess_county_ny_a3c286fd2d7644b1 (cost=0.00..7,318.88 rows=110,788 width=1,125) (actual time=0.013..92.060 rows=110,788 loops=1)

321. 46.525 46.525 ↑ 1.0 39,638 1

Seq Scan on assessor_eagle_county_co_58b9e20bd0f4414b (cost=0.00..5,037.38 rows=39,638 width=747) (actual time=0.005..46.525 rows=39,638 loops=1)

322. 2.486 2.486 ↑ 1.0 2,825 1

Seq Scan on assessor_el_paso_county_co_51247c7b1bfb477d (cost=0.00..202.25 rows=2,825 width=1,117) (actual time=0.015..2.486 rows=2,825 loops=1)

323. 294.602 294.602 ↑ 1.0 346,693 1

Seq Scan on assessor_fairfax_county_va_bc2c864d9db4492b (cost=0.00..23,272.93 rows=346,693 width=1,113) (actual time=0.013..294.602 rows=346,693 loops=1)

324. 25.604 25.604 ↑ 1.0 27,315 1

Seq Scan on assessor_flathead_county_mt_ff793f07bbde4c61 (cost=0.00..1,770.15 rows=27,315 width=1,142) (actual time=0.016..25.604 rows=27,315 loops=1)

325. 0.092 0.092 ↑ 1.0 37 1

Seq Scan on assessor_glynn_county_ga_15730844c7b641ea (cost=0.00..3.37 rows=37 width=1,126) (actual time=0.013..0.092 rows=37 loops=1)

326. 28.327 28.327 ↑ 1.0 27,502 1

Seq Scan on assessor_grapevine_tx_ba7f7ab9c9294c97 (cost=0.00..1,721.02 rows=27,502 width=1,170) (actual time=0.012..28.327 rows=27,502 loops=1)

327. 11.704 11.704 ↑ 1.0 13,497 1

Seq Scan on assessor_holland_mi_ea53583e81014141 (cost=0.00..904.97 rows=13,497 width=1,126) (actual time=0.015..11.704 rows=13,497 loops=1)

328. 119.233 119.233 ↑ 1.0 170,270 1

Seq Scan on assessor_honolulu_county_hi_a3e1407380c0451b (cost=0.00..8,331.70 rows=170,270 width=1,127) (actual time=0.013..119.233 rows=170,270 loops=1)

329. 3.855 3.855 ↑ 1.0 4,291 1

Seq Scan on assessor_indian_harbour_beach_fl_132d04726c164566 (cost=0.00..330.91 rows=4,291 width=1,142) (actual time=0.014..3.855 rows=4,291 loops=1)

330. 79.696 79.696 ↑ 1.0 90,597 1

Seq Scan on assessor_indian_river_county_fl_5cd05d8e82144ac2 (cost=0.00..6,513.97 rows=90,597 width=1,127) (actual time=0.012..79.696 rows=90,597 loops=1)

331. 57.922 57.922 ↑ 1.0 71,550 1

Seq Scan on assessor_knoxville_tn_4051c459fd784e31 (cost=0.00..4,447.50 rows=71,550 width=858) (actual time=0.013..57.922 rows=71,550 loops=1)

332. 9.033 9.033 ↑ 1.0 10,419 1

Seq Scan on assessor_lake_bluff_il_fe7c7f48d18e486b (cost=0.00..717.19 rows=10,419 width=1,108) (actual time=0.015..9.033 rows=10,419 loops=1)

333. 82.071 82.071 ↑ 1.0 105,844 1

Seq Scan on assessor_lane_county_or_fbfe09929d584acd (cost=0.00..6,049.08 rows=105,908 width=1,100) (actual time=0.017..82.071 rows=105,844 loops=1)

334. 20.106 20.106 ↑ 1.0 26,200 1

Seq Scan on assessor_la_plata_county_co_161e0885636e4666 (cost=0.00..1,488.43 rows=26,243 width=1,127) (actual time=0.012..20.106 rows=26,200 loops=1)

335. 96.000 96.000 ↑ 1.0 115,672 1

Seq Scan on assessor_larimer_county_co_4691458b1e694e5e (cost=0.00..7,539.72 rows=115,672 width=977) (actual time=0.015..96.000 rows=115,672 loops=1)

336. 296.639 296.639 ↑ 1.0 382,198 1

Seq Scan on assessor_las_vegas_nv_f951bd5dc54f495b (cost=0.00..23,122.38 rows=382,238 width=1,099) (actual time=0.015..296.639 rows=382,198 loops=1)

337. 2.716 2.716 ↑ 1.0 3,788 1

Seq Scan on assessor_lenox_ma_c59abe06e5544030 (cost=0.00..200.88 rows=3,788 width=1,170) (actual time=0.013..2.716 rows=3,788 loops=1)

338. 65.322 65.322 ↑ 1.0 83,234 1

Seq Scan on assessor_los_angeles_county_ca_a0ba9f83a3a74c7b (cost=0.00..5,140.34 rows=83,234 width=985) (actual time=0.014..65.322 rows=83,234 loops=1)

339. 45.197 45.197 ↑ 1.0 59,338 1

Seq Scan on assessor_madera_county_ca_793fa2de6d8d4f28 (cost=0.00..3,510.38 rows=59,338 width=1,139) (actual time=0.013..45.197 rows=59,338 loops=1)

340. 5.737 5.737 ↑ 1.0 7,109 1

Seq Scan on assessor_malibu_ca_0845a6fcbb9c4cd7 (cost=0.00..464.09 rows=7,109 width=1,132) (actual time=0.013..5.737 rows=7,109 loops=1)

341. 2.626 2.626 ↑ 1.0 3,112 1

Seq Scan on assessor_maplewood_mo_f6a496c371b948d5 (cost=0.00..215.12 rows=3,112 width=613) (actual time=0.012..2.626 rows=3,112 loops=1)

342. 129.882 129.882 ↑ 1.0 168,360 1

Seq Scan on assessor_maricopa_county_az_1310d115da1e401e (cost=0.00..9,923.01 rows=168,401 width=1,124) (actual time=0.013..129.882 rows=168,360 loops=1)

343. 54.426 54.426 ↑ 1.0 67,490 1

Seq Scan on assessor_marin_county_ca_5e9be0dfb41b4b69 (cost=0.00..4,137.27 rows=67,627 width=1,133) (actual time=0.014..54.426 rows=67,490 loops=1)

344. 11.689 11.689 ↑ 1.0 14,286 1

Seq Scan on assessor_mariposa_county_ca_adf688d000c946f6 (cost=0.00..930.86 rows=14,286 width=1,116) (actual time=0.013..11.689 rows=14,286 loops=1)

345. 62.007 62.007 ↑ 1.0 78,456 1

Seq Scan on assessor_martin_county_fl_d39775dc28f54bae (cost=0.00..4,957.56 rows=78,456 width=1,125) (actual time=0.016..62.007 rows=78,456 loops=1)

346. 35.212 35.212 ↑ 1.0 46,811 1

Seq Scan on assessor_maui_county_hi_ab040cda4b2e4d48 (cost=0.00..2,615.11 rows=46,811 width=1,100) (actual time=0.014..35.212 rows=46,811 loops=1)

347. 53.933 53.933 ↑ 1.0 71,959 1

Seq Scan on assessor_mendocino_county_ca_eebd45525e244e9e (cost=0.00..4,193.59 rows=71,959 width=1,171) (actual time=0.013..53.933 rows=71,959 loops=1)

348. 74.130 74.130 ↑ 1.0 79,696 1

Seq Scan on assessor_miami_dade_county_fl_c11f3ae1c6aa45f1 (cost=0.00..6,291.96 rows=79,696 width=1,122) (actual time=0.014..74.130 rows=79,696 loops=1)

349. 3.795 3.795 ↑ 1.0 4,667 1

Seq Scan on assessor_monmouth_county_nj_d1e2578feb474e0a (cost=0.00..294.67 rows=4,667 width=1,177) (actual time=0.013..3.795 rows=4,667 loops=1)

350. 17.029 17.029 ↑ 1.0 20,392 1

Seq Scan on assessor_mono_county_ca_48e87d96928e4012 (cost=0.00..1,386.92 rows=20,392 width=610) (actual time=0.013..17.029 rows=20,392 loops=1)

351. 73.259 73.259 ↑ 1.0 89,259 1

Seq Scan on assessor_monroe_county_fl_3869d98d04d34e23 (cost=0.00..5,851.59 rows=89,259 width=586) (actual time=0.004..73.259 rows=89,259 loops=1)

352. 18.817 18.817 ↑ 1.0 25,019 1

Seq Scan on assessor_napa_ca_6121cc9120de42a4 (cost=0.00..1,415.19 rows=25,019 width=1,060) (actual time=0.014..18.817 rows=25,019 loops=1)

353. 15.090 15.090 ↑ 1.0 19,184 1

Seq Scan on assessor_napa_county_ca_cbfa387c66264992 (cost=0.00..1,211.84 rows=19,184 width=1,144) (actual time=0.012..15.090 rows=19,184 loops=1)

354. 3.019 3.019 ↑ 1.0 4,006 1

Seq Scan on assessor_nelson_bc_ec1e1aea81364882 (cost=0.00..243.26 rows=4,026 width=1,102) (actual time=0.013..3.019 rows=4,006 loops=1)

355. 27.799 27.799 ↑ 1.0 36,064 1

Seq Scan on assessor_newport_beach_ca_0aa2254bb33e4817 (cost=0.00..2,184.64 rows=36,064 width=975) (actual time=0.013..27.799 rows=36,064 loops=1)

356. 11.801 11.801 ↑ 1.0 14,052 1

Seq Scan on assessor_oakland_park_fl_6e32bc7de7554f8d (cost=0.00..984.52 rows=14,052 width=1,141) (actual time=0.014..11.801 rows=14,052 loops=1)

357. 104.035 104.035 ↑ 1.0 131,975 1

Seq Scan on assessor_orange_county_fl_37f421a34ff74bdf (cost=0.00..7,777.39 rows=132,139 width=1,185) (actual time=0.014..104.035 rows=131,975 loops=1)

358. 109.483 109.483 ↑ 1.0 116,667 1

Seq Scan on assessor_orlando_fl_17493e7181d748af (cost=0.00..7,847.67 rows=116,667 width=967) (actual time=0.016..109.483 rows=116,667 loops=1)

359. 40.685 40.685 ↑ 1.0 39,447 1

Seq Scan on assessor_pasadena_ca_1fd922b2e9de424b (cost=0.00..2,990.47 rows=39,447 width=966) (actual time=0.016..40.685 rows=39,447 loops=1)

360. 28.199 28.199 ↑ 1.0 26,761 1

Seq Scan on assessor_petaluma_ca_9c0e4b4b78dd48c8 (cost=0.00..2,209.61 rows=26,761 width=1,150) (actual time=0.016..28.199 rows=26,761 loops=1)

361. 3.507 3.507 ↑ 1.0 3,868 1

Seq Scan on assessor_piedmont_ca_ffea2b3f783e411a (cost=0.00..253.68 rows=3,868 width=992) (actual time=0.016..3.507 rows=3,868 loops=1)

362. 21.490 21.490 ↑ 1.0 24,092 1

Seq Scan on assessor_portland_me_1023e1af508947b0 (cost=0.00..1,526.92 rows=24,092 width=1,095) (actual time=0.014..21.490 rows=24,092 loops=1)

363. 38.061 38.061 ↑ 1.0 45,378 1

Seq Scan on assessor_prescott_az_f10ad646895148bb (cost=0.00..2,649.78 rows=45,378 width=1,134) (actual time=0.013..38.061 rows=45,378 loops=1)

364. 3.853 3.853 ↑ 1.0 3,263 1

Seq Scan on assessor_revelstoke_bc_777586092eec4145 (cost=0.00..214.63 rows=3,263 width=816) (actual time=0.018..3.853 rows=3,263 loops=1)

365. 94.663 94.663 ↑ 1.0 82,865 1

Seq Scan on assessor_riverside_county_ca_6e4b1d7145f24ac9 (cost=0.00..5,444.01 rows=84,201 width=1,149) (actual time=0.018..94.663 rows=82,865 loops=1)

366. 2.412 2.412 ↑ 1.0 2,742 1

Seq Scan on assessor_rossland_bc_8713f203bb3642b1 (cost=0.00..165.42 rows=2,742 width=1,083) (actual time=0.018..2.412 rows=2,742 loops=1)

367. 16.596 16.596 ↑ 1.0 17,581 1

Seq Scan on assessor_san_marcos_tx_96b2bad78d42444f (cost=0.00..1,178.81 rows=17,581 width=996) (actual time=0.017..16.596 rows=17,581 loops=1)

368. 6.807 6.807 ↑ 1.0 7,307 1

Seq Scan on assessor_san_mateo_county_ca_ef8b46ccc8414877 (cost=0.00..521.07 rows=7,307 width=856) (actual time=0.004..6.807 rows=7,307 loops=1)

369. 101.776 101.776 ↑ 1.0 99,648 1

Seq Scan on assessor_santa_cruz_county_ca_d0e3f0d1a6e6404b (cost=0.00..7,829.48 rows=99,648 width=1,154) (actual time=0.017..101.776 rows=99,648 loops=1)

370. 60.252 60.252 ↑ 1.0 61,266 1

Seq Scan on assessor_sarasota_county_fl_db132f6b066f4ba1 (cost=0.00..4,247.66 rows=61,266 width=969) (actual time=0.015..60.252 rows=61,266 loops=1)

371. 34.749 34.749 ↑ 1.0 40,644 1

Seq Scan on assessor_sawyer_county_wi_81016738c88e49ac (cost=0.00..2,326.44 rows=40,644 width=1,148) (actual time=0.015..34.749 rows=40,644 loops=1)

372. 24.527 24.527 ↑ 1.0 11,292 1

Seq Scan on assessor_solano_county_ca_82192e65550b43e0 (cost=0.00..2,822.92 rows=11,292 width=1,165) (actual time=0.015..24.527 rows=11,292 loops=1)

373. 4.435 4.435 ↑ 1.0 4,632 1

Seq Scan on assessor_sonoma_county_ca_3eeb161470914f73 (cost=0.00..319.32 rows=4,632 width=1,149) (actual time=0.014..4.435 rows=4,632 loops=1)

374. 14.702 14.702 ↑ 1.0 15,219 1

Seq Scan on assessor_south_lake_tahoe_ca_37c5e13796674bef (cost=0.00..1,092.19 rows=15,219 width=1,003) (actual time=0.016..14.702 rows=15,219 loops=1)

375. 126.931 126.931 ↑ 1.0 139,025 1

Seq Scan on assessor_st_johns_county_fl_9bc627b9355f4b15 (cost=0.00..9,198.25 rows=139,025 width=1,155) (actual time=0.016..126.931 rows=139,025 loops=1)

376. 8.938 8.938 ↑ 1.0 12,530 1

Seq Scan on assessor_sun_peaks_bc_1bdb590dd315404e (cost=0.00..546.30 rows=12,530 width=1,123) (actual time=0.015..8.938 rows=12,530 loops=1)

377. 1.841 1.841 ↑ 1.0 1,946 1

Seq Scan on assessor_suttons_bay_mi_4fae44266331495b (cost=0.00..141.46 rows=1,946 width=1,147) (actual time=0.017..1.841 rows=1,946 loops=1)

378. 32.124 32.124 ↑ 1.0 32,890 1

Seq Scan on assessor_tamarac_fl_ebc06a52caea48ea (cost=0.00..2,349.90 rows=32,890 width=1,099) (actual time=0.016..32.124 rows=32,890 loops=1)

379. 5.212 5.212 ↑ 1.0 4,667 1

Seq Scan on assessor_taos_county_nm_2b15473860264850 (cost=0.00..403.67 rows=4,667 width=883) (actual time=0.015..5.212 rows=4,667 loops=1)

380. 4.412 4.412 ↑ 1.0 4,862 1

Seq Scan on assessor_teton_county_wy_08c55071ca944f14 (cost=0.00..307.62 rows=4,862 width=1,004) (actual time=0.015..4.412 rows=4,862 loops=1)

381. 13.379 13.379 ↑ 1.0 14,550 1

Seq Scan on assessor_tofino_bc_9d44fa4331d849cd (cost=0.00..919.50 rows=14,550 width=1,151) (actual time=0.017..13.379 rows=14,550 loops=1)

382. 19.945 19.945 ↑ 1.0 21,987 1

Seq Scan on assessor_ucluelet_bc_e6251e82ee8044ec (cost=0.00..1,366.87 rows=21,987 width=992) (actual time=0.016..19.945 rows=21,987 loops=1)

383. 36.286 36.286 ↑ 1.0 46,584 1

Seq Scan on assessor_vermont_bbddb672dfb8473e (cost=0.00..2,355.84 rows=46,584 width=1,137) (actual time=0.016..36.286 rows=46,584 loops=1)

384. 24.515 24.515 ↑ 1.0 28,931 1

Seq Scan on assessor_victoria_bc_52ef0b03daf748c1 (cost=0.00..1,705.31 rows=28,931 width=1,203) (actual time=0.017..24.515 rows=28,931 loops=1)

385. 180.615 180.615 ↑ 1.0 161,286 1

Seq Scan on assessor_virginia_beach_va_7ac246f385914a1d (cost=0.00..14,972.86 rows=161,286 width=1,247) (actual time=0.017..180.615 rows=161,286 loops=1)

386. 37.894 37.894 ↑ 1.0 42,905 1

Seq Scan on assessor_walton_county_fl_fcb628587c614a48 (cost=0.00..3,122.05 rows=42,905 width=1,144) (actual time=0.004..37.894 rows=42,905 loops=1)

387. 10.572 10.572 ↑ 1.0 9,657 1

Seq Scan on assessor_west_hollywood_ca_0ad80d9e052d49bf (cost=0.00..818.57 rows=9,657 width=874) (actual time=0.014..10.572 rows=9,657 loops=1)

388. 23.705 23.705 ↑ 1.0 23,391 1

Seq Scan on assessor_yorba_linda_ca_601b0e9dbd6741a3 (cost=0.00..1,780.91 rows=23,391 width=1,116) (actual time=0.014..23.705 rows=23,391 loops=1)

389. 12.452 12.452 ↑ 1.0 13,350 1

Seq Scan on assessor_yucca_valley_ca_991b980d76e5478f (cost=0.00..898.50 rows=13,350 width=1,120) (actual time=0.016..12.452 rows=13,350 loops=1)

390. 8.477 8.477 ↑ 1.0 6,509 1

Seq Scan on assessor_marquette_county_mi_0cbee586637f4332 (cost=0.00..825.09 rows=6,509 width=1,143) (actual time=0.057..8.477 rows=6,509 loops=1)

391. 290.099 290.099 ↑ 1.0 230,669 1

Seq Scan on assessor_denver_co_6e0a991a8fb7435d (cost=0.00..27,528.69 rows=230,669 width=960) (actual time=0.017..290.099 rows=230,669 loops=1)

392. 176.844 176.844 ↑ 1.0 132,268 1

Seq Scan on assessor_santa_barbara_county_ca_d44970aa7bb94eb0 (cost=0.00..17,078.68 rows=132,268 width=878) (actual time=0.451..176.844 rows=132,268 loops=1)

393. 74.628 74.628 ↑ 1.0 52,599 1

Seq Scan on assessor_lee_county_fl_18fc47cddcad4743 (cost=0.00..6,984.99 rows=52,599 width=987) (actual time=0.015..74.628 rows=52,599 loops=1)

394. 10.774 10.774 ↑ 1.0 7,958 1

Seq Scan on assessor_east_bay_township_mi_c0b85928790f4246 (cost=0.00..1,014.58 rows=7,958 width=897) (actual time=3.026..10.774 rows=7,958 loops=1)

395. 2.732 2.732 ↑ 1.0 2,344 1

Seq Scan on assessor_driggs_id_2ebfbebfc56149aa (cost=0.00..248.44 rows=2,344 width=1,154) (actual time=0.693..2.732 rows=2,344 loops=1)

396. 147.086 147.086 ↑ 1.0 121,104 1

Seq Scan on assessor_asheville_nc_f813d3c87eb34adb (cost=0.00..13,284.04 rows=121,104 width=921) (actual time=0.118..147.086 rows=121,104 loops=1)

397. 40.168 40.168 ↑ 1.0 25,966 1

Seq Scan on assessor_douglas_county_nv_bd00177a8b504c95 (cost=0.00..3,984.66 rows=25,966 width=604) (actual time=0.015..40.168 rows=25,966 loops=1)

398. 13.648 13.648 ↑ 1.0 15,369 1

Seq Scan on assessor_del_norte_county_ca_510c4787ef0041c4 (cost=0.00..966.69 rows=15,369 width=1,127) (actual time=0.015..13.648 rows=15,369 loops=1)

399. 197.667 197.667 ↑ 1.0 121,306 1

Seq Scan on assessor_monterey_county_ca_155b4757b2fb483f (cost=0.00..21,015.06 rows=121,306 width=1,009) (actual time=41.511..197.667 rows=121,306 loops=1)

400. 0.218 0.218 ↑ 1.0 147 1

Seq Scan on assessor_boston_ma_e1479ec6e26c412c (cost=0.00..21.47 rows=147 width=1,146) (actual time=0.089..0.218 rows=147 loops=1)

401. 325.203 325.203 ↑ 1.0 171,609 1

Seq Scan on assessor_placer_county_ca_f2273f13841c4e48 (cost=0.00..39,511.25 rows=172,025 width=1,086) (actual time=0.015..325.203 rows=171,609 loops=1)

402. 331.249 331.249 ↓ 1.0 255,371 1

Seq Scan on assessor_nashville_tn_39405bcc5d0b4771 (cost=0.00..32,981.78 rows=255,178 width=989) (actual time=0.019..331.249 rows=255,371 loops=1)

403. 7.748 7.748 ↑ 1.0 10,655 1

Seq Scan on assessor_ventura_county_ca_ccc24a0684b043f3 (cost=0.00..1,142.55 rows=10,655 width=1,053) (actual time=0.012..7.748 rows=10,655 loops=1)

404. 34.402 34.402 ↑ 1.0 48,137 1

Seq Scan on assessor_rockingham_county_va_cffd52fe180645af (cost=0.00..5,004.37 rows=48,137 width=1,055) (actual time=0.178..34.402 rows=48,137 loops=1)

405. 2.237 2.237 ↑ 1.0 2,901 1

Seq Scan on assessor_collegedale_tn_6aa970dc665e4bef (cost=0.00..349.01 rows=2,901 width=1,164) (actual time=0.127..2.237 rows=2,901 loops=1)

406. 24.834 24.834 ↑ 1.0 33,015 1

Seq Scan on assessor_sunnyvale_ca_bfaee40a08e540cb (cost=0.00..3,817.15 rows=33,015 width=1,137) (actual time=0.065..24.834 rows=33,015 loops=1)

407. 24.379 24.379 ↑ 1.0 30,485 1

Seq Scan on assessor_new_braunfels_tx_7184eb6576fa462d (cost=0.00..3,860.85 rows=30,485 width=874) (actual time=0.046..24.379 rows=30,485 loops=1)

408. 3.214 3.214 ↑ 1.0 4,445 1

Seq Scan on assessor_los_altos_hills_ca_eba63a5a5af64615 (cost=0.00..477.45 rows=4,445 width=1,191) (actual time=0.010..3.214 rows=4,445 loops=1)

409. 4.719 4.719 ↑ 1.0 5,967 1

Seq Scan on assessor_holmes_beach_fl_eee3440dbcb6413e (cost=0.00..760.67 rows=5,967 width=1,138) (actual time=0.270..4.719 rows=5,967 loops=1)

410. 7.563 7.563 ↑ 1.0 9,328 1

Seq Scan on assessor_south_portland_me_d474fc2830eb4772 (cost=0.00..1,217.28 rows=9,328 width=1,030) (actual time=0.005..7.563 rows=9,328 loops=1)

411. 16.450 16.450 ↑ 1.0 20,814 1

Seq Scan on assessor_redwood_city_ca_7cea3cc128ce4727 (cost=0.00..2,681.14 rows=20,814 width=877) (actual time=0.007..16.450 rows=20,814 loops=1)

412. 94.208 94.208 ↑ 1.0 124,214 1

Seq Scan on assessor_boulder_county_co_91fb110cd94043c8 (cost=0.00..14,475.14 rows=124,214 width=1,008) (actual time=0.733..94.208 rows=124,214 loops=1)

413. 28.542 28.542 ↑ 1.0 41,282 1

Seq Scan on assessor_tuolumne_county_ca_cdd383fb4e9449d9 (cost=0.00..2,592.82 rows=41,282 width=1,126) (actual time=0.005..28.542 rows=41,282 loops=1)

414. 4.109 4.109 ↑ 1.0 5,739 1

Seq Scan on assessor_albany_ca_65e90507932c419b (cost=0.00..594.39 rows=5,739 width=1,130) (actual time=0.223..4.109 rows=5,739 loops=1)

415. 4.041 4.041 ↑ 1.0 5,064 1

Seq Scan on assessor_hood_river_county_or_5c35f0da0b3541ce (cost=0.00..648.64 rows=5,064 width=1,176) (actual time=0.237..4.041 rows=5,064 loops=1)

416. 10.542 10.542 ↑ 1.0 15,174 1

Seq Scan on assessor_penticton_bc_0ba5a823796f4b42 (cost=0.00..970.74 rows=15,174 width=1,128) (actual time=0.004..10.542 rows=15,174 loops=1)

417. 1.961 1.961 ↑ 1.0 2,503 1

Seq Scan on assessor_williams_bay_wi_dfab8a075b5544aa (cost=0.00..303.03 rows=2,503 width=1,165) (actual time=0.117..1.961 rows=2,503 loops=1)

418. 0.985 0.985 ↑ 1.0 1,357 1

Seq Scan on assessor_connestee_falls_nc_305175fcd5a643e5 (cost=0.00..147.57 rows=1,357 width=1,185) (actual time=0.004..0.985 rows=1,357 loops=1)

419. 23.886 23.886 ↑ 1.0 32,371 1

Seq Scan on assessor_garden_grove_ca_416b5aa8ac2442d8 (cost=0.00..3,554.71 rows=32,371 width=1,047) (actual time=0.060..23.886 rows=32,371 loops=1)

420. 101.251 101.251 ↑ 1.0 118,825 1

Seq Scan on assessor_loudoun_county_va_ce6c1d66f0274472 (cost=0.00..16,572.25 rows=118,825 width=892) (actual time=1.537..101.251 rows=118,825 loops=1)

421. 61.397 61.397 ↑ 1.9 76,463 1

Seq Scan on assessor_hall_county_ga_unincorporated_1aca2434ca314a97 (cost=0.00..11,053.68 rows=141,668 width=884) (actual time=0.005..61.397 rows=76,463 loops=1)

422. 49.824 49.824 ↑ 1.0 63,525 1

Seq Scan on assessor_nevada_county_ca_e708945e3e7b4b1b (cost=0.00..8,012.25 rows=63,525 width=877) (actual time=0.004..49.824 rows=63,525 loops=1)

423. 2.457 2.457 ↑ 1.0 3,058 1

Seq Scan on assessor_sausalito_ca_276099f310e34338 (cost=0.00..387.58 rows=3,058 width=1,084) (actual time=0.063..2.457 rows=3,058 loops=1)

424. 536.125 536.125 ↑ 1.0 694,688 1

Seq Scan on assessor_san_antonio_tx_8147f36cb4b04c99 (cost=0.00..86,930.76 rows=695,876 width=787) (actual time=0.005..536.125 rows=694,688 loops=1)

425. 2.672 2.672 ↑ 1.0 3,389 1

Seq Scan on assessor_indian_wells_ca_e74205b7cf374d0f (cost=0.00..581.89 rows=3,389 width=1,134) (actual time=0.151..2.672 rows=3,389 loops=1)

426. 329.376 329.376 ↑ 1.0 424,544 1

Seq Scan on assessor_broward_county_fl_54568cf8aec1441c (cost=0.00..57,197.22 rows=440,922 width=1,166) (actual time=0.439..329.376 rows=424,544 loops=1)

427. 2.614 2.614 ↑ 1.0 3,468 1

Seq Scan on assessor_frisco_co_33a2c6fd3ff04245 (cost=0.00..427.68 rows=3,468 width=981) (actual time=0.136..2.614 rows=3,468 loops=1)

428. 5.819 5.819 ↑ 1.0 8,239 1

Seq Scan on assessor_breckenridge_co_8a74ce3e128c4548 (cost=0.00..583.39 rows=8,239 width=1,142) (actual time=0.005..5.819 rows=8,239 loops=1)

429. 22.905 22.905 ↑ 1.0 33,155 1

Seq Scan on assessor_redding_ca_a960c2a6977d47b8 (cost=0.00..2,111.05 rows=33,305 width=993) (actual time=0.004..22.905 rows=33,155 loops=1)

430. 6.800 6.800 ↑ 1.0 9,413 1

Seq Scan on assessor_newport_county_ri_6c0661dbb60e44d2 (cost=0.00..619.13 rows=9,413 width=984) (actual time=0.004..6.800 rows=9,413 loops=1)

431. 75.025 75.025 ↑ 1.0 103,087 1

Seq Scan on assessor_alachua_county_fl_1a46db0573604880 (cost=0.00..11,664.87 rows=103,087 width=1,194) (actual time=0.003..75.025 rows=103,087 loops=1)

432. 60.220 60.220 ↑ 1.0 76,301 1

Seq Scan on assessor_page_az_b494526f192e40ff (cost=0.00..8,438.01 rows=76,301 width=1,128) (actual time=0.300..60.220 rows=76,301 loops=1)

433. 42.363 42.363 ↑ 1.0 47,754 1

Seq Scan on assessor_wilmington_nc_f5f27c9dab984c06 (cost=0.00..5,691.54 rows=47,754 width=1,027) (actual time=0.015..42.363 rows=47,754 loops=1)

434. 3.237 3.237 ↑ 1.0 4,347 1

Seq Scan on assessor_hailey_id_5a4d3d75f8b94e26 (cost=0.00..501.47 rows=4,347 width=1,126) (actual time=0.184..3.237 rows=4,347 loops=1)

435. 19.787 19.787 ↑ 1.0 25,644 1

Seq Scan on assessor_alexandria_va_5efbeca77575478d (cost=0.00..3,045.44 rows=25,644 width=1,022) (actual time=0.098..19.787 rows=25,644 loops=1)

436. 65.601 65.601 ↑ 1.0 79,753 1

Seq Scan on assessor_madison_wi_37c3f18db22f4b9a (cost=0.00..10,063.53 rows=79,753 width=1,015) (actual time=0.004..65.601 rows=79,753 loops=1)

437. 1.188 1.188 ↑ 1.0 1,469 1

Seq Scan on assessor_gearhart_or_d32e1239534a4186 (cost=0.00..182.69 rows=1,469 width=988) (actual time=0.068..1.188 rows=1,469 loops=1)

438. 0.964 0.964 ↑ 1.0 1,209 1

Seq Scan on assessor_garden_city_ut_eb914c2128bc422e (cost=0.00..160.09 rows=1,209 width=1,143) (actual time=0.059..0.964 rows=1,209 loops=1)

439. 1.713 1.713 ↑ 1.0 2,262 1

Seq Scan on assessor_moab_ut_808fc2566da84170 (cost=0.00..249.62 rows=2,262 width=969) (actual time=0.083..1.713 rows=2,262 loops=1)

440. 158.114 158.114 ↑ 1.0 209,212 1

Seq Scan on assessor_austin_tx_f6572d91c36f4e9f (cost=0.00..24,314.12 rows=209,212 width=1,126) (actual time=0.544..158.114 rows=209,212 loops=1)

441. 111.873 111.873 ↑ 1.0 156,345 1

Seq Scan on assessor_tulare_county_ca_25c67a45378648fd (cost=0.00..16,906.45 rows=156,345 width=1,166) (actual time=3.226..111.873 rows=156,345 loops=1)

442. 28.633 28.633 ↑ 1.0 41,085 1

Seq Scan on assessor_summit_county_ut_df245175543640ca (cost=0.00..4,209.85 rows=41,085 width=1,157) (actual time=0.378..28.633 rows=41,085 loops=1)

443. 704.821 704.821 ↑ 1.0 909,757 1

Seq Scan on assessor_san_diego_county_ca_5c3d607356664645 (cost=0.00..114,170.57 rows=909,757 width=988) (actual time=0.100..704.821 rows=909,757 loops=1)

444. 47.146 47.146 ↑ 1.0 64,137 1

Seq Scan on assessor_lake_county_ca_7c3b5d982a5d4b25 (cost=0.00..7,402.37 rows=64,137 width=1,169) (actual time=0.033..47.146 rows=64,137 loops=1)

445. 23.346 23.346 ↑ 1.0 28,400 1

Seq Scan on assessor_marin_county_ca_unincorporated_20c395697d0e4470 (cost=0.00..3,949.00 rows=28,400 width=1,154) (actual time=0.322..23.346 rows=28,400 loops=1)

446. 3.934 3.934 ↑ 1.0 5,292 1

Seq Scan on assessor_kane_county_ut_cc31fab012c54796 (cost=0.00..630.92 rows=5,292 width=994) (actual time=0.010..3.934 rows=5,292 loops=1)

447. 7.867 7.867 ↑ 1.0 10,819 1

Seq Scan on assessor_lehman_township_pa_bf800d907ffc47af (cost=0.00..1,301.19 rows=10,819 width=985) (actual time=0.132..7.867 rows=10,819 loops=1)

448. 1.265 1.265 ↑ 1.0 1,626 1

Seq Scan on assessor_anna_maria_fl_c0b4b797a8f14296 (cost=0.00..213.26 rows=1,626 width=1,019) (actual time=0.073..1.265 rows=1,626 loops=1)

449. 2.058 2.058 ↑ 1.0 2,673 1

Seq Scan on assessor_silverthorne_co_10fc3895b1bf4a62 (cost=0.00..345.73 rows=2,673 width=1,008) (actual time=0.112..2.058 rows=2,673 loops=1)

450. 7.480 7.480 ↑ 1.0 9,705 1

Seq Scan on assessor_big_bear_lake_ca_8f097e18cb894ab4 (cost=0.00..1,275.05 rows=9,705 width=1,009) (actual time=0.143..7.480 rows=9,705 loops=1)

451. 36.640 36.640 ↑ 1.0 47,214 1

Seq Scan on assessor_roseville_ca_4d670f6793f74f1c (cost=0.00..6,041.14 rows=47,214 width=1,051) (actual time=1.854..36.640 rows=47,214 loops=1)

452. 54.036 54.036 ↑ 1.0 75,727 1

Seq Scan on assessor_chattanooga_tn_38e262c7baa04eda (cost=0.00..8,385.27 rows=75,727 width=1,033) (actual time=0.004..54.036 rows=75,727 loops=1)

453. 1.769 1.769 ↑ 1.0 2,424 1

Seq Scan on assessor_angel_fire_nm_be382a82b81043fa (cost=0.00..190.50 rows=2,450 width=1,019) (actual time=0.005..1.769 rows=2,424 loops=1)

454. 3.049 3.049 ↑ 1.0 4,240 1

Seq Scan on assessor_beech_mountain_nc_43d5f02f856740ca (cost=0.00..310.40 rows=4,240 width=1,161) (actual time=0.004..3.049 rows=4,240 loops=1)

455. 0.946 0.946 ↑ 1.0 1,401 1

Seq Scan on assessor_dillon_co_3373607f8c4b4c1b (cost=0.00..99.01 rows=1,401 width=983) (actual time=0.005..0.946 rows=1,401 loops=1)

456. 1.458 1.458 ↑ 1.0 2,027 1

Seq Scan on assessor_blowing_rock_nc_edddaaba07554aea (cost=0.00..137.99 rows=2,099 width=1,147) (actual time=0.004..1.458 rows=2,027 loops=1)

457. 1.853 1.853 ↑ 1.0 2,538 1

Seq Scan on assessor_folly_beach_sc_46310055eddd40f1 (cost=0.00..215.38 rows=2,538 width=1,137) (actual time=0.004..1.853 rows=2,538 loops=1)

458. 7.298 7.298 ↑ 1.0 10,919 1

Seq Scan on assessor_bozeman_mt_e52b17bcbf034652 (cost=0.00..702.65 rows=11,165 width=1,137) (actual time=0.005..7.298 rows=10,919 loops=1)

459. 0.981 0.981 ↑ 1.0 1,408 1

Seq Scan on assessor_fraser_co_6efcb0645b5048d1 (cost=0.00..102.08 rows=1,408 width=1,130) (actual time=0.003..0.981 rows=1,408 loops=1)

460. 16.934 16.934 ↑ 1.0 25,954 1

Seq Scan on assessor_chico_ca_fb1090c1d58c4085 (cost=0.00..1,589.73 rows=26,473 width=1,121) (actual time=0.004..16.934 rows=25,954 loops=1)

461. 9.275 9.275 ↑ 1.0 14,001 1

Seq Scan on assessor_franklin_county_ny_97c569a37fa44e4a (cost=0.00..869.36 rows=14,236 width=1,134) (actual time=0.005..9.275 rows=14,001 loops=1)

462. 36.943 36.943 ↑ 1.0 57,092 1

Seq Scan on assessor_columbus_ga_84044eecc9a94b1c (cost=0.00..3,455.91 rows=57,291 width=986) (actual time=0.005..36.943 rows=57,092 loops=1)

463. 91.132 91.132 ↑ 1.0 134,278 1

Seq Scan on assessor_aurora_co_8f3892a814af408c (cost=0.00..8,483.59 rows=134,959 width=1,135) (actual time=0.004..91.132 rows=134,278 loops=1)

464. 57.250 57.250 ↑ 1.0 85,795 1

Seq Scan on assessor_brown_county_wi_2b1ecc33486f4f36 (cost=0.00..5,252.86 rows=86,986 width=1,125) (actual time=0.004..57.250 rows=85,795 loops=1)

465. 95.156 95.156 ↑ 1.0 135,027 1

Seq Scan on assessor_charleston_county_sc_ac9aabfe8acb4d62 (cost=0.00..9,290.43 rows=141,343 width=1,144) (actual time=0.005..95.156 rows=135,027 loops=1)

466. 149.708 149.708 ↑ 1.0 193,250 1

Seq Scan on assessor_kansas_city_mo_8547276bea12463e (cost=0.00..12,480.18 rows=199,018 width=996) (actual time=0.005..149.708 rows=193,250 loops=1)

467. 30.918 30.918 ↑ 1.0 39,700 1

Seq Scan on assessor_irvine_ca_ffd0d45df0a3446c (cost=0.00..4,154.00 rows=39,700 width=1,006) (actual time=0.004..30.918 rows=39,700 loops=1)

468. 54.918 54.918 ↑ 1.0 69,643 1

Seq Scan on assessor_wyandotte_county_ks_0820e3e49a0d42d8 (cost=0.00..8,095.45 rows=69,645 width=1,114) (actual time=0.016..54.918 rows=69,643 loops=1)

469. 90.138 90.138 ↑ 1.0 124,106 1

Seq Scan on assessor_minneapolis_mn_a2207af2b038487c (cost=0.00..8,388.35 rows=127,735 width=996) (actual time=0.005..90.138 rows=124,106 loops=1)

470. 20.427 20.427 ↑ 1.0 29,290 1

Seq Scan on assessor_fulton_county_ga_aa62ce4711444df2 (cost=0.00..1,933.97 rows=29,597 width=1,179) (actual time=0.005..20.427 rows=29,290 loops=1)

471. 81.260 81.260 ↑ 1.0 120,728 1

Seq Scan on assessor_san_luis_obispo_county_ca_cd71eef6b94b43dd (cost=0.00..7,467.65 rows=123,665 width=894) (actual time=0.004..81.260 rows=120,728 loops=1)

472. 9.254 9.254 ↑ 1.0 12,977 1

Seq Scan on assessor_normal_il_91f7a10acd0f48f2 (cost=0.00..1,389.77 rows=12,977 width=1,149) (actual time=0.099..9.254 rows=12,977 loops=1)

473. 17.593 17.593 ↑ 1.0 24,864 1

Seq Scan on assessor_wasatch_county_ut_46e3c895c61a45ce (cost=0.00..1,820.36 rows=25,136 width=1,019) (actual time=0.005..17.593 rows=24,864 loops=1)

474. 6.074 6.074 ↑ 1.0 8,672 1

Seq Scan on assessor_dania_beach_fl_05c9b4122e93412b (cost=0.00..586.42 rows=8,942 width=1,140) (actual time=0.005..6.074 rows=8,672 loops=1)

475. 13.454 13.454 ↑ 1.0 19,324 1

Seq Scan on assessor_bonner_county_id_d28e1b8800b942f6 (cost=0.00..1,294.56 rows=19,756 width=1,141) (actual time=0.004..13.454 rows=19,324 loops=1)

476. 2.779 2.779 ↑ 1.0 3,979 1

Seq Scan on assessor_half_moon_bay_ca_8b25445193a24cd5 (cost=0.00..279.81 rows=4,081 width=1,149) (actual time=0.004..2.779 rows=3,979 loops=1)

477. 1.790 1.790 ↑ 1.0 2,766 1

Seq Scan on assessor_ojai_ca_b671f1045b114aaf (cost=0.00..162.08 rows=2,808 width=1,142) (actual time=0.004..1.790 rows=2,766 loops=1)

478. 4.387 4.387 ↑ 1.0 6,387 1

Seq Scan on assessor_port_hueneme_ca_47dbdb2fb5c94f18 (cost=0.00..422.41 rows=6,441 width=1,146) (actual time=0.005..4.387 rows=6,387 loops=1)

479. 64.379 64.379 ↑ 1.0 93,027 1

Seq Scan on assessor_new_hanover_county_nc_b9abd9021823452f (cost=0.00..6,276.64 rows=95,764 width=1,012) (actual time=0.004..64.379 rows=93,027 loops=1)

480. 1.684 1.684 ↑ 1.0 2,370 1

Seq Scan on assessor_shleter_island_ny_fd4f0ad7aed346a7 (cost=0.00..178.70 rows=2,370 width=1,007) (actual time=0.003..1.684 rows=2,370 loops=1)

481. 6.092 6.092 ↑ 1.0 8,002 1

Seq Scan on assessor_port_angeles_wa_5619274c051544c4 (cost=0.00..967.03 rows=8,003 width=1,145) (actual time=0.352..6.092 rows=8,002 loops=1)

482. 17.096 17.096 ↑ 1.0 24,214 1

Seq Scan on assessor_santa_cruz_ca_09bd2134cb674d61 (cost=0.00..1,690.11 rows=24,711 width=1,019) (actual time=0.004..17.096 rows=24,214 loops=1)

483. 16.254 16.254 ↑ 1.0 23,474 1

Seq Scan on assessor_lake_forest_ca_470ef5d1c54d4ef3 (cost=0.00..1,547.82 rows=23,582 width=1,005) (actual time=0.004..16.254 rows=23,474 loops=1)

484. 15.443 15.443 ↑ 1.0 22,443 1

Seq Scan on assessor_weston_fl_847c1ebec8164c3f (cost=0.00..1,419.75 rows=22,575 width=986) (actual time=0.005..15.443 rows=22,443 loops=1)

485. 9.563 9.563 ↑ 1.0 13,916 1

Seq Scan on assessor_gunnison_co_ad214efdfbd94db1 (cost=0.00..956.33 rows=13,933 width=1,142) (actual time=0.004..9.563 rows=13,916 loops=1)

486. 19.277 19.277 ↑ 1.0 28,160 1

Seq Scan on assessor_san_mateo_ca_1f786549df054b15 (cost=0.00..1,796.92 rows=28,692 width=1,128) (actual time=0.005..19.277 rows=28,160 loops=1)

487. 39.989 39.989 ↑ 1.0 57,864 1

Seq Scan on assessor_bay_county_fl_986cd275334b4ace (cost=0.00..4,107.64 rows=57,864 width=1,146) (actual time=0.005..39.989 rows=57,864 loops=1)

488. 19.223 19.223 ↑ 1.1 29,203 1

Seq Scan on assessor_indio_ca_0335078219e64bd4 (cost=0.00..1,796.09 rows=30,709 width=1,111) (actual time=0.004..19.223 rows=29,203 loops=1)

489. 1.333 1.333 ↑ 1.0 1,895 1

Seq Scan on assessor_cannon_beach_or_b58348aa8eb943f8 (cost=0.00..139.95 rows=1,895 width=1,003) (actual time=0.004..1.333 rows=1,895 loops=1)

490. 1.935 1.935 ↑ 1.0 2,787 1

Seq Scan on assessor_grand_county_ut_525180824a4847e8 (cost=0.00..192.93 rows=2,793 width=989) (actual time=0.004..1.935 rows=2,787 loops=1)

491. 0.846 0.846 ↑ 1.0 1,182 1

Seq Scan on assessor_grand_lake_co_cfc8a6ad0fd64c4b (cost=0.00..87.82 rows=1,182 width=1,141) (actual time=0.004..0.846 rows=1,182 loops=1)

492. 4.237 4.237 ↑ 1.0 6,113 1

Seq Scan on assessor_golden_co_632c53189af04663 (cost=0.00..392.07 rows=6,207 width=986) (actual time=0.004..4.237 rows=6,113 loops=1)

493. 2.954 2.954 ↑ 1.0 4,383 1

Seq Scan on assessor_healdsburg_ca_fea3b5eece5b4cd0 (cost=0.00..274.02 rows=4,402 width=1,147) (actual time=0.003..2.954 rows=4,383 loops=1)

494. 5.423 5.423 ↑ 1.0 7,688 1

Seq Scan on assessor_grand_county_co_344c6772a11942cb (cost=0.00..554.19 rows=7,719 width=1,140) (actual time=0.003..5.423 rows=7,688 loops=1)

495. 11.627 11.627 ↑ 1.0 16,554 1

Seq Scan on assessor_hot_springs_ar_ac466d44f29c41d0 (cost=0.00..1,125.82 rows=16,782 width=1,006) (actual time=0.004..11.627 rows=16,554 loops=1)

496. 4.203 4.203 ↑ 1.0 6,043 1

Seq Scan on assessor_twentynine_palms_ca_5371804d41dd40d7 (cost=0.00..404.69 rows=6,169 width=1,005) (actual time=0.004..4.203 rows=6,043 loops=1)

497. 15.363 15.363 ↑ 1.0 22,328 1

Seq Scan on assessor_iron_county_ut_043608fabca94286 (cost=0.00..1,509.27 rows=22,827 width=1,165) (actual time=0.004..15.363 rows=22,328 loops=1)

498. 74.899 74.899 ↑ 1.0 108,765 1

Seq Scan on assessor_henrico_county_va_e4cc95db69d04dd9 (cost=0.00..6,934.89 rows=108,989 width=995) (actual time=0.005..74.899 rows=108,765 loops=1)

499. 8.245 8.245 ↑ 1.0 11,094 1

Seq Scan on assessor_ruidoso_nm_6e8345a4bf974788 (cost=0.00..1,276.94 rows=11,094 width=1,132) (actual time=0.003..8.245 rows=11,094 loops=1)

500. 33.803 33.803 ↑ 1.0 43,532 1

Seq Scan on assessor_norman_ok_22572b23caa74b80 (cost=0.00..5,282.32 rows=43,532 width=983) (actual time=0.248..33.803 rows=43,532 loops=1)

501. 10.215 10.215 ↑ 1.0 15,203 1

Seq Scan on assessor_baldwin_park_ca_740deb8eb465474a (cost=0.00..1,506.03 rows=15,203 width=1,181) (actual time=0.010..10.215 rows=15,203 loops=1)

502. 26.150 26.150 ↑ 1.0 38,338 1

Seq Scan on assessor_oconee_county_sc_2330900e5cf4408d (cost=0.00..2,477.40 rows=38,840 width=1,136) (actual time=0.004..26.150 rows=38,338 loops=1)

503. 47.068 47.068 ↑ 1.0 70,302 1

Seq Scan on assessor_ulster_county_ny_059968e3b55140b0 (cost=0.00..4,323.11 rows=72,311 width=984) (actual time=0.004..47.068 rows=70,302 loops=1)

504. 1.120 1.120 ↑ 1.0 1,585 1

Seq Scan on assessor_pagosa_springs_co_b39a0b95e1eb4162 (cost=0.00..111.37 rows=1,637 width=1,147) (actual time=0.005..1.120 rows=1,585 loops=1)

505. 9.615 9.615 ↑ 1.0 13,763 1

Seq Scan on assessor_lake_oswego_or_b8f686e77a3a49e4 (cost=0.00..914.70 rows=13,870 width=1,151) (actual time=0.004..9.615 rows=13,763 loops=1)

506. 1.407 1.407 ↑ 1.0 1,961 1

Seq Scan on assessor_rockaway_beach_or_b607d279faca4812 (cost=0.00..150.61 rows=1,961 width=1,012) (actual time=0.004..1.407 rows=1,961 loops=1)

507. 9.528 9.528 ↑ 1.0 13,850 1

Seq Scan on assessor_kerrville_tx_63b2994366754851 (cost=0.00..907.60 rows=14,260 width=991) (actual time=0.003..9.528 rows=13,850 loops=1)

508. 2.512 2.512 ↑ 1.0 3,591 1

Seq Scan on assessor_rich_county_ut_b037e5ba9b434bf8 (cost=0.00..240.63 rows=3,663 width=1,137) (actual time=0.005..2.512 rows=3,591 loops=1)

509. 11.683 11.683 ↑ 1.0 18,378 1

Seq Scan on assessor_lodi_ca_196ed6af0c8c458b (cost=0.00..1,048.42 rows=18,442 width=995) (actual time=0.004..11.683 rows=18,378 loops=1)

510. 4.241 4.241 ↑ 1.0 6,078 1

Seq Scan on assessor_rancho_mirage_ca_97a210244f5a4e11 (cost=0.00..439.78 rows=6,078 width=999) (actual time=0.005..4.241 rows=6,078 loops=1)

511. 2.597 2.597 ↑ 1.1 3,673 1

Seq Scan on assessor_lake_placid_ny_41e6bdf037344c22 (cost=0.00..260.95 rows=4,095 width=997) (actual time=0.005..2.597 rows=3,673 loops=1)

512. 20.188 20.188 ↑ 1.1 29,546 1

Seq Scan on assessor_palm_desert_ca_3a03a87b1ae44ddb (cost=0.00..1,946.08 rows=31,208 width=1,130) (actual time=0.004..20.188 rows=29,546 loops=1)

513. 5.581 5.581 ↑ 1.0 7,977 1

Seq Scan on assessor_garfield_county_ut_2a9d0370f3d043fe (cost=0.00..524.00 rows=8,200 width=1,001) (actual time=0.005..5.581 rows=7,977 loops=1)

514. 522.147 522.147 ↑ 1.0 799,686 1

Seq Scan on assessor_los_angeles_ca_58e6d7cf3ef14eed (cost=0.00..45,814.41 rows=799,741 width=1,179) (actual time=0.004..522.147 rows=799,686 loops=1)

515. 2.342 2.342 ↑ 1.0 3,386 1

Seq Scan on assessor_sandpoint_id_b839f4f274ed4fef (cost=0.00..232.11 rows=3,511 width=1,004) (actual time=0.004..2.342 rows=3,386 loops=1)

516. 13.413 13.413 ↑ 1.0 16,757 1

Seq Scan on assessor_summit_county_co_2e3f848939b349ee (cost=0.00..2,073.23 rows=16,823 width=1,007) (actual time=0.003..13.413 rows=16,757 loops=1)

517. 2.072 2.072 ↑ 1.0 3,053 1

Seq Scan on assessor_sonoma_ca_f04bdafeb7464c3a (cost=0.00..188.53 rows=3,053 width=985) (actual time=0.005..2.072 rows=3,053 loops=1)

518. 5.290 5.290 ↑ 1.0 7,243 1

Seq Scan on assessor_south_padre_tx_94dbf12c0dea42ab (cost=0.00..561.43 rows=7,243 width=1,043) (actual time=0.004..5.290 rows=7,243 loops=1)

519. 2.326 2.326 ↑ 1.0 3,334 1

Seq Scan on assessor_talbot_county_md_662cb28e9bda4449 (cost=0.00..223.34 rows=3,334 width=994) (actual time=0.005..2.326 rows=3,334 loops=1)

520. 2.942 2.942 ↑ 1.0 4,338 1

Seq Scan on assessor_seaside_or_bd06677ada184238 (cost=0.00..287.38 rows=4,338 width=1,004) (actual time=0.004..2.942 rows=4,338 loops=1)

521. 17.450 17.450 ↑ 1.0 25,329 1

Seq Scan on assessor_rutherford_county_nc_7417df36ec264c35 (cost=0.00..1,679.78 rows=26,178 width=1,141) (actual time=0.004..17.450 rows=25,329 loops=1)

522. 63.481 63.481 ↑ 1.0 95,796 1

Seq Scan on assessor_wimberley_tx_eaa0f84cf646438a (cost=0.00..5,649.45 rows=96,145 width=1,136) (actual time=0.004..63.481 rows=95,796 loops=1)

523. 0.462 0.462 ↑ 1.0 680 1

Seq Scan on assessor_holland_wi_6e4bd9fb57ca4210 (cost=0.00..45.80 rows=680 width=1,134) (actual time=0.004..0.462 rows=680 loops=1)

524. 1.008 1.008 ↑ 1.0 1,484 1

Seq Scan on assessor_wayne_county_ut_32e9d616cf644ceb (cost=0.00..94.84 rows=1,484 width=988) (actual time=0.004..1.008 rows=1,484 loops=1)

525. 5.713 5.713 ↑ 1.0 8,372 1

Seq Scan on assessor_vail_co_84a792b22e2e4026 (cost=0.00..539.19 rows=8,619 width=1,135) (actual time=0.004..5.713 rows=8,372 loops=1)

526. 1.684 1.684 ↑ 1.1 2,501 1

Seq Scan on assessor_lake_george_ny_f9a95a00f0224d9e (cost=0.00..161.38 rows=2,638 width=883) (actual time=0.004..1.684 rows=2,501 loops=1)

527. 3.478 3.478 ↑ 1.0 5,023 1

Seq Scan on assessor_whitefish_mt_7fa8277bc971411d (cost=0.00..331.71 rows=5,171 width=999) (actual time=0.004..3.478 rows=5,023 loops=1)

528. 8.792 8.792 ↑ 1.0 12,705 1

Seq Scan on assessor_sedona_az_238b9f8d94034ad0 (cost=0.00..850.05 rows=12,705 width=989) (actual time=0.005..8.792 rows=12,705 loops=1)

529. 12.705 12.705 ↑ 1.0 18,419 1

Seq Scan on assessor_tillamook_county_or_15df87eb92934879 (cost=0.00..1,264.19 rows=18,419 width=1,007) (actual time=0.005..12.705 rows=18,419 loops=1)

530. 3.000 3.000 ↑ 1.0 4,650 1

Seq Scan on assessor_south_haven_mi_4059e48320ff45cc (cost=0.00..270.79 rows=4,779 width=1,187) (actual time=0.005..3.000 rows=4,650 loops=1)

531. 110.157 110.157 ↑ 1.0 145,235 1

Seq Scan on assessor_sacramento_ca_563f8f139d6b403e (cost=0.00..9,490.62 rows=145,962 width=1,000) (actual time=0.004..110.157 rows=145,235 loops=1)

532. 15.577 15.577 ↑ 1.0 20,421 1

Seq Scan on assessor_rocklin_ca_e23f296c4a844110 (cost=0.00..1,310.56 rows=20,856 width=997) (actual time=0.004..15.577 rows=20,421 loops=1)

533. 254.995 254.995 ↑ 1.0 322,075 1

Seq Scan on assessor_montgomery_county_md_5283463c77a0409c (cost=0.00..41,041.34 rows=322,134 width=999) (actual time=0.641..254.995 rows=322,075 loops=1)

534. 632.912 632.912 ↑ 1.0 1 39,557

Index Scan using level1_listing_pkey on level1_listing (cost=0.56..1.83 rows=1 width=161) (actual time=0.015..0.016 rows=1 loops=39,557)

  • Index Cond: (internal_listing_id = l1.internal_listing_id)
535. 593.355 593.355 ↑ 1.0 1 39,557

Index Scan using listing_pkey on listing (cost=0.56..1.85 rows=1 width=160) (actual time=0.014..0.015 rows=1 loops=39,557)

  • Index Cond: (internal_listing_id = l1.internal_listing_id)
536. 1,700.951 1,700.951 ↑ 1.0 1 39,557

Index Scan using listing_pricing_internal_listing_id_idx on listing_pricing (cost=0.56..1.81 rows=1 width=29) (actual time=0.043..0.043 rows=1 loops=39,557)

  • Index Cond: (listing.internal_listing_id = internal_listing_id)
537. 1,186.710 1,186.710 ↑ 1.0 1 39,557

Index Scan using jobs_output_pkey on jobs_output (cost=0.42..2.08 rows=1 width=105) (actual time=0.029..0.030 rows=1 loops=39,557)

  • Index Cond: (internal_listing_id = lpj.internal_listing_id)
538. 4.047 20.271 ↑ 2.8 8,902 1

Hash (cost=37,340.67..37,340.67 rows=24,832 width=51) (actual time=20.271..20.271 rows=8,902 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 804kB
539. 16.224 16.224 ↑ 2.8 8,902 1

Index Scan using property_to_permit_persisted_key on property_to_permit_persisted (cost=0.55..37,340.67 rows=24,832 width=51) (actual time=0.019..16.224 rows=8,902 loops=1)

  • Index Cond: (((geoid)::text = '99999US09'::text) AND (is_active = true) AND (exact_match = true))
  • Filter: (is_active AND exact_match)
540. 2.554 8.577 ↓ 1.4 6,448 1

Hash (cost=19,024.02..19,024.02 rows=4,614 width=35) (actual time=8.577..8.577 rows=6,448 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 459kB
541. 6.023 6.023 ↓ 1.4 6,448 1

Index Scan using property_to_permit_is_active_idx on property_to_permit_persisted property_to_permit_persisted_1 (cost=0.42..19,024.02 rows=4,614 width=35) (actual time=0.420..6.023 rows=6,448 loops=1)

  • Index Cond: (is_active = false)
  • Filter: ((NOT is_active) AND exact_match AND ((geoid)::text = '99999US09'::text))
  • Rows Removed by Filter: 5984
542. 2,848.104 2,848.104 ↑ 1.0 1 39,557

Index Scan using listing_host_internal_listing_id_idx on listing_host (cost=0.56..1.81 rows=1 width=237) (actual time=0.071..0.072 rows=1 loops=39,557)

  • Index Cond: (internal_listing_id = listing.internal_listing_id)
543.          

SubPlan (forNested Loop Left Join)

544. 593.355 11,155.074 ↑ 1.0 1 39,557

Aggregate (cost=78.94..78.95 rows=1 width=8) (actual time=0.282..0.282 rows=1 loops=39,557)

545. 10,561.719 10,561.719 ↑ 1.3 51 39,557

Index Scan using screenshot_internal_listing_id_idx on screenshot (cost=0.56..78.77 rows=68 width=8) (actual time=0.040..0.267 rows=51 loops=39,557)

  • Index Cond: (internal_listing_id = listing.internal_listing_id)
  • Filter: active
  • Rows Removed by Filter: 1
546. 118.671 7,911.400 ↑ 1.0 1 39,557

Result (cost=2.64..2.66 rows=1 width=0) (actual time=0.199..0.200 rows=1 loops=39,557)

547.          

Initplan (forResult)

548. 39.557 7,792.729 ↓ 0.0 0 39,557

Limit (cost=0.70..2.64 rows=1 width=4) (actual time=0.197..0.197 rows=0 loops=39,557)

549. 7,753.172 7,753.172 ↓ 0.0 0 39,557

Index Scan using listing_calendar_availability_key on listing_calendar_availability (cost=0.70..7,762.61 rows=4,002 width=4) (actual time=0.196..0.196 rows=0 loops=39,557)

  • Index Cond: ((internal_listing_id = listing.internal_listing_id) AND (availability_date IS NOT NULL) AND (availability_date > now()))
  • Filter: available
  • Rows Removed by Filter: 7
550. 118.671 1,226.267 ↑ 1.0 1 39,557

Aggregate (cost=32.90..32.92 rows=1 width=8) (actual time=0.030..0.031 rows=1 loops=39,557)

551. 1,107.596 1,107.596 ↓ 0.0 0 39,557

Index Scan using listing_identification_status_internal_listing_id_idx on listing_identification_status (cost=0.43..32.89 rows=4 width=8) (actual time=0.026..0.028 rows=0 loops=39,557)

  • Index Cond: (internal_listing_id = level1_listing.internal_listing_id)
  • Filter: (active AND (job_status = 'not_submitted'::text))
  • Rows Removed by Filter: 1
552. 79.114 3,085.446 ↑ 1.0 1 39,557

Limit (cost=25.43..25.43 rows=1 width=25) (actual time=0.077..0.078 rows=1 loops=39,557)

553. 158.228 3,006.332 ↑ 6.0 1 39,557

Sort (cost=25.43..25.44 rows=6 width=25) (actual time=0.076..0.076 rows=1 loops=39,557)

  • Sort Key: property_to_jurisdiction.geoid DESC
  • Sort Method: quicksort Memory: 25kB
554. 157.388 2,848.104 ↑ 6.0 1 39,557

Nested Loop (cost=0.98..25.40 rows=6 width=25) (actual time=0.061..0.072 rows=1 loops=39,557)

555. 2,294.306 2,294.306 ↑ 6.0 1 39,557

Index Scan using property_to_jurisdiction_internal_property_id_idx on property_to_jurisdiction (cost=0.56..9.48 rows=6 width=13) (actual time=0.048..0.058 rows=1 loops=39,557)

  • Index Cond: (internal_property_id = lpj.internal_property_id)
  • Filter: (contained AND ((geoid)::text !~~ '%%u'::text) AND ((geoid)::text !~~ '99999%%'::text))
  • Rows Removed by Filter: 2
556. 396.410 396.410 ↑ 1.0 1 39,641

Index Scan using place_data_pkey on place_data (cost=0.42..2.64 rows=1 width=26) (actual time=0.009..0.010 rows=1 loops=39,641)

  • Index Cond: ((geoid)::text = (property_to_jurisdiction.geoid)::text)
Planning time : 342.516 ms
Execution time : 97,015.878 ms