explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K67D

Settings
# exclusive inclusive rows x rows loops node
1. 586.356 596.765 ↑ 1.0 27,573 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.670 10.409 ↑ 1.2 9,191 3 / 3

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

3. 3.769 3.769 ↓ 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.026..11.306 rows=14,149 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))
4. 1.425 1.425 ↓ 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.035..4.274 rows=5,927 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))
5. 3.147 3.147 ↓ 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.034..9.441 rows=4,419 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat > '-27'::integer) AND (lat < '-24'::integer))
6. 1.399 1.399 ↓ 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.044..4.196 rows=3,078 loops=1)

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