explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UVoS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,889.038 ↑ 1.0 1,713,165 1

Gather Merge (cost=235,873.64..442,424.99 rows=1,725,076 width=154) (actual time=3,391.269..5,889.038 rows=1,713,165 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 4,474.850 17,943.360 ↑ 1.3 342,633 5

Sort (cost=234,873.58..235,951.75 rows=431,269 width=154) (actual time=3,340.371..3,588.672 rows=342,633 loops=5)

  • Sort Key: capacity.dump_date DESC, eicfrom.eid, eicto.eid
  • Sort Method: quicksort Memory: 58526kB
3. 2,737.480 13,468.510 ↑ 1.3 342,633 5

Hash Join (cost=432.59..175,136.62 rows=431,269 width=154) (actual time=58.242..2,693.702 rows=342,633 loops=5)

  • Hash Cond: (capacity.data_source_id = datasource.id)
4. 2,791.420 10,730.290 ↑ 1.3 342,633 5

Hash Join (cost=429.92..169,708.32 rows=431,269 width=126) (actual time=57.954..2,146.058 rows=342,633 loops=5)

  • Hash Cond: (capacity.border_id = border.id)
5. 2,700.690 7,649.900 ↑ 1.3 342,633 5

Hash Join (cost=1.23..163,349.67 rows=431,269 width=96) (actual time=0.107..1,529.980 rows=342,633 loops=5)

  • Hash Cond: (capacity.capacity_type_id = captype.id)
6. 2,310.950 4,948.990 ↑ 2.2 342,633 5

Append (cost=0.00..153,994.33 rows=743,534 width=64) (actual time=0.043..989.798 rows=342,633 loops=5)

7. 0.005 0.005 ↓ 0.0 0 5

Parallel Seq Scan on capacity (cost=0.00..0.00 rows=1 width=64) (actual time=0.001..0.001 rows=0 loops=5)

8. 13.570 13.570 ↑ 2.9 2,474 5

Parallel Seq Scan on _hyper_1_9_chunk capacity_1 (cost=0.00..251.75 rows=7,275 width=64) (actual time=0.040..2.714 rows=2,474 loops=5)

9. 64.920 64.920 ↑ 2.9 10,467 5

Parallel Seq Scan on _hyper_1_10_chunk capacity_2 (cost=0.00..1,307.86 rows=30,786 width=64) (actual time=0.055..12.984 rows=10,467 loops=5)

10. 91.685 91.685 ↑ 2.9 15,376 5

Parallel Seq Scan on _hyper_1_11_chunk capacity_3 (cost=0.00..1,913.24 rows=45,224 width=64) (actual time=0.034..18.337 rows=15,376 loops=5)

11. 2.060 2.060 ↑ 2.9 378 5

Parallel Seq Scan on _hyper_1_12_chunk capacity_4 (cost=0.00..43.11 rows=1,111 width=64) (actual time=0.034..0.412 rows=378 loops=5)

12. 2.050 2.050 ↑ 2.9 364 5

Parallel Seq Scan on _hyper_1_13_chunk capacity_5 (cost=0.00..42.71 rows=1,071 width=64) (actual time=0.023..0.410 rows=364 loops=5)

13. 0.615 0.615 ↑ 3.0 86 5

Parallel Seq Scan on _hyper_1_14_chunk capacity_6 (cost=0.00..15.54 rows=254 width=64) (actual time=0.020..0.123 rows=86 loops=5)

14. 1.140 1.140 ↑ 2.9 203 5

Parallel Seq Scan on _hyper_1_15_chunk capacity_7 (cost=0.00..18.98 rows=598 width=64) (actual time=0.027..0.228 rows=203 loops=5)

15. 1.005 1.005 ↑ 2.9 182 5

Parallel Seq Scan on _hyper_1_16_chunk capacity_8 (cost=0.00..17.36 rows=536 width=64) (actual time=0.025..0.201 rows=182 loops=5)

16. 0.560 0.560 ↑ 2.9 48 5

Parallel Seq Scan on _hyper_1_17_chunk capacity_9 (cost=0.00..13.41 rows=141 width=64) (actual time=0.024..0.112 rows=48 loops=5)

17. 0.425 0.425 ↑ 3.0 30 5

Parallel Seq Scan on _hyper_1_18_chunk capacity_10 (cost=0.00..8.89 rows=89 width=64) (actual time=0.036..0.085 rows=30 loops=5)

18. 197.970 197.970 ↑ 2.9 36,049 5

Parallel Seq Scan on _hyper_1_21_chunk capacity_11 (cost=0.00..3,935.26 rows=106,026 width=64) (actual time=0.028..39.594 rows=36,049 loops=5)

19. 204.435 204.435 ↑ 2.9 39,493 5

Parallel Seq Scan on _hyper_1_23_chunk capacity_12 (cost=0.00..3,599.55 rows=116,155 width=64) (actual time=0.033..40.887 rows=39,493 loops=5)

20. 237.440 237.440 ↑ 2.1 44,909 5

Parallel Seq Scan on _hyper_1_24_chunk capacity_13 (cost=0.00..4,412.68 rows=93,468 width=64) (actual time=0.046..47.488 rows=44,909 loops=5)

21. 255.415 255.415 ↑ 2.1 49,705 5

Parallel Seq Scan on _hyper_1_25_chunk capacity_14 (cost=0.00..4,135.45 rows=103,545 width=64) (actual time=0.037..51.083 rows=49,705 loops=5)

22. 864.440 864.440 ↑ 1.2 47,466 5

Parallel Seq Scan on _hyper_1_26_chunk capacity_15 (cost=0.00..63,948.28 rows=59,228 width=64) (actual time=0.036..172.888 rows=47,466 loops=5)

23. 317.315 317.315 ↑ 1.7 47,070 5

Parallel Seq Scan on _hyper_1_27_chunk capacity_16 (cost=0.00..24,405.61 rows=80,461 width=64) (actual time=0.012..63.463 rows=47,070 loops=5)

24. 150.200 150.200 ↑ 1.6 17,582 5

Parallel Seq Scan on _hyper_1_28_chunk capacity_17 (cost=0.00..17,806.73 rows=27,873 width=64) (actual time=0.015..30.040 rows=17,582 loops=5)

25. 84.880 84.880 ↑ 2.1 12,299 5

Parallel Seq Scan on _hyper_1_66_chunk capacity_18 (cost=0.00..9,104.24 rows=25,624 width=64) (actual time=0.012..16.976 rows=12,299 loops=5)

26. 66.155 66.155 ↑ 2.1 8,090 5

Parallel Seq Scan on _hyper_1_70_chunk capacity_19 (cost=0.00..8,724.53 rows=16,853 width=64) (actual time=0.012..13.231 rows=8,090 loops=5)

27. 0.095 0.095 ↑ 2.9 16 5

Parallel Seq Scan on _hyper_1_85_chunk capacity_20 (cost=0.00..3.47 rows=47 width=64) (actual time=0.005..0.019 rows=16 loops=5)

28. 0.155 0.155 ↑ 2.9 26 5

Parallel Seq Scan on _hyper_1_86_chunk capacity_21 (cost=0.00..4.75 rows=75 width=64) (actual time=0.008..0.031 rows=26 loops=5)

29. 16.550 16.550 ↑ 2.9 3,368 5

Parallel Seq Scan on _hyper_1_87_chunk capacity_22 (cost=0.00..370.06 rows=9,906 width=64) (actual time=0.008..3.310 rows=3,368 loops=5)

30. 0.165 0.165 ↑ 2.9 32 5

Parallel Seq Scan on _hyper_1_88_chunk capacity_23 (cost=0.00..4.94 rows=94 width=64) (actual time=0.006..0.033 rows=32 loops=5)

31. 21.690 21.690 ↑ 2.9 3,123 5

Parallel Seq Scan on _hyper_1_89_chunk capacity_24 (cost=0.00..2,107.86 rows=9,186 width=64) (actual time=0.009..4.338 rows=3,123 loops=5)

32. 43.100 43.100 ↑ 2.1 3,795 5

Parallel Seq Scan on _hyper_1_90_chunk capacity_25 (cost=0.00..7,798.07 rows=7,907 width=64) (actual time=0.009..8.620 rows=3,795 loops=5)

33. 0.070 0.220 ↑ 1.0 10 5

Hash (cost=1.10..1.10 rows=10 width=36) (actual time=0.044..0.044 rows=10 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.150 0.150 ↑ 1.0 10 5

Seq Scan on border_capacity_type captype (cost=0.00..1.10 rows=10 width=36) (actual time=0.022..0.030 rows=10 loops=5)

35. 1.470 288.970 ↑ 1.0 300 5

Hash (cost=424.95..424.95 rows=300 width=36) (actual time=57.794..57.794 rows=300 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
36. 39.800 287.500 ↑ 1.0 300 5

Merge Join (cost=222.91..424.95 rows=300 width=36) (actual time=36.079..57.500 rows=300 loops=5)

  • Merge Cond: ((eicto.eid)::integer = border.area_to)
37. 66.540 66.540 ↑ 1.0 10,345 5

Index Scan using common_eic_eid_index on eic eicto (cost=0.29..350.35 rows=10,671 width=17) (actual time=0.048..13.308 rows=10,345 loops=5)

38. 2.700 181.160 ↑ 1.0 300 5

Sort (cost=222.59..223.34 rows=300 width=23) (actual time=36.018..36.232 rows=300 loops=5)

  • Sort Key: border.area_to
  • Sort Method: quicksort Memory: 40kB
39. 55.890 178.460 ↑ 1.0 300 5

Merge Join (cost=0.47..210.25 rows=300 width=23) (actual time=0.047..35.692 rows=300 loops=5)

  • Merge Cond: (border.area_from = (eicfrom.eid)::integer)
40. 1.595 1.595 ↑ 1.0 300 5

Index Scan using border_area_from_area_to_key on border (cost=0.15..8.65 rows=300 width=10) (actual time=0.025..0.319 rows=300 loops=5)

41. 120.975 120.975 ↑ 1.0 10,344 5

Index Scan using common_eic_eid_index on eic eicfrom (cost=0.29..350.35 rows=10,671 width=17) (actual time=0.012..24.195 rows=10,344 loops=5)

42. 0.330 0.740 ↑ 1.0 74 5

Hash (cost=1.74..1.74 rows=74 width=36) (actual time=0.148..0.148 rows=74 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
43. 0.410 0.410 ↑ 1.0 74 5

Seq Scan on data_source datasource (cost=0.00..1.74 rows=74 width=36) (actual time=0.030..0.082 rows=74 loops=5)