explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BvSv

Settings
# exclusive inclusive rows x rows loops node
1. 0.481 94.078 ↓ 1.0 4,871 1

Append (cost=0.43..124,471.40 rows=4,836 width=25) (actual time=53.686..94.078 rows=4,871 loops=1)

  • Functions: 56
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 7.539 ms, Inlining 0.000 ms, Optimization 3.722 ms, Emission 47.299 ms, Total 58.560 ms
2. 0.002 1.956 ↓ 0.0 0 1

Nested Loop (cost=0.43..80.38 rows=3 width=25) (actual time=1.956..1.956 rows=0 loops=1)

3. 1.954 1.954 ↓ 0.0 0 1

Index Scan using road_network_partitioned3_cell_796_geometry_idx on road_network_partitioned3_cell_796 (cost=0.15..79.23 rows=3 width=12) (actual time=1.954..1.954 rows=0 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Filter: ((lon >= 152) AND (lon <= 153) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 (cost=0.28..0.37 rows=1 width=27) (never executed)

  • Index Cond: ((lon = road_network_partitioned3_cell_796.lon) AND (lon >= 152) AND (lon <= 153) AND (lat = road_network_partitioned3_cell_796.lat) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND (link_id = road_network_partitioned3_cell_796.link_id))
5. 1.141 58.587 ↓ 1.1 805 1

Nested Loop (cost=0.56..19,898.57 rows=762 width=25) (actual time=51.728..58.587 rows=805 loops=1)

6. 55.031 55.031 ↓ 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=51.701..55.031 rows=805 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Filter: ((lon >= 152) AND (lon <= 153) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry))
7. 2.415 2.415 ↑ 1.0 1 805

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

  • Index Cond: ((lon = road_network_partitioned3_cell_754.lon) AND (lon >= 152) AND (lon <= 153) AND (lat = road_network_partitioned3_cell_754.lat) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND (link_id = road_network_partitioned3_cell_754.link_id))
8. 0.000 1.379 ↓ 0.0 0 1

Nested Loop (cost=0.56..398.13 rows=15 width=25) (actual time=1.379..1.379 rows=0 loops=1)

9. 1.379 1.379 ↓ 0.0 0 1

Index Scan using road_network_partitioned3_cell_797_geometry_idx on road_network_partitioned3_cell_797 (cost=0.28..391.69 rows=15 width=12) (actual time=1.379..1.379 rows=0 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Filter: ((lon >= 152) AND (lon <= 153) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using road_network_partitioned2_cell_797_pkey on road_network_partitioned2_cell_797 (cost=0.29..0.42 rows=1 width=25) (never executed)

  • Index Cond: ((lon = road_network_partitioned3_cell_797.lon) AND (lon >= 152) AND (lon <= 153) AND (lat = road_network_partitioned3_cell_797.lat) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND (link_id = road_network_partitioned3_cell_797.link_id))
11. 4.397 31.675 ↓ 1.0 4,066 1

Nested Loop (cost=0.56..104,070.14 rows=4,056 width=25) (actual time=0.099..31.675 rows=4,066 loops=1)

12. 15.080 15.080 ↓ 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.074..15.080 rows=4,066 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Filter: ((lon >= 152) AND (lon <= 153) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry))
13. 12.198 12.198 ↑ 1.0 1 4,066

Index Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 (cost=0.29..0.47 rows=1 width=25) (actual time=0.003..0.003 rows=1 loops=4,066)

  • Index Cond: ((lon = road_network_partitioned3_cell_755.lon) AND (lon >= 152) AND (lon <= 153) AND (lat = road_network_partitioned3_cell_755.lat) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer) AND (link_id = road_network_partitioned3_cell_755.link_id))
Planning time : 12.493 ms