explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WaWA

Settings
# exclusive inclusive rows x rows loops node
1. 23.461 107.713 ↓ 168.1 47,576 1

Merge Join (cost=1.15..6,752.12 rows=283 width=25) (actual time=0.068..107.713 rows=47,576 loops=1)

  • Merge Cond: ((road_network_partitioned2_cell_754.lon = road_network_partitioned3_cell_754.lon) AND (road_network_partitioned2_cell_754.lat = road_network_partitioned3_cell_754.lat) AND (road_network_partitioned2_cell_754.link_id = road_network_partitioned3_cell_754.link_id))
2. 3.386 36.021 ↑ 1.0 47,576 1

Append (cost=0.57..2,832.86 rows=47,576 width=25) (actual time=0.032..36.021 rows=47,576 loops=1)

3. 15.728 15.728 ↑ 1.0 22,586 1

Index Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 (cost=0.29..1,255.94 rows=22,586 width=26) (actual time=0.031..15.728 rows=22,586 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-27'::integer))
4. 16.907 16.907 ↑ 1.0 24,990 1

Index Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 (cost=0.29..1,339.04 rows=24,990 width=25) (actual time=0.021..16.907 rows=24,990 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-27'::integer))
5. 10.324 48.231 ↑ 1.0 47,576 1

Materialize (cost=0.57..3,202.80 rows=47,576 width=12) (actual time=0.034..48.231 rows=47,576 loops=1)

6. 3.457 37.907 ↑ 1.0 47,576 1

Append (cost=0.57..3,083.86 rows=47,576 width=12) (actual time=0.030..37.907 rows=47,576 loops=1)

7. 16.470 16.470 ↑ 1.0 22,586 1

Index Only Scan using road_network_partitioned3_cell_754_pkey on road_network_partitioned3_cell_754 (cost=0.29..1,374.94 rows=22,586 width=12) (actual time=0.030..16.470 rows=22,586 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-27'::integer))
  • Heap Fetches: 22586
8. 17.980 17.980 ↑ 1.0 24,990 1

Index Only Scan using road_network_partitioned3_cell_755_pkey on road_network_partitioned3_cell_755 (cost=0.29..1,471.04 rows=24,990 width=12) (actual time=0.032..17.980 rows=24,990 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-27'::integer))
  • Heap Fetches: 24990
Planning time : 1.667 ms