explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XQs4

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,194,609.08..1,251,177.49 rows=955 width=152) (actual rows= loops=)

  • Hash Cond: (eligible_subdivid."SubdivID" = subscribed_area."SubdivID")
2.          

CTE subscribed_area

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=62,392.61..63,048.96 rows=23,867 width=79) (actual rows= loops=)

  • Group Key: ((((county.state || ' '::text) || county.name) || '-'::text) || ma.name), agent.name, CASE WHEN (subscription.reservation OR subscription.future_subscription OR (agent.status ~~ '%Reserver%'::text)) THEN ('Reserved by '::text || agent.name) ELSE ('Subscribed by '::text || agent.name) END
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32,434.87..62,213.61 rows=23,867 width=79) (actual rows= loops=)

  • Join Filter: CASE WHEN (lock_sp.value)::boolean THEN subscription.lockdown ELSE (((subscription.status)::text = 'Active'::text) AND (agent_1.status = 'Client'::text)) END
5. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100.00..193.15 rows=1 width=32) (actual rows= loops=)

  • Relations: (public.settings_properties mailing_sp) INNER JOIN (public.settings_properties lock_sp)
6. 0.000 0.000 ↓ 0.0

Gather (cost=32,334.87..60,648.10 rows=47,734 width=74) (actual rows= loops=)

  • Workers Planned: 2
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=31,334.87..54,874.70 rows=19,889 width=74) (actual rows= loops=)

  • Hash Cond: (ma.county_id = county.id)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=31,330.14..54,814.89 rows=19,889 width=71) (actual rows= loops=)

  • Join Filter: (subscription.agent_id = agent.id)
9. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=31,329.72..37,750.70 rows=19,889 width=59) (actual rows= loops=)

  • Hash Cond: (subscription.agent_id = agent_1.id)
10. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,145.78..7,491.55 rows=19,889 width=42) (actual rows= loops=)

  • Hash Cond: (ma.id = subscription.mailing_area_id)
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on mailing_area ma (cost=0.00..3,819.65 rows=56,365 width=34) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,794.79..1,794.79 rows=28,079 width=20) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on subscription (cost=0.00..1,794.79 rows=28,079 width=20) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=27,075.42..27,075.42 rows=114,842 width=17) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on agent agent_1 (cost=0.00..27,075.42 rows=114,842 width=17) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using agent_pkey on agent (cost=0.42..0.85 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = agent_1.id)
17. 0.000 0.000 ↓ 0.0

Hash (cost=3.77..3.77 rows=77 width=19) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on county (cost=0.00..3.77 rows=77 width=19) (actual rows= loops=)

19.          

CTE eligible_properties

20. 0.000 0.000 ↓ 0.0

Unique (cost=1,090,791.08..1,090,826.24 rows=4,689 width=27) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Sort (cost=1,090,791.08..1,090,802.80 rows=4,689 width=27) (actual rows= loops=)

  • Sort Key: pt_106."SubdivCode", pt_106."CountyID
22. 0.000 0.000 ↓ 0.0

Gather (cost=1,389.80..1,090,505.16 rows=4,689 width=27) (actual rows= loops=)

  • Workers Planned: 2
23. 0.000 0.000 ↓ 0.0

Hash Join (cost=389.80..1,089,036.26 rows=1,954 width=27) (actual rows= loops=)

  • Hash Cond: (pt_106."PropertyID" = (requested_area_property.property_id)::text)
24. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..875,611.01 rows=6,086,169 width=46) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Harris Property Table" pt_106 (cost=0.00..68,137.33 rows=462,925 width=44) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
26. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Miami Dade Property Table" pt_114 (cost=0.00..43,740.94 rows=318,238 width=47) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
27. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Broward Property Table" pt_108 (cost=0.00..36,453.08 rows=274,703 width=42) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
28. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Dallas Property Table" pt_97 (cost=0.00..36,348.14 rows=262,708 width=41) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
29. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Palm Beach Property Table" pt_104 (cost=0.00..31,233.43 rows=234,073 width=52) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
30. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Bexar Property Table" pt_70 (cost=0.00..30,336.80 rows=214,950 width=36) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
31. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Tarrant Property Table" pt_103 (cost=0.00..27,367.81 rows=230,235 width=34) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
32. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Hillsborough Property Table" pt_127 (cost=0.00..26,651.90 rows=176,599 width=52) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
33. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Lee Property Table" pt_132 (cost=0.00..26,304.76 rows=197,970 width=47) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
34. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Orange Property Table" pt_125 (cost=0.00..21,936.31 rows=167,120 width=45) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
35. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Pinellas Property Table" pt_116 (cost=0.00..21,717.07 rows=152,389 width=61) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
36. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Travis Property Table" pt_131 (cost=0.00..19,488.76 rows=125,847 width=38) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
37. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Collin Property Table" pt_102 (cost=0.00..17,441.43 rows=115,430 width=31) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
38. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Duval Property Table" pt_113 (cost=0.00..17,201.23 rows=130,189 width=35) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
39. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Brevard Property Table" pt_109 (cost=0.00..16,029.56 rows=115,285 width=52) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
40. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Polk Property Table" pt_118 (cost=0.00..15,407.54 rows=96,968 width=50) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
41. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Denton Property Table" pt_130 (cost=0.00..14,834.27 rows=98,005 width=32) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
42. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GA Fulton Property Table" pt_95 (cost=0.00..14,464.51 rows=133,520 width=45) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
43. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Fort Bend Property Table" pt_71 (cost=0.00..14,083.99 rows=96,425 width=52) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
44. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Sarasota Property Table" pt_135 (cost=0.00..13,277.15 rows=104,729 width=36) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
45. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Volusia Property Table" pt_119 (cost=0.00..13,224.62 rows=100,590 width=43) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
46. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Montgomery Property Table" pt_96 (cost=0.00..13,198.57 rows=66,419 width=44) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
47. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GA Gwinnett Property Table" pt_128 (cost=0.00..12,574.26 rows=104,971 width=35) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
48. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Collier Property Table" pt_134 (cost=0.00..12,531.94 rows=92,020 width=39) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
49. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Pasco Property Table" pt_115 (cost=0.00..12,360.59 rows=74,557 width=49) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
50. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Williamson Property Table" pt_129 (cost=0.00..11,816.10 rows=68,400 width=49) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
51. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Marion Property Table" pt_123 (cost=0.00..11,815.55 rows=88,151 width=42) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
52. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GA Cobb Property Table" pt_100 (cost=0.00..11,382.61 rows=98,899 width=32) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
53. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GA DeKalb Property Table" pt_99 (cost=0.00..10,148.82 rows=91,880 width=40) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
54. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Bergen Property Table" pt_74 (cost=0.00..9,980.05 rows=8,020 width=65) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
55. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Middlesex Property Table" pt_81 (cost=0.00..9,749.86 rows=91,184 width=64) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
56. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Monmouth Property Table" pt_92 (cost=0.00..9,677.36 rows=88,681 width=62) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
57. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Charlotte Property Table" pt_110 (cost=0.00..9,358.29 rows=75,687 width=49) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
58. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Manatee Property Table" pt_117 (cost=0.00..8,973.19 rows=64,587 width=38) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
59. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Osceola Property Table" pt_124 (cost=0.00..8,749.34 rows=60,777 width=57) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
60. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL St Lucie Property Table" pt_133 (cost=0.00..8,230.64 rows=61,121 width=44) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
61. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Escambia Property Table" pt_121 (cost=0.00..8,060.95 rows=52,877 width=48) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
62. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Galveston Property Table" pt_73 (cost=0.00..7,905.32 rows=48,468 width=41) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
63. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Camden Property Table" pt_91 (cost=0.00..7,318.98 rows=64,858 width=60) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
64. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Essex Property Table" pt_75 (cost=0.00..7,188.34 rows=63,838 width=59) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
65. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Burlington Property Table" pt_85 (cost=0.00..7,028.89 rows=60,803 width=64) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
66. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Brazoria Property Table" pt_72 (cost=0.00..6,863.79 rows=39,274 width=40) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
67. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Morris Property Table" pt_76 (cost=0.00..6,762.53 rows=63,411 width=60) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
68. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL St Johns Property Table" pt_122 (cost=0.00..6,747.46 rows=49,348 width=36) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
69. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Lake Property Table" pt_126 (cost=0.00..6,638.17 rows=47,493 width=49) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
70. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Seminole Property Table" pt_101 (cost=0.00..6,612.57 rows=1 width=67) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
71. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Atlantic Property Table" pt_84 (cost=0.00..5,966.36 rows=43,347 width=62) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
72. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Union Property Table" pt_82 (cost=0.00..5,573.81 rows=54,275 width=58) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
73. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Mercer Property Table" pt_89 (cost=0.00..5,286.55 rows=47,828 width=60) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
74. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Hudson Property Table" pt_93 (cost=0.00..5,180.85 rows=45,864 width=61) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
75. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Martin Property Table" pt_107 (cost=0.00..5,014.22 rows=29,113 width=57) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
76. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Passiac Property Table" pt_83 (cost=0.00..4,932.32 rows=45,631 width=61) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
77. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Leon Property Table" pt_112 (cost=0.00..4,858.96 rows=35,901 width=38) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
78. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GA Cherokee Property Table" pt_105 (cost=0.00..4,799.35 rows=30,811 width=46) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
79. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Indian River Property Table" pt_111 (cost=0.00..4,668.79 rows=28,198 width=61) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
80. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Somerset Property Table" pt_77 (cost=0.00..4,633.43 rows=42,988 width=63) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
81. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Gloucester Property Table" pt_94 (cost=0.00..4,625.97 rows=39,512 width=64) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
82. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Glouster Property Table" pt_88 (cost=0.00..4,567.97 rows=39,276 width=62) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
83. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "TX Hays Property Table" pt_98 (cost=0.00..4,308.14 rows=21,763 width=44) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
84. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Cape May Property Table" pt_86 (cost=0.00..4,196.38 rows=37,081 width=63) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
85. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Clay Property Table" pt_69 (cost=0.00..4,111.47 rows=390 width=96) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
86. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "FL Flagler Property Table" pt_120 (cost=0.00..3,584.26 rows=28,483 width=50) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
87. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Sussex Property Table" pt_80 (cost=0.00..3,076.33 rows=32,447 width=60) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
88. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Cumberland Property Table" pt_87 (cost=0.00..2,688.42 rows=24,734 width=63) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
89. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Hunterdon Property Table" pt_78 (cost=0.00..2,438.68 rows=24,962 width=63) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
90. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Warren Property Table" pt_79 (cost=0.00..1,994.54 rows=20,378 width=60) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
91. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NJ Salem Property Table" pt_90 (cost=0.00..1,318.54 rows=11,952 width=58) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
92. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "Property Table" pt_68 (cost=0.00..0.00 rows=1 width=96) (actual rows= loops=)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
93. 0.000 0.000 ↓ 0.0

