explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EqAl

Settings
# exclusive inclusive rows x rows loops node
1. 608.339 646.840 ↑ 1.7 27,573 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.740 38.501 ↑ 2.1 9,191 3 / 3

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

3. 7.080 7.080 ↓ 0.0 0 1 / 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=21.240..21.240 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 22586
4. 5.772 5.772 ↓ 0.0 0 1 / 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=17.316..17.316 rows=0 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
  • Rows Removed by Filter: 22540
5. 4.499 4.499 ↓ 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.036..13.498 rows=14,149 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
6. 2.740 2.740 ↓ 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=8.220..8.220 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. 1.998 1.998 ↓ 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=5.994..5.994 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.759 1.759 ↓ 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.277..5.277 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.385 1.385 ↓ 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.155..4.155 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. 2.646 2.646 ↓ 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.025..7.937 rows=5,927 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
11. 1.254 1.254 ↓ 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=3.762..3.762 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. 1.220 1.220 ↓ 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.024..3.660 rows=4,419 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
13. 0.986 0.986 ↓ 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.957..2.957 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.072 1.072 ↓ 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=3.216..3.216 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. 1.020 1.020 ↓ 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=3.060..3.060 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.801 0.801 ↓ 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.403..2.403 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. 0.955 0.955 ↓ 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..2.866 rows=3,078 loops=1)

  • Index Cond: ((lon > 150) AND (lon < 153) AND (lat < '-24'::integer))
  • Filter: ((lat)::numeric > '-27'::numeric)
18. 0.626 0.626 ↓ 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=1.878..1.879 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. 0.591 0.591 ↓ 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=1.773..1.773 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. 1.330 1.330 ↓ 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=3.990..3.990 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.004..0.004 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.003..0.003 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.004..0.004 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.004..0.004 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.003..0.003 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.003..0.003 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.004..0.004 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.004..0.004 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.004..0.004 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.004..0.004 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.015..0.015 rows=0 loops=1)

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