explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tu4T

Settings
# exclusive inclusive rows x rows loops node
1. 0.397 314.371 ↓ 152.2 4,871 1

Append (cost=0.42..132,521.20 rows=32 width=36) (actual time=202.918..314.371 rows=4,871 loops=1)

  • Functions: 329
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 27.828 ms, Inlining 0.000 ms, Optimization 8.512 ms, Emission 191.069 ms, Total 227.409 ms
2. 2.509 261.768 ↓ 115.0 805 1

Nested Loop (cost=0.42..25,577.73 rows=7 width=36) (actual time=202.918..261.768 rows=805 loops=1)

3. 210.959 210.959 ↓ 1.1 805 1

Index Scan using road_network_partitioned3_cell_754_geometry_idx on road_network_partitioned3_cell_754 (cost=0.28..19,538.23 rows=762 width=12) (actual time=202.768..210.959 rows=805 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Filter: ((lon >= 152) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-27'::integer) AND st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry))
4. 12.880 48.300 ↑ 34.0 1 805

Append (cost=0.14..7.59 rows=34 width=29) (actual time=0.034..0.060 rows=1 loops=805)

5. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1426 on road_network_partitioned2_cell_1426 (cost=0.14..0.16 rows=1 width=230) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
6. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1384 on road_network_partitioned2_cell_1384 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
7. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1342 on road_network_partitioned2_cell_1342 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
8. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1300 on road_network_partitioned2_cell_1300 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
9. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1258 on road_network_partitioned2_cell_1258 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
10. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1216 on road_network_partitioned2_cell_1216 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
11. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1174 on road_network_partitioned2_cell_1174 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
12. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1132 on road_network_partitioned2_cell_1132 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
13. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1090 on road_network_partitioned2_cell_1090 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
14. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1048 on road_network_partitioned2_cell_1048 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
15. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_c_link_id_street_name_road_km_idx1006 on road_network_partitioned2_cell_1006 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
16. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_964_pkey on road_network_partitioned2_cell_964 (cost=0.28..0.33 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
17. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_922_pkey on road_network_partitioned2_cell_922 (cost=0.28..0.37 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
18. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_880_pkey on road_network_partitioned2_cell_880 (cost=0.28..0.36 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
19. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_838_pkey on road_network_partitioned2_cell_838 (cost=0.28..0.34 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
20. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 (cost=0.28..0.36 rows=1 width=27) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
21. 3.220 3.220 ↑ 1.0 1 805

Index Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 (cost=0.29..0.45 rows=1 width=26) (actual time=0.004..0.004 rows=1 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
22. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_712_pkey on road_network_partitioned2_cell_712 (cost=0.29..0.41 rows=1 width=26) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
23. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_670_pkey on road_network_partitioned2_cell_670 (cost=0.28..0.35 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
24. 1.610 1.610 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_cell_628_pkey on road_network_partitioned2_cell_628 (cost=0.28..0.32 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=805)

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lat = road_network_partitioned3_cell_754.lat) AND (link_id = road_network_partitioned3_cell_754.link_id))
25. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx586 on road_network_partitioned2_cell_586 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
26. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx544 on road_network_partitioned2_cell_544 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
27. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx502 on road_network_partitioned2_cell_502 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
28. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx460 on road_network_partitioned2_cell_460 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
29. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx418 on road_network_partitioned2_cell_418 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
30. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx376 on road_network_partitioned2_cell_376 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
31. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx334 on road_network_partitioned2_cell_334 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
32. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx292 on road_network_partitioned2_cell_292 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
33. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx250 on road_network_partitioned2_cell_250 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
34. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx208 on road_network_partitioned2_cell_208 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
35. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx166 on road_network_partitioned2_cell_166 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
36. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km_idx124 on road_network_partitioned2_cell_124 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
37. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km__idx82 on road_network_partitioned2_cell_82 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
38. 0.805 0.805 ↓ 0.0 0 805

Index Scan using road_network_partitioned2_ce_link_id_street_name_road_km__idx40 on road_network_partitioned2_cell_40 (cost=0.14..0.16 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=805)

  • Index Cond: (link_id = road_network_partitioned3_cell_754.link_id)
  • Filter: ((road_network_partitioned3_cell_754.lon = lon) AND (road_network_partitioned3_cell_754.lat = lat))
39. 5.358 52.206 ↓ 162.6 4,066 1

Merge Join (cost=102,382.23..106,943.31 rows=25 width=36) (actual time=37.513..52.206 rows=4,066 loops=1)

  • Merge Cond: ((road_network_partitioned2_cell_1427.lon = road_network_partitioned3_cell_755.lon) AND (road_network_partitioned2_cell_1427.lat = road_network_partitioned3_cell_755.lat) AND (road_network_partitioned2_cell_1427.link_id = road_network_partitioned3_cell_755.link_id))
40. 4.862 30.193 ↑ 1.1 44,096 1

Merge Append (cost=6.34..4,151.98 rows=49,951 width=31) (actual time=0.190..30.193 rows=44,096 loops=1)

  • Sort Key: road_network_partitioned2_cell_1427.lon, road_network_partitioned2_cell_1427.lat, road_network_partitioned2_cell_1427.link_id
41. 0.009 0.009 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1427_pkey on road_network_partitioned2_cell_1427 (cost=0.14..11.89 rows=50 width=230) (actual time=0.009..0.009 rows=0 loops=1)

42. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1385_pkey on road_network_partitioned2_cell_1385 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

43. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1343_pkey on road_network_partitioned2_cell_1343 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

44. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1301_pkey on road_network_partitioned2_cell_1301 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

45. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1259_pkey on road_network_partitioned2_cell_1259 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

46. 0.006 0.006 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1217_pkey on road_network_partitioned2_cell_1217 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.006 rows=0 loops=1)

47. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1175_pkey on road_network_partitioned2_cell_1175 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

48. 0.006 0.006 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1133_pkey on road_network_partitioned2_cell_1133 (cost=0.14..11.89 rows=50 width=230) (actual time=0.006..0.006 rows=0 loops=1)

49. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1091_pkey on road_network_partitioned2_cell_1091 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

50. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1049_pkey on road_network_partitioned2_cell_1049 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

51. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_1007_pkey on road_network_partitioned2_cell_1007 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

52. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_965_pkey on road_network_partitioned2_cell_965 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

53. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_923_pkey on road_network_partitioned2_cell_923 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

54. 1.603 1.603 ↑ 1.0 3,107 1

Index Scan using road_network_partitioned2_cell_881_pkey on road_network_partitioned2_cell_881 (cost=0.28..165.88 rows=3,107 width=25) (actual time=0.019..1.603 rows=3,107 loops=1)

55. 1.412 1.412 ↑ 1.0 2,796 1

Index Scan using road_network_partitioned2_cell_839_pkey on road_network_partitioned2_cell_839 (cost=0.28..149.22 rows=2,796 width=25) (actual time=0.011..1.412 rows=2,796 loops=1)

56. 7.327 7.327 ↑ 1.0 13,205 1

Index Scan using road_network_partitioned2_cell_797_pkey on road_network_partitioned2_cell_797 (cost=0.29..691.36 rows=13,205 width=25) (actual time=0.011..7.327 rows=13,205 loops=1)

57. 14.857 14.857 ↑ 1.0 24,988 1

Index Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 (cost=0.29..1,089.14 rows=24,990 width=25) (actual time=0.011..14.857 rows=24,988 loops=1)

58. 0.018 0.018 ↑ 4,367.0 1 1

Index Scan using road_network_partitioned2_cell_713_pkey on road_network_partitioned2_cell_713 (cost=0.28..195.79 rows=4,367 width=25) (actual time=0.018..0.018 rows=1 loops=1)

59. 0.009 0.009 ↑ 86.0 1 1

Index Scan using road_network_partitioned2_cell_671_pkey on road_network_partitioned2_cell_671 (cost=0.14..6.43 rows=86 width=27) (actual time=0.009..0.009 rows=1 loops=1)

60. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_629_pkey on road_network_partitioned2_cell_629 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

61. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_587_pkey on road_network_partitioned2_cell_587 (cost=0.14..11.89 rows=50 width=230) (actual time=0.004..0.004 rows=0 loops=1)

62. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_545_pkey on road_network_partitioned2_cell_545 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

63. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_503_pkey on road_network_partitioned2_cell_503 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

64. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_461_pkey on road_network_partitioned2_cell_461 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

65. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_419_pkey on road_network_partitioned2_cell_419 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

66. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_377_pkey on road_network_partitioned2_cell_377 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

67. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_335_pkey on road_network_partitioned2_cell_335 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

68. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_293_pkey on road_network_partitioned2_cell_293 (cost=0.14..11.89 rows=50 width=230) (actual time=0.005..0.005 rows=0 loops=1)

69. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_251_pkey on road_network_partitioned2_cell_251 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

70. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_209_pkey on road_network_partitioned2_cell_209 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

71. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_167_pkey on road_network_partitioned2_cell_167 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

72. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_125_pkey on road_network_partitioned2_cell_125 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

73. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_83_pkey on road_network_partitioned2_cell_83 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

74. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_41_pkey on road_network_partitioned2_cell_41 (cost=0.14..11.89 rows=50 width=230) (actual time=0.003..0.003 rows=0 loops=1)

75. 3.334 16.655 ↓ 1.0 4,066 1

Sort (cost=102,375.89..102,386.03 rows=4,056 width=12) (actual time=16.061..16.655 rows=4,066 loops=1)

  • Sort Key: road_network_partitioned3_cell_755.lon, road_network_partitioned3_cell_755.lat, road_network_partitioned3_cell_755.link_id
  • Sort Method: quicksort Memory: 287kB
76. 13.321 13.321 ↓ 1.0 4,066 1

Index Scan using road_network_partitioned3_cell_755_geometry_idx on road_network_partitioned3_cell_755 (cost=0.28..102,132.82 rows=4,056 width=12) (actual time=0.063..13.321 rows=4,066 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Filter: ((lon >= 152) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-27'::integer) AND st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry))
Planning time : 9,723.926 ms