explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TZpA

Settings
# exclusive inclusive rows x rows loops node
1. 64.663 18,298.092 ↑ 130.8 5,107 1

Hash Join (cost=970,614.34..987,269.30 rows=668,163 width=152) (actual time=18,217.525..18,298.092 rows=5,107 loops=1)

  • Hash Cond: (nt."SubdivID" = eligible_subdivid."SubdivID")
  • rows=1 loops=1)
  • rows=1 loops=1)
  • rows=312603 loops=1)
  • rows=1 loops=1)
  • rows=1 loops=1)
  • rows=1 loops=1)
  • rows=1 loops=1)
  • loops=98)
  • loops=98)
  • loops=98)
2.          

CTE subscribed_area

3. 8.155 1,203.891 ↑ 9.3 2,548 1

HashAggregate (cost=62,115.00..62,766.42 rows=23,688 width=79) (actual time=1,200.946..1,203.891 rows=2,548 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. 41.345 1,195.736 ↑ 9.3 2,548 1

Nested Loop (cost=33,201.41..61,937.34 rows=23,688 width=79) (actual time=799.024..1,195.736 rows=2,548 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: 44842
5. 2.284 2.284 ↑ 1.0 1 1

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

  • Relations: (public.settings_properties mailing_sp) INNER JOIN (public.settings_properties lock_sp)
6. 55.607 1,152.107 ↓ 1.0 47,390 1

Gather (cost=33,101.41..60,382.15 rows=47,375 width=74) (actual time=796.465..1,152.107 rows=47,390 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 31.248 1,096.500 ↑ 1.2 15,797 3 / 3

Hash Join (cost=32,101.41..54,644.65 rows=19,740 width=74) (actual time=758.635..1,096.500 rows=15,797 loops=3)

  • Hash Cond: (ma.county_id = county.id)
8. 74.591 1,064.989 ↑ 1.2 15,797 3 / 3

Nested Loop (cost=32,096.67..54,585.25 rows=19,740 width=71) (actual time=758.121..1,064.989 rows=15,797 loops=3)

  • Join Filter: (subscription.agent_id = agent.id)
9. 79.575 879.821 ↑ 1.2 15,797 3 / 3

Parallel Hash Join (cost=32,096.25..37,647.31 rows=19,740 width=59) (actual time=757.998..879.821 rows=15,797 loops=3)

  • Hash Cond: (ma.id = subscription.mailing_area_id)
10. 43.421 43.421 ↑ 1.2 45,047 3 / 3

Parallel Seq Scan on mailing_area ma (cost=0.00..3,816.08 rows=56,308 width=34) (actual time=0.021..43.421 rows=45,047 loops=3)

11. 30.336 756.825 ↑ 1.8 15,797 3 / 3

Parallel Hash (cost=31,747.90..31,747.90 rows=27,868 width=37) (actual time=756.824..756.825 rows=15,797 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 4256kB
12. 189.050 726.489 ↑ 1.8 15,797 3 / 3

Parallel Hash Join (cost=28,897.07..31,747.90 rows=27,868 width=37) (actual time=680.813..726.489 rows=15,797 loops=3)

  • Hash Cond: (subscription.agent_id = agent_1.id)
13. 33.873 33.873 ↑ 1.8 15,797 3 / 3

Parallel Seq Scan on subscription (cost=0.00..1,781.68 rows=27,868 width=20) (actual time=0.036..33.873 rows=15,797 loops=3)

14. 179.697 503.566 ↑ 1.2 91,096 3 / 3

Parallel Hash (cost=26,805.70..26,805.70 rows=113,870 width=17) (actual time=503.565..503.566 rows=91,096 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2432kB
15. 323.869 323.869 ↑ 1.2 91,096 3 / 3

Parallel Seq Scan on agent agent_1 (cost=0.00..26,805.70 rows=113,870 width=17) (actual time=0.069..323.869 rows=91,096 loops=3)

16. 110.577 110.577 ↑ 1.0 1 47,390 / 3

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

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

Hash (cost=3.77..3.77 rows=77 width=19) (actual time=0.262..0.263 rows=77 loops=3)

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

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

19.          

CTE eligible_properties

20. 3.682 14,254.235 ↑ 49.9 98 1

Unique (cost=807,501.74..807,538.46 rows=4,895 width=27) (actual time=14,247.846..14,254.235 rows=98 loops=1)

21. 10.100 14,250.553 ↑ 1.0 4,700 1

Sort (cost=807,501.74..807,513.98 rows=4,895 width=27) (actual time=14,247.843..14,250.553 rows=4,700 loops=1)

  • Sort Key: pt_68."SubdivCode", pt_68."CountyID
  • Sort Method: quicksort Memory: 560kB
22. 2,477.606 14,240.453 ↑ 1.0 4,700 1

Merge Join (cost=636.58..807,201.75 rows=4,895 width=27) (actual time=14,078.380..14,240.453 rows=4,700 loops=1)

  • Merge Cond: (pt_68."PropertyID" = (requested_area_property.property_id)::text)
23. 5,509.526 11,721.249 ↑ 4.7 3,112,197 1

Merge Append (cost=29.98..3,664,067.40 rows=14,713,140 width=46) (actual time=48.707..11,721.249 rows=3,112,197 loops=1)

  • Sort Key: pt_68."PropertyID
  • -> Index Scan using "NJ Morris Property Table_idx_1" on "NJ Morris Property Table" pt_76 (cost=0.42..20360.76 rows=152187 width=60) (actual time=0.076..0.076rows=1 loops=1)
  • -> Index Scan using "NJ Mercer Property Table_idx_1" on "NJ Mercer Property Table" pt_89 (cost=0.42..17333.79 rows=114786 width=60) (actual time=0.070..0.070rows=1 loops=1)
  • -> Index Scan using "NJ Camden Property Table_idx_1" on "NJ Camden Property Table" pt_91 (cost=0.42..21656.65 rows=155658 width=60) (actual time=0.036..0.036rows=1 loops=1)
  • -> Index Scan using "NJ Hudson Property Table_idx_1" on "NJ Hudson Property Table" pt_93 (cost=0.42..21667.24 rows=110074 width=61) (actual time=0.101..0.101rows=1 loops=1)
  • -> Index Scan using "GA Fulton Property Table_idx_1" on "GA Fulton Property Table" pt_95 (cost=0.42..61513.67 rows=320447 width=45) (actual time=0.186..0.187rows=1 loops=1)
  • -> Index Scan using "TX Dallas Property Table_idx_1" on "TX Dallas Property Table" pt_97 (cost=0.42..148898.92 rows=630500 width=41) (actual time=1.929..1.930
  • -> Index Scan using "GA DeKalb Property Table_idx_1" on "GA DeKalb Property Table" pt_99 (cost=0.42..44353.32 rows=220992 width=40) (actual time=0.077..0.077rows=1 loops=1)
  • -> Index Scan using "TX Collin Property Table_idx_1" on "TX Collin Property Table" pt_103 (cost=0.42..72269.15 rows=277031 width=31) (actual time=0.086..0.087
  • -> Index Scan using "FL Martin Property Table_idx_1" on "FL Martin Property Table" pt_109 (cost=0.42..15951.06 rows=69872 width=57) (actual time=0.102..0.102rows=1 loops=1)
  • -> Index Scan using "FL Duval Property Table_idx_1" on "FL Duval Property Table" pt_116 (cost=0.42..70743.50 rows=312453 width=35) (actual time=0.086..679.649
  • -> Index Scan using "FL Marion Property Table_idx_1" on "FL Marion Property Table" pt_127 (cost=0.42..37212.71 rows=211562 width=42) (actual time=0.055..0.056
  • -> Index Scan using "FL Orange Property Table_idx_1" on "FL Orange Property Table" pt_129 (cost=0.42..65044.55 rows=401088 width=45) (actual time=0.048..0.048
  • -> Index Scan using "TX Denton Property Table_idx_1" on "TX Denton Property Table" pt_134 (cost=0.42..61028.65 rows=235212 width=32) (actual time=0.067..0.067
  • -> Index Scan using "TX Travis Property Table_idx_1" on "TX Travis Property Table" pt_135 (cost=0.42..85352.07 rows=302482 width=38) (actual time=0.093..0.093
24. 0.014 0.014 ↓ 0.0 0 1

Index Scan using "Property Table_idx_1" on "Property Table" pt_68 (cost=0.12..8.14 rows=1 width=96) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
25. 165.840 165.840 ↓ 67.4 63,127 1

Index Scan using "FL Clay Property Table_idx_1" on "FL Clay Property Table" pt_69 (cost=0.42..18,002.33 rows=936 width=96) (actual time=2.695..165.840 rows=63,127 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 30468
26. 0.039 0.039 ↑ 515,833.0 1 1

Index Scan using "TX Bexar Property Table_idx_1" on "TX Bexar Property Table" pt_70 (cost=0.42..134,352.11 rows=515,833 width=38) (actual time=0.039..0.039 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
27. 0.103 0.103 ↑ 231,421.0 1 1

Index Scan using "TX Fort Bend Property Table_idx_1" on "TX Fort Bend Property Table" pt_71 (cost=0.42..43,264.48 rows=231,421 width=52) (actual time=0.103..0.103 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 20
28. 0.209 0.209 ↑ 94,257.0 1 1

Index Scan using "TX Brazoria Property Table_idx_1" on "TX Brazoria Property Table" pt_72 (cost=0.42..27,452.58 rows=94,257 width=40) (actual time=0.208..0.209 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 34
29. 0.077 0.077 ↑ 116,322.0 1 1

Index Scan using "TX Galveston Property Table_idx_1" on "TX Galveston Property Table" pt_73 (cost=0.42..34,757.62 rows=116,322 width=41) (actual time=0.076..0.077 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 12
30. 0.060 0.060 ↑ 19,249.0 1 1

Index Scan using "NJ Bergen Property Table_idx_1" on "NJ Bergen Property Table" pt_74 (cost=0.42..38,483.79 rows=19,249 width=65) (actual time=0.060..0.060 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
31. 0.109 0.109 ↑ 153,212.0 1 1

Index Scan using "NJ Essex Property Table_idx_1" on "NJ Essex Property Table" pt_75 (cost=0.42..23,224.44 rows=153,212 width=59) (actual time=0.108..0.109 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 4
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
32. 0.140 0.140 ↑ 103,172.0 1 1

Index Scan using "NJ Somerset Property Table_idx_1" on "NJ Somerset Property Table" pt_77 (cost=0.42..13,903.00 rows=103,172 width=63) (actual time=0.140..0.140 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 2
33. 0.054 0.054 ↑ 42,436.0 1 1

Index Scan using "NJ Hunterdon Property Table_idx_1" on "NJ Hunterdon Property Table" pt_78 (cost=0.41..7,764.81 rows=42,436 width=63) (actual time=0.053..0.054 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
34. 0.145 0.145 ↑ 34,643.0 1 1

Index Scan using "NJ Warren Property Table_idx_1" on "NJ Warren Property Table" pt_79 (cost=0.41..6,491.54 rows=34,643 width=60) (actual time=0.145..0.145 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 34
35. 0.041 0.041 ↑ 55,160.0 1 1

Index Scan using "NJ Sussex Property Table_idx_1" on "NJ Sussex Property Table" pt_80 (cost=0.42..10,456.14 rows=55,160 width=60) (actual time=0.041..0.041 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
36. 0.088 0.088 ↑ 218,842.0 1 1

Index Scan using "NJ Middlesex Property Table_idx_1" on "NJ Middlesex Property Table" pt_81 (cost=0.42..27,867.48 rows=218,842 width=64) (actual time=0.088..0.088 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
37. 0.109 0.109 ↑ 130,260.0 1 1

Index Scan using "NJ Union Property Table_idx_1" on "NJ Union Property Table" pt_82 (cost=0.42..14,965.51 rows=130,260 width=58) (actual time=0.109..0.109 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
38. 0.085 0.085 ↑ 109,515.0 1 1

Index Scan using "NJ Passiac Property Table_idx_1" on "NJ Passiac Property Table" pt_83 (cost=0.42..15,069.93 rows=109,515 width=61) (actual time=0.084..0.085 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 3
39. 0.118 0.118 ↑ 104,033.0 1 1

Index Scan using "NJ Atlantic Property Table_idx_1" on "NJ Atlantic Property Table" pt_84 (cost=0.42..19,955.33 rows=104,033 width=62) (actual time=0.118..0.118 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 2
40. 0.251 0.251 ↑ 145,927.0 1 1

Index Scan using "NJ Burlington Property Table_idx_1" on "NJ Burlington Property Table" pt_85 (cost=0.42..24,475.61 rows=145,927 width=64) (actual time=0.251..0.251 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 157
41. 0.038 0.038 ↑ 88,994.0 1 1

Index Scan using "NJ Cape May Property Table_idx_1" on "NJ Cape May Property Table" pt_86 (cost=0.42..13,311.72 rows=88,994 width=63) (actual time=0.037..0.038 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
42. 0.094 0.094 ↑ 42,047.0 1 1

Index Scan using "NJ Cumberland Property Table_idx_1" on "NJ Cumberland Property Table" pt_87 (cost=0.42..8,147.85 rows=42,047 width=63) (actual time=0.094..0.094 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
43. 0.065 0.065 ↑ 94,262.0 1 1

Index Scan using "NJ Glouster Property Table_idx_1" on "NJ Glouster Property Table" pt_88 (cost=0.42..13,765.49 rows=94,262 width=62) (actual time=0.065..0.065 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 10
44. 0.065 0.065 ↑ 20,318.0 1 1

Index Scan using "NJ Salem Property Table_idx_1" on "NJ Salem Property Table" pt_90 (cost=0.29..4,639.25 rows=20,318 width=58) (actual time=0.064..0.065 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
45. 0.091 0.091 ↑ 212,834.0 1 1

Index Scan using "NJ Monmouth Property Table_idx_1" on "NJ Monmouth Property Table" pt_92 (cost=0.42..28,543.31 rows=212,834 width=62) (actual time=0.090..0.091 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 2
46. 0.077 0.077 ↑ 94,830.0 1 1

Index Scan using "NJ Gloucester Property Table_idx_1" on "NJ Gloucester Property Table" pt_94 (cost=0.42..13,715.72 rows=94,830 width=64) (actual time=0.077..0.077 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
47. 0.116 0.116 ↑ 158,881.0 1 1

Index Scan using "TX Montgomery Property Table_idx_1" on "TX Montgomery Property Table" pt_96 (cost=0.42..46,585.71 rows=158,881 width=44) (actual time=0.116..0.116 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 977
48. 0.014 0.014 ↓ 0.0 0 1

Index Scan using "TX Hays Property Table_idx_1" on "TX Hays Property Table" pt_98 (cost=0.14..45.54 rows=2 width=96) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
49. 971.711 971.711 ↑ 1.0 474,703 1

Index Scan using "FL Lee Property Table_idx_1" on "FL Lee Property Table" pt_100 (cost=0.42..78,578.20 rows=475,715 width=47) (actual time=0.155..971.711 rows=474,703 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 68682
50. 0.099 0.099 ↑ 237,357.0 1 1

Index Scan using "GA Cobb Property Table_idx_1" on "GA Cobb Property Table" pt_101 (cost=0.42..49,896.97 rows=237,357 width=32) (actual time=0.098..0.099 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
51. 0.110 0.110 ↑ 151,880.0 1 1

Index Scan using "FL Seminole Property Table_idx_1" on "FL Seminole Property Table" pt_102 (cost=0.42..14,009.98 rows=151,880 width=49) (actual time=0.109..0.110 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
52. 0.071 0.071 ↑ 552,565.0 1 1

Index Scan using "TX Tarrant Property Table_idx_1" on "TX Tarrant Property Table" pt_104 (cost=0.42..116,910.36 rows=552,565 width=34) (actual time=0.071..0.071 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
53. 0.150 0.150 ↑ 562,780.0 1 1

Index Scan using "FL Palm Beach Property Table_idx_1" on "FL Palm Beach Property Table" pt_105 (cost=0.42..93,638.30 rows=562,780 width=52) (actual time=0.149..0.150 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 14
54. 0.109 0.109 ↑ 74,451.0 1 1

Index Scan using "GA Cherokee Property Table_idx_1" on "GA Cherokee Property Table" pt_106 (cost=0.42..21,591.26 rows=74,451 width=46) (actual time=0.108..0.109 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 13
55. 1.700 1.700 ↑ 1,111,019.0 1 1

Index Scan using "TX Harris Property Table_idx_1" on "TX Harris Property Table" pt_107 (cost=0.43..296,892.67 rows=1,111,019 width=44) (actual time=1.700..1.700 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1084
56. 3.500 3.500 ↑ 250,963.0 1 1

Index Scan using "FL Sarasota Property Table_idx_1" on "FL Sarasota Property Table" pt_108 (cost=0.42..56,128.69 rows=250,963 width=36) (actual time=3.500..3.500 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1409
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 13
57. 1,422.696 1,422.696 ↓ 1.0 660,975 1

Index Scan using "FL Broward Property Table_idx_1" on "FL Broward Property Table" pt_110 (cost=0.42..117,793.61 rows=659,134 width=41) (actual time=0.108..1,422.696 rows=660,975 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 87637
58. 622.568 622.568 ↑ 1.0 276,532 1

Index Scan using "FL Brevard Property Table_idx_1" on "FL Brevard Property Table" pt_111 (cost=0.42..67,817.22 rows=277,152 width=52) (actual time=0.630..622.568 rows=276,532 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 55758
59. 484.220 484.220 ↑ 1.0 181,290 1

Index Scan using "FL Charlotte Property Table_idx_1" on "FL Charlotte Property Table" pt_112 (cost=0.42..40,188.00 rows=181,725 width=49) (actual time=0.048..484.220 rows=181,290 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 29773
60. 163.636 163.636 ↓ 1.0 67,686 1

Index Scan using "FL Indian River Property Table_idx_1" on "FL Indian River Property Table" pt_113 (cost=0.42..20,081.54 rows=67,674 width=61) (actual time=0.105..163.636 rows=67,686 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 25010
61. 482.939 482.939 ↑ 1.0 219,122 1

Index Scan using "FL Collier Property Table_idx_1" on "FL Collier Property Table" pt_114 (cost=0.42..39,110.12 rows=220,231 width=39) (actual time=0.151..482.939 rows=219,122 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 63129
62. 170.155 170.155 ↑ 1.0 85,793 1

Index Scan using "FL Leon Property Table_idx_1" on "FL Leon Property Table" pt_115 (cost=0.42..19,725.55 rows=86,162 width=38) (actual time=0.103..170.155 rows=85,793 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 22487
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 61458
63. 0.282 0.282 ↑ 767,842.0 1 1

Index Scan using "FL Miami Dade Property Table_idx_1" on "FL Miami Dade Property Table" pt_117 (cost=0.42..128,266.49 rows=767,842 width=47) (actual time=0.281..0.282 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 171
64. 0.119 0.119 ↑ 179,849.0 1 1

Index Scan using "FL Pasco Property Table_idx_1" on "FL Pasco Property Table" pt_118 (cost=0.42..50,900.08 rows=179,849 width=49) (actual time=0.118..0.119 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 24
65. 0.122 0.122 ↑ 365,734.0 1 1

Index Scan using "FL Pinellas Property Table_idx_1" on "FL Pinellas Property Table" pt_119 (cost=0.42..93,829.75 rows=365,734 width=61) (actual time=0.121..0.122 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 2
66. 75.309 75.309 ↑ 4.4 35,246 1

Index Scan using "FL Manatee Property Table_idx_1" on "FL Manatee Property Table" pt_120 (cost=0.42..37,763.54 rows=155,227 width=38) (actual time=0.069..75.309 rows=35,246 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 9257
67. 0.052 0.052 ↑ 232,722.0 1 1

Index Scan using "FL Polk Property Table_idx_1" on "FL Polk Property Table" pt_121 (cost=0.42..66,599.61 rows=232,722 width=50) (actual time=0.052..0.052 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
68. 0.054 0.054 ↑ 241,415.0 1 1

Index Scan using "FL Volusia Property Table_idx_1" on "FL Volusia Property Table" pt_122 (cost=0.42..43,501.90 rows=241,415 width=43) (actual time=0.054..0.054 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 8
69. 141.025 141.025 ↓ 1.0 68,461 1

Index Scan using "FL Flagler Property Table_idx_1" on "FL Flagler Property Table" pt_123 (cost=0.42..15,863.91 rows=68,360 width=50) (actual time=0.081..141.025 rows=68,461 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 12804
70. 286.881 286.881 ↓ 1.0 127,151 1

Index Scan using "FL Escambia Property Table_idx_1" on "FL Escambia Property Table" pt_124 (cost=0.42..24,605.03 rows=126,905 width=48) (actual time=0.086..286.881 rows=127,151 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 30855
71. 0.528 0.528 ↑ 146,315.0 1 1

Index Scan using "FL St Lucie Property Table_idx_1" on "FL St Lucie Property Table" pt_125 (cost=0.42..23,492.47 rows=146,315 width=44) (actual time=0.528..0.528 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 434
72. 0.107 0.107 ↑ 117,800.0 1 1

Index Scan using "FL St Johns Property Table_idx_1" on "FL St Johns Property Table" pt_126 (cost=0.42..27,683.75 rows=117,800 width=36) (actual time=0.107..0.107 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
73. 0.066 0.066 ↑ 145,864.0 1 1

Index Scan using "FL Osceola Property Table_idx_1" on "FL Osceola Property Table" pt_128 (cost=0.42..27,774.64 rows=145,864 width=57) (actual time=0.066..0.066 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 20
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
74. 236.194 236.194 ↓ 1.0 114,147 1

Index Scan using "FL Lake Property Table_idx_1" on "FL Lake Property Table" pt_130 (cost=0.42..19,981.47 rows=113,984 width=49) (actual time=0.085..236.194 rows=114,147 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 22013
75. 947.418 947.418 ↓ 1.0 425,361 1

Index Scan using "FL Hillsborough Property Table_idx_1" on "FL Hillsborough Property Table" pt_131 (cost=0.42..112,079.75 rows=423,716 width=52) (actual time=0.097..947.418 rows=425,361 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 95708
76. 0.078 0.078 ↑ 251,930.0 1 1

Index Scan using "GA Gwinnett Property Table_idx_1" on "GA Gwinnett Property Table" pt_132 (cost=0.42..53,292.66 rows=251,930 width=35) (actual time=0.077..0.078 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 1
77. 31.782 31.782 ↑ 164,938.0 1 1

Index Scan using "TX Williamson Property Table_idx_1" on "TX Williamson Property Table" pt_133 (cost=0.42..52,038.19 rows=164,938 width=51) (actual time=31.782..31.782 rows=1 loops=1)

  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 22890
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Filter: ("PropertyType" = ANY ('{SF,CON}'::text[]))
  • Rows Removed by Filter: 10
78. 36.364 41.598 ↑ 1.0 4,700 1

Sort (cost=606.16..617.91 rows=4,700 width=15) (actual time=39.361..41.598 rows=4,700 loops=1)

  • Sort Key: requested_area_property.property_id
  • Sort Method: quicksort Memory: 413kB
79. 5.234 5.234 ↑ 1.0 4,700 1

Seq Scan on requested_area_property (cost=0.00..319.50 rows=4,700 width=15) (actual time=1.868..5.234 rows=4,700 loops=1)

  • Filter: (requested_area_id = 25)
  • Rows Removed by Filter: 11340
80.          

CTE eligible_subdivid

81. 0.169 16,771.209 ↓ 3.5 98 1

Unique (cost=42,143.86..42,144.21 rows=28 width=111) (actual time=16,770.969..16,771.209 rows=98 loops=1)

82. 0.701 16,771.040 ↓ 3.5 98 1

Sort (cost=42,143.86..42,143.93 rows=28 width=111) (actual time=16,770.966..16,771.040 rows=98 loops=1)

  • Sort Key: st."SubdivID", st."SubdivName", pt_136."SubdivCode", pt_136."CountyID
  • Sort Method: quicksort Memory: 38kB
83. 443.913 16,770.339 ↓ 3.5 98 1

Hash Join (cost=35,067.29..42,143.18 rows=28 width=111) (actual time=16,478.435..16,770.339 rows=98 loops=1)

  • Hash Cond: ((pt_136."CountyID" = st."CountyID") AND (pt_136."SubdivCode" = st."SubdivCode"))
84. 14,254.433 14,254.433 ↑ 49.9 98 1

CTE Scan on eligible_properties pt_136 (cost=0.00..97.90 rows=4,895 width=64) (actual time=14,247.849..14,254.433 rows=98 loops=1)

85. 892.327 2,071.993 ↑ 1.0 583,000 1

Hash (cost=19,484.14..19,484.14 rows=583,210 width=72) (actual time=2,071.993..2,071.993 rows=583,000 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2427kB
86. 613.980 1,179.666 ↑ 1.0 583,001 1

Append (cost=0.00..19,484.14 rows=583,210 width=72) (actual time=0.031..1,179.666 rows=583,001 loops=1)

87. 0.010 0.010 ↓ 0.0 0 1

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

88. 7.823 7.823 ↑ 1.0 8,644 1

Seq Scan on "TX Montgomery Subdivision Table" st_1 (cost=0.00..242.44 rows=8,644 width=74) (actual time=0.019..7.823 rows=8,644 loops=1)

89. 6.144 6.144 ↑ 1.0 8,252 1

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

90. 5.532 5.532 ↑ 1.0 6,830 1

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

91. 5.281 5.281 ↑ 1.0 7,011 1

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

92. 3.011 3.011 ↑ 1.0 4,067 1

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

93. 1.463 1.463 ↑ 1.0 1,916 1

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

94. 13.064 13.064 ↑ 1.0 16,231 1

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

95. 5.823 5.823 ↑ 1.0 7,343 1

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

96. 4.597 4.597 ↑ 1.0 6,034 1

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

97. 5.891 5.891 ↑ 1.0 8,075 1

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

98. 2.821 2.821 ↑ 1.0 3,655 1

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

99. 2.516 2.516 ↑ 1.0 3,515 1

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

100. 9.150 9.150 ↑ 1.0 11,570 1

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

101. 12.842 12.842 ↑ 1.0 17,644 1

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

102. 14.000 14.000 ↑ 1.0 18,216 1

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

103. 5.863 5.863 ↑ 1.0 7,268 1

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

104. 7.582 7.582 ↑ 1.0 9,762 1

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

105. 3.634 3.634 ↑ 1.0 4,223 1

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

106. 39.468 39.468 ↑ 1.0 48,120 1

Seq Scan on "FL Lee Subdivision Table" st_19 (cost=0.00..1,436.20 rows=48,120 width=72) (actual time=0.014..39.468 rows=48,120 loops=1)

107. 17.479 17.479 ↑ 1.0 22,000 1

Seq Scan on "FL Broward Subdivision Table" st_20 (cost=0.00..644.00 rows=22,000 width=69) (actual time=0.018..17.479 rows=22,000 loops=1)

108. 18.593 18.593 ↑ 1.0 22,136 1

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

109. 9.231 9.231 ↑ 1.0 11,804 1

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

110. 3.880 3.880 ↑ 1.0 5,147 1

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

111. 1.561 1.561 ↑ 1.0 1,868 1

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

112. 10.093 10.093 ↑ 1.0 13,018 1

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

113. 7.343 7.343 ↑ 1.0 9,010 1

Seq Scan on "FL Sarasota Subdivision Table" st_26 (cost=0.00..254.10 rows=9,010 width=74) (actual time=0.018..7.343 rows=9,010 loops=1)

114. 43.493 43.493 ↑ 1.0 54,586 1

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

115. 12.015 12.015 ↑ 1.0 13,360 1

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

116. 7.768 7.768 ↑ 1.0 7,997 1

Seq Scan on "FL St Lucie Subdivision Table" st_29 (cost=0.00..229.97 rows=7,997 width=75) (actual time=0.023..7.768 rows=7,997 loops=1)

117. 2.520 2.520 ↑ 1.0 2,615 1

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

118. 7.891 7.891 ↑ 1.0 9,448 1

Seq Scan on "FL Collier Subdivision Table" st_31 (cost=0.00..259.48 rows=9,448 width=71) (actual time=0.018..7.891 rows=9,448 loops=1)

119. 9.507 9.507 ↑ 1.0 11,397 1

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

120. 25.951 25.951 ↑ 1.0 20,828 1

Seq Scan on "FL Hillsborough Subdivision Table" st_33 (cost=0.00..605.28 rows=20,828 width=72) (actual time=0.036..25.951 rows=20,828 loops=1)

121. 16.305 16.305 ↑ 1.0 16,396 1

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

122. 28.931 28.931 ↑ 1.0 23,685 1

Seq Scan on "TX Travis Subdivision Table" st_35 (cost=0.00..656.85 rows=23,685 width=67) (actual time=0.020..28.931 rows=23,685 loops=1)

123. 46.134 46.134 ↑ 1.0 46,279 1

Seq Scan on "TX Bexar Subdivision Table" st_36 (cost=0.00..1,302.79 rows=46,279 width=79) (actual time=0.023..46.134 rows=46,279 loops=1)

124. 13.966 13.966 ↑ 1.0 16,384 1

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

125. 12.061 12.061 ↑ 1.0 11,200 1

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

126. 14.249 14.249 ↑ 1.0 10,117 1

Seq Scan on "FL Manatee Subdivision Table" st_39 (cost=0.00..301.25 rows=10,325 width=74) (actual time=0.030..14.249 rows=10,117 loops=1)

127. 16.736 16.736 ↑ 1.0 12,980 1

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

128. 72.598 72.598 ↑ 1.0 33,934 1

Seq Scan on "FL Miami Dade Subdivision Table" st_41 (cost=0.00..1,007.34 rows=33,934 width=74) (actual time=0.029..72.598 rows=33,934 loops=1)

129. 10.866 10.866 ↑ 1.0 8,436 1

Seq Scan on "GA DeKalb Subdivision Table" st_42 (cost=0.00..237.36 rows=8,436 width=67) (actual time=0.021..10.866 rows=8,436 loops=1)

130. 94.495 167.201 ↑ 1.0 122,070 1

Append (cost=0.00..3,705.37 rows=125,359 width=29) (actual time=0.040..167.201 rows=122,070 loops=1)

131. 0.005 0.005 ↓ 0.0 0 1

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

132. 0.524 0.524 ↓ 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.032..0.524 rows=821 loops=1)

133. 0.760 0.760 ↑ 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=0.012..0.760 rows=1,300 loops=1)

134. 0.836 0.836 ↑ 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=0.011..0.836 rows=1,451 loops=1)

135. 1.282 1.282 ↑ 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=0.012..1.282 rows=2,147 loops=1)

136. 1.754 1.754 ↑ 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=0.013..1.754 rows=3,012 loops=1)

137. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

138. 2.177 2.177 ↑ 1.0 3,631 1

Seq Scan on "GA DeKalb Neighborhood Table" nt_7 (cost=0.00..88.31 rows=3,631 width=28) (actual time=0.012..2.177 rows=3,631 loops=1)

139. 6.851 6.851 ↑ 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=0.012..6.851 rows=11,707 loops=1)

140. 1.811 1.811 ↑ 1.0 3,134 1

Seq Scan on "FL Lee Neighborhood Table" nt_9 (cost=0.00..75.34 rows=3,134 width=28) (actual time=0.013..1.811 rows=3,134 loops=1)

141. 1.995 1.995 ↑ 1.0 3,464 1

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

142. 1.139 1.139 ↑ 1.0 1,810 1

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

143. 0.005 0.005 ↓ 0.0 0 1

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

144. 0.003 0.003 ↓ 0.0 0 1

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

145. 3.132 3.132 ↑ 1.0 4,835 1

Seq Scan on "FL Palm Beach Neighborhood Table" nt_14 (cost=0.00..122.35 rows=4,835 width=32) (actual time=0.023..3.132 rows=4,835 loops=1)

146. 0.004 0.004 ↓ 0.0 0 1

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

147. 3.231 3.231 ↑ 1.0 5,273 1

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

148. 1.910 1.910 ↑ 1.0 3,254 1

Seq Scan on "FL Sarasota Neighborhood Table" nt_17 (cost=0.00..80.54 rows=3,254 width=31) (actual time=0.013..1.910 rows=3,254 loops=1)

149. 0.639 0.639 ↑ 1.0 1,026 1

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

150. 3.101 3.101 ↑ 1.0 5,194 1

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

151. 1.358 1.358 ↑ 1.0 2,444 1

Seq Scan on "FL Brevard Neighborhood Table" nt_20 (cost=0.00..60.44 rows=2,444 width=30) (actual time=0.014..1.358 rows=2,444 loops=1)

152. 0.478 0.478 ↑ 1.0 755 1

Seq Scan on "FL Charlotte Neighborhood Table" nt_21 (cost=0.00..19.55 rows=755 width=32) (actual time=0.019..0.478 rows=755 loops=1)

153. 0.652 0.652 ↑ 1.0 993 1

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

154. 1.582 1.582 ↑ 1.0 2,402 1

Seq Scan on "FL Collier Neighborhood Table" nt_23 (cost=0.00..61.02 rows=2,402 width=32) (actual time=0.012..1.582 rows=2,402 loops=1)

155. 0.885 0.885 ↑ 1.0 1,410 1

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

156. 2.034 2.034 ↑ 1.0 3,507 1

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

157. 5.956 5.956 ↑ 1.0 10,219 1

Seq Scan on "FL Miami Dade Neighborhood Table" nt_26 (cost=0.00..251.19 rows=10,219 width=30) (actual time=0.017..5.956 rows=10,219 loops=1)

158. 0.866 0.866 ↑ 1.0 1,361 1

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

159. 3.154 3.154 ↑ 1.0 5,504 1

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

160. 2.032 2.032 ↑ 1.0 3,446 1

Seq Scan on "FL Manatee Neighborhood Table" nt_29 (cost=0.00..84.46 rows=3,446 width=29) (actual time=0.012..2.032 rows=3,446 loops=1)

161. 2.749 2.749 ↑ 1.0 4,320 1

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

162. 1.684 1.684 ↑ 1.0 2,891 1

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

163. 0.215 0.215 ↑ 1.0 346 1

Seq Scan on "FL Flagler Neighborhood Table" nt_32 (cost=0.00..8.46 rows=346 width=27) (actual time=0.012..0.215 rows=346 loops=1)

164. 0.882 0.882 ↑ 1.0 1,527 1

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

165. 0.519 0.519 ↑ 1.0 858 1

Seq Scan on "FL St Lucie Neighborhood Table" nt_34 (cost=0.00..21.58 rows=858 width=31) (actual time=0.017..0.519 rows=858 loops=1)

166. 0.684 0.684 ↑ 1.0 1,173 1

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

167. 1.162 1.162 ↑ 1.0 1,998 1

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

168. 0.719 0.719 ↑ 1.0 1,239 1

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

169. 2.529 2.529 ↑ 1.0 4,226 1

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

170. 1.134 1.134 ↑ 1.0 1,938 1

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

171. 3.304 3.304 ↑ 1.0 5,670 1

Seq Scan on "FL Hillsborough Neighborhood Table" nt_40 (cost=0.00..142.70 rows=5,670 width=32) (actual time=0.011..3.304 rows=5,670 loops=1)

172. 2.090 2.090 ↑ 1.0 3,542 1

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

173. 0.003 0.003 ↓ 0.0 0 1

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

174. 4.294 4.294 ↑ 1.0 7,290 1

Seq Scan on "TX Travis Neighborhood Table" nt_43 (cost=0.00..183.90 rows=7,290 width=32) (actual time=0.010..4.294 rows=7,290 loops=1)

175. 0.573 0.573 ↑ 1.0 952 1

Seq Scan on "TX Bexar Neighborhood Table" nt_44 (cost=0.00..23.52 rows=952 width=25) (actual time=0.012..0.573 rows=952 loops=1)

176. 5.750 18,066.228 ↓ 4.8 5,107 1

Hash (cost=58,151.93..58,151.93 rows=1,066 width=152) (actual time=18,066.227..18,066.228 rows=5,107 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 811kB
177. 6.965 18,060.478 ↓ 4.8 5,107 1

Hash Left Join (cost=769.86..58,151.93 rows=1,066 width=152) (actual time=17,984.792..18,060.478 rows=5,107 loops=1)

  • Hash Cond: (eligible_subdivid."SubdivID" = subscribed_area."SubdivID")
178. 5.429 16,841.348 ↓ 567.4 5,107 1

Nested Loop (cost=0.00..57,344.74 rows=9 width=120) (actual time=16,772.426..16,841.348 rows=5,107 loops=1)

179. 16,771.435 16,771.435 ↓ 3.5 98 1

CTE Scan on eligible_subdivid (cost=0.00..0.63 rows=28 width=128) (actual time=16,770.990..16,771.435 rows=98 loops=1)

  • Filter: ("SubdivID" !~~ '%Not in Subdivision%'::text)
180. 30.478 64.484 ↑ 12.2 52 98

Append (cost=0.00..2,041.64 rows=636 width=84) (actual time=0.395..0.658 rows=52 loops=98)

  • -> 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.003..0.003 rows=0
  • -> Index Scan using "TX Brazoria Property Table_idx_2" on "TX Brazoria Property Table" pt_4 (cost=0.42..47.02 rows=1 width=77) (actual time=0.006..0.006 rows=0loops=98)
  • -> 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
  • -> 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.006..0.006 rows=0loops=98)
  • -> 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.006..0.006 rows=0loops=98)
  • -> 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.006..0.006 rows=0loops=98)
  • -> 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.006..0.006 rows=0loops=98)
  • -> Index Scan using "TX Tarrant Property Table_idx_2" on "TX Tarrant Property Table" pt_36 (cost=0.42..48.65 rows=11 width=70) (actual time=0.006..0.006 rows=0loops=98)
  • -> Index Scan using "FL Broward Property Table_idx_2" on "FL Broward Property Table" pt_42 (cost=0.42..52.80 rows=22 width=77) (actual time=0.007..0.007 rows=0loops=98)
  • -> Index Scan using "FL Brevard Property Table_idx_2" on "FL Brevard Property Table" pt_43 (cost=0.42..46.57 rows=19 width=87) (actual time=0.008..0.008 rows=0loops=98)
  • -> Index Scan using "FL Manatee Property Table_idx_2" on "FL Manatee Property Table" pt_52 (cost=0.42..51.42 rows=20 width=75) (actual time=0.021..0.121 rows=52
  • -> Index Scan using "FL Osceola Property Table_idx_2" on "FL Osceola Property Table" pt_60 (cost=0.42..51.42 rows=21 width=94) (actual time=0.008..0.008 rows=0loops=98)
181. 0.098 0.098 ↓ 0.0 0 98

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

  • 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"))
182. 0.196 0.980 ↓ 0.0 0 98

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

  • 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[])))
183. 0.784 0.784 ↓ 0.0 0 98

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

  • Index Cond: (("CountyID" = eligible_subdivid."CountyID") AND ("SubdivCode" = eligible_subdivid."SubdivCode"))
184. 0.686 0.686 ↓ 0.0 0 98

Index Scan using "TX Bexar Property Table_idx_2" on "TX Bexar Property Table" pt_2 (cost=0.42..47.01 rows=13 width=74) (actual time=0.007..0.007 rows=0 loops=98)

  • 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[])))
  • 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"))
  • 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[])))
  • 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"))
185. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
186. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
187. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
188. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
189. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "NJ Hunterdon Property Table_idx_2" on "NJ Hunterdon Property Table" pt_10 (cost=0.41..6.04 rows=1 width=99) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
190. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "NJ Warren Property Table_idx_2" on "NJ Warren Property Table" pt_11 (cost=0.41..6.04 rows=1 width=96) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
191. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
192. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
193. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
194. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
  • 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[])))
195. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
  • 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[])))
196. 0.588 0.588 ↓ 0.0 0 98

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

  • 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[])))
  • 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[])))
197. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
198. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "NJ Salem Property Table_idx_2" on "NJ Salem Property Table" pt_22 (cost=0.41..5.90 rows=1 width=93) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
199. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
  • 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[])))
200. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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[])))
201. 0.588 0.588 ↓ 0.0 0 98

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.006..0.006 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "GA Fulton Property Table_idx_2" on "GA Fulton Property Table" pt_27 (cost=0.42..31.18 rows=13 width=83) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
203. 0.294 0.294 ↓ 0.0 0 98

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.003..0.003 rows=0 loops=98)

  • 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"))
204. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "TX Dallas Property Table_idx_2" on "TX Dallas Property Table" pt_29 (cost=0.42..29.59 rows=6 width=78) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
205. 0.196 0.196 ↓ 0.0 0 98

Index Scan using "TX Hays Property Table_idx_2" on "TX Hays Property Table" pt_30 (cost=0.14..1.74 rows=1 width=176) (actual time=0.002..0.002 rows=0 loops=98)

  • 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.294 0.294 ↓ 0.0 0 98

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.003..0.003 rows=0 loops=98)

  • 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"))
207. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "FL Lee Property Table_idx_2" on "FL Lee Property Table" pt_32 (cost=0.42..52.61 rows=22 width=84) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.294 0.294 ↓ 0.0 0 98

Index Scan using "GA Cobb Property Table_idx_3" on "GA Cobb Property Table" pt_33 (cost=0.42..8.45 rows=1 width=70) (actual time=0.003..0.003 rows=0 loops=98)

  • 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"))
209. 0.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Seminole Property Table_idx_2" on "FL Seminole Property Table" pt_34 (cost=0.42..51.05 rows=25 width=85) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "TX Collin Property Table_idx_2" on "TX Collin Property Table" pt_35 (cost=0.42..46.63 rows=12 width=67) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Palm Beach Property Table_idx_2" on "FL Palm Beach Property Table" pt_37 (cost=0.42..52.74 rows=10 width=89) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "GA Cherokee Property Table_idx_2" on "GA Cherokee Property Table" pt_38 (cost=0.42..38.53 rows=12 width=82) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "TX Harris Property Table_idx_2" on "TX Harris Property Table" pt_39 (cost=0.43..52.99 rows=17 width=81) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.784 0.784 ↓ 0.0 0 98

Index Scan using "FL Sarasota Property Table_idx_2" on "FL Sarasota Property Table" pt_40 (cost=0.42..51.98 rows=21 width=72) (actual time=0.008..0.008 rows=0 loops=98)

  • 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.882 0.882 ↓ 0.0 0 98

Index Scan using "FL Martin Property Table_idx_2" on "FL Martin Property Table" pt_41 (cost=0.42..50.10 rows=18 width=96) (actual time=0.009..0.009 rows=0 loops=98)

  • 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[])))
  • 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[])))
  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "FL Charlotte Property Table_idx_2" on "FL Charlotte Property Table" pt_44 (cost=0.42..49.23 rows=21 width=86) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "FL Indian River Property Table_idx_2" on "FL Indian River Property Table" pt_45 (cost=0.42..49.85 rows=13 width=96) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Collier Property Table_idx_2" on "FL Collier Property Table" pt_46 (cost=0.42..49.67 rows=8 width=78) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "FL Leon Property Table_idx_2" on "FL Leon Property Table" pt_47 (cost=0.42..47.73 rows=20 width=75) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Duval Property Table_idx_2" on "FL Duval Property Table" pt_48 (cost=0.42..52.30 rows=21 width=72) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.882 0.882 ↓ 0.0 0 98

Index Scan using "FL Miami Dade Property Table_idx_2" on "FL Miami Dade Property Table" pt_49 (cost=0.42..52.86 rows=19 width=83) (actual time=0.009..0.009 rows=0 loops=98)

  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Pasco Property Table_idx_2" on "FL Pasco Property Table" pt_50 (cost=0.42..49.67 rows=16 width=89) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Pinellas Property Table_idx_2" on "FL Pinellas Property Table" pt_51 (cost=0.42..52.48 rows=21 width=98) (actual time=0.007..0.007 rows=0 loops=98)

  • 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[])))
  • 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.784 0.784 ↓ 0.0 0 98

Index Scan using "FL Polk Property Table_idx_2" on "FL Polk Property Table" pt_53 (cost=0.42..50.46 rows=18 width=86) (actual time=0.008..0.008 rows=0 loops=98)

  • 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.784 0.784 ↓ 0.0 0 98

Index Scan using "FL Volusia Property Table_idx_2" on "FL Volusia Property Table" pt_54 (cost=0.42..51.98 rows=1 width=79) (actual time=0.008..0.008 rows=0 loops=98)

  • 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.294 0.294 ↓ 0.0 0 98

Index Scan using "FL Flagler Property Table_idx_3" on "FL Flagler Property Table" pt_55 (cost=0.29..8.32 rows=1 width=85) (actual time=0.003..0.003 rows=0 loops=98)

  • 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"))
227. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "FL Escambia Property Table_idx_2" on "FL Escambia Property Table" pt_56 (cost=0.42..51.23 rows=19 width=84) (actual time=0.006..0.006 rows=0 loops=98)

  • 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[])))
228. 0.686 0.686 ↓ 0.0 0 98

Index Scan using "FL St Lucie Property Table_idx_2" on "FL St Lucie Property Table" pt_57 (cost=0.42..51.30 rows=18 width=81) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.784 0.784 ↓ 0.0 0 98

Index Scan using "FL St Johns Property Table_idx_2" on "FL St Johns Property Table" pt_58 (cost=0.42..43.79 rows=12 width=72) (actual time=0.008..0.008 rows=0 loops=98)

  • 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[])))
230. 0.784 0.784 ↓ 0.0 0 98

Index Scan using "FL Marion Property Table_idx_2" on "FL Marion Property Table" pt_59 (cost=0.42..49.61 rows=19 width=79) (actual time=0.008..0.008 rows=0 loops=98)

  • 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[])))
  • 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[])))
231. 0.784 0.784 ↓ 0.0 0 98

Index Scan using "FL Orange Property Table_idx_2" on "FL Orange Property Table" pt_61 (cost=0.42..52.48 rows=22 width=82) (actual time=0.008..0.008 rows=0 loops=98)

  • 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[])))
232. 0.588 0.588 ↓ 0.0 0 98

Index Scan using "FL Lake Property Table_idx_2" on "FL Lake Property Table" pt_62 (cost=0.42..50.80 rows=21 width=86) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "FL Hillsborough Property Table_idx_2" on "FL Hillsborough Property Table" pt_63 (cost=0.42..52.61 rows=19 width=90) (actual time=0.007..0.007 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "GA Gwinnett Property Table_idx_2" on "GA Gwinnett Property Table" pt_64 (cost=0.42..46.32 rows=20 width=72) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "TX Williamson Property Table_idx_2" on "TX Williamson Property Table" pt_65 (cost=0.42..44.60 rows=12 width=87) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.588 0.588 ↓ 0.0 0 98

Index Scan using "TX Denton Property Table_idx_2" on "TX Denton Property Table" pt_66 (cost=0.42..48.21 rows=13 width=68) (actual time=0.006..0.006 rows=0 loops=98)

  • 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.686 0.686 ↓ 0.0 0 98

Index Scan using "TX Travis Property Table_idx_2" on "TX Travis Property Table" pt_67 (cost=0.42..45.04 rows=10 width=75) (actual time=0.007..0.007 rows=0 loops=98)

  • 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. 3.098 1,212.165 ↑ 9.3 2,548 1

Hash (cost=473.76..473.76 rows=23,688 width=64) (actual time=1,212.165..1,212.165 rows=2,548 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 487kB
239. 1,209.067 1,209.067 ↑ 9.3 2,548 1

CTE Scan on subscribed_area (cost=0.00..473.76 rows=23,688 width=64) (actual time=1,200.954..1,209.067 rows=2,548 loops=1)