explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZUbc

Settings
# exclusive inclusive rows x rows loops node
1. 4.401 91.260 ↑ 1.0 67,458 1

Append (cost=0.56..53,284.08 rows=67,458 width=32) (actual time=0.039..91.260 rows=67,458 loops=1)

2. 2.272 8.439 ↑ 1.0 6,677 1

Merge Join (cost=0.56..4,746.36 rows=6,677 width=32) (actual time=0.038..8.439 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.308 2.308 ↑ 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,622.02 rows=6,677 width=27) (actual time=0.013..2.308 rows=6,677 loops=1)

4. 3.859 3.859 ↑ 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.022..3.859 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.654 29.051 ↑ 1.0 22,586 1

Merge Join (cost=0.57..15,501.08 rows=22,586 width=32) (actual time=0.040..29.051 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. 7.905 7.905 ↑ 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,209.62 rows=22,586 width=26) (actual time=0.013..7.905 rows=22,586 loops=1)

7. 13.492 13.492 ↑ 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.025..13.492 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.563 16.930 ↑ 1.0 13,205 1

Merge Join (cost=0.57..9,241.02 rows=13,205 width=32) (actual time=0.032..16.930 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. 4.650 4.650 ↑ 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,134.95 rows=13,205 width=25) (actual time=0.011..4.650 rows=13,205 loops=1)

10. 7.717 7.717 ↑ 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.019..7.717 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.492 32.439 ↑ 1.0 24,990 1

Merge Join (cost=0.57..17,049.82 rows=24,990 width=32) (actual time=0.032..32.439 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. 8.864 8.864 ↑ 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,713.54 rows=24,990 width=25) (actual time=0.010..8.864 rows=24,990 loops=1)

13. 15.083 15.083 ↑ 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.083 rows=24,990 loops=1)

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