explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lUoc

Settings
# exclusive inclusive rows x rows loops node
1. 4.521 94.569 ↑ 1.0 67,458 1

Append (cost=0.56..53,284.08 rows=67,458 width=21) (actual time=0.041..94.569 rows=67,458 loops=1)

2. 2.313 8.760 ↑ 1.0 6,677 1

Merge Join (cost=0.56..4,746.36 rows=6,677 width=21) (actual time=0.041..8.760 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.743 2.743 ↑ 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.027..2.743 rows=6,677 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
4. 3.704 3.704 ↑ 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,622.02 rows=6,677 width=12) (actual time=0.010..3.704 rows=6,677 loops=1)

  • Heap Fetches: 6677
5. 7.600 29.535 ↑ 1.0 22,586 1

Merge Join (cost=0.57..15,501.08 rows=22,586 width=21) (actual time=0.041..29.535 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.764 8.764 ↑ 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.028..8.764 rows=22,586 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
7. 13.171 13.171 ↑ 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,209.62 rows=22,586 width=12) (actual time=0.011..13.171 rows=22,586 loops=1)

  • Heap Fetches: 22586
8. 4.756 19.016 ↑ 1.0 13,205 1

Merge Join (cost=0.57..9,241.02 rows=13,205 width=21) (actual time=0.034..19.016 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.915 5.915 ↑ 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.024..5.915 rows=13,205 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
10. 8.345 8.345 ↑ 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,134.95 rows=13,205 width=12) (actual time=0.008..8.345 rows=13,205 loops=1)

  • Heap Fetches: 13205
11. 8.479 32.737 ↑ 1.0 24,990 1

Merge Join (cost=0.57..17,049.82 rows=24,990 width=21) (actual time=0.036..32.737 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. 10.145 10.145 ↑ 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.025..10.145 rows=24,990 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
13. 14.113 14.113 ↑ 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,713.54 rows=24,990 width=12) (actual time=0.008..14.113 rows=24,990 loops=1)

  • Heap Fetches: 24990