explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JR83

Settings
# exclusive inclusive rows x rows loops node
1. 4.809 52.563 ↑ 1.0 67,458 1

Append (cost=0.28..23,100.50 rows=67,458 width=21) (actual time=0.047..52.563 rows=67,458 loops=1)

2. 4.151 4.151 ↑ 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=23) (actual time=0.047..4.151 rows=6,677 loops=1)

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

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
4. 8.454 8.454 ↑ 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=21) (actual time=0.041..8.454 rows=13,205 loops=1)

  • Index Cond: ((lon >= 152) AND (lon <= 154) AND (lat >= '-28'::integer) AND (lat <= '-27'::integer))
5. 20.360 20.360 ↑ 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=21) (actual time=0.042..20.360 rows=24,990 loops=1)

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