explain.depesz.com

PostgreSQL's explain analyze made readable

Result: umgp

Settings
# exclusive inclusive rows x rows loops node
1. 91.253 129.587 ↑ 1.0 99,838 1

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

  • Workers Planned: 3
  • Workers Launched: 3
2. 1.746 38.334 ↑ 1.3 24,960 4 / 4

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

3. 11.491 11.491 ↑ 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.056..11.491 rows=6,248 loops=4)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
4. 6.105 6.105 ↑ 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.063..12.210 rows=11,293 loops=2)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
5. 6.652 6.652 ↑ 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=1.306..13.303 rows=7,074 loops=2)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
6. 2.673 2.673 ↓ 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.030..10.693 rows=9,306 loops=1)

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

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

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
9. 2.636 2.636 ↓ 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.027..10.545 rows=4,367 loops=1)

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

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
11. 1.814 1.814 ↓ 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.025..7.255 rows=2,540 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
12. 0.356 0.356 ↓ 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.022..1.423 rows=2,437 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
13. 0.333 0.333 ↓ 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.025..1.333 rows=2,274 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
14. 0.294 0.294 ↓ 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.020..1.177 rows=2,056 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
15. 0.166 0.166 ↓ 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.022..0.664 rows=1,161 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
16. 0.067 0.067 ↓ 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.017..0.269 rows=462 loops=1)

  • Index Cond: ((lon >= 150) AND (lon <= 153) AND (lat >= '-27'::integer) AND (lat <= '-24'::integer))
17. 0.013 0.013 ↓ 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.051 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.009..0.009 rows=0 loops=1)

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