explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kabF

Settings
# exclusive inclusive rows x rows loops node
1. 0.442 68.917 ↓ 1.0 4,871 1

Append (cost=0.56..127,079.08 rows=4,818 width=25) (actual time=29.867..68.917 rows=4,871 loops=1)

  • Functions: 24
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 5.052 ms, Inlining 0.000 ms, Optimization 1.977 ms, Emission 26.995 ms, Total 34.023 ms
2. 1.080 36.961 ↓ 1.1 805 1

Nested Loop (cost=0.56..20,313.05 rows=762 width=25) (actual time=29.866..36.961 rows=805 loops=1)

3. 33.466 33.466 ↓ 1.1 805 1

Index Scan using road_network_1deg_partitioned_cell_754_geometry_idx on road_network_1deg_partitioned_cell_754 b (cost=0.28..19,674.58 rows=762 width=26) (actual time=29.821..33.466 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. 2.415 2.415 ↑ 1.0 1 805

Index Only Scan using road_network_1deg_partitioned_cell_754_pkey on road_network_1deg_partitioned_cell_754 a (cost=0.29..0.64 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=805)

  • Index Cond: ((lon = b.lon) AND (lat = b.lat) AND (link_id = b.link_id))
  • Heap Fetches: 805
5. 3.400 31.514 ↓ 1.0 4,066 1

Nested Loop (cost=0.56..106,284.23 rows=4,056 width=25) (actual time=0.112..31.514 rows=4,066 loops=1)

6. 15.916 15.916 ↓ 1.0 4,066 1

Index Scan using road_network_1deg_partitioned_cell_755_geometry_idx on road_network_1deg_partitioned_cell_755 b_1 (cost=0.28..102,862.21 rows=4,056 width=25) (actual time=0.088..15.916 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))
7. 12.198 12.198 ↑ 1.0 1 4,066

Index Only Scan using road_network_1deg_partitioned_cell_755_pkey on road_network_1deg_partitioned_cell_755 a_1 (cost=0.29..0.64 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=4,066)

  • Index Cond: ((lon = b_1.lon) AND (lat = b_1.lat) AND (link_id = b_1.link_id))
  • Heap Fetches: 4066
Planning time : 1,437.954 ms