Database Reference
In-Depth Information
width=204) (actual
time=4224.661..4230.587 rows=234 loops=1)
Output: scpo.school,
(first_value(scpo.police_address) OVER
(?)), (first_value(scpo.distance) OVER
(?)), scpo.distance
CTE scpo
-> Sort (cost=19.36..19.37 rows=1
width=104) (actual
time=3977.815..3986.504 rows=7956 loops=1)
Output: ca.name, ca.address,
(st_distance(st_transform(ca.geom, 3310),
st_transform(ca.geom, 3310)))
Sort Key: ca.name,
(st_distance(st_transform(ca.geom, 3310),
st_transform(ca.geom, 3310))), ca.address
Sort Method: external merge
Disk: 496kB
-> Nested Loop
(cost=0.01..19.35 rows=1 width=104)
(actual time=174.856..3858.436 rows=7956
loops=1)
Output: ca.name, ca.address,
st_distance(st_transform(ca.geom, 3310),
st_transform(ca.geom, 3310))
-> Nested Loop
(cost=0.00..10.56 rows=1 width=81)
(actual time=90.613..108.940 rows=34
loops=1)
Output: ca.address, ca.geom,
sf.geom
-> Nested Loop
(cost=0.00..9.54 rows=1 width=49) (actual
time=90.576..108.221 rows=34 loops=1)
Output: ca.address, ca.geom
...
