explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 56bN : un15

Settings
# exclusive inclusive rows x rows loops node
1. 413.690 43,022.131 ↑ 1.1 15,083 1

Nested Loop Left Join (cost=19,095.32..1,088,311,210.90 rows=17,166 width=1,263) (actual time=9.699..43,022.131 rows=15,083 loops=1)

2. 38.412 12,177.171 ↑ 1.1 15,083 1

Nested Loop Left Join (cost=19,094.90..1,472,619.75 rows=17,166 width=1,199) (actual time=8.379..12,177.171 rows=15,083 loops=1)

3. 318.320 11,942.680 ↑ 1.1 15,083 1

Nested Loop Left Join (cost=19,094.35..1,429,263.06 rows=17,166 width=1,183) (actual time=8.360..11,942.680 rows=15,083 loops=1)

4. 27.677 357.359 ↑ 1.1 15,083 1

Hash Left Join (cost=19,094.35..67,322.86 rows=17,166 width=230) (actual time=8.098..357.359 rows=15,083 loops=1)

  • Hash Cond: (((property_compliance_persisted.geoid)::text = (property_to_permit_persisted_1.geoid)::text) AND (property_compliance_persisted.internal_property_id = property_to_permit_persisted_1.internal_property_id))
5. 33.291 321.669 ↑ 1.1 15,083 1

Nested Loop (cost=1.12..47,242.44 rows=17,166 width=221) (actual time=0.070..321.669 rows=15,083 loops=1)

6. 62.133 62.133 ↑ 1.1 15,083 1

Index Scan using property_compliance_persisted_geoid_idx on property_compliance_persisted (cost=0.56..1,025.72 rows=17,166 width=72) (actual time=0.048..62.133 rows=15,083 loops=1)

  • Index Cond: ((geoid)::text = '99999US09'::text)
7. 226.245 226.245 ↑ 1.0 1 15,083

