explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ICjw

Settings
# exclusive inclusive rows x rows loops node
1. 95.690 138.986 ↑ 1.0 99,838 1

Gather (cost=1,000.28..30,186.97 rows=99,839 width=22) (actual time=1.156..138.986 rows=99,838 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 4.412 43.296 ↑ 1.3 24,960 4 / 4

Parallel Append (cost=0.29..19,203.07 rows=32,207 width=22) (actual time=0.092..43.296 rows=24,960 loops=4)

3. 12.446 12.446 ↑ 2.4 6,248 4 / 4

Parallel Index Scan using road_network_partitioned2_cell_755_pkey on road_network_partitioned2_cell_755 a_12 (cost=0.29..3,905.44 rows=14,700 width=21) (actual time=0.057..12.446 rows=6,248 loops=4)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
4. 7.269 7.269 ↑ 1.2 11,293 2 / 4

Parallel Index Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 a_8 (cost=0.29..3,575.45 rows=13,286 width=22) (actual time=0.065..14.537 rows=11,293 loops=2)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
5. 4.202 4.202 ↑ 1.2 7,074 2 / 4

Parallel Index Scan using road_network_partitioned2_cell_712_pkey on road_network_partitioned2_cell_712 a_9 (cost=0.29..2,311.07 rows=8,323 width=22) (actual time=0.066..8.405 rows=7,074 loops=2)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
6. 1.410 1.410 ↓ 1.7 9,306 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_753_pkey on road_network_partitioned2_cell_753 a_4 (cost=0.29..1,465.63 rows=5,474 width=22) (actual time=0.029..5.641 rows=9,306 loops=1)

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

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

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

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

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
9. 2.357 2.357 ↓ 1.7 4,367 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_713_pkey on road_network_partitioned2_cell_713 a_13 (cost=0.28..687.94 rows=2,569 width=21) (actual time=0.031..9.426 rows=4,367 loops=1)

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

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

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
11. 0.354 0.354 ↓ 1.7 2,540 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_627_pkey on road_network_partitioned2_cell_627 a_7 (cost=0.28..433.63 rows=1,494 width=20) (actual time=0.029..1.416 rows=2,540 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
12. 1.926 1.926 ↓ 1.7 2,437 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_628_pkey on road_network_partitioned2_cell_628 a_11 (cost=0.28..384.48 rows=1,434 width=21) (actual time=0.044..7.705 rows=2,437 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
13. 0.710 0.710 ↓ 1.7 2,274 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_626_pkey on road_network_partitioned2_cell_626 a_3 (cost=0.28..374.66 rows=1,338 width=21) (actual time=0.033..2.840 rows=2,274 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
14. 0.371 0.371 ↓ 1.7 2,056 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_710_pkey on road_network_partitioned2_cell_710 a_1 (cost=0.28..333.83 rows=1,209 width=21) (actual time=0.032..1.484 rows=2,056 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
15. 3.249 3.249 ↓ 1.7 1,161 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_752_pkey on road_network_partitioned2_cell_752 a (cost=0.28..191.53 rows=683 width=22) (actual time=0.036..12.997 rows=1,161 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
16. 0.068 0.068 ↓ 1.7 462 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_668_pkey on road_network_partitioned2_cell_668 a_2 (cost=0.27..92.27 rows=272 width=22) (actual time=0.018..0.271 rows=462 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
17. 0.017 0.017 ↓ 1.7 86 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_671_pkey on road_network_partitioned2_cell_671 a_14 (cost=0.14..16.12 rows=51 width=23) (actual time=0.017..0.066 rows=86 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
18. 0.002 0.002 ↓ 0.0 0 1 / 4

Parallel Index Scan using road_network_partitioned2_cell_629_pkey on road_network_partitioned2_cell_629 a_15 (cost=0.14..2.27 rows=1 width=226) (actual time=0.008..0.008 rows=0 loops=1)

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