explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PcZe

Settings
# exclusive inclusive rows x rows loops node
1. 4.226 371.259 ↓ 168.0 4,871 1

Nested Loop (cost=0.56..126,328.20 rows=29 width=25) (actual time=244.545..371.259 rows=4,871 loops=1)

  • Functions: 30
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 50.511 ms, Inlining 0.000 ms, Optimization 47.501 ms, Emission 151.796 ms, Total 249.808 ms"Execution Time: 431.161 ms
2. 0.431 337.807 ↓ 1.0 4,871 1

Append (cost=0.28..121,695.14 rows=4,818 width=12) (actual time=244.474..337.807 rows=4,871 loops=1)

3. 260.977 260.977 ↓ 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=244.473..260.977 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. 76.399 76.399 ↓ 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=5.246..76.399 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))
5. 8.937 29.226 ↑ 2.0 1 4,871

Append (cost=0.29..0.94 rows=2 width=25) (actual time=0.006..0.006 rows=1 loops=4,871)

6. 4.025 4.025 ↑ 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.004..0.005 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 >= '-27'::integer) AND (lat <= '-27'::integer) AND (link_id = road_network_partitioned3_cell_754.link_id))
7. 16.264 16.264 ↑ 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.004..0.004 rows=1 loops=4,066)

  • 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 >= '-27'::integer) AND (lat <= '-27'::integer) AND (link_id = road_network_partitioned3_cell_754.link_id))