Hash (cost=331.05..331.05 rows=4,700 width=15) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Seq Scan on requested_area_property (cost=0.00..331.05 rows=4,700 width=15) (actual rows= loops=)

  • Filter: (requested_area_id = 25)
95.          

CTE eligible_subdivid

96. 0.000 0.000 ↓ 0.0

Unique (cost=39,956.97..39,957.29 rows=26 width=111) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Sort (cost=39,956.97..39,957.03 rows=26 width=111) (actual rows= loops=)

  • Sort Key: st."SubdivID", st."SubdivName", pt_136."SubdivCode", pt_136."CountyID
98. 0.000 0.000 ↓ 0.0

Hash Join (cost=33,240.15..39,956.36 rows=26 width=111) (actual rows= loops=)

  • Hash Cond: ((pt_136."CountyID" = st."CountyID") AND (pt_136."SubdivCode" = st."SubdivCode"))
99. 0.000 0.000 ↓ 0.0

CTE Scan on eligible_properties pt_136 (cost=0.00..93.78 rows=4,689 width=64) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Hash (cost=18,454.57..18,454.57 rows=553,372 width=72) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Append (cost=0.00..18,454.57 rows=553,372 width=72) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Seq Scan on "Subdivision Table" st (cost=0.00..0.00 rows=1 width=128) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Fort Bend Subdivision Table" st_1 (cost=0.00..240.52 rows=8,252 width=74) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Galveston Subdivision Table" st_2 (cost=0.00..195.30 rows=6,830 width=68) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Seminole Subdivision Table" st_3 (cost=0.00..188.11 rows=7,011 width=73) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Cobb Subdivision Table" st_4 (cost=0.00..105.67 rows=4,067 width=56) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Cherokee Subdivision Table" st_5 (cost=0.00..55.16 rows=1,916 width=78) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Escambia Subdivision Table" st_6 (cost=0.00..446.31 rows=16,231 width=71) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Seq Scan on "FL St Johns Subdivision Table" st_7 (cost=0.00..210.43 rows=7,343 width=70) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Marion Subdivision Table" st_8 (cost=0.00..172.34 rows=6,034 width=69) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Osceola Subdivision Table" st_9 (cost=0.00..221.75 rows=8,075 width=74) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Martin Subdivision Table" st_10 (cost=0.00..111.55 rows=3,655 width=71) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Leon Subdivision Table" st_11 (cost=0.00..93.15 rows=3,515 width=60) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Polk Subdivision Table" st_12 (cost=0.00..327.70 rows=11,570 width=69) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Orange Subdivision Table" st_13 (cost=0.00..492.44 rows=17,644 width=69) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Gwinnett Subdivision Table" st_14 (cost=0.00..480.16 rows=18,216 width=71) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Lake Subdivision Table" st_15 (cost=0.00..204.68 rows=7,268 width=70) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Indian River Subdivision Table" st_16 (cost=0.00..125.23 rows=4,223 width=81) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Tarrant Subdivision Table" st_17 (cost=0.00..328.04 rows=11,804 width=66) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Fulton Subdivision Table" st_18 (cost=0.00..141.47 rows=5,147 width=69) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Flagler Subdivision Table" st_19 (cost=0.00..53.68 rows=1,868 width=74) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Collin Subdivision Table" st_20 (cost=0.00..371.18 rows=13,018 width=65) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Dallas Subdivision Table" st_21 (cost=0.00..1,515.86 rows=54,586 width=73) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Volusia Subdivision Table" st_22 (cost=0.00..390.60 rows=13,360 width=71) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Harris Subdivision Table" st_23 (cost=0.00..449.96 rows=16,396 width=70) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Pinellas Subdivision Table" st_24 (cost=0.00..490.84 rows=16,384 width=84) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Duval Subdivision Table" st_25 (cost=0.00..302.00 rows=11,200 width=60) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Denton Subdivision Table" st_26 (cost=0.00..349.80 rows=12,980 width=66) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Travis Subdivision Table" st_27 (cost=0.00..667.85 rows=23,685 width=67) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Charlotte Subdivision Table" st_28 (cost=0.00..68.15 rows=2,615 width=74) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Broward Subdivision Table" st_29 (cost=0.00..645.00 rows=22,000 width=69) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Pasco Subdivision Table" st_30 (cost=0.00..265.62 rows=9,762 width=67) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Montgomery Subdivision Table" st_31 (cost=0.00..247.45 rows=8,645 width=74) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Lee Subdivision Table" st_32 (cost=0.00..1,461.18 rows=49,718 width=72) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Collier Subdivision Table" st_33 (cost=0.00..257.67 rows=9,467 width=71) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Manatee Subdivision Table" st_34 (cost=0.00..293.16 rows=10,116 width=74) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Seq Scan on "GA DeKalb Subdivision Table" st_35 (cost=0.00..237.61 rows=8,461 width=67) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Palm Beach Subdivision Table" st_36 (cost=0.00..648.36 rows=22,136 width=80) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Williamson Subdivision Table" st_37 (cost=0.00..280.66 rows=10,666 width=74) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Sarasota Subdivision Table" st_38 (cost=0.00..252.14 rows=9,014 width=74) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Seq Scan on "FL St Lucie Subdivision Table" st_39 (cost=0.00..230.08 rows=8,008 width=75) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Bexar Subdivision Table" st_40 (cost=0.00..105.70 rows=4,170 width=61) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Brevard Subdivision Table" st_41 (cost=0.00..344.97 rows=11,397 width=89) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Hillsborough Subdivision Table" st_42 (cost=0.00..610.79 rows=20,979 width=72) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Miami Dade Subdivision Table" st_43 (cost=0.00..1,007.39 rows=33,939 width=74) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.91..56,535.88 rows=8 width=120) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.91..4,281.10 rows=26 width=128) (actual rows= loops=)

  • Hash Cond: (nt."SubdivID" = eligible_subdivid."SubdivID")
