explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JwCt

Settings
# exclusive inclusive rows x rows loops node
1. 4.601 95.458 ↑ 1.0 67,458 1

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

2. 2.401 8.863 ↑ 1.0 6,677 1

Merge Join (cost=0.56..4,746.36 rows=6,677 width=32) (actual time=0.038..8.863 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.395 2.395 ↑ 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.012..2.395 rows=6,677 loops=1)

4. 4.067 4.067 ↑ 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.024..4.067 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.960 30.356 ↑ 1.0 22,586 1

Merge Join (cost=0.57..15,501.08 rows=22,586 width=32) (actual time=0.036..30.356 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.177 8.177 ↑ 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.010..8.177 rows=22,586 loops=1)

7. 14.219 14.219 ↑ 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..14.219 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.658 17.497 ↑ 1.0 13,205 1

Merge Join (cost=0.57..9,241.02 rows=13,205 width=32) (actual time=0.037..17.497 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.756 4.756 ↑ 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.014..4.756 rows=13,205 loops=1)

10. 8.083 8.083 ↑ 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.021..8.083 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.778 34.141 ↑ 1.0 24,990 1

Merge Join (cost=0.57..17,049.82 rows=24,990 width=32) (actual time=0.034..34.141 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.260 9.260 ↑ 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.011..9.260 rows=24,990 loops=1)

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

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