Index Scan using property_pkey on property (cost=0.56..2.68 rows=1 width=162) (actual time=0.015..0.015 rows=1 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
8. 2.573 8.013 ↓ 1.4 6,448 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 459kB
9. 5.440 5.440 ↓ 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.273..5.440 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
10. 2,051.288 11,267.001 ↑ 225.0 1 15,083

Append (cost=0.00..77.09 rows=225 width=1,007) (actual time=0.302..0.747 rows=1 loops=15,083)

11. 0.000 0.000 ↓ 0.0 0 15,083

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

  • Filter: (((source)::text = property.assessor_source) AND ((parcel_number)::text = (property.parcel_number)::text))
12. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_alameda_county_ca_2140fc0a90d54c01_parcel_number_idx on assessor_alameda_county_ca_2140fc0a90d54c01 (cost=0.29..0.31 rows=1 width=1,030) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
13. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_arlington_county_va_3262dfdd743a4445_parcel_number_idx on assessor_arlington_county_va_3262dfdd743a4445 (cost=0.42..0.44 rows=1 width=639) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
14. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_arlington_tx_19f9d48f80174876_parcel_number_idx on assessor_arlington_tx_19f9d48f80174876 (cost=0.42..0.44 rows=1 width=1,032) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
15. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_beaufort_sc_fc802e02137b44fa_parcel_number_idx on assessor_beaufort_sc_fc802e02137b44fa (cost=0.28..0.30 rows=1 width=510) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
16. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_buena_park_ca_aa42f34398dd474a_parcel_number_idx on assessor_buena_park_ca_aa42f34398dd474a (cost=0.29..0.31 rows=1 width=1,046) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
17. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_casco_mi_5113ae42336e427d_parcel_number_idx on assessor_casco_mi_5113ae42336e427d (cost=0.28..0.30 rows=1 width=903) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
18. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_contra_costa_county_ca_3c0ba605a1ef405b_parcel_number_ on assessor_contra_costa_county_ca_3c0ba605a1ef405b (cost=0.29..0.31 rows=1 width=1,048) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
19. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_coppell_tx_6782d465eae9445d_parcel_number_idx on assessor_coppell_tx_6782d465eae9445d (cost=0.29..0.31 rows=1 width=1,085) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
20. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_dana_point_ca_d39664795202410f_parcel_number_idx on assessor_dana_point_ca_d39664795202410f (cost=0.29..0.31 rows=1 width=1,052) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
21. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_durham_county_nc_aa6110175fac41ec_parcel_number_idx on assessor_durham_county_nc_aa6110175fac41ec (cost=0.42..0.44 rows=1 width=1,006) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
22. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_dutchess_county_ny_a3c286fd2d7644b1_parcel_number_idx on assessor_dutchess_county_ny_a3c286fd2d7644b1 (cost=0.42..0.44 rows=1 width=1,033) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
23. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_eagle_county_co_58b9e20bd0f4414b_parcel_number_idx on assessor_eagle_county_co_58b9e20bd0f4414b (cost=0.41..0.44 rows=1 width=636) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
24. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_el_paso_county_co_51247c7b1bfb477d_parcel_number_idx on assessor_el_paso_county_co_51247c7b1bfb477d (cost=0.28..0.30 rows=1 width=995) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
25. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_fairfax_county_va_bc2c864d9db4492b_parcel_number_idx on assessor_fairfax_county_va_bc2c864d9db4492b (cost=0.42..0.44 rows=1 width=1,054) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
26. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_flathead_county_mt_ff793f07bbde4c61_parcel_number_idx on assessor_flathead_county_mt_ff793f07bbde4c61 (cost=0.29..0.31 rows=1 width=1,090) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
27. 15.083 15.083 ↓ 0.0 0 15,083

Index Scan using assessor_glynn_county_ga_15730844c7b641ea_parcel_number_idx on assessor_glynn_county_ga_15730844c7b641ea (cost=0.14..0.16 rows=1 width=1,053) (actual time=0.001..0.001 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
28. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_grapevine_tx_ba7f7ab9c9294c97_parcel_number_idx on assessor_grapevine_tx_ba7f7ab9c9294c97 (cost=0.29..0.31 rows=1 width=1,066) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
29. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_holland_mi_ea53583e81014141_parcel_number_idx on assessor_holland_mi_ea53583e81014141 (cost=0.29..0.31 rows=1 width=1,049) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
30. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_honolulu_county_hi_a3e1407380c0451b_parcel_number_idx on assessor_honolulu_county_hi_a3e1407380c0451b (cost=0.42..0.44 rows=1 width=1,044) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
31. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_indian_harbour_beach_fl_132d04726c164566_parcel_number on assessor_indian_harbour_beach_fl_132d04726c164566 (cost=0.28..0.30 rows=1 width=1,057) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
32. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_indian_river_county_fl_5cd05d8e82144ac2_parcel_number_ on assessor_indian_river_county_fl_5cd05d8e82144ac2 (cost=0.42..0.44 rows=1 width=1,039) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
33. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_knoxville_tn_4051c459fd784e31_parcel_number_idx on assessor_knoxville_tn_4051c459fd784e31 (cost=0.42..0.44 rows=1 width=767) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
34. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_lake_bluff_il_fe7c7f48d18e486b_parcel_number_idx on assessor_lake_bluff_il_fe7c7f48d18e486b (cost=0.29..0.31 rows=1 width=1,032) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
35. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_lane_county_or_fbfe09929d584acd_parcel_number_idx on assessor_lane_county_or_fbfe09929d584acd (cost=0.42..0.44 rows=1 width=1,040) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
36. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_la_plata_county_co_161e0885636e4666_parcel_number_idx on assessor_la_plata_county_co_161e0885636e4666 (cost=0.29..0.31 rows=1 width=1,050) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
37. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_larimer_county_co_4691458b1e694e5e_parcel_number_idx on assessor_larimer_county_co_4691458b1e694e5e (cost=0.42..0.44 rows=1 width=916) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
38. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_las_vegas_nv_f951bd5dc54f495b_parcel_number_idx on assessor_las_vegas_nv_f951bd5dc54f495b (cost=0.42..0.44 rows=1 width=1,035) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
39. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_lenox_ma_c59abe06e5544030_parcel_number_idx on assessor_lenox_ma_c59abe06e5544030 (cost=0.28..0.30 rows=1 width=1,061) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
40. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_los_angeles_county_ca_a0ba9f83a3a74c7b_parcel_number_i on assessor_los_angeles_county_ca_a0ba9f83a3a74c7b (cost=0.42..0.44 rows=1 width=897) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
41. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_madera_county_ca_793fa2de6d8d4f28_parcel_number_idx on assessor_madera_county_ca_793fa2de6d8d4f28 (cost=0.41..0.44 rows=1 width=1,082) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
42. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_malibu_ca_0845a6fcbb9c4cd7_parcel_number_idx on assessor_malibu_ca_0845a6fcbb9c4cd7 (cost=0.28..0.30 rows=1 width=1,050) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
43. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_maplewood_mo_f6a496c371b948d5_parcel_number_idx on assessor_maplewood_mo_f6a496c371b948d5 (cost=0.28..0.30 rows=1 width=525) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
44. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_maricopa_county_az_1310d115da1e401e_parcel_number_idx on assessor_maricopa_county_az_1310d115da1e401e (cost=0.42..0.44 rows=1 width=1,045) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
45. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_marin_county_ca_5e9be0dfb41b4b69_parcel_number_idx on assessor_marin_county_ca_5e9be0dfb41b4b69 (cost=0.42..0.44 rows=1 width=1,019) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
46. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_mariposa_county_ca_adf688d000c946f6_parcel_number_idx on assessor_mariposa_county_ca_adf688d000c946f6 (cost=0.29..0.31 rows=1 width=1,022) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
47. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_martin_county_fl_d39775dc28f54bae_parcel_number_idx on assessor_martin_county_fl_d39775dc28f54bae (cost=0.42..0.44 rows=1 width=1,066) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
48. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_maui_county_hi_ab040cda4b2e4d48_parcel_number_idx on assessor_maui_county_hi_ab040cda4b2e4d48 (cost=0.29..0.31 rows=1 width=1,046) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
49. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_mendocino_county_ca_eebd45525e244e9e_parcel_number_idx on assessor_mendocino_county_ca_eebd45525e244e9e (cost=0.42..0.44 rows=1 width=1,059) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
50. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_miami_dade_county_fl_c11f3ae1c6aa45f1_parcel_number_id on assessor_miami_dade_county_fl_c11f3ae1c6aa45f1 (cost=0.42..0.44 rows=1 width=1,077) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
51. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_monmouth_county_nj_d1e2578feb474e0a_parcel_number_idx on assessor_monmouth_county_nj_d1e2578feb474e0a (cost=0.28..0.30 rows=1 width=1,055) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
52. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_mono_county_ca_48e87d96928e4012_parcel_number_idx on assessor_mono_county_ca_48e87d96928e4012 (cost=0.29..0.31 rows=1 width=487) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
53. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_monroe_county_fl_3869d98d04d34e23_parcel_number_idx on assessor_monroe_county_fl_3869d98d04d34e23 (cost=0.42..0.44 rows=1 width=474) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
54. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_napa_ca_6121cc9120de42a4_parcel_number_idx on assessor_napa_ca_6121cc9120de42a4 (cost=0.29..0.31 rows=1 width=983) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
55. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_napa_county_ca_cbfa387c66264992_parcel_number_idx on assessor_napa_county_ca_cbfa387c66264992 (cost=0.29..0.31 rows=1 width=1,031) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
56. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_nelson_bc_ec1e1aea81364882_parcel_number_idx on assessor_nelson_bc_ec1e1aea81364882 (cost=0.28..0.30 rows=1 width=1,011) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
57. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_newport_beach_ca_0aa2254bb33e4817_parcel_number_idx on assessor_newport_beach_ca_0aa2254bb33e4817 (cost=0.29..0.31 rows=1 width=911) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
58. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_oakland_park_fl_6e32bc7de7554f8d_parcel_number_idx on assessor_oakland_park_fl_6e32bc7de7554f8d (cost=0.29..0.31 rows=1 width=1,051) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
59. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_orange_county_fl_37f421a34ff74bdf_parcel_number_idx on assessor_orange_county_fl_37f421a34ff74bdf (cost=0.42..0.44 rows=1 width=1,108) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
60. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_orlando_fl_17493e7181d748af_parcel_number_idx on assessor_orlando_fl_17493e7181d748af (cost=0.42..0.44 rows=1 width=911) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
61. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_pasadena_ca_1fd922b2e9de424b_parcel_number_idx on assessor_pasadena_ca_1fd922b2e9de424b (cost=0.29..0.31 rows=1 width=882) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
62. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_petaluma_ca_9c0e4b4b78dd48c8_parcel_number_idx on assessor_petaluma_ca_9c0e4b4b78dd48c8 (cost=0.29..0.31 rows=1 width=1,020) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
63. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_piedmont_ca_ffea2b3f783e411a_parcel_number_idx on assessor_piedmont_ca_ffea2b3f783e411a (cost=0.28..0.30 rows=1 width=933) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
64. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_portland_me_1023e1af508947b0_parcel_number_idx on assessor_portland_me_1023e1af508947b0 (cost=0.29..0.31 rows=1 width=1,036) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
65. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_prescott_az_f10ad646895148bb_parcel_number_idx on assessor_prescott_az_f10ad646895148bb (cost=0.29..0.31 rows=1 width=1,049) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
66. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_revelstoke_bc_777586092eec4145_parcel_number_idx on assessor_revelstoke_bc_777586092eec4145 (cost=0.28..0.30 rows=1 width=732) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
67. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_riverside_county_ca_6e4b1d7145f24ac9_parcel_number_idx on assessor_riverside_county_ca_6e4b1d7145f24ac9 (cost=0.42..0.44 rows=1 width=1,089) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
68. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_rossland_bc_8713f203bb3642b1_parcel_number_idx on assessor_rossland_bc_8713f203bb3642b1 (cost=0.28..0.30 rows=1 width=991) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
69. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_san_marcos_tx_96b2bad78d42444f_parcel_number_idx on assessor_san_marcos_tx_96b2bad78d42444f (cost=0.29..0.31 rows=1 width=942) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
70. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_san_mateo_county_ca_ef8b46ccc8414877_parcel_number_idx on assessor_san_mateo_county_ca_ef8b46ccc8414877 (cost=0.28..0.30 rows=1 width=809) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
71. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_santa_cruz_county_ca_d0e3f0d1a6e6404b_parcel_number_id on assessor_santa_cruz_county_ca_d0e3f0d1a6e6404b (cost=0.42..0.44 rows=1 width=1,059) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
72. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_sarasota_county_fl_db132f6b066f4ba1_parcel_number_idx on assessor_sarasota_county_fl_db132f6b066f4ba1 (cost=0.41..0.44 rows=1 width=918) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
73. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_sawyer_county_wi_81016738c88e49ac_parcel_number_idx on assessor_sawyer_county_wi_81016738c88e49ac (cost=0.29..0.31 rows=1 width=1,058) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
74. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_solano_county_ca_82192e65550b43e0_parcel_number_idx on assessor_solano_county_ca_82192e65550b43e0 (cost=0.41..0.43 rows=1 width=1,024) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
75. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_sonoma_county_ca_3eeb161470914f73_parcel_number_idx on assessor_sonoma_county_ca_3eeb161470914f73 (cost=0.28..0.30 rows=1 width=1,037) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
76. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_south_lake_tahoe_ca_37c5e13796674bef_parcel_number_idx on assessor_south_lake_tahoe_ca_37c5e13796674bef (cost=0.29..0.31 rows=1 width=906) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
77. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_st_johns_county_fl_9bc627b9355f4b15_parcel_number_idx on assessor_st_johns_county_fl_9bc627b9355f4b15 (cost=0.42..0.44 rows=1 width=1,062) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
78. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_sun_peaks_bc_1bdb590dd315404e_parcel_number_idx on assessor_sun_peaks_bc_1bdb590dd315404e (cost=0.29..0.31 rows=1 width=1,041) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
79. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_suttons_bay_mi_4fae44266331495b_parcel_number_idx on assessor_suttons_bay_mi_4fae44266331495b (cost=0.28..0.30 rows=1 width=1,083) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
80. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_tamarac_fl_ebc06a52caea48ea_parcel_number_idx on assessor_tamarac_fl_ebc06a52caea48ea (cost=0.29..0.31 rows=1 width=1,035) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
81. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_taos_county_nm_2b15473860264850_parcel_number_idx on assessor_taos_county_nm_2b15473860264850 (cost=0.28..0.30 rows=1 width=829) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
82. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_teton_county_wy_08c55071ca944f14_parcel_number_idx on assessor_teton_county_wy_08c55071ca944f14 (cost=0.28..0.30 rows=1 width=915) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
83. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_tofino_bc_9d44fa4331d849cd_parcel_number_idx on assessor_tofino_bc_9d44fa4331d849cd (cost=0.29..0.31 rows=1 width=1,029) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
84. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_ucluelet_bc_e6251e82ee8044ec_parcel_number_idx on assessor_ucluelet_bc_e6251e82ee8044ec (cost=0.29..0.31 rows=1 width=893) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
85. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_vermont_bbddb672dfb8473e_parcel_number_idx on assessor_vermont_bbddb672dfb8473e (cost=0.29..0.31 rows=1 width=1,052) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
86. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_victoria_bc_52ef0b03daf748c1_parcel_number_idx on assessor_victoria_bc_52ef0b03daf748c1 (cost=0.29..0.31 rows=1 width=1,126) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
87. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_virginia_beach_va_7ac246f385914a1d_parcel_number_idx on assessor_virginia_beach_va_7ac246f385914a1d (cost=0.42..0.44 rows=1 width=1,108) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
88. 165.913 165.913 ↑ 1.0 1 15,083

Index Scan using assessor_walton_county_fl_fcb628587c614a48_parcel_number_idx on assessor_walton_county_fl_fcb628587c614a48 (cost=0.41..0.44 rows=1 width=1,059) (actual time=0.010..0.011 rows=1 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
89. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_west_hollywood_ca_0ad80d9e052d49bf_parcel_number_idx on assessor_west_hollywood_ca_0ad80d9e052d49bf (cost=0.29..0.31 rows=1 width=781) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
90. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_yorba_linda_ca_601b0e9dbd6741a3_parcel_number_idx on assessor_yorba_linda_ca_601b0e9dbd6741a3 (cost=0.29..0.31 rows=1 width=1,030) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
91. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_yucca_valley_ca_991b980d76e5478f_parcel_number_idx on assessor_yucca_valley_ca_991b980d76e5478f (cost=0.29..0.31 rows=1 width=1,056) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
92. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_marquette_county_mi_0cbee586637f4332_parcel_number_idx on assessor_marquette_county_mi_0cbee586637f4332 (cost=0.28..0.30 rows=1 width=1,054) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
93. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_denver_co_6e0a991a8fb7435d_parcel_number_idx on assessor_denver_co_6e0a991a8fb7435d (cost=0.42..0.44 rows=1 width=887) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
94. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_santa_barbara_county_ca_d44970aa7bb94eb0_parcel_number on assessor_santa_barbara_county_ca_d44970aa7bb94eb0 (cost=0.42..0.44 rows=1 width=810) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
95. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_lee_county_fl_18fc47cddcad4743_parcel_number_idx on assessor_lee_county_fl_18fc47cddcad4743 (cost=0.41..0.44 rows=1 width=916) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
96. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_east_bay_township_mi_c0b85928790f4246_parcel_number_id on assessor_east_bay_township_mi_c0b85928790f4246 (cost=0.28..0.30 rows=1 width=834) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
97. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_driggs_id_2ebfbebfc56149aa_parcel_number_idx on assessor_driggs_id_2ebfbebfc56149aa (cost=0.28..0.30 rows=1 width=1,071) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
98. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_asheville_nc_f813d3c87eb34adb_parcel_number_idx on assessor_asheville_nc_f813d3c87eb34adb (cost=0.42..0.44 rows=1 width=812) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
99. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_douglas_county_nv_bd00177a8b504c95_parcel_number_idx on assessor_douglas_county_nv_bd00177a8b504c95 (cost=0.29..0.31 rows=1 width=552) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
100. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_del_norte_county_ca_510c4787ef0041c4_parcel_number_idx on assessor_del_norte_county_ca_510c4787ef0041c4 (cost=0.29..0.31 rows=1 width=1,066) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
101. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_monterey_county_ca_155b4757b2fb483f_parcel_number_idx on assessor_monterey_county_ca_155b4757b2fb483f (cost=0.42..0.44 rows=1 width=919) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
102. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_boston_ma_e1479ec6e26c412c_parcel_number_idx on assessor_boston_ma_e1479ec6e26c412c (cost=0.27..0.29 rows=1 width=1,038) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
103. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_placer_county_ca_f2273f13841c4e48_parcel_number_idx on assessor_placer_county_ca_f2273f13841c4e48 (cost=0.42..0.44 rows=1 width=996) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
104. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_nashville_tn_39405bcc5d0b4771_parcel_number_idx on assessor_nashville_tn_39405bcc5d0b4771 (cost=0.42..0.44 rows=1 width=913) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
105. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_ventura_county_ca_ccc24a0684b043f3_parcel_number_idx on assessor_ventura_county_ca_ccc24a0684b043f3 (cost=0.29..0.31 rows=1 width=947) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
106. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_rockingham_county_va_cffd52fe180645af_parcel_number_id on assessor_rockingham_county_va_cffd52fe180645af (cost=0.29..0.31 rows=1 width=942) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
107. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_collegedale_tn_6aa970dc665e4bef_parcel_number_idx on assessor_collegedale_tn_6aa970dc665e4bef (cost=0.28..0.30 rows=1 width=1,061) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
108. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_sunnyvale_ca_bfaee40a08e540cb_parcel_number_idx on assessor_sunnyvale_ca_bfaee40a08e540cb (cost=0.29..0.31 rows=1 width=1,078) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
109. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_new_braunfels_tx_7184eb6576fa462d_parcel_number_idx on assessor_new_braunfels_tx_7184eb6576fa462d (cost=0.29..0.31 rows=1 width=803) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
  • Rows Removed by Filter: 0
110. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_los_altos_hills_ca_eba63a5a5af64615_parcel_number_idx on assessor_los_altos_hills_ca_eba63a5a5af64615 (cost=0.28..0.30 rows=1 width=1,082) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
111. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_holmes_beach_fl_eee3440dbcb6413e_parcel_number_idx on assessor_holmes_beach_fl_eee3440dbcb6413e (cost=0.28..0.30 rows=1 width=1,042) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
112. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_south_portland_me_d474fc2830eb4772_parcel_number_idx on assessor_south_portland_me_d474fc2830eb4772 (cost=0.29..0.31 rows=1 width=926) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
113. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_redwood_city_ca_7cea3cc128ce4727_parcel_number_idx on assessor_redwood_city_ca_7cea3cc128ce4727 (cost=0.29..0.31 rows=1 width=805) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
114. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_boulder_county_co_91fb110cd94043c8_parcel_number_idx on assessor_boulder_county_co_91fb110cd94043c8 (cost=0.42..0.44 rows=1 width=903) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
115. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_tuolumne_county_ca_cdd383fb4e9449d9_parcel_number_idx on assessor_tuolumne_county_ca_cdd383fb4e9449d9 (cost=0.29..0.31 rows=1 width=1,040) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
116. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_albany_ca_65e90507932c419b_parcel_number_idx on assessor_albany_ca_65e90507932c419b (cost=0.28..0.30 rows=1 width=1,073) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
117. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_hood_river_county_or_5c35f0da0b3541ce_parcel_number_id on assessor_hood_river_county_or_5c35f0da0b3541ce (cost=0.28..0.30 rows=1 width=1,084) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
118. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_penticton_bc_0ba5a823796f4b42_parcel_number_idx on assessor_penticton_bc_0ba5a823796f4b42 (cost=0.29..0.31 rows=1 width=1,055) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
119. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_williams_bay_wi_dfab8a075b5544aa_parcel_number_idx on assessor_williams_bay_wi_dfab8a075b5544aa (cost=0.28..0.30 rows=1 width=1,055) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
120. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_connestee_falls_nc_305175fcd5a643e5_parcel_number_idx on assessor_connestee_falls_nc_305175fcd5a643e5 (cost=0.28..0.30 rows=1 width=1,078) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
121. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_garden_grove_ca_416b5aa8ac2442d8_parcel_number_idx on assessor_garden_grove_ca_416b5aa8ac2442d8 (cost=0.29..0.31 rows=1 width=941) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
122. 75.415 75.415 ↓ 0.0 0 15,083

Index Scan using assessor_loudoun_county_va_ce6c1d66f0274472_parcel_number_idx on assessor_loudoun_county_va_ce6c1d66f0274472 (cost=0.42..0.44 rows=1 width=803) (actual time=0.005..0.005 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
123. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_hall_county_ga_unincorporated_1aca2434ca314a97_parcel_ on assessor_hall_county_ga_unincorporated_1aca2434ca314a97 (cost=0.42..0.44 rows=1 width=801) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
124. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_nevada_county_ca_e708945e3e7b4b1b_parcel_number_idx on assessor_nevada_county_ca_e708945e3e7b4b1b (cost=0.41..0.44 rows=1 width=812) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
125. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_sausalito_ca_276099f310e34338_parcel_number_idx on assessor_sausalito_ca_276099f310e34338 (cost=0.28..0.30 rows=1 width=996) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
126. 75.415 75.415 ↓ 0.0 0 15,083

Index Scan using assessor_san_antonio_tx_8147f36cb4b04c99_parcel_number_idx on assessor_san_antonio_tx_8147f36cb4b04c99 (cost=0.42..0.45 rows=1 width=729) (actual time=0.005..0.005 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
127. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_indian_wells_ca_e74205b7cf374d0f_parcel_number_idx on assessor_indian_wells_ca_e74205b7cf374d0f (cost=0.28..0.30 rows=1 width=1,063) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
128. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_broward_county_fl_54568cf8aec1441c_parcel_number_idx on assessor_broward_county_fl_54568cf8aec1441c (cost=0.42..0.45 rows=1 width=1,084) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
129. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_frisco_co_33a2c6fd3ff04245_parcel_number_idx on assessor_frisco_co_33a2c6fd3ff04245 (cost=0.28..0.30 rows=1 width=918) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
130. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_breckenridge_co_8a74ce3e128c4548_parcel_number_idx on assessor_breckenridge_co_8a74ce3e128c4548 (cost=0.29..0.31 rows=1 width=1,077) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
131. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_redding_ca_a960c2a6977d47b8_parcel_number_idx on assessor_redding_ca_a960c2a6977d47b8 (cost=0.29..0.31 rows=1 width=906) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
132. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_newport_county_ri_6c0661dbb60e44d2_parcel_number_idx on assessor_newport_county_ri_6c0661dbb60e44d2 (cost=0.29..0.31 rows=1 width=900) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
133. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_alachua_county_fl_1a46db0573604880_parcel_number_idx on assessor_alachua_county_fl_1a46db0573604880 (cost=0.42..0.44 rows=1 width=1,061) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
134. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_page_az_b494526f192e40ff_parcel_number_idx on assessor_page_az_b494526f192e40ff (cost=0.42..0.44 rows=1 width=1,074) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
135. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_wilmington_nc_f5f27c9dab984c06_parcel_number_idx on assessor_wilmington_nc_f5f27c9dab984c06 (cost=0.41..0.44 rows=1 width=939) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
136. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_hailey_id_5a4d3d75f8b94e26_parcel_number_idx on assessor_hailey_id_5a4d3d75f8b94e26 (cost=0.28..0.30 rows=1 width=1,071) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
137. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_alexandria_va_5efbeca77575478d_parcel_number_idx on assessor_alexandria_va_5efbeca77575478d (cost=0.29..0.31 rows=1 width=918) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
138. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_madison_wi_37c3f18db22f4b9a_parcel_number_idx on assessor_madison_wi_37c3f18db22f4b9a (cost=0.42..0.44 rows=1 width=915) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
139. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_gearhart_or_d32e1239534a4186_parcel_number_idx on assessor_gearhart_or_d32e1239534a4186 (cost=0.28..0.30 rows=1 width=922) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
140. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_garden_city_ut_eb914c2128bc422e_parcel_number_idx on assessor_garden_city_ut_eb914c2128bc422e (cost=0.28..0.30 rows=1 width=1,064) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
141. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_moab_ut_808fc2566da84170_parcel_number_idx on assessor_moab_ut_808fc2566da84170 (cost=0.28..0.30 rows=1 width=910) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
142. 75.415 75.415 ↓ 0.0 0 15,083

Index Scan using assessor_austin_tx_f6572d91c36f4e9f_parcel_number_idx on assessor_austin_tx_f6572d91c36f4e9f (cost=0.42..0.44 rows=1 width=1,050) (actual time=0.005..0.005 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
143. 75.415 75.415 ↓ 0.0 0 15,083

Index Scan using assessor_tulare_county_ca_25c67a45378648fd_parcel_number_idx on assessor_tulare_county_ca_25c67a45378648fd (cost=0.42..0.44 rows=1 width=1,085) (actual time=0.005..0.005 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
144. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_summit_county_ut_df245175543640ca_parcel_number_idx on assessor_summit_county_ut_df245175543640ca (cost=0.29..0.31 rows=1 width=1,048) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
145. 75.415 75.415 ↓ 0.0 0 15,083

Index Scan using assessor_san_diego_county_ca_5c3d607356664645_parcel_number_idx on assessor_san_diego_county_ca_5c3d607356664645 (cost=0.42..0.46 rows=1 width=927) (actual time=0.005..0.005 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
146. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_lake_county_ca_7c3b5d982a5d4b25_parcel_number_idx on assessor_lake_county_ca_7c3b5d982a5d4b25 (cost=0.41..0.44 rows=1 width=1,081) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
147. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_marin_county_ca_unincorporated_20c395697d0e4470_parcel on assessor_marin_county_ca_unincorporated_20c395697d0e4470 (cost=0.29..0.31 rows=1 width=1,084) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
148. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_kane_county_ut_cc31fab012c54796_parcel_number_idx on assessor_kane_county_ut_cc31fab012c54796 (cost=0.28..0.30 rows=1 width=920) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
149. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_lehman_township_pa_bf800d907ffc47af_parcel_number_idx on assessor_lehman_township_pa_bf800d907ffc47af (cost=0.29..0.31 rows=1 width=945) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
150. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_anna_maria_fl_c0b4b797a8f14296_parcel_number_idx on assessor_anna_maria_fl_c0b4b797a8f14296 (cost=0.28..0.30 rows=1 width=946) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
151. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_silverthorne_co_10fc3895b1bf4a62_parcel_number_idx on assessor_silverthorne_co_10fc3895b1bf4a62 (cost=0.28..0.30 rows=1 width=933) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
152. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_big_bear_lake_ca_8f097e18cb894ab4_parcel_number_idx on assessor_big_bear_lake_ca_8f097e18cb894ab4 (cost=0.29..0.31 rows=1 width=931) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
153. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_roseville_ca_4d670f6793f74f1c_parcel_number_idx on assessor_roseville_ca_4d670f6793f74f1c (cost=0.41..0.44 rows=1 width=954) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
154. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_chattanooga_tn_38e262c7baa04eda_parcel_number_idx on assessor_chattanooga_tn_38e262c7baa04eda (cost=0.42..0.44 rows=1 width=942) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
155. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_angel_fire_nm_be382a82b81043fa_parcel_number_idx on assessor_angel_fire_nm_be382a82b81043fa (cost=0.28..0.30 rows=1 width=944) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
156. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_beech_mountain_nc_43d5f02f856740ca_parcel_number_idx on assessor_beech_mountain_nc_43d5f02f856740ca (cost=0.28..0.30 rows=1 width=1,080) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
157. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_dillon_co_3373607f8c4b4c1b_parcel_number_idx on assessor_dillon_co_3373607f8c4b4c1b (cost=0.28..0.30 rows=1 width=915) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
158. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_blowing_rock_nc_edddaaba07554aea_parcel_number_idx on assessor_blowing_rock_nc_edddaaba07554aea (cost=0.28..0.30 rows=1 width=1,192) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
159. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_folly_beach_sc_46310055eddd40f1_parcel_number_idx on assessor_folly_beach_sc_46310055eddd40f1 (cost=0.28..0.30 rows=1 width=1,062) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
160. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_bozeman_mt_e52b17bcbf034652_parcel_number_idx on assessor_bozeman_mt_e52b17bcbf034652 (cost=0.29..0.31 rows=1 width=1,191) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
161. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_fraser_co_6efcb0645b5048d1_parcel_number_idx on assessor_fraser_co_6efcb0645b5048d1 (cost=0.28..0.30 rows=1 width=1,061) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
162. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_chico_ca_fb1090c1d58c4085_parcel_number_idx on assessor_chico_ca_fb1090c1d58c4085 (cost=0.29..0.31 rows=1 width=1,178) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
163. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_franklin_county_ny_97c569a37fa44e4a_parcel_number_idx on assessor_franklin_county_ny_97c569a37fa44e4a (cost=0.29..0.31 rows=1 width=1,185) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
164. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_columbus_ga_84044eecc9a94b1c_parcel_number_idx on assessor_columbus_ga_84044eecc9a94b1c (cost=0.41..0.44 rows=1 width=1,037) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
165. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_aurora_co_8f3892a814af408c_parcel_number_idx on assessor_aurora_co_8f3892a814af408c (cost=0.42..0.44 rows=1 width=1,188) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
166. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_brown_county_wi_2b1ecc33486f4f36_parcel_number_idx on assessor_brown_county_wi_2b1ecc33486f4f36 (cost=0.29..0.31 rows=1 width=1,176) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
167. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_charleston_county_sc_ac9aabfe8acb4d62_parcel_number_id on assessor_charleston_county_sc_ac9aabfe8acb4d62 (cost=0.42..0.44 rows=1 width=1,186) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
168. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_kansas_city_mo_8547276bea12463e_parcel_number_idx on assessor_kansas_city_mo_8547276bea12463e (cost=0.42..0.44 rows=1 width=1,042) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
  • Rows Removed by Filter: 0
169. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_irvine_ca_ffd0d45df0a3446c_parcel_number_idx on assessor_irvine_ca_ffd0d45df0a3446c (cost=0.41..0.44 rows=1 width=924) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
170. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_wyandotte_county_ks_0820e3e49a0d42d8_parcel_number_idx on assessor_wyandotte_county_ks_0820e3e49a0d42d8 (cost=0.29..0.31 rows=1 width=1,059) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
171. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_minneapolis_mn_a2207af2b038487c_parcel_number_idx on assessor_minneapolis_mn_a2207af2b038487c (cost=0.42..0.44 rows=1 width=1,041) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
172. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_fulton_county_ga_aa62ce4711444df2_parcel_number_idx on assessor_fulton_county_ga_aa62ce4711444df2 (cost=0.29..0.31 rows=1 width=1,210) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
173. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_san_luis_obispo_county_ca_cd71eef6b94b43dd_parcel_numb on assessor_san_luis_obispo_county_ca_cd71eef6b94b43dd (cost=0.42..0.44 rows=1 width=954) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
174. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_normal_il_91f7a10acd0f48f2_parcel_number_idx on assessor_normal_il_91f7a10acd0f48f2 (cost=0.29..0.31 rows=1 width=1,068) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
175. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_wasatch_county_ut_46e3c895c61a45ce_parcel_number_idx on assessor_wasatch_county_ut_46e3c895c61a45ce (cost=0.29..0.31 rows=1 width=1,145) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
176. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_dania_beach_fl_05c9b4122e93412b_parcel_number_idx on assessor_dania_beach_fl_05c9b4122e93412b (cost=0.29..0.31 rows=1 width=1,186) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
177. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_bonner_county_id_d28e1b8800b942f6_parcel_number_idx on assessor_bonner_county_id_d28e1b8800b942f6 (cost=0.29..0.31 rows=1 width=1,191) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
178. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_half_moon_bay_ca_8b25445193a24cd5_parcel_number_idx on assessor_half_moon_bay_ca_8b25445193a24cd5 (cost=0.28..0.30 rows=1 width=1,191) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
179. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_ojai_ca_b671f1045b114aaf_parcel_number_idx on assessor_ojai_ca_b671f1045b114aaf (cost=0.28..0.30 rows=1 width=1,176) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
180. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_port_hueneme_ca_47dbdb2fb5c94f18_parcel_number_idx on assessor_port_hueneme_ca_47dbdb2fb5c94f18 (cost=0.28..0.30 rows=1 width=1,191) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
181. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_new_hanover_county_nc_b9abd9021823452f_parcel_number_i on assessor_new_hanover_county_nc_b9abd9021823452f (cost=0.42..0.44 rows=1 width=1,058) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
182. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_shleter_island_ny_fd4f0ad7aed346a7_parcel_number_idx on assessor_shleter_island_ny_fd4f0ad7aed346a7 (cost=0.28..0.30 rows=1 width=918) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
183. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_port_angeles_wa_5619274c051544c4_parcel_number_idx on assessor_port_angeles_wa_5619274c051544c4 (cost=0.28..0.30 rows=1 width=1,083) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
184. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_santa_cruz_ca_09bd2134cb674d61_parcel_number_idx on assessor_santa_cruz_ca_09bd2134cb674d61 (cost=0.29..0.31 rows=1 width=1,063) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
185. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_lake_forest_ca_470ef5d1c54d4ef3_parcel_number_idx on assessor_lake_forest_ca_470ef5d1c54d4ef3 (cost=0.29..0.31 rows=1 width=1,049) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
186. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_weston_fl_847c1ebec8164c3f_parcel_number_idx on assessor_weston_fl_847c1ebec8164c3f (cost=0.29..0.31 rows=1 width=1,037) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
187. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_gunnison_co_ad214efdfbd94db1_parcel_number_idx on assessor_gunnison_co_ad214efdfbd94db1 (cost=0.29..0.31 rows=1 width=1,063) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
188. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_san_mateo_ca_1f786549df054b15_parcel_number_idx on assessor_san_mateo_ca_1f786549df054b15 (cost=0.29..0.31 rows=1 width=1,177) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
189. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_bay_county_fl_986cd275334b4ace_parcel_number_idx on assessor_bay_county_fl_986cd275334b4ace (cost=0.41..0.44 rows=1 width=1,066) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
  • Rows Removed by Filter: 0
190. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_indio_ca_0335078219e64bd4_parcel_number_idx on assessor_indio_ca_0335078219e64bd4 (cost=0.29..0.31 rows=1 width=1,166) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
191. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_cannon_beach_or_b58348aa8eb943f8_parcel_number_idx on assessor_cannon_beach_or_b58348aa8eb943f8 (cost=0.28..0.30 rows=1 width=925) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
192. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_grand_county_ut_525180824a4847e8_parcel_number_idx on assessor_grand_county_ut_525180824a4847e8 (cost=0.28..0.30 rows=1 width=923) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
193. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_grand_lake_co_cfc8a6ad0fd64c4b_parcel_number_idx on assessor_grand_lake_co_cfc8a6ad0fd64c4b (cost=0.28..0.30 rows=1 width=1,067) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
194. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_golden_co_632c53189af04663_parcel_number_idx on assessor_golden_co_632c53189af04663 (cost=0.28..0.30 rows=1 width=1,038) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
195. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_healdsburg_ca_fea3b5eece5b4cd0_parcel_number_idx on assessor_healdsburg_ca_fea3b5eece5b4cd0 (cost=0.28..0.30 rows=1 width=1,190) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
196. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_grand_county_co_344c6772a11942cb_parcel_number_idx on assessor_grand_county_co_344c6772a11942cb (cost=0.28..0.30 rows=1 width=1,069) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
197. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_hot_springs_ar_ac466d44f29c41d0_parcel_number_idx on assessor_hot_springs_ar_ac466d44f29c41d0 (cost=0.29..0.31 rows=1 width=1,051) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
198. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_twentynine_palms_ca_5371804d41dd40d7_parcel_number_idx on assessor_twentynine_palms_ca_5371804d41dd40d7 (cost=0.28..0.30 rows=1 width=1,048) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
199. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_iron_county_ut_043608fabca94286_parcel_number_idx on assessor_iron_county_ut_043608fabca94286 (cost=0.29..0.31 rows=1 width=1,213) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
200. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_henrico_county_va_e4cc95db69d04dd9_parcel_number_idx on assessor_henrico_county_va_e4cc95db69d04dd9 (cost=0.42..0.44 rows=1 width=1,046) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
201. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_ruidoso_nm_6e8345a4bf974788_parcel_number_idx on assessor_ruidoso_nm_6e8345a4bf974788 (cost=0.29..0.31 rows=1 width=1,047) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
202. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_norman_ok_22572b23caa74b80_parcel_number_idx on assessor_norman_ok_22572b23caa74b80 (cost=0.41..0.44 rows=1 width=922) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
203. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_baldwin_park_ca_740deb8eb465474a_parcel_number_idx on assessor_baldwin_park_ca_740deb8eb465474a (cost=0.29..0.31 rows=1 width=1,209) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
204. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_oconee_county_sc_2330900e5cf4408d_parcel_number_idx on assessor_oconee_county_sc_2330900e5cf4408d (cost=0.29..0.31 rows=1 width=1,188) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
205. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_ulster_county_ny_059968e3b55140b0_parcel_number_idx on assessor_ulster_county_ny_059968e3b55140b0 (cost=0.42..0.44 rows=1 width=1,038) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
206. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_pagosa_springs_co_b39a0b95e1eb4162_parcel_number_idx on assessor_pagosa_springs_co_b39a0b95e1eb4162 (cost=0.28..0.30 rows=1 width=1,068) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
207. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_lake_oswego_or_b8f686e77a3a49e4_parcel_number_idx on assessor_lake_oswego_or_b8f686e77a3a49e4 (cost=0.29..0.31 rows=1 width=1,194) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
208. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_rockaway_beach_or_b607d279faca4812_parcel_number_idx on assessor_rockaway_beach_or_b607d279faca4812 (cost=0.28..0.30 rows=1 width=932) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
209. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_kerrville_tx_63b2994366754851_parcel_number_idx on assessor_kerrville_tx_63b2994366754851 (cost=0.29..0.31 rows=1 width=1,038) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
210. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_rich_county_ut_b037e5ba9b434bf8_parcel_number_idx on assessor_rich_county_ut_b037e5ba9b434bf8 (cost=0.28..0.30 rows=1 width=1,182) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
211. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_lodi_ca_196ed6af0c8c458b_parcel_number_idx on assessor_lodi_ca_196ed6af0c8c458b (cost=0.29..0.31 rows=1 width=1,028) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
212. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_rancho_mirage_ca_97a210244f5a4e11_parcel_number_idx on assessor_rancho_mirage_ca_97a210244f5a4e11 (cost=0.28..0.30 rows=1 width=921) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
213. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_lake_placid_ny_41e6bdf037344c22_parcel_number_idx on assessor_lake_placid_ny_41e6bdf037344c22 (cost=0.28..0.30 rows=1 width=922) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
214. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_palm_desert_ca_3a03a87b1ae44ddb_parcel_number_idx on assessor_palm_desert_ca_3a03a87b1ae44ddb (cost=0.29..0.31 rows=1 width=1,173) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
215. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_garfield_county_ut_2a9d0370f3d043fe_parcel_number_idx on assessor_garfield_county_ut_2a9d0370f3d043fe (cost=0.29..0.31 rows=1 width=1,048) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
216. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_los_angeles_ca_58e6d7cf3ef14eed_parcel_number_idx on assessor_los_angeles_ca_58e6d7cf3ef14eed (cost=0.42..0.45 rows=1 width=1,210) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
217. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_sandpoint_id_b839f4f274ed4fef_parcel_number_idx on assessor_sandpoint_id_b839f4f274ed4fef (cost=0.28..0.30 rows=1 width=1,055) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
218. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_summit_county_co_2e3f848939b349ee_parcel_number_idx on assessor_summit_county_co_2e3f848939b349ee (cost=0.29..0.31 rows=1 width=933) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
219. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_sonoma_ca_f04bdafeb7464c3a_parcel_number_idx on assessor_sonoma_ca_f04bdafeb7464c3a (cost=0.28..0.30 rows=1 width=917) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
220. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_south_padre_tx_94dbf12c0dea42ab_parcel_number_idx on assessor_south_padre_tx_94dbf12c0dea42ab (cost=0.28..0.30 rows=1 width=955) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
221. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_talbot_county_md_662cb28e9bda4449_parcel_number_idx on assessor_talbot_county_md_662cb28e9bda4449 (cost=0.28..0.30 rows=1 width=917) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
222. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_seaside_or_bd06677ada184238_parcel_number_idx on assessor_seaside_or_bd06677ada184238 (cost=0.28..0.30 rows=1 width=936) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
223. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_rutherford_county_nc_7417df36ec264c35_parcel_number_id on assessor_rutherford_county_nc_7417df36ec264c35 (cost=0.29..0.31 rows=1 width=1,185) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
224. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_wimberley_tx_eaa0f84cf646438a_parcel_number_idx on assessor_wimberley_tx_eaa0f84cf646438a (cost=0.29..0.31 rows=1 width=1,200) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
225. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_holland_wi_6e4bd9fb57ca4210_parcel_number_idx on assessor_holland_wi_6e4bd9fb57ca4210 (cost=0.28..0.30 rows=1 width=1,060) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
226. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_wayne_county_ut_32e9d616cf644ceb_parcel_number_idx on assessor_wayne_county_ut_32e9d616cf644ceb (cost=0.28..0.30 rows=1 width=920) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
227. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_vail_co_84a792b22e2e4026_parcel_number_idx on assessor_vail_co_84a792b22e2e4026 (cost=0.29..0.31 rows=1 width=1,193) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
228. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_lake_george_ny_f9a95a00f0224d9e_parcel_number_idx on assessor_lake_george_ny_f9a95a00f0224d9e (cost=0.28..0.30 rows=1 width=887) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
229. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_whitefish_mt_7fa8277bc971411d_parcel_number_idx on assessor_whitefish_mt_7fa8277bc971411d (cost=0.28..0.30 rows=1 width=1,045) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
230. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_sedona_az_238b9f8d94034ad0_parcel_number_idx on assessor_sedona_az_238b9f8d94034ad0 (cost=0.29..0.31 rows=1 width=920) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
231. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_tillamook_county_or_15df87eb92934879_parcel_number_idx on assessor_tillamook_county_or_15df87eb92934879 (cost=0.29..0.31 rows=1 width=932) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
232. 30.166 30.166 ↓ 0.0 0 15,083

Index Scan using assessor_south_haven_mi_4059e48320ff45cc_parcel_number_idx on assessor_south_haven_mi_4059e48320ff45cc (cost=0.28..0.30 rows=1 width=1,172) (actual time=0.002..0.002 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
233. 60.332 60.332 ↓ 0.0 0 15,083

Index Scan using assessor_sacramento_ca_563f8f139d6b403e_parcel_number_idx on assessor_sacramento_ca_563f8f139d6b403e (cost=0.42..0.44 rows=1 width=1,049) (actual time=0.004..0.004 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
234. 45.249 45.249 ↓ 0.0 0 15,083

Index Scan using assessor_rocklin_ca_e23f296c4a844110_parcel_number_idx on assessor_rocklin_ca_e23f296c4a844110 (cost=0.29..0.31 rows=1 width=1,050) (actual time=0.003..0.003 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
235. 75.415 75.415 ↓ 0.0 0 15,083

Index Scan using assessor_montgomery_county_md_5283463c77a0409c_parcel_number_id on assessor_montgomery_county_md_5283463c77a0409c (cost=0.42..0.45 rows=1 width=926) (actual time=0.005..0.005 rows=0 loops=15,083)

  • Index Cond: ((parcel_number)::text = (property.parcel_number)::text)
  • Filter: ((source)::text = property.assessor_source)
236. 196.079 196.079 ↑ 1.0 1 15,083

Index Scan using property_to_permit_persisted_key on property_to_permit_persisted (cost=0.55..2.52 rows=1 width=55) (actual time=0.013..0.013 rows=1 loops=15,083)

  • Index Cond: (((geoid)::text = (property_compliance_persisted.geoid)::text) AND ((geoid)::text = '99999US09'::text) AND (internal_property_id = property_compliance_persisted.internal_property_id) AND (is_active = true) AND (exact_match = true))
  • Filter: (is_active AND exact_match)
237. 75.415 75.415 ↑ 1.0 1 15,083

Index Scan using permit_registrations_pkey on permit_registrations pr (cost=0.42..1.07 rows=1 width=72) (actual time=0.005..0.005 rows=1 loops=15,083)

  • Index Cond: (property_to_permit_persisted.permit_id = id)
238.          

SubPlan (forNested Loop Left Join)

239. 15.083 180.996 ↓ 0.0 0 15,083

Limit (cost=6.48..6.49 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=15,083)

240. 45.249 165.913 ↓ 0.0 0 15,083

Sort (cost=6.48..6.49 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=15,083)

  • Sort Key: permit_revenue.period_end DESC
  • Sort Method: quicksort Memory: 25kB
241. 15.083 120.664 ↓ 0.0 0 15,083

Nested Loop (cost=0.98..6.47 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=15,083)

  • Join Filter: ((permit_revenue.registration_number)::text = (property_to_permit_disaggregated_persisted.permit_number)::text)
242. 105.581 105.581 ↓ 0.0 0 15,083

Index Scan using permit_revenue_geoid_idx on permit_revenue (cost=0.42..2.59 rows=1 width=37) (actual time=0.007..0.007 rows=0 loops=15,083)

  • Index Cond: ((geoid)::text = '99999US09'::text)
243. 0.000 0.000 ↓ 0.0 0

Index Scan using property_to_permit_disaggregated_idx on property_to_permit_disaggregated_persisted (cost=0.56..3.86 rows=1 width=21) (never executed)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
  • Filter: (exact_match AND ((geoid)::text = '99999US09'::text))
244. 105.581 3,152.347 ↑ 1.0 1 15,083

Aggregate (cost=51.42..51.43 rows=1 width=25) (actual time=0.209..0.209 rows=1 loops=15,083)

245. 78.722 3,046.766 ↑ 3.0 3 15,083

Nested Loop (cost=1.68..51.31 rows=9 width=25) (actual time=0.137..0.202 rows=3 loops=15,083)

246. 54.179 2,413.280 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=50) (actual time=0.120..0.160 rows=3 loops=15,083)

247. 1,764.711 1,764.711 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property (cost=0.56..13.95 rows=11 width=13) (actual time=0.102..0.117 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
248. 594.390 594.390 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing l (cost=0.56..2.78 rows=1 width=37) (actual time=0.014..0.015 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property.internal_listing_id)
249. 554.764 554.764 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing (cost=0.56..0.73 rows=1 width=14) (actual time=0.014..0.014 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = l.internal_listing_id)
250. 60.332 754.150 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=8) (actual time=0.049..0.050 rows=1 loops=15,083)

251. 76.936 693.818 ↑ 3.7 3 15,083

Nested Loop (cost=1.12..44.61 rows=11 width=8) (actual time=0.024..0.046 rows=3 loops=15,083)

252. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_1 (cost=0.56..13.95 rows=11 width=13) (actual time=0.011..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
253. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing level1_listing_1 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_1.internal_listing_id)
254. 45.249 723.984 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=15,083)

255. 61.853 678.735 ↑ 3.7 3 15,083

Nested Loop (cost=1.12..44.61 rows=11 width=8) (actual time=0.023..0.045 rows=3 loops=15,083)

256. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_2 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
257. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing level1_listing_2 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_2.internal_listing_id)
258. 30.166 708.901 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=8) (actual time=0.047..0.047 rows=1 loops=15,083)

259. 76.936 678.735 ↑ 3.7 3 15,083

Nested Loop (cost=1.12..44.61 rows=11 width=8) (actual time=0.023..0.045 rows=3 loops=15,083)

260. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_3 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
261. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing level1_listing_3 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_3.internal_listing_id)
262. 497.739 4,796.394 ↑ 1.0 1 15,083

Aggregate (cost=887.93..887.94 rows=1 width=8) (actual time=0.318..0.318 rows=1 loops=15,083)

263. 868.327 4,298.655 ↓ 7.9 134 15,083

Nested Loop (cost=1.12..887.89 rows=17 width=8) (actual time=0.029..0.285 rows=134 loops=15,083)

264. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_4 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
265. 3,249.332 3,249.332 ↑ 1.3 51 39,626

Index Scan using screenshot_internal_listing_id_idx on screenshot (cost=0.56..78.77 rows=68 width=23) (actual time=0.016..0.082 rows=51 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_4.internal_listing_id)
  • Filter: active
  • Rows Removed by Filter: 1
266. 90.498 1,387.636 ↑ 1.0 1 15,083

Aggregate (cost=51.38..51.39 rows=1 width=170) (actual time=0.092..0.092 rows=1 loops=15,083)

267. 52.393 1,297.138 ↑ 3.0 3 15,083

Nested Loop (cost=1.68..51.33 rows=9 width=170) (actual time=0.040..0.086 rows=3 loops=15,083)

  • Join Filter: (listing_to_property_5.internal_listing_id = level1_listing_4.internal_listing_id)
268. 97.642 769.233 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=150) (actual time=0.026..0.051 rows=3 loops=15,083)

269. 196.079 196.079 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_5 (cost=0.56..13.95 rows=11 width=13) (actual time=0.011..0.013 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
270. 475.512 475.512 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing (cost=0.56..2.78 rows=1 width=137) (actual time=0.012..0.012 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_5.internal_listing_id)
271. 475.512 475.512 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing level1_listing_4 (cost=0.56..0.73 rows=1 width=59) (actual time=0.012..0.012 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing.internal_listing_id)
272. 45.249 723.984 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=15,083)

273. 61.853 678.735 ↑ 3.7 3 15,083

Nested Loop (cost=1.12..44.61 rows=11 width=8) (actual time=0.023..0.045 rows=3 loops=15,083)

274. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_6 (cost=0.56..13.95 rows=11 width=13) (actual time=0.011..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
275. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing level1_listing_5 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_6.internal_listing_id)
276. 60.332 844.648 ↑ 1.0 1 15,083

Aggregate (cost=44.66..44.67 rows=1 width=52) (actual time=0.056..0.056 rows=1 loops=15,083)

277. 63.639 784.316 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=52) (actual time=0.027..0.052 rows=3 loops=15,083)

278. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_7 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
279. 554.764 554.764 ↑ 1.0 1 39,626

Index Scan using listing_host_internal_listing_id_idx on listing_host (cost=0.56..2.78 rows=1 width=65) (actual time=0.014..0.014 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_7.internal_listing_id)
280. 45.249 723.984 ↑ 1.0 1 15,083

Aggregate (cost=43.13..43.14 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=15,083)

281. 37.310 678.735 ↓ 2.0 2 15,083

Nested Loop (cost=0.99..43.13 rows=1 width=8) (actual time=0.029..0.045 rows=2 loops=15,083)

282. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_8 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
283. 475.512 475.512 ↑ 1.0 1 39,626

Index Scan using jobs_output_pkey on jobs_output (cost=0.42..2.64 rows=1 width=20) (actual time=0.011..0.012 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_8.internal_listing_id)
284. 30.166 723.984 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=15,083)

285. 52.393 693.818 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=8) (actual time=0.023..0.046 rows=3 loops=15,083)

286. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_9 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
287. 475.512 475.512 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_1 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.012 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_9.internal_listing_id)
288. 30.166 708.901 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=4) (actual time=0.046..0.047 rows=1 loops=15,083)

