explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RPbT

Settings
# exclusive inclusive rows x rows loops node
1. 0.563 5.326 ↓ 1.0 7,802 1

Append (cost=0.14..2,644.75 rows=7,479 width=21) (actual time=0.059..5.326 rows=7,802 loops=1)

2. 0.014 0.014 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_378_pkey on road_network_partitioned2_cell_378 a (cost=0.14..2.47 rows=1 width=226) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
3. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_379_pkey on road_network_partitioned2_cell_379 a_1 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
4. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_380_pkey on road_network_partitioned2_cell_380 a_2 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
5. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_381_pkey on road_network_partitioned2_cell_381 a_3 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
6. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_382_pkey on road_network_partitioned2_cell_382 a_4 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
7. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_383_pkey on road_network_partitioned2_cell_383 a_5 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
8. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_384_pkey on road_network_partitioned2_cell_384 a_6 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
9. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_385_pkey on road_network_partitioned2_cell_385 a_7 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
10. 0.033 0.033 ↓ 26.0 26 1

Index Scan using road_network_partitioned2_cell_386_pkey on road_network_partitioned2_cell_386 a_8 (cost=0.14..3.47 rows=1 width=226) (actual time=0.021..0.033 rows=26 loops=1)

  • Index Cond: (lat = '-19'::integer)
11. 0.027 0.027 ↓ 42.0 42 1

Index Scan using road_network_partitioned2_cell_387_pkey on road_network_partitioned2_cell_387 a_9 (cost=0.14..3.47 rows=1 width=226) (actual time=0.009..0.027 rows=42 loops=1)

  • Index Cond: (lat = '-19'::integer)
12. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_388_pkey on road_network_partitioned2_cell_388 a_10 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_389_pkey on road_network_partitioned2_cell_389 a_11 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
14. 0.006 0.006 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_390_pkey on road_network_partitioned2_cell_390 a_12 (cost=0.14..2.47 rows=1 width=226) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
15. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_391_pkey on road_network_partitioned2_cell_391 a_13 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_392_pkey on road_network_partitioned2_cell_392 a_14 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
17. 0.019 0.019 ↓ 30.0 30 1

Index Scan using road_network_partitioned2_cell_393_pkey on road_network_partitioned2_cell_393 a_15 (cost=0.14..3.47 rows=1 width=226) (actual time=0.007..0.019 rows=30 loops=1)

  • Index Cond: (lat = '-19'::integer)
18. 0.009 0.009 ↓ 13.0 13 1

Index Scan using road_network_partitioned2_cell_394_pkey on road_network_partitioned2_cell_394 a_16 (cost=0.14..3.47 rows=1 width=226) (actual time=0.006..0.009 rows=13 loops=1)

  • Index Cond: (lat = '-19'::integer)
19. 0.020 0.020 ↓ 32.0 32 1

Index Scan using road_network_partitioned2_cell_395_pkey on road_network_partitioned2_cell_395 a_17 (cost=0.14..3.47 rows=1 width=226) (actual time=0.007..0.020 rows=32 loops=1)

  • Index Cond: (lat = '-19'::integer)
20. 0.004 0.004 ↑ 1.0 1 1

Index Scan using road_network_partitioned2_cell_396_pkey on road_network_partitioned2_cell_396 a_18 (cost=0.14..3.47 rows=1 width=226) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (lat = '-19'::integer)
21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_397_pkey on road_network_partitioned2_cell_397 a_19 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
22. 0.003 0.003 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_398_pkey on road_network_partitioned2_cell_398 a_20 (cost=0.14..2.47 rows=1 width=226) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
23. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_399_pkey on road_network_partitioned2_cell_399 a_21 (cost=0.14..2.47 rows=1 width=226) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
24. 0.226 0.226 ↑ 1.0 285 1

Index Scan using road_network_partitioned2_cell_400_pkey on road_network_partitioned2_cell_400 a_22 (cost=0.15..67.87 rows=285 width=19) (actual time=0.015..0.226 rows=285 loops=1)

  • Index Cond: (lat = '-19'::integer)
25. 0.052 0.052 ↑ 1.0 93 1

Index Scan using road_network_partitioned2_cell_401_pkey on road_network_partitioned2_cell_401 a_23 (cost=0.14..24.98 rows=93 width=21) (actual time=0.013..0.052 rows=93 loops=1)

  • Index Cond: (lat = '-19'::integer)
26. 0.059 0.059 ↑ 1.0 91 1

Index Scan using road_network_partitioned2_cell_402_pkey on road_network_partitioned2_cell_402 a_24 (cost=0.14..24.57 rows=91 width=20) (actual time=0.009..0.059 rows=91 loops=1)

  • Index Cond: (lat = '-19'::integer)
27. 0.020 0.020 ↓ 34.0 34 1

