explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pEec

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

Gather Merge (cost=235,873.64..442,424.99 rows=1,725,076 width=154) (actual time=7,314.642..11,924.454 rows=1,713,165 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 5,073.130 37,485.080 ↑ 1.3 342,633 5

Sort (cost=234,873.58..235,951.75 rows=431,269 width=154) (actual time=7,191.170..7,497.016 rows=342,633 loops=5)

  • Sort Key: capacity.dump_date DESC, eicfrom.eid, eicto.eid
  • Sort Method: quicksort Memory: 59690kB
3. 2,812.415 32,411.950 ↑ 1.3 342,633 5

Hash Join (cost=432.59..175,136.62 rows=431,269 width=154) (actual time=35.764..6,482.390 rows=342,633 loops=5)

  • Hash Cond: (capacity.data_source_id = datasource.id)
4. 2,896.165 29,598.825 ↑ 1.3 342,633 5

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

  • Hash Cond: (capacity.border_id = border.id)
5. 2,809.705 26,526.855 ↑ 1.3 342,633 5

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

  • Hash Cond: (capacity.capacity_type_id = captype.id)
6. 2,368.440 23,716.915 ↑ 2.2 342,633 5

Append (cost=0.00..153,994.33 rows=743,534 width=64) (actual time=0.034..4,743.383 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.750 13.750 ↑ 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.031..2.750 rows=2,474 loops=5)

9. 66.475 66.475 ↑ 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.038..13.295 rows=10,467 loops=5)

10. 106.455 106.455 ↑ 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.039..21.291 rows=15,376 loops=5)

11. 3.315 3.315 ↑ 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.035..0.663 rows=378 loops=5)

12. 2.680 2.680 ↑ 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.021..0.536 rows=364 loops=5)

13. 0.565 0.565 ↑ 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.024..0.113 rows=86 loops=5)

14. 1.860 1.860 ↑ 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.022..0.372 rows=203 loops=5)

15. 2.095 2.095 ↑ 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.030..0.419 rows=182 loops=5)

16. 0.620 0.620 ↑ 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.066..0.124 rows=48 loops=5)

17. 0.275 0.275 ↑ 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.029..0.055 rows=30 loops=5)

18. 196.035 196.035 ↑ 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.026..39.207 rows=36,049 loops=5)

19. 203.600 203.600 ↑ 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.034..40.720 rows=39,493 loops=5)

20. 241.120 241.120 ↑ 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.039..48.224 rows=44,909 loops=5)

21. 255.585 255.585 ↑ 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.035..51.117 rows=49,705 loops=5)

22. 5,599.780 5,599.780 ↑ 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.031..1,119.956 rows=47,466 loops=5)

23. 4,883.105 4,883.105 ↑ 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.968..976.621 rows=47,070 loops=5)

24. 3,481.810 3,481.810 ↑ 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=1.832..696.362 rows=17,582 loops=5)

25. 1,973.460 1,973.460 ↑ 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=3.013..394.692 rows=12,299 loops=5)

26. 2,031.480 2,031.480 ↑ 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=1.587..406.296 rows=8,090 loops=5)

27. 3.245 3.245 ↑ 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.638..0.649 rows=16 loops=5)

28. 2.145 2.145 ↑ 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.407..0.429 rows=26 loops=5)

29. 48.825 48.825 ↑ 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=1.373..9.765 rows=3,368 loops=5)

30. 2.770 2.770 ↑ 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.516..0.554 rows=32 loops=5)

31. 410.710 410.710 ↑ 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.562..82.142 rows=3,123 loops=5)

32. 1,816.710 1,816.710 ↑ 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=1.346..363.342 rows=3,795 loops=5)

33. 0.075 0.235 ↑ 1.0 10 5

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

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

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

35. 1.495 175.805 ↑ 1.0 300 5

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

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

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

  • Merge Cond: ((eicto.eid)::integer = border.area_to)
37. 41.715 41.715 ↑ 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.049..8.343 rows=10,345 loops=5)

38. 2.860 92.170 ↑ 1.0 300 5

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

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

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

  • Merge Cond: (border.area_from = (eicfrom.eid)::integer)
40. 1.670 1.670 ↑ 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.023..0.334 rows=300 loops=5)

41. 47.000 47.000 ↑ 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.013..9.400 rows=10,344 loops=5)

42. 0.345 0.710 ↑ 1.0 74 5

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

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

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