148. 0.000 0.000 ↓ 0.0

Append (cost=0.00..3,798.14 rows=128,477 width=29) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Seq Scan on "Neighborhood Table" nt (cost=0.00..0.00 rows=1 width=32) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Clay Neighborhood Table" nt_1 (cost=0.00..15.29 rows=429 width=32) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Fort Bend Neighborhood Table" nt_2 (cost=0.00..33.00 rows=1,300 width=33) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Brazoria Neighborhood Table" nt_3 (cost=0.00..35.51 rows=1,451 width=29) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Galveston Neighborhood Table" nt_4 (cost=0.00..54.47 rows=2,147 width=32) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Fulton Neighborhood Table" nt_5 (cost=0.00..73.12 rows=3,012 width=28) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Montgomery Neighborhood Table" nt_6 (cost=0.00..17.10 rows=710 width=32) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Seq Scan on "GA DeKalb Neighborhood Table" nt_7 (cost=0.00..88.51 rows=3,651 width=28) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Dallas Neighborhood Table" nt_8 (cost=0.00..292.07 rows=11,707 width=31) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Cobb Neighborhood Table" nt_9 (cost=0.00..80.64 rows=3,464 width=24) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Seminole Neighborhood Table" nt_10 (cost=0.00..44.10 rows=1,810 width=28) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Collin Neighborhood Table" nt_11 (cost=0.00..17.30 rows=730 width=30) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Tarrant Neighborhood Table" nt_12 (cost=0.00..17.40 rows=740 width=29) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Palm Beach Neighborhood Table" nt_13 (cost=0.00..122.36 rows=4,836 width=32) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Cherokee Neighborhood Table" nt_14 (cost=0.00..17.40 rows=740 width=29) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Harris Neighborhood Table" nt_15 (cost=0.00..127.73 rows=5,273 width=28) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Martin Neighborhood Table" nt_16 (cost=0.00..25.26 rows=1,026 width=28) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Broward Neighborhood Table" nt_17 (cost=0.00..125.94 rows=5,194 width=29) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Brevard Neighborhood Table" nt_18 (cost=0.00..60.43 rows=2,443 width=29) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Charlotte Neighborhood Table" nt_19 (cost=0.00..19.55 rows=755 width=32) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Indian River Neighborhood Table" nt_20 (cost=0.00..25.93 rows=993 width=32) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Leon Neighborhood Table" nt_21 (cost=0.00..33.10 rows=1,410 width=25) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Duval Neighborhood Table" nt_22 (cost=0.00..82.07 rows=3,507 width=25) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Miami Dade Neighborhood Table" nt_23 (cost=0.00..251.25 rows=10,225 width=30) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Pasco Neighborhood Table" nt_24 (cost=0.00..32.61 rows=1,361 width=26) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Pinellas Neighborhood Table" nt_25 (cost=0.00..135.04 rows=5,504 width=29) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Polk Neighborhood Table" nt_26 (cost=0.00..102.20 rows=4,320 width=26) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Volusia Neighborhood Table" nt_27 (cost=0.00..70.91 rows=2,891 width=29) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Flagler Neighborhood Table" nt_28 (cost=0.00..8.46 rows=346 width=27) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Escambia Neighborhood Table" nt_29 (cost=0.00..37.27 rows=1,527 width=28) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Seq Scan on "FL St Johns Neighborhood Table" nt_30 (cost=0.00..29.73 rows=1,173 width=30) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Marion Neighborhood Table" nt_31 (cost=0.00..47.98 rows=1,998 width=28) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Osceola Neighborhood Table" nt_32 (cost=0.00..30.39 rows=1,239 width=28) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Orange Neighborhood Table" nt_33 (cost=0.00..102.26 rows=4,226 width=28) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Lake Neighborhood Table" nt_34 (cost=0.00..45.38 rows=1,938 width=24) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Hillsborough Neighborhood Table" nt_35 (cost=0.00..143.74 rows=5,674 width=32) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Seq Scan on "GA Gwinnett Neighborhood Table" nt_36 (cost=0.00..86.42 rows=3,542 width=29) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Denton Neighborhood Table" nt_37 (cost=0.00..17.60 rows=760 width=28) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Travis Neighborhood Table" nt_38 (cost=0.00..188.36 rows=7,336 width=32) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Lee Neighborhood Table" nt_39 (cost=0.00..75.37 rows=3,137 width=28) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Seq Scan on "FL St Lucie Neighborhood Table" nt_40 (cost=0.00..21.60 rows=860 width=31) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Collier Neighborhood Table" nt_41 (cost=0.00..61.15 rows=2,415 width=32) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Manatee Neighborhood Table" nt_42 (cost=0.00..82.49 rows=3,449 width=29) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Williamson Neighborhood Table" nt_43 (cost=0.00..49.89 rows=1,989 width=30) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Sarasota Neighborhood Table" nt_44 (cost=0.00..80.53 rows=3,253 width=31) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Seq Scan on "TX Bexar Neighborhood Table" nt_45 (cost=0.00..46.85 rows=1,985 width=25) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Hash (cost=0.58..0.58 rows=26 width=128) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