289. 76.936 678.735 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=4) (actual time=0.023..0.045 rows=3 loops=15,083)

290. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_10 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
291. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_2 (cost=0.56..2.78 rows=1 width=17) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_10.internal_listing_id)
292. 75.415 754.150 ↑ 1.0 1 15,083

Aggregate (cost=44.77..44.78 rows=1 width=8) (actual time=0.050..0.050 rows=1 loops=15,083)

293. 76.936 678.735 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=8) (actual time=0.023..0.045 rows=3 loops=15,083)

294. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_11 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
295. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_3 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_11.internal_listing_id)
296. 105.581 784.316 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=14) (actual time=0.052..0.052 rows=1 loops=15,083)

297. 76.936 678.735 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=14) (actual time=0.023..0.045 rows=3 loops=15,083)

298. 165.913 165.913 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_12 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
299. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_4 (cost=0.56..2.78 rows=1 width=27) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_12.internal_listing_id)
300. 75.415 754.150 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=9) (actual time=0.050..0.050 rows=1 loops=15,083)

301. 61.853 678.735 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=9) (actual time=0.023..0.045 rows=3 loops=15,083)

302. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_13 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
303. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_5 (cost=0.56..2.78 rows=1 width=22) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_13.internal_listing_id)
304. 60.332 739.067 ↑ 1.0 1 15,083

Aggregate (cost=44.64..44.65 rows=1 width=15) (actual time=0.049..0.049 rows=1 loops=15,083)

305. 61.853 678.735 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=15) (actual time=0.023..0.045 rows=3 loops=15,083)

306. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_14 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
307. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_6 (cost=0.56..2.78 rows=1 width=28) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_14.internal_listing_id)
308. 105.581 1,025.644 ↑ 1.0 1 15,083

Aggregate (cost=47.97..47.98 rows=1 width=3) (actual time=0.068..0.068 rows=1 loops=15,083)

309. 67.741 920.063 ↑ 36.0 2 15,083

Nested Loop (cost=1.40..47.43 rows=72 width=3) (actual time=0.030..0.061 rows=2 loops=15,083)

310. 76.936 693.818 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..44.61 rows=9 width=13) (actual time=0.023..0.046 rows=3 loops=15,083)

311. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_15 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
312. 435.886 435.886 ↑ 1.0 1 39,626

Index Scan using listing_pkey on listing listing_7 (cost=0.56..2.78 rows=1 width=26) (actual time=0.011..0.011 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_15.internal_listing_id)
313. 158.504 158.504 ↑ 1.0 1 39,626

Index Scan using property_types_pkey on property_types (cost=0.28..0.30 rows=1 width=15) (actual time=0.004..0.004 rows=1 loops=39,626)

  • Index Cond: ((internal_site_id = (listing_7.internal_site_id)::text) AND (listing_property_type = listing_7.listing_property_type))
314. 60.332 769.233 ↑ 1.0 1 15,083

Aggregate (cost=44.67..44.68 rows=1 width=16) (actual time=0.051..0.051 rows=1 loops=15,083)

315. 52.393 708.901 ↑ 3.7 3 15,083

Nested Loop (cost=1.12..44.61 rows=11 width=16) (actual time=0.025..0.047 rows=3 loops=15,083)

316. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_16 (cost=0.56..13.95 rows=11 width=13) (actual time=0.011..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
317. 475.512 475.512 ↑ 1.0 1 39,626

Index Scan using level1_listing_pkey on level1_listing level1_listing_6 (cost=0.56..2.78 rows=1 width=29) (actual time=0.012..0.012 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_16.internal_listing_id)
318. 13.146 144.606 ↑ 1.0 1 4,382

Aggregate (cost=44.64..44.65 rows=1 width=8) (actual time=0.032..0.033 rows=1 loops=4,382)

319. 12.407 131.460 ↑ 11.0 1 4,382

Nested Loop (cost=1.12..44.61 rows=11 width=8) (actual time=0.023..0.030 rows=1 loops=4,382)

320. 48.202 48.202 ↑ 11.0 1 4,382

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_17 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.011 rows=1 loops=4,382)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
321. 70.851 70.851 ↑ 1.0 1 6,441

Index Scan using level1_listing_pkey on level1_listing level1_listing_7 (cost=0.56..2.78 rows=1 width=21) (actual time=0.011..0.011 rows=1 loops=6,441)

  • Index Cond: (internal_listing_id = listing_to_property_17.internal_listing_id)
322. 407.241 9,321.294 ↑ 1.0 1 15,083

Aggregate (cost=61,614.29..61,614.30 rows=1 width=4) (actual time=0.618..0.618 rows=1 loops=15,083)

323. 883.802 8,914.053 ↓ 1.2 109 15,083

Nested Loop (cost=1.83..61,614.06 rows=91 width=4) (actual time=0.066..0.591 rows=109 loops=15,083)

  • Join Filter: (listing_to_property_18.internal_listing_id = listing_calendar_availability.internal_listing_id)
324. 82.559 739.067 ↑ 3.0 3 15,083

Nested Loop (cost=1.12..34.71 rows=9 width=26) (actual time=0.024..0.049 rows=3 loops=15,083)

325. 180.996 180.996 ↑ 3.7 3 15,083

Index Scan using listing_to_property_internal_property_id_idx on listing_to_property listing_to_property_18 (cost=0.56..13.95 rows=11 width=13) (actual time=0.010..0.012 rows=3 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
326. 475.512 475.512 ↑ 1.0 1 39,626

Index Only Scan using listing_pkey on listing listing_8 (cost=0.56..1.88 rows=1 width=13) (actual time=0.012..0.012 rows=1 loops=39,626)

  • Index Cond: (internal_listing_id = listing_to_property_18.internal_listing_id)
  • Heap Fetches: 26532
327. 7,291.184 7,291.184 ↑ 95.3 42 39,626

Index Scan using listing_calendar_availability_key on listing_calendar_availability (cost=0.70..6,792.12 rows=4,002 width=17) (actual time=0.023..0.184 rows=42 loops=39,626)

  • Index Cond: ((internal_listing_id = listing_8.internal_listing_id) AND (availability_date > now()))
  • Filter: available
  • Rows Removed by Filter: 28
328. 15.083 527.905 ↑ 1.0 1 15,083

Limit (cost=25.43..25.43 rows=1 width=25) (actual time=0.035..0.035 rows=1 loops=15,083)

329. 60.332 512.822 ↑ 6.0 1 15,083

Sort (cost=25.43..25.44 rows=6 width=25) (actual time=0.034..0.034 rows=1 loops=15,083)

  • Sort Key: property_to_jurisdiction_1.geoid DESC
  • Sort Method: quicksort Memory: 25kB
330. 59.792 452.490 ↑ 6.0 1 15,083

Nested Loop (cost=0.98..25.40 rows=6 width=25) (actual time=0.028..0.030 rows=1 loops=15,083)

331. 241.328 241.328 ↑ 6.0 1 15,083

Index Scan using property_to_jurisdiction_internal_property_id_idx on property_to_jurisdiction property_to_jurisdiction_1 (cost=0.56..9.48 rows=6 width=13) (actual time=0.015..0.016 rows=1 loops=15,083)

  • Index Cond: (internal_property_id = property_compliance_persisted.internal_property_id)
  • Filter: (contained AND ((geoid)::text !~~ '%%u'::text) AND ((geoid)::text !~~ '99999%%'::text))
  • Rows Removed by Filter: 2
332. 151.370 151.370 ↑ 1.0 1 15,137

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

  • Index Cond: ((geoid)::text = (property_to_jurisdiction_1.geoid)::text)
333. 15.083 105.581 ↑ 1.0 1 15,083

Aggregate (cost=3.61..3.62 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=15,083)

334. 90.498 90.498 ↓ 0.0 0 15,083

Index Scan using call_center_log2_google_place_id_idx on call_center_log2 (cost=0.28..3.61 rows=2 width=4) (actual time=0.006..0.006 rows=0 loops=15,083)

  • Index Cond: (google_place_id = property.google_place_id)