explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8Ua

Settings
# exclusive inclusive rows x rows loops node
1. 55.943 63.857 ↑ 1.0 27,573 1

Gather (cost=1,000.28..9,425.22 rows=27,573 width=22) (actual time=0.469..63.857 rows=27,573 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.697 7.914 ↑ 1.2 9,191 3 / 3

Parallel Append (cost=0.28..5,667.92 rows=11,488 width=22) (actual time=0.010..7.914 rows=9,191 loops=3)

3. 2.933 2.933 ↓ 1.7 14,149 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_712_pkey on road_network_partitioned2_cell_712 a_2 (cost=0.29..2,311.07 rows=8,323 width=22) (actual time=0.027..8.800 rows=14,149 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))
4. 2.290 2.290 ↓ 1.7 5,927 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_670_pkey on road_network_partitioned2_cell_670 a_3 (cost=0.28..961.14 rows=3,486 width=21) (actual time=0.021..6.871 rows=5,927 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))
5. 1.382 1.382 ↓ 1.7 4,419 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_711_pkey on road_network_partitioned2_cell_711 a (cost=0.28..716.58 rows=2,599 width=22) (actual time=0.035..4.145 rows=4,419 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))
6. 0.612 0.612 ↓ 1.7 3,078 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_669_pkey on road_network_partitioned2_cell_669 a_1 (cost=0.28..530.33 rows=1,811 width=22) (actual time=0.028..1.836 rows=3,078 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))