CTE Scan on eligible_subdivid (cost=0.00..0.58 rows=26 width=128) (actual rows= loops=)

  • Filter: ("SubdivID" !~~ '%Not in Subdivision%'::text)
197. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,003.68 rows=612 width=84) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Seq Scan on "Property Table" pt (cost=0.00..0.00 rows=1 width=176) (actual rows= loops=)

  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
199. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "FL Clay Property Table" pt_1 (cost=4.44..12.33 rows=1 width=176) (actual rows= loops=)

  • Recheck Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
200. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "FL Clay Property Table_idx_2" (cost=0.00..4.44 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
201. 0.000 0.000 ↓ 0.0

Index Scan using "TX Bexar Property Table_idx_2" on "TX Bexar Property Table" pt_2 (cost=0.42..43.56 rows=13 width=72) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
202. 0.000 0.000 ↓ 0.0

Index Scan using "TX Fort Bend Property Table_idx_3" on "TX Fort Bend Property Table" pt_3 (cost=0.42..8.45 rows=1 width=90) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
203. 0.000 0.000 ↓ 0.0

Index Scan using "TX Brazoria Property Table_idx_2" on "TX Brazoria Property Table" pt_4 (cost=0.42..47.19 rows=1 width=77) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
204. 0.000 0.000 ↓ 0.0

Index Scan using "TX Galveston Property Table_idx_3" on "TX Galveston Property Table" pt_5 (cost=0.42..8.45 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
205. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Bergen Property Table_idx_2" on "NJ Bergen Property Table" pt_6 (cost=0.42..6.20 rows=1 width=101) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
206. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Essex Property Table_idx_2" on "NJ Essex Property Table" pt_7 (cost=0.42..6.19 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
207. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Morris Property Table_idx_2" on "NJ Morris Property Table" pt_8 (cost=0.42..6.19 rows=1 width=94) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
208. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Somerset Property Table_idx_2" on "NJ Somerset Property Table" pt_9 (cost=0.42..6.19 rows=1 width=98) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
209. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Hunterdon Property Table_idx_2" on "NJ Hunterdon Property Table" pt_10 (cost=0.41..6.03 rows=1 width=99) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
210. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Warren Property Table_idx_2" on "NJ Warren Property Table" pt_11 (cost=0.41..6.03 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
211. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Sussex Property Table_idx_2" on "NJ Sussex Property Table" pt_12 (cost=0.42..6.19 rows=1 width=94) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
212. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Middlesex Property Table_idx_2" on "NJ Middlesex Property Table" pt_13 (cost=0.42..6.19 rows=1 width=99) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
213. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Union Property Table_idx_2" on "NJ Union Property Table" pt_14 (cost=0.42..6.19 rows=1 width=93) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
214. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Passiac Property Table_idx_2" on "NJ Passiac Property Table" pt_15 (cost=0.42..6.19 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
215. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Atlantic Property Table_idx_2" on "NJ Atlantic Property Table" pt_16 (cost=0.42..6.19 rows=1 width=98) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
216. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Burlington Property Table_idx_2" on "NJ Burlington Property Table" pt_17 (cost=0.42..6.19 rows=1 width=99) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
217. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Cape May Property Table_idx_2" on "NJ Cape May Property Table" pt_18 (cost=0.42..6.19 rows=1 width=98) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
218. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Cumberland Property Table_idx_2" on "NJ Cumberland Property Table" pt_19 (cost=0.42..6.19 rows=1 width=98) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
219. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Glouster Property Table_idx_2" on "NJ Glouster Property Table" pt_20 (cost=0.42..6.19 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
220. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Mercer Property Table_idx_2" on "NJ Mercer Property Table" pt_21 (cost=0.42..6.19 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
221. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Salem Property Table_idx_2" on "NJ Salem Property Table" pt_22 (cost=0.41..6.03 rows=1 width=93) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
222. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Camden Property Table_idx_2" on "NJ Camden Property Table" pt_23 (cost=0.42..6.19 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
223. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Monmouth Property Table_idx_2" on "NJ Monmouth Property Table" pt_24 (cost=0.42..6.19 rows=1 width=97) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
224. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Hudson Property Table_idx_2" on "NJ Hudson Property Table" pt_25 (cost=0.42..6.19 rows=1 width=95) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
225. 0.000 0.000 ↓ 0.0

Index Scan using "NJ Gloucester Property Table_idx_2" on "NJ Gloucester Property Table" pt_26 (cost=0.42..6.19 rows=1 width=98) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
226. 0.000 0.000 ↓ 0.0

Index Scan using "GA Fulton Property Table_idx_2" on "GA Fulton Property Table" pt_27 (cost=0.42..31.15 rows=13 width=83) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
227. 0.000 0.000 ↓ 0.0

Index Scan using "TX Montgomery Property Table_idx_3" on "TX Montgomery Property Table" pt_28 (cost=0.42..8.45 rows=1 width=83) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
228. 0.000 0.000 ↓ 0.0

Index Scan using "TX Dallas Property Table_idx_2" on "TX Dallas Property Table" pt_29 (cost=0.42..29.65 rows=6 width=78) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
229. 0.000 0.000 ↓ 0.0

Index Scan using "TX Hays Property Table_idx_3" on "TX Hays Property Table" pt_30 (cost=0.29..8.32 rows=1 width=79) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
230. 0.000 0.000 ↓ 0.0

Index Scan using "GA DeKalb Property Table_idx_3" on "GA DeKalb Property Table" pt_31 (cost=0.42..8.45 rows=1 width=77) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
231. 0.000 0.000 ↓ 0.0

Index Scan using "GA Cobb Property Table_idx_3" on "GA Cobb Property Table" pt_32 (cost=0.42..8.45 rows=1 width=70) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
232. 0.000 0.000 ↓ 0.0

Index Scan using "FL Seminole Property Table_idx_2" on "FL Seminole Property Table" pt_33 (cost=0.42..6.19 rows=1 width=132) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
233. 0.000 0.000 ↓ 0.0

Index Scan using "TX Collin Property Table_idx_2" on "TX Collin Property Table" pt_34 (cost=0.42..46.70 rows=12 width=67) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
234. 0.000 0.000 ↓ 0.0

Index Scan using "TX Tarrant Property Table_idx_2" on "TX Tarrant Property Table" pt_35 (cost=0.42..48.74 rows=11 width=70) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
235. 0.000 0.000 ↓ 0.0

Index Scan using "FL Palm Beach Property Table_idx_2" on "FL Palm Beach Property Table" pt_36 (cost=0.42..52.77 rows=10 width=89) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
236. 0.000 0.000 ↓ 0.0

Index Scan using "GA Cherokee Property Table_idx_2" on "GA Cherokee Property Table" pt_37 (cost=0.42..38.53 rows=12 width=82) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
237. 0.000 0.000 ↓ 0.0

Index Scan using "TX Harris Property Table_idx_2" on "TX Harris Property Table" pt_38 (cost=0.43..53.04 rows=17 width=81) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
238. 0.000 0.000 ↓ 0.0

Index Scan using "FL Martin Property Table_idx_2" on "FL Martin Property Table" pt_39 (cost=0.42..50.34 rows=18 width=96) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
239. 0.000 0.000 ↓ 0.0

Index Scan using "FL Broward Property Table_idx_2" on "FL Broward Property Table" pt_40 (cost=0.42..52.83 rows=22 width=78) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
240. 0.000 0.000 ↓ 0.0

Index Scan using "FL Brevard Property Table_idx_2" on "FL Brevard Property Table" pt_41 (cost=0.42..46.63 rows=19 width=87) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
241. 0.000 0.000 ↓ 0.0

Index Scan using "FL Charlotte Property Table_idx_2" on "FL Charlotte Property Table" pt_42 (cost=0.42..49.37 rows=21 width=86) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
242. 0.000 0.000 ↓ 0.0

Index Scan using "FL Indian River Property Table_idx_2" on "FL Indian River Property Table" pt_43 (cost=0.42..50.13 rows=13 width=96) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
243. 0.000 0.000 ↓ 0.0

Index Scan using "FL Leon Property Table_idx_2" on "FL Leon Property Table" pt_44 (cost=0.42..47.95 rows=20 width=75) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
244. 0.000 0.000 ↓ 0.0

Index Scan using "FL Duval Property Table_idx_2" on "FL Duval Property Table" pt_45 (cost=0.42..52.36 rows=21 width=72) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
245. 0.000 0.000 ↓ 0.0

Index Scan using "FL Miami Dade Property Table_idx_2" on "FL Miami Dade Property Table" pt_46 (cost=0.42..52.90 rows=19 width=83) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
246. 0.000 0.000 ↓ 0.0

Index Scan using "FL Pasco Property Table_idx_2" on "FL Pasco Property Table" pt_47 (cost=0.42..49.77 rows=16 width=89) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
247. 0.000 0.000 ↓ 0.0

Index Scan using "FL Pinellas Property Table_idx_2" on "FL Pinellas Property Table" pt_48 (cost=0.42..52.56 rows=21 width=98) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
248. 0.000 0.000 ↓ 0.0

Index Scan using "FL Manatee Property Table_idx_2" on "FL Manatee Property Table" pt_49 (cost=0.42..51.55 rows=20 width=75) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
249. 0.000 0.000 ↓ 0.0

Index Scan using "FL Polk Property Table_idx_2" on "FL Polk Property Table" pt_50 (cost=0.42..50.59 rows=18 width=86) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
250. 0.000 0.000 ↓ 0.0

Index Scan using "FL Volusia Property Table_idx_2" on "FL Volusia Property Table" pt_51 (cost=0.42..52.09 rows=1 width=79) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
251. 0.000 0.000 ↓ 0.0

Index Scan using "FL Flagler Property Table_idx_3" on "FL Flagler Property Table" pt_52 (cost=0.29..8.32 rows=1 width=85) (actual rows= loops=)

  • Index Cond: (("Latitude" IS NOT NULL) AND ("Longitude" IS NOT NULL))
  • Filter: (("PropertyType" = ANY ('{SF,CON}'::text[])) AND (eligible_subdivid."CountyID" = "CountyID") AND (eligible_subdivid."SubdivCode" = "SubdivCode"))
252. 0.000 0.000 ↓ 0.0

Index Scan using "FL Escambia Property Table_idx_2" on "FL Escambia Property Table" pt_53 (cost=0.42..51.42 rows=19 width=84) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
253. 0.000 0.000 ↓ 0.0

Index Scan using "FL St Johns Property Table_idx_2" on "FL St Johns Property Table" pt_54 (cost=0.42..43.91 rows=12 width=72) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
254. 0.000 0.000 ↓ 0.0

Index Scan using "FL Marion Property Table_idx_2" on "FL Marion Property Table" pt_55 (cost=0.42..49.71 rows=19 width=79) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
255. 0.000 0.000 ↓ 0.0

Index Scan using "FL Osceola Property Table_idx_2" on "FL Osceola Property Table" pt_56 (cost=0.42..51.55 rows=21 width=94) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
256. 0.000 0.000 ↓ 0.0

Index Scan using "FL Orange Property Table_idx_2" on "FL Orange Property Table" pt_57 (cost=0.42..52.56 rows=22 width=82) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
257. 0.000 0.000 ↓ 0.0

Index Scan using "FL Lake Property Table_idx_2" on "FL Lake Property Table" pt_58 (cost=0.42..51.01 rows=21 width=86) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
258. 0.000 0.000 ↓ 0.0

Index Scan using "FL Hillsborough Property Table_idx_2" on "FL Hillsborough Property Table" pt_59 (cost=0.42..52.70 rows=19 width=90) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
259. 0.000 0.000 ↓ 0.0

Index Scan using "GA Gwinnett Property Table_idx_2" on "GA Gwinnett Property Table" pt_60 (cost=0.42..46.43 rows=20 width=72) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
260. 0.000 0.000 ↓ 0.0

Index Scan using "TX Williamson Property Table_idx_2" on "TX Williamson Property Table" pt_61 (cost=0.42..44.66 rows=12 width=85) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
261. 0.000 0.000 ↓ 0.0

Index Scan using "TX Denton Property Table_idx_2" on "TX Denton Property Table" pt_62 (cost=0.42..48.27 rows=13 width=68) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
262. 0.000 0.000 ↓ 0.0

Index Scan using "TX Travis Property Table_idx_2" on "TX Travis Property Table" pt_63 (cost=0.42..45.06 rows=10 width=75) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
263. 0.000 0.000 ↓ 0.0

Index Scan using "FL Lee Property Table_idx_2" on "FL Lee Property Table" pt_64 (cost=0.42..52.70 rows=22 width=84) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
264. 0.000 0.000 ↓ 0.0

Index Scan using "FL St Lucie Property Table_idx_2" on "FL St Lucie Property Table" pt_65 (cost=0.42..51.42 rows=18 width=81) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
265. 0.000 0.000 ↓ 0.0

Index Scan using "FL Collier Property Table_idx_2" on "FL Collier Property Table" pt_66 (cost=0.42..49.77 rows=8 width=78) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
266. 0.000 0.000 ↓ 0.0

Index Scan using "FL Sarasota Property Table_idx_2" on "FL Sarasota Property Table" pt_67 (cost=0.42..52.09 rows=21 width=72) (actual rows= loops=)

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
  • Filter: (("Longitude" IS NOT NULL) AND ("Latitude" IS NOT NULL) AND ("PropertyType" = ANY ('{SF,CON}'::text[])))
267. 0.000 0.000 ↓ 0.0

Hash (cost=477.34..477.34 rows=23,867 width=64) (actual rows= loops=)

268. 0.000 0.000 ↓ 0.0

CTE Scan on subscribed_area (cost=0.00..477.34 rows=23,867 width=64) (actual rows= loops=)