explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9W4E

Settings
# exclusive inclusive rows x rows loops node
1. 95.621 153.861 ↑ 1.7 27,573 1

Gather (cost=1,000.29..29,925.75 rows=45,583 width=22) (actual time=12.704..153.861 rows=27,573 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.753 58.240 ↑ 2.1 9,191 3 / 3

Parallel Append (cost=0.29..24,367.45 rows=19,003 width=22) (actual time=15.308..58.240 rows=9,191 loops=3)

3. 9.049 9.049 ↓ 0.0 0 2 / 3

Parallel Index Scan using road_network_partitioned2_cell_754_pkey on road_network_partitioned2_cell_754 a_35 (cost=0.29..3,585.42 rows=4,429 width=22) (actual time=13.574..13.574 rows=0 loops=2)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 11293
4. 12.591 12.591 ↓ 0.0 0 2 / 3

Parallel Index Scan using road_network_partitioned2_cell_1005_pkey on road_network_partitioned2_cell_1005 a_10 (cost=0.29..3,528.52 rows=4,419 width=20) (actual time=18.886..18.886 rows=0 loops=2)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 11270
5. 8.307 8.307 ↓ 5.1 14,149 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_712_pkey on road_network_partitioned2_cell_712 a_36 (cost=0.29..2,317.31 rows=2,774 width=22) (actual time=0.028..24.920 rows=14,149 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
6. 2.659 2.659 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_963_pkey on road_network_partitioned2_cell_963 a_11 (cost=0.29..1,952.40 rows=2,358 width=21) (actual time=7.977..7.977 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 12027
7. 2.077 2.077 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_753_pkey on road_network_partitioned2_cell_753 a_16 (cost=0.29..1,469.74 rows=1,825 width=22) (actual time=6.231..6.231 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 9306
8. 1.769 1.769 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_922_pkey on road_network_partitioned2_cell_922 a_31 (cost=0.28..1,345.70 rows=1,565 width=21) (actual time=5.307..5.307 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 7979
9. 1.451 1.451 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_796_pkey on road_network_partitioned2_cell_796 a_34 (cost=0.28..1,141.86 rows=1,309 width=23) (actual time=4.354..4.354 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 6677
10. 1.569 1.569 ↓ 5.1 5,927 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_670_pkey on road_network_partitioned2_cell_670 a_37 (cost=0.28..963.76 rows=1,162 width=21) (actual time=0.023..4.707 rows=5,927 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
11. 2.292 2.292 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_880_pkey on road_network_partitioned2_cell_880 a_32 (cost=0.28..954.95 rows=1,042 width=21) (actual time=6.875..6.875 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 5312
12. 3.768 3.768 ↓ 5.1 4,419 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_711_pkey on road_network_partitioned2_cell_711 a_17 (cost=0.28..718.53 rows=866 width=22) (actual time=0.023..11.303 rows=4,419 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
13. 0.966 0.966 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_795_pkey on road_network_partitioned2_cell_795 a_15 (cost=0.28..685.47 rows=808 width=22) (actual time=2.897..2.897 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 4122
14. 1.777 1.777 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_838_pkey on road_network_partitioned2_cell_838 a_33 (cost=0.28..696.65 rows=781 width=21) (actual time=5.331..5.331 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 3983
15. 3.621 3.621 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_879_pkey on road_network_partitioned2_cell_879 a_13 (cost=0.28..684.12 rows=779 width=21) (actual time=10.864..10.864 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 3971
16. 0.922 0.922 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_837_pkey on road_network_partitioned2_cell_837 a_14 (cost=0.28..599.74 rows=669 width=21) (actual time=2.765..2.765 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 3414
17. 1.157 1.157 ↓ 5.1 3,078 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_669_pkey on road_network_partitioned2_cell_669 a_18 (cost=0.28..531.69 rows=604 width=22) (actual time=0.022..3.470 rows=3,078 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
18. 0.785 0.785 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_921_pkey on road_network_partitioned2_cell_921 a_12 (cost=0.28..505.38 rows=529 width=21) (actual time=2.355..2.355 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 2701
19. 2.404 2.404 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_964_pkey on road_network_partitioned2_cell_964 a_30 (cost=0.28..487.91 rows=570 width=20) (actual time=7.211..7.211 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 2908
20. 0.302 0.302 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1047_pkey on road_network_partitioned2_cell_1047 a_9 (cost=0.28..252.63 rows=311 width=21) (actual time=0.907..0.907 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 1587
21. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1425_pkey on road_network_partitioned2_cell_1425 a (cost=0.14..2.27 rows=1 width=226) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
22. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1383_pkey on road_network_partitioned2_cell_1383 a_1 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
23. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1341_pkey on road_network_partitioned2_cell_1341 a_2 (cost=0.14..2.27 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
24. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1299_pkey on road_network_partitioned2_cell_1299 a_3 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
25. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1257_pkey on road_network_partitioned2_cell_1257 a_4 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
26. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1215_pkey on road_network_partitioned2_cell_1215 a_5 (cost=0.14..2.27 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
27. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1173_pkey on road_network_partitioned2_cell_1173 a_6 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
28. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1131_pkey on road_network_partitioned2_cell_1131 a_7 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
29. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1089_pkey on road_network_partitioned2_cell_1089 a_8 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
30. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1426_pkey on road_network_partitioned2_cell_1426 a_19 (cost=0.14..2.27 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
31. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1384_pkey on road_network_partitioned2_cell_1384 a_20 (cost=0.14..2.27 rows=1 width=226) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
32. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1342_pkey on road_network_partitioned2_cell_1342 a_21 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
33. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1300_pkey on road_network_partitioned2_cell_1300 a_22 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
34. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1258_pkey on road_network_partitioned2_cell_1258 a_23 (cost=0.14..2.27 rows=1 width=226) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
35. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1216_pkey on road_network_partitioned2_cell_1216 a_24 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
36. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1174_pkey on road_network_partitioned2_cell_1174 a_25 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
37. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1132_pkey on road_network_partitioned2_cell_1132 a_26 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
38. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1090_pkey on road_network_partitioned2_cell_1090 a_27 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
39. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1048_pkey on road_network_partitioned2_cell_1048 a_28 (cost=0.14..2.27 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
40. 0.005 0.005 ↓ 0.0 0 1 / 3

Parallel Index Scan using road_network_partitioned2_cell_1006_pkey on road_network_partitioned2_cell_1006 a_29 (cost=0.14..2.27 rows=1 width=226) (actual time=0.014..0.014 rows=0 loops=1)

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