explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mPN1

Settings
# exclusive inclusive rows x rows loops node
1. 4.469 94.223 ↑ 1.0 67,458 1

Append (cost=0.56..53,958.66 rows=67,458 width=21) (actual time=0.046..94.223 rows=67,458 loops=1)

2. 2.322 8.853 ↑ 1.0 6,677 1

Merge Join (cost=0.56..4,813.13 rows=6,677 width=21) (actual time=0.046..8.853 rows=6,677 loops=1)

  • Merge Cond: ((a.lon = b.lon) AND (a.lat = b.lat) AND (a.link_id = b.link_id))
3. 2.646 2.646 ↑ 1.0 6,677 1

Index Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 a (cost=0.28..1,688.79 rows=6,677 width=27) (actual time=0.024..2.646 rows=6,677 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
4. 3.885 3.885 ↑ 1.0 6,677 1

Index Only Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 b (cost=0.28..1,688.79 rows=6,677 width=12) (actual time=0.019..3.885 rows=6,677 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
  • Heap Fetches: 6677
5. 7.906 30.237 ↑ 1.0 22,586 1

Merge Join (cost=0.57..15,726.94 rows=22,586 width=21) (actual time=0.061..30.237 rows=22,586 loops=1)

  • Merge Cond: ((a_1.lon = b_1.lon) AND (a_1.lat = b_1.lat) AND (a_1.link_id = b_1.link_id))
6. 8.760 8.760 ↑ 1.0 22,586 1

Index Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 a_1 (cost=0.29..5,435.48 rows=22,586 width=26) (actual time=0.035..8.760 rows=22,586 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
7. 13.571 13.571 ↑ 1.0 22,586 1

Index Only Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 b_1 (cost=0.29..5,435.48 rows=22,586 width=12) (actual time=0.024..13.571 rows=22,586 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
  • Heap Fetches: 22586
8. 4.485 17.222 ↑ 1.0 13,205 1

Merge Join (cost=0.57..9,373.07 rows=13,205 width=21) (actual time=0.046..17.222 rows=13,205 loops=1)

  • Merge Cond: ((a_2.lon = b_2.lon) AND (a_2.lat = b_2.lat) AND (a_2.link_id = b_2.link_id))
9. 5.136 5.136 ↑ 1.0 13,205 1

Index Scan using road_network_partitioned2_cell_797_pkey on road_network_partitioned2_cell_797 a_2 (cost=0.29..3,267.00 rows=13,205 width=25) (actual time=0.026..5.136 rows=13,205 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
10. 7.601 7.601 ↑ 1.0 13,205 1

Index Only Scan using road_network_partitioned2_cell_797_pkey on road_network_partitioned2_cell_797 b_2 (cost=0.29..3,267.00 rows=13,205 width=12) (actual time=0.018..7.601 rows=13,205 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
  • Heap Fetches: 13205
11. 8.546 33.442 ↑ 1.0 24,990 1

Merge Join (cost=0.57..17,299.72 rows=24,990 width=21) (actual time=0.048..33.442 rows=24,990 loops=1)

  • Merge Cond: ((a_3.lon = b_3.lon) AND (a_3.lat = b_3.lat) AND (a_3.link_id = b_3.link_id))
12. 9.858 9.858 ↑ 1.0 24,990 1

Index Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 a_3 (cost=0.29..5,963.44 rows=24,990 width=25) (actual time=0.026..9.858 rows=24,990 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
13. 15.038 15.038 ↑ 1.0 24,990 1

Index Only Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 b_3 (cost=0.29..5,963.44 rows=24,990 width=12) (actual time=0.020..15.038 rows=24,990 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
  • Heap Fetches: 24990