Index Scan using road_network_partitioned2_cell_403_pkey on road_network_partitioned2_cell_403 a_25 (cost=0.14..3.47 rows=1 width=226) (actual time=0.009..0.020 rows=34 loops=1)

  • Index Cond: (lat = '-19'::integer)
28. 0.091 0.091 ↑ 1.0 166 1

Index Scan using road_network_partitioned2_cell_404_pkey on road_network_partitioned2_cell_404 a_26 (cost=0.14..44.77 rows=166 width=25) (actual time=0.012..0.091 rows=166 loops=1)

  • Index Cond: (lat = '-19'::integer)
29. 0.046 0.046 ↑ 1.0 68 1

Index Scan using road_network_partitioned2_cell_405_pkey on road_network_partitioned2_cell_405 a_27 (cost=0.14..22.92 rows=68 width=21) (actual time=0.008..0.046 rows=68 loops=1)

  • Index Cond: (lat = '-19'::integer)
30. 0.115 0.115 ↑ 1.0 176 1

Index Scan using road_network_partitioned2_cell_406_pkey on road_network_partitioned2_cell_406 a_28 (cost=0.14..45.79 rows=176 width=29) (actual time=0.011..0.115 rows=176 loops=1)

  • Index Cond: (lat = '-19'::integer)
31. 0.057 0.057 ↑ 1.0 100 1

Index Scan using road_network_partitioned2_cell_407_pkey on road_network_partitioned2_cell_407 a_29 (cost=0.14..29.40 rows=100 width=23) (actual time=0.011..0.057 rows=100 loops=1)

  • Index Cond: (lat = '-19'::integer)
32. 0.099 0.099 ↑ 1.0 95 1

Index Scan using road_network_partitioned2_cell_408_pkey on road_network_partitioned2_cell_408 a_30 (cost=0.14..30.38 rows=95 width=25) (actual time=0.010..0.099 rows=95 loops=1)

  • Index Cond: (lat = '-19'::integer)
33. 0.100 0.100 ↑ 1.0 114 1

Index Scan using road_network_partitioned2_cell_409_pkey on road_network_partitioned2_cell_409 a_31 (cost=0.14..34.23 rows=114 width=21) (actual time=0.013..0.100 rows=114 loops=1)

  • Index Cond: (lat = '-19'::integer)
34. 0.101 0.101 ↓ 174.0 174 1

Index Scan using road_network_partitioned2_cell_410_pkey on road_network_partitioned2_cell_410 a_32 (cost=0.14..3.49 rows=1 width=226) (actual time=0.015..0.101 rows=174 loops=1)

  • Index Cond: (lat = '-19'::integer)
35. 0.211 0.211 ↑ 1.0 357 1

Index Scan using road_network_partitioned2_cell_411_pkey on road_network_partitioned2_cell_411 a_33 (cost=0.27..98.58 rows=357 width=27) (actual time=0.015..0.211 rows=357 loops=1)

  • Index Cond: (lat = '-19'::integer)
36. 2.371 2.371 ↑ 1.0 4,118 1

Index Scan using road_network_partitioned2_cell_412_pkey on road_network_partitioned2_cell_412 a_34 (cost=0.28..970.38 rows=4,118 width=20) (actual time=0.015..2.371 rows=4,118 loops=1)

  • Index Cond: (lat = '-19'::integer)
37. 0.966 0.966 ↑ 1.0 1,698 1

Index Scan using road_network_partitioned2_cell_413_pkey on road_network_partitioned2_cell_413 a_35 (cost=0.28..400.21 rows=1,698 width=19) (actual time=0.019..0.966 rows=1,698 loops=1)

  • Index Cond: (lat = '-19'::integer)
38. 0.051 0.051 ↑ 1.0 89 1

Index Scan using road_network_partitioned2_cell_414_pkey on road_network_partitioned2_cell_414 a_36 (cost=0.14..23.17 rows=89 width=19) (actual time=0.014..0.051 rows=89 loops=1)

  • Index Cond: (lat = '-19'::integer)
39. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_415_pkey on road_network_partitioned2_cell_415 a_37 (cost=0.14..2.47 rows=1 width=226) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
40. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_416_pkey on road_network_partitioned2_cell_416 a_38 (cost=0.14..2.47 rows=1 width=226) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
41. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_417_pkey on road_network_partitioned2_cell_417 a_39 (cost=0.14..2.47 rows=1 width=226) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
42. 0.004 0.004 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_418_pkey on road_network_partitioned2_cell_418 a_40 (cost=0.14..2.47 rows=1 width=226) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)
43. 0.005 0.005 ↓ 0.0 0 1

Index Scan using road_network_partitioned2_cell_419_pkey on road_network_partitioned2_cell_419 a_41 (cost=0.14..2.47 rows=1 width=226) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (lat = '-19'::integer)