explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yNJd

Settings
# exclusive inclusive rows x rows loops node
1. 18.729 134,096.854 ↓ 11.3 10,751 1

Hash Left Join (cost=1,194,609.08..1,251,177.49 rows=955 width=152) (actual time=133,675.507..134,096.854 rows=10,751 loops=1)

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

CTE subscribed_area

3. 17.963 5,536.193 ↑ 9.2 2,608 1

HashAggregate (cost=62,392.61..63,048.96 rows=23,867 width=79) (actual time=5,531.961..5,536.193 rows=2,608 loops=1)

  • 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. 42.114 5,518.230 ↑ 9.2 2,608 1

Nested Loop (cost=32,434.87..62,213.61 rows=23,867 width=79) (actual time=4,912.343..5,518.230 rows=2,608 loops=1)

  • Join Filter: CASE WHEN (lock_sp.value)::boolean THEN subscription.lockdown ELSE (((subscription.status)::text = 'Active'::text) AND (agent_1.status = 'Client'::text)) END
  • Rows Removed by Join Filter: 45126
5. 395.291 395.291 ↑ 1.0 1 1

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

  • Relations: (public.settings_properties mailing_sp) INNER JOIN (public.settings_properties lock_sp)
6. 284.755 5,080.825 ↑ 1.0 47,734 1

Gather (cost=32,334.87..60,648.10 rows=47,734 width=74) (actual time=4,516.165..5,080.825 rows=47,734 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 43.126 4,796.070 ↑ 1.3 15,911 3 / 3

Hash Join (cost=31,334.87..54,874.70 rows=19,889 width=74) (actual time=4,303.077..4,796.070 rows=15,911 loops=3)

  • Hash Cond: (ma.county_id = county.id)
8. 91.058 4,752.729 ↑ 1.3 15,911 3 / 3

Nested Loop (cost=31,330.14..54,814.89 rows=19,889 width=71) (actual time=4,302.485..4,752.729 rows=15,911 loops=3)

  • Join Filter: (subscription.agent_id = agent.id)
9. 212.520 4,359.356 ↑ 1.3 15,911 3 / 3

Parallel Hash Join (cost=31,329.72..37,750.70 rows=19,889 width=59) (actual time=4,297.121..4,359.356 rows=15,911 loops=3)

  • Hash Cond: (subscription.agent_id = agent_1.id)
10. 113.581 1,065.503 ↑ 1.3 15,911 3 / 3

Parallel Hash Join (cost=2,145.78..7,491.55 rows=19,889 width=42) (actual time=432.451..1,065.503 rows=15,911 loops=3)

  • Hash Cond: (ma.id = subscription.mailing_area_id)
11. 549.942 549.942 ↑ 1.2 45,092 3 / 3

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

12. 38.369 401.980 ↑ 1.8 15,911 3 / 3

Parallel Hash (cost=1,794.79..1,794.79 rows=28,079 width=20) (actual time=401.979..401.980 rows=15,911 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3168kB
13. 363.611 363.611 ↑ 1.8 15,911 3 / 3

Parallel Seq Scan on subscription (cost=0.00..1,794.79 rows=28,079 width=20) (actual time=16.779..363.611 rows=15,911 loops=3)

14. 201.468 3,081.333 ↑ 1.3 91,873 3 / 3

Parallel Hash (cost=27,075.42..27,075.42 rows=114,842 width=17) (actual time=3,081.333..3,081.333 rows=91,873 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2432kB
15. 2,879.865 2,879.865 ↑ 1.3 91,873 3 / 3

Parallel Seq Scan on agent agent_1 (cost=0.00..27,075.42 rows=114,842 width=17) (actual time=95.496..2,879.865 rows=91,873 loops=3)

16. 302.315 302.315 ↑ 1.0 1 47,734 / 3

Index Scan using agent_pkey on agent (cost=0.42..0.85 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=47,734)

  • Index Cond: (id = agent_1.id)
17. 0.094 0.215 ↑ 1.0 77 3 / 3

Hash (cost=3.77..3.77 rows=77 width=19) (actual time=0.214..0.215 rows=77 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
18. 0.121 0.121 ↑ 1.0 77 3 / 3

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

19.          

CTE eligible_properties

20. 5.256 120,737.920 ↑ 47.4 99 1

Unique (cost=1,090,791.08..1,090,826.24 rows=4,689 width=27) (actual time=120,728.846..120,737.920 rows=99 loops=1)

21. 17.823 120,732.664 ↓ 1.0 4,700 1

Sort (cost=1,090,791.08..1,090,802.80 rows=4,689 width=27) (actual time=120,728.841..120,732.664 rows=4,700 loops=1)

  • Sort Key: pt_106."SubdivCode", pt_106."CountyID
  • Sort Method: quicksort Memory: 559kB
22. 2,419.214 120,714.841 ↓ 1.0 4,700 1

Gather (cost=1,389.80..1,090,505.16 rows=4,689 width=27) (actual time=79,384.985..120,714.841 rows=4,700 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
23. 5,402.631 118,295.627 ↑ 1.2 1,567 3 / 3

Hash Join (cost=389.80..1,089,036.26 rows=1,954 width=27) (actual time=104,521.619..118,295.627 rows=1,567 loops=3)

  • Hash Cond: (pt_106."PropertyID" = (requested_area_property.property_id)::text)
24. 7,517.005 112,881.757 ↑ 1.2 4,889,781 3 / 3

Parallel Append (cost=0.00..875,611.01 rows=6,086,169 width=46) (actual time=3,211.527..112,881.757 rows=4,889,781 loops=3)

25. 10,021.490 10,021.490 ↓ 2.4 1,113,648 1 / 3

Parallel Seq Scan on "TX Harris Property Table" pt_106 (cost=0.00..68,137.33 rows=462,925 width=44) (actual time=7,376.073..30,064.469 rows=1,113,648 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 361714
26. 6,061.045 6,061.045 ↓ 2.4 762,771 1 / 3

Parallel Seq Scan on "FL Miami Dade Property Table" pt_114 (cost=0.00..43,740.94 rows=318,238 width=47) (actual time=1,974.676..18,183.135 rows=762,771 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 152255
27. 5,986.492 5,986.492 ↓ 2.4 660,975 1 / 3

Parallel Seq Scan on "FL Broward Property Table" pt_108 (cost=0.00..36,453.08 rows=274,703 width=42) (actual time=1,117.933..17,959.476 rows=660,975 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 87637
28. 5,006.733 5,006.733 ↓ 2.4 629,909 1 / 3

Parallel Seq Scan on "TX Dallas Property Table" pt_97 (cost=0.00..36,348.14 rows=262,708 width=41) (actual time=84.325..15,020.198 rows=629,909 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 210206
29. 3,699.653 3,699.653 ↓ 2.4 561,299 1 / 3

Parallel Seq Scan on "FL Palm Beach Property Table" pt_104 (cost=0.00..31,233.43 rows=234,073 width=52) (actual time=647.071..11,098.958 rows=561,299 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 79680
30. 3,729.771 3,729.771 ↓ 2.4 513,666 1 / 3

Parallel Seq Scan on "TX Bexar Property Table" pt_70 (cost=0.00..30,336.80 rows=214,950 width=36) (actual time=2,177.655..11,189.313 rows=513,666 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 179223
31. 2,554.673 2,554.673 ↓ 2.4 552,084 1 / 3

Parallel Seq Scan on "TX Tarrant Property Table" pt_103 (cost=0.00..27,367.81 rows=230,235 width=34) (actual time=468.281..7,664.019 rows=552,084 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 65928
32. 2,148.234 2,148.234 ↓ 2.4 425,361 1 / 3

Parallel Seq Scan on "FL Hillsborough Property Table" pt_127 (cost=0.00..26,651.90 rows=176,599 width=52) (actual time=25.970..6,444.703 rows=425,361 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 95708
33. 3,446.739 3,446.739 ↓ 2.4 475,242 1 / 3

Parallel Seq Scan on "FL Lee Property Table" pt_132 (cost=0.00..26,304.76 rows=197,970 width=47) (actual time=66.596..10,340.218 rows=475,242 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 68840
34. 1,575.666 1,575.666 ↓ 2.4 400,566 1 / 3

Parallel Seq Scan on "FL Orange Property Table" pt_125 (cost=0.00..21,936.31 rows=167,120 width=45) (actual time=302.944..4,726.997 rows=400,566 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 64517
35. 2,468.633 2,468.633 ↓ 2.4 365,531 1 / 3

Parallel Seq Scan on "FL Pinellas Property Table" pt_116 (cost=0.00..21,717.07 rows=152,389 width=61) (actual time=385.001..7,405.899 rows=365,531 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 66098
36. 2,259.019 2,259.019 ↓ 2.4 302,289 1 / 3

Parallel Seq Scan on "TX Travis Property Table" pt_131 (cost=0.00..19,488.76 rows=125,847 width=38) (actual time=1,775.323..6,777.058 rows=302,289 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 147520
37. 1,676.716 1,676.716 ↓ 2.4 276,852 1 / 3

Parallel Seq Scan on "TX Collin Property Table" pt_102 (cost=0.00..17,441.43 rows=115,430 width=31) (actual time=1,014.448..5,030.149 rows=276,852 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 114527
38. 2,251.198 2,251.198 ↓ 2.4 312,603 1 / 3

Parallel Seq Scan on "FL Duval Property Table" pt_113 (cost=0.00..17,201.23 rows=130,189 width=35) (actual time=210.039..6,753.593 rows=312,603 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 61458
39. 1,626.444 1,626.444 ↓ 2.4 276,465 1 / 3

Parallel Seq Scan on "FL Brevard Property Table" pt_109 (cost=0.00..16,029.56 rows=115,285 width=52) (actual time=588.449..4,879.331 rows=276,465 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 55995
40. 1,642.487 1,642.487 ↓ 2.4 232,991 1 / 3

Parallel Seq Scan on "FL Polk Property Table" pt_118 (cost=0.00..15,407.54 rows=96,968 width=50) (actual time=32.323..4,927.460 rows=232,991 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 86025
41. 1,864.470 1,864.470 ↓ 2.4 234,164 1 / 3

Parallel Seq Scan on "TX Denton Property Table" pt_130 (cost=0.00..14,834.27 rows=98,005 width=32) (actual time=1,255.642..5,593.409 rows=234,164 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 100928
42. 1,656.569 1,656.569 ↓ 2.4 320,532 1 / 3

Parallel Seq Scan on "GA Fulton Property Table" pt_95 (cost=0.00..14,464.51 rows=133,520 width=45) (actual time=102.303..4,969.707 rows=320,532 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 7885
43. 1,839.994 1,839.994 ↓ 2.4 230,133 1 / 3

Parallel Seq Scan on "TX Fort Bend Property Table" pt_71 (cost=0.00..14,083.99 rows=96,425 width=52) (actual time=1,450.442..5,519.981 rows=230,133 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 86665
44. 1,807.490 1,807.490 ↓ 2.4 251,072 1 / 3

Parallel Seq Scan on "FL Sarasota Property Table" pt_135 (cost=0.00..13,277.15 rows=104,729 width=36) (actual time=286.498..5,422.471 rows=251,072 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 36381
45. 1,729.752 1,729.752 ↓ 2.4 242,160 1 / 3

Parallel Seq Scan on "FL Volusia Property Table" pt_119 (cost=0.00..13,224.62 rows=100,590 width=43) (actual time=36.567..5,189.255 rows=242,160 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 49992
46. 1,480.363 1,480.363 ↓ 2.4 159,417 1 / 3

Parallel Seq Scan on "TX Montgomery Property Table" pt_96 (cost=0.00..13,198.57 rows=66,419 width=44) (actual time=2,573.207..4,441.088 rows=159,417 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 155573
47. 1,347.827 1,347.827 ↓ 2.4 251,995 1 / 3

Parallel Seq Scan on "GA Gwinnett Property Table" pt_128 (cost=0.00..12,574.26 rows=104,971 width=35) (actual time=90.595..4,043.481 rows=251,995 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 17046
48. 949.396 949.396 ↓ 2.4 220,124 1 / 3

Parallel Seq Scan on "FL Collier Property Table" pt_134 (cost=0.00..12,531.94 rows=92,020 width=39) (actual time=373.400..2,848.188 rows=220,124 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 63064
49. 1,374.270 1,374.270 ↑ 1.2 59,753 3 / 3

Parallel Seq Scan on "FL Pasco Property Table" pt_115 (cost=0.00..12,360.59 rows=74,557 width=49) (actual time=155.670..1,374.270 rows=59,753 loops=3)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 31420
50. 1,273.908 1,273.908 ↓ 2.4 165,164 1 / 3

Parallel Seq Scan on "TX Williamson Property Table" pt_129 (cost=0.00..11,816.10 rows=68,400 width=49) (actual time=1,326.283..3,821.724 rows=165,164 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 83687
51. 1,024.322 1,024.322 ↓ 2.4 212,080 1 / 3

Parallel Seq Scan on "FL Marion Property Table" pt_123 (cost=0.00..11,815.55 rows=88,151 width=42) (actual time=570.290..3,072.967 rows=212,080 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 59130
52. 1,670.090 1,670.090 ↓ 2.4 237,612 1 / 3

Parallel Seq Scan on "GA Cobb Property Table" pt_100 (cost=0.00..11,382.61 rows=98,899 width=32) (actual time=175.452..5,010.269 rows=237,612 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 30537
53. 1,502.783 1,502.783 ↓ 2.4 221,158 1 / 3

Parallel Seq Scan on "GA DeKalb Property Table" pt_99 (cost=0.00..10,148.82 rows=91,880 width=40) (actual time=183.495..4,508.350 rows=221,158 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 18807
54. 1,282.425 1,282.425 ↓ 2.4 19,500 1 / 3

Parallel Seq Scan on "NJ Bergen Property Table" pt_74 (cost=0.00..9,980.05 rows=8,020 width=65) (actual time=1,260.804..3,847.274 rows=19,500 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 262750
55. 1,241.121 1,241.121 ↓ 2.4 218,505 1 / 3

Parallel Seq Scan on "NJ Middlesex Property Table" pt_81 (cost=0.00..9,749.86 rows=91,184 width=64) (actual time=487.827..3,723.364 rows=218,505 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 34141
56. 1,552.460 1,552.460 ↓ 2.4 212,566 1 / 3

Parallel Seq Scan on "NJ Monmouth Property Table" pt_92 (cost=0.00..9,677.36 rows=88,681 width=62) (actual time=761.349..4,657.379 rows=212,566 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 39408
57. 723.764 723.764 ↓ 2.4 181,290 1 / 3

Parallel Seq Scan on "FL Charlotte Property Table" pt_110 (cost=0.00..9,358.29 rows=75,687 width=49) (actual time=25.722..2,171.293 rows=181,290 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 29773
58. 1,282.153 1,282.153 ↓ 2.4 154,987 1 / 3

Parallel Seq Scan on "FL Manatee Property Table" pt_117 (cost=0.00..8,973.19 rows=64,587 width=38) (actual time=198.291..3,846.459 rows=154,987 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 38394
59. 821.551 821.551 ↓ 2.4 145,843 1 / 3

Parallel Seq Scan on "FL Osceola Property Table" pt_124 (cost=0.00..8,749.34 rows=60,777 width=57) (actual time=140.382..2,464.652 rows=145,843 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 27023
60. 513.176 513.176 ↓ 2.4 146,523 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 24479
61. 1,107.020 1,107.020 ↓ 2.4 127,151 1 / 3

Parallel Seq Scan on "FL Escambia Property Table" pt_121 (cost=0.00..8,060.95 rows=52,877 width=48) (actual time=93.068..3,321.061 rows=127,151 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 30855
62. 601.376 601.376 ↓ 2.4 115,951 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 78415
63. 845.456 845.456 ↓ 2.4 155,821 1 / 3

Parallel Seq Scan on "NJ Camden Property Table" pt_91 (cost=0.00..7,318.98 rows=64,858 width=60) (actual time=332.003..2,536.369 rows=155,821 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 37136
64. 694.279 694.279 ↓ 2.4 153,363 1 / 3

Parallel Seq Scan on "NJ Essex Property Table" pt_75 (cost=0.00..7,188.34 rows=63,838 width=59) (actual time=137.876..2,082.836 rows=153,363 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 37167
65. 1,107.823 1,107.823 ↓ 2.4 146,082 1 / 3

Parallel Seq Scan on "NJ Burlington Property Table" pt_85 (cost=0.00..7,028.89 rows=60,803 width=64) (actual time=619.080..3,323.470 rows=146,082 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 33609
66. 900.402 900.402 ↓ 2.4 93,606 1 / 3

Parallel Seq Scan on "TX Brazoria Property Table" pt_72 (cost=0.00..6,863.79 rows=39,274 width=40) (actual time=513.443..2,701.206 rows=93,606 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 72818
67. 1,073.562 1,073.562 ↓ 2.4 152,236 1 / 3

Parallel Seq Scan on "NJ Morris Property Table" pt_76 (cost=0.00..6,762.53 rows=63,411 width=60) (actual time=217.569..3,220.686 rows=152,236 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 27194
68. 831.436 831.436 ↓ 2.4 118,489 1 / 3

Parallel Seq Scan on "FL St Johns Property Table" pt_122 (cost=0.00..6,747.46 rows=49,348 width=36) (actual time=413.308..2,494.309 rows=118,489 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 31168
69. 1,113.981 1,113.981 ↓ 2.4 114,147 1 / 3

Parallel Seq Scan on "FL Lake Property Table" pt_126 (cost=0.00..6,638.17 rows=47,493 width=49) (actual time=195.636..3,341.942 rows=114,147 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 22013
70. 729.910 729.910 ↓ 0.0 0 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 152174
71. 769.370 769.370 ↓ 2.4 103,787 1 / 3

Parallel Seq Scan on "NJ Atlantic Property Table" pt_84 (cost=0.00..5,966.36 rows=43,347 width=62) (actual time=21.622..2,308.110 rows=103,787 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 51610
72. 1,042.993 1,042.993 ↓ 2.4 130,206 1 / 3

Parallel Seq Scan on "NJ Union Property Table" pt_82 (cost=0.00..5,573.81 rows=54,275 width=58) (actual time=186.638..3,128.978 rows=130,206 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 18941
73. 916.008 916.008 ↓ 2.4 115,058 1 / 3

Parallel Seq Scan on "NJ Mercer Property Table" pt_89 (cost=0.00..5,286.55 rows=47,828 width=60) (actual time=22.754..2,748.023 rows=115,058 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 23288
74. 831.465 831.465 ↓ 2.4 110,353 1 / 3

Parallel Seq Scan on "NJ Hudson Property Table" pt_93 (cost=0.00..5,180.85 rows=45,864 width=61) (actual time=673.872..2,494.396 rows=110,353 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 30930
75. 977.863 977.863 ↓ 2.4 69,991 1 / 3

Parallel Seq Scan on "FL Martin Property Table" pt_107 (cost=0.00..5,014.22 rows=29,113 width=57) (actual time=765.553..2,933.588 rows=69,991 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 24708
76. 834.108 834.108 ↓ 2.4 109,523 1 / 3

Parallel Seq Scan on "NJ Passiac Property Table" pt_83 (cost=0.00..4,932.32 rows=45,631 width=61) (actual time=21.565..2,502.323 rows=109,523 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 20522
77. 778.908 778.908 ↓ 2.4 85,793 1 / 3

Parallel Seq Scan on "FL Leon Property Table" pt_112 (cost=0.00..4,858.96 rows=35,901 width=38) (actual time=51.676..2,336.724 rows=85,793 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 22487
78. 481.048 481.048 ↓ 2.4 74,359 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 32269
79. 623.691 623.691 ↓ 2.4 67,686 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 25010
80. 548.787 548.787 ↓ 2.4 102,906 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 16792
81. 590.764 590.764 ↓ 2.4 94,488 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 23971
82. 489.592 489.592 ↓ 2.4 94,488 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 23971
83. 415.235 415.235 ↓ 2.4 52,674 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 49689
84. 789.880 789.880 ↓ 2.4 88,759 1 / 3

Parallel Seq Scan on "NJ Cape May Property Table" pt_86 (cost=0.00..4,196.38 rows=37,081 width=63) (actual time=416.308..2,369.640 rows=88,759 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 19217
85. 948.523 948.523 ↓ 161.9 63,127 1 / 3

Parallel Seq Scan on "FL Clay Property Table" pt_69 (cost=0.00..4,111.47 rows=390 width=96) (actual time=1,118.673..2,845.568 rows=63,127 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 30468
86. 715.474 715.474 ↓ 2.4 68,461 1 / 3

Parallel Seq Scan on "FL Flagler Property Table" pt_120 (cost=0.00..3,584.26 rows=28,483 width=50) (actual time=360.879..2,146.421 rows=68,461 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 12804
87. 421.282 421.282 ↓ 1.7 55,336 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 22501
88. 242.299 242.299 ↓ 1.7 41,866 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 24015
89. 287.764 287.764 ↓ 1.7 42,355 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 16897
90. 302.300 302.300 ↓ 1.7 34,633 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 14944
91. 259.279 259.279 ↓ 1.7 20,311 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 13083
92. 0.001 0.001 ↓ 0.0 0 1 / 3

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

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
93. 4.159 11.239 ↑ 1.0 4,700 3 / 3

Hash (cost=331.05..331.05 rows=4,700 width=15) (actual time=11.238..11.239 rows=4,700 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 285kB
94. 7.080 7.080 ↑ 1.0 4,700 3 / 3

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

  • Filter: (requested_area_id = 25)
  • Rows Removed by Filter: 11789
95.          

CTE eligible_subdivid

96. 0.175 126,345.302 ↓ 3.8 99 1

Unique (cost=39,956.97..39,957.29 rows=26 width=111) (actual time=126,345.067..126,345.302 rows=99 loops=1)

97. 0.782 126,345.127 ↓ 3.8 99 1

Sort (cost=39,956.97..39,957.03 rows=26 width=111) (actual time=126,345.063..126,345.127 rows=99 loops=1)

  • Sort Key: st."SubdivID", st."SubdivName", pt_136."SubdivCode", pt_136."CountyID
  • Sort Method: quicksort Memory: 38kB
98. 405.618 126,344.345 ↓ 3.8 99 1

Hash Join (cost=33,240.15..39,956.36 rows=26 width=111) (actual time=126,103.291..126,344.345 rows=99 loops=1)

  • Hash Cond: ((pt_136."CountyID" = st."CountyID") AND (pt_136."SubdivCode" = st."SubdivCode"))
99. 120,738.322 120,738.322 ↑ 47.4 99 1

CTE Scan on eligible_properties pt_136 (cost=0.00..93.78 rows=4,689 width=64) (actual time=120,728.851..120,738.322 rows=99 loops=1)

100. 945.939 5,200.405 ↑ 1.0 553,369 1

Hash (cost=18,454.57..18,454.57 rows=553,372 width=72) (actual time=5,200.405..5,200.405 rows=553,369 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 4060kB
101. 653.092 4,254.466 ↑ 1.0 553,371 1

Append (cost=0.00..18,454.57 rows=553,372 width=72) (actual time=13.451..4,254.466 rows=553,371 loops=1)

102. 0.011 0.011 ↓ 0.0 0 1

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

103. 42.526 42.526 ↑ 1.0 8,252 1

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

104. 16.046 16.046 ↑ 1.0 6,830 1

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

105. 41.830 41.830 ↑ 1.0 7,011 1

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

106. 11.073 11.073 ↑ 1.0 4,067 1

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

107. 9.568 9.568 ↑ 1.0 1,916 1

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

108. 61.655 61.655 ↑ 1.0 16,231 1

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

109. 60.008 60.008 ↑ 1.0 7,343 1

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

110. 49.457 49.457 ↑ 1.0 6,034 1

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

111. 36.379 36.379 ↑ 1.0 8,075 1

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

112. 35.086 35.086 ↑ 1.0 3,655 1

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

113. 22.837 22.837 ↑ 1.0 3,515 1

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

114. 133.512 133.512 ↑ 1.0 11,570 1

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

115. 36.337 36.337 ↑ 1.0 17,644 1

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

116. 97.651 97.651 ↑ 1.0 18,216 1

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

117. 39.696 39.696 ↑ 1.0 7,268 1

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

118. 17.330 17.330 ↑ 1.0 4,223 1

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

119. 125.615 125.615 ↑ 1.0 11,804 1

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

120. 5.706 5.706 ↑ 1.0 5,147 1

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

121. 2.218 2.218 ↑ 1.0 1,868 1

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

122. 149.740 149.740 ↑ 1.0 13,018 1

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

123. 324.848 324.848 ↑ 1.0 54,586 1

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

124. 154.968 154.968 ↑ 1.0 13,360 1

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

125. 36.444 36.444 ↑ 1.0 16,396 1

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

126. 62.575 62.575 ↑ 1.0 16,384 1

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

127. 73.300 73.300 ↑ 1.0 11,200 1

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

128. 79.579 79.579 ↑ 1.0 12,980 1

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

129. 52.285 52.285 ↑ 1.0 23,685 1

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

130. 49.140 49.140 ↑ 1.0 2,615 1

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

131. 277.842 277.842 ↑ 1.0 22,000 1

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

132. 71.318 71.318 ↑ 1.0 9,762 1

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

133. 37.378 37.378 ↑ 1.0 8,645 1

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

134. 267.830 267.830 ↑ 1.0 49,718 1

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

135. 138.184 138.184 ↑ 1.0 9,467 1

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

136. 54.658 54.658 ↑ 1.0 10,116 1

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

137. 93.260 93.260 ↑ 1.0 8,461 1

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

138. 154.159 154.159 ↑ 1.0 22,136 1

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

139. 31.003 31.003 ↑ 1.0 10,666 1

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

140. 108.186 108.186 ↑ 1.0 9,014 1

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

141. 164.872 164.872 ↑ 1.0 8,008 1

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

142. 21.358 21.358 ↑ 1.0 4,170 1

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

143. 31.202 31.202 ↑ 1.0 11,397 1

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

144. 96.028 96.028 ↑ 1.0 20,979 1

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

145. 226.676 226.676 ↑ 1.0 33,939 1

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

146. 15.134 128,530.168 ↓ 1,343.9 10,751 1

Nested Loop (cost=0.91..56,535.88 rows=8 width=120) (actual time=128,126.947..128,530.168 rows=10,751 loops=1)

147. 114.134 128,306.639 ↓ 3.8 99 1

Hash Join (cost=0.91..4,281.10 rows=26 width=128) (actual time=128,124.185..128,306.639 rows=99 loops=1)

  • Hash Cond: (nt."SubdivID" = eligible_subdivid."SubdivID")
148. 168.754 1,846.717 ↑ 1.0 125,188 1

Append (cost=0.00..3,798.14 rows=128,477 width=29) (actual time=0.075..1,846.717 rows=125,188 loops=1)

149. 0.009 0.009 ↓ 0.0 0 1

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

150. 30.727 30.727 ↓ 1.9 821 1

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

151. 29.679 29.679 ↑ 1.0 1,300 1

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

152. 21.351 21.351 ↑ 1.0 1,451 1

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

153. 28.054 28.054 ↑ 1.0 2,147 1

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

154. 46.356 46.356 ↑ 1.0 3,012 1

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

155. 0.012 0.012 ↓ 0.0 0 1

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

156. 61.769 61.769 ↑ 1.0 3,651 1

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

157. 45.659 45.659 ↑ 1.0 11,707 1

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

158. 12.133 12.133 ↑ 1.0 3,464 1

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

159. 19.582 19.582 ↑ 1.0 1,810 1

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

160. 0.010 0.010 ↓ 0.0 0 1

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

161. 0.004 0.004 ↓ 0.0 0 1

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

162. 12.879 12.879 ↑ 1.0 4,836 1

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

163. 0.010 0.010 ↓ 0.0 0 1

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

164. 14.567 14.567 ↑ 1.0 5,273 1

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

165. 25.230 25.230 ↑ 1.0 1,026 1

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

166. 15.062 15.062 ↑ 1.0 5,194 1

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

167. 35.540 35.540 ↑ 1.0 2,443 1

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

168. 63.868 63.868 ↑ 1.0 755 1

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

169. 5.821 5.821 ↑ 1.0 993 1

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

170. 19.920 19.920 ↑ 1.0 1,410 1

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

171. 21.686 21.686 ↑ 1.0 3,507 1

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

172. 179.370 179.370 ↑ 1.0 10,225 1

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

173. 29.736 29.736 ↑ 1.0 1,361 1

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

174. 76.335 76.335 ↑ 1.0 5,504 1

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

175. 13.100 13.100 ↑ 1.0 4,320 1

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

176. 9.661 9.661 ↑ 1.0 2,891 1

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

177. 57.674 57.674 ↑ 1.0 346 1

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

178. 20.901 20.901 ↑ 1.0 1,527 1

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

179. 30.825 30.825 ↑ 1.0 1,173 1

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

180. 36.096 36.096 ↑ 1.0 1,998 1

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

181. 29.972 29.972 ↑ 1.0 1,239 1

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

182. 22.702 22.702 ↑ 1.0 4,226 1

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

183. 19.672 19.672 ↑ 1.0 1,938 1

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

184. 26.142 26.142 ↑ 1.0 5,674 1

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

185. 11.254 11.254 ↑ 1.0 3,542 1

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

186. 0.023 0.023 ↓ 0.0 0 1

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

187. 236.068 236.068 ↑ 1.0 7,336 1

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

188. 12.178 12.178 ↑ 1.0 3,137 1

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

189. 114.764 114.764 ↑ 1.0 860 1

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

190. 58.269 58.269 ↑ 1.0 2,415 1

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

191. 28.285 28.285 ↑ 1.0 3,449 1

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

192. 13.704 13.704 ↑ 1.0 1,989 1

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

193. 20.885 20.885 ↑ 1.0 3,253 1

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

194. 120.419 120.419 ↑ 1.0 1,985 1

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

195. 0.197 126,345.788 ↓ 3.8 99 1

Hash (cost=0.58..0.58 rows=26 width=128) (actual time=126,345.787..126,345.788 rows=99 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
196. 126,345.591 126,345.591 ↓ 3.8 99 1

CTE Scan on eligible_subdivid (cost=0.00..0.58 rows=26 width=128) (actual time=126,345.090..126,345.591 rows=99 loops=1)

  • Filter: ("SubdivID" !~~ '%Not in Subdivision%'::text)
197. 25.344 208.395 ↑ 5.6 109 99

Append (cost=0.00..2,003.68 rows=612 width=84) (actual time=0.810..2.105 rows=109 loops=99)

198. 0.099 0.099 ↓ 0.0 0 99

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

  • 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.297 1.287 ↓ 0.0 0 99

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

  • 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.990 0.990 ↓ 0.0 0 99

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

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

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 time=0.009..0.009 rows=0 loops=99)

  • 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.495 0.495 ↓ 0.0 0 99

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 time=0.005..0.005 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.297 0.297 ↓ 0.0 0 99

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 time=0.003..0.003 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.396 0.396 ↓ 0.0 0 99

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 time=0.004..0.004 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.396 0.396 ↓ 0.0 0 99

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 time=0.004..0.004 rows=0 loops=99)

  • 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.396 0.396 ↓ 0.0 0 99

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 time=0.004..0.004 rows=0 loops=99)

  • 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.396 0.396 ↓ 0.0 0 99

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 time=0.004..0.004 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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. 1.089 1.089 ↓ 0.0 0 99

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 time=0.011..0.011 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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. 1.089 1.089 ↓ 0.0 0 99

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 time=0.011..0.011 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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. 1.188 1.188 ↓ 0.0 0 99

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 time=0.012..0.012 rows=0 loops=99)

  • 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. 1.089 1.089 ↓ 0.0 0 99

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 time=0.011..0.011 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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. 127.215 127.215 ↓ 5.5 109 99

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 time=0.319..1.285 rows=109 loops=99)

  • 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[])))
  • Rows Removed by Filter: 0
249. 1.188 1.188 ↓ 0.0 0 99

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 time=0.012..0.012 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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.297 0.297 ↓ 0.0 0 99

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 time=0.003..0.003 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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. 1.089 1.089 ↓ 0.0 0 99

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 time=0.011..0.011 rows=0 loops=99)

  • 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. 1.287 1.287 ↓ 0.0 0 99

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 time=0.013..0.013 rows=0 loops=99)

  • 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. 1.089 1.089 ↓ 0.0 0 99

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 time=0.011..0.011 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.693 0.693 ↓ 0.0 0 99

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 time=0.007..0.007 rows=0 loops=99)

  • 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.792 0.792 ↓ 0.0 0 99

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 time=0.008..0.008 rows=0 loops=99)

  • 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.990 0.990 ↓ 0.0 0 99

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 time=0.010..0.010 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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.891 0.891 ↓ 0.0 0 99

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 time=0.009..0.009 rows=0 loops=99)

  • 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. 4.412 5,547.957 ↑ 9.2 2,608 1

Hash (cost=477.34..477.34 rows=23,867 width=64) (actual time=5,547.956..5,547.957 rows=2,608 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 493kB
268. 5,543.545 5,543.545 ↑ 9.2 2,608 1

CTE Scan on subscribed_area (cost=0.00..477.34 rows=23,867 width=64) (actual time=5,531.976..5,543.545 rows=2,608 loops=1)