explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S4u3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 11,125.960 ↓ 7.2 1,443 1

Finalize GroupAggregate (cost=841,613.59..841,664.76 rows=200 width=12) (actual time=11,125.350..11,125.960 rows=1,443 loops=1)

  • Group Key: (time_bucket(86400, ts_trackingmessagesraw.tmr_date))
2. 0.000 11,148.466 ↓ 3.7 1,479 1

Gather Merge (cost=841,613.59..841,660.26 rows=400 width=12) (actual time=11,125.344..11,148.466 rows=1,479 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.591 33,319.011 ↓ 2.5 493 3

Sort (cost=840,613.57..840,614.07 rows=200 width=12) (actual time=11,106.307..11,106.337 rows=493 loops=3)

  • Sort Key: (time_bucket(86400, ts_trackingmessagesraw.tmr_date))
  • Sort Method: quicksort Memory: 101kB
  • Worker 0: Sort Method: quicksort Memory: 33kB
  • Worker 1: Sort Method: quicksort Memory: 33kB
4. 9,846.822 33,318.420 ↓ 2.5 493 3

Partial HashAggregate (cost=840,603.42..840,605.92 rows=200 width=12) (actual time=11,106.057..11,106.140 rows=493 loops=3)

  • Group Key: time_bucket(86400, ts_trackingmessagesraw.tmr_date)
5. 6,858.345 23,471.598 ↑ 1.3 14,679,788 3

Result (cost=0.00..748,850.91 rows=18,350,502 width=4) (actual time=0.244..7,823.866 rows=14,679,788 loops=3)

6. 4,764.074 16,613.253 ↑ 1.3 14,679,788 3

Parallel Append (cost=0.00..519,469.64 rows=18,350,502 width=4) (actual time=0.242..5,537.751 rows=14,679,788 loops=3)

7. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on ts_trackingmessagesraw (cost=0.00..0.00 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

8. 659.207 659.207 ↓ 2.4 2,954,876 1

Parallel Seq Scan on _hyper_2_7_chunk (cost=0.00..28,284.98 rows=1,231,198 width=4) (actual time=0.021..659.207 rows=2,954,876 loops=1)

9. 840.111 840.111 ↓ 2.4 2,814,928 1

Parallel Seq Scan on _hyper_2_8_chunk (cost=0.00..26,944.87 rows=1,172,887 width=4) (actual time=0.047..840.111 rows=2,814,928 loops=1)

10. 1,195.468 1,195.468 ↓ 2.4 2,777,193 1

Parallel Seq Scan on _hyper_2_5_chunk (cost=0.00..26,583.64 rows=1,157,164 width=4) (actual time=57.401..1,195.468 rows=2,777,193 loops=1)

11. 1,149.895 1,149.895 ↓ 2.4 2,735,626 1

Parallel Seq Scan on _hyper_2_4_chunk (cost=0.00..26,186.44 rows=1,139,844 width=4) (actual time=0.579..1,149.895 rows=2,735,626 loops=1)

12. 563.864 563.864 ↓ 2.4 2,727,264 1

Parallel Seq Scan on _hyper_2_11_chunk (cost=0.00..26,105.60 rows=1,136,360 width=4) (actual time=0.047..563.864 rows=2,727,264 loops=1)

13. 732.668 732.668 ↓ 2.4 2,725,122 1

Parallel Seq Scan on _hyper_2_10_chunk (cost=0.00..26,085.68 rows=1,135,468 width=4) (actual time=0.041..732.668 rows=2,725,122 loops=1)

14. 543.479 543.479 ↓ 2.4 2,659,292 1

Parallel Seq Scan on _hyper_2_6_chunk (cost=0.00..25,455.38 rows=1,108,038 width=4) (actual time=0.048..543.479 rows=2,659,292 loops=1)

15. 592.944 592.944 ↓ 2.4 2,630,325 1

Parallel Seq Scan on _hyper_2_12_chunk (cost=0.00..25,177.69 rows=1,095,969 width=4) (actual time=0.050..592.944 rows=2,630,325 loops=1)

16. 561.989 561.989 ↓ 2.4 2,484,047 1

Parallel Seq Scan on _hyper_2_55_chunk (cost=0.00..23,778.20 rows=1,035,020 width=4) (actual time=0.032..561.989 rows=2,484,047 loops=1)

17. 531.531 531.531 ↓ 2.4 2,377,803 1

Parallel Seq Scan on _hyper_2_9_chunk (cost=0.00..22,760.51 rows=990,751 width=4) (actual time=0.037..531.531 rows=2,377,803 loops=1)

18. 477.789 477.789 ↑ 1.3 787,078 3

Parallel Seq Scan on _hyper_2_56_chunk (cost=0.00..22,602.48 rows=983,848 width=4) (actual time=0.031..159.263 rows=787,078 loops=3)

19. 548.030 548.030 ↓ 1.2 1,046,806 2

Parallel Seq Scan on _hyper_2_54_chunk (cost=0.00..20,040.38 rows=872,338 width=4) (actual time=0.024..274.015 rows=1,046,806 loops=2)

20. 330.265 330.265 ↓ 2.4 1,668,063 1

Parallel Seq Scan on _hyper_2_53_chunk (cost=0.00..15,967.26 rows=695,026 width=4) (actual time=0.015..330.265 rows=1,668,063 loops=1)

21. 260.680 260.680 ↓ 2.4 1,430,436 1

Parallel Seq Scan on _hyper_2_52_chunk (cost=0.00..13,693.15 rows=596,015 width=4) (actual time=0.010..260.680 rows=1,430,436 loops=1)

22. 267.082 267.082 ↓ 2.4 1,293,563 1

Parallel Seq Scan on _hyper_2_51_chunk (cost=0.00..12,382.85 rows=538,985 width=4) (actual time=0.010..267.082 rows=1,293,563 loops=1)

23. 163.879 163.879 ↓ 2.4 884,813 1

Parallel Seq Scan on _hyper_2_48_chunk (cost=0.00..8,469.72 rows=368,672 width=4) (actual time=0.009..163.879 rows=884,813 loops=1)

24. 164.345 164.345 ↓ 2.4 842,790 1

Parallel Seq Scan on _hyper_2_47_chunk (cost=0.00..8,067.62 rows=351,162 width=4) (actual time=0.012..164.345 rows=842,790 loops=1)

25. 147.352 147.352 ↓ 2.4 824,350 1

Parallel Seq Scan on _hyper_2_49_chunk (cost=0.00..7,890.79 rows=343,479 width=4) (actual time=0.019..147.352 rows=824,350 loops=1)

26. 291.261 291.261 ↓ 2.4 808,507 1

Parallel Seq Scan on _hyper_2_50_chunk (cost=0.00..7,739.78 rows=336,878 width=4) (actual time=76.807..291.261 rows=808,507 loops=1)

27. 200.750 200.750 ↓ 2.4 760,589 1

Parallel Seq Scan on _hyper_2_46_chunk (cost=0.00..7,281.12 rows=316,912 width=4) (actual time=0.011..200.750 rows=760,589 loops=1)

28. 144.635 144.635 ↓ 1.7 530,699 1

Parallel Seq Scan on _hyper_2_45_chunk (cost=0.00..5,990.76 rows=312,176 width=4) (actual time=0.015..144.635 rows=530,699 loops=1)

29. 213.146 213.146 ↓ 2.4 615,517 1

Parallel Seq Scan on _hyper_2_41_chunk (cost=0.00..5,892.65 rows=256,465 width=4) (actual time=0.010..213.146 rows=615,517 loops=1)

30. 270.010 270.010 ↓ 1.7 478,822 1

Parallel Seq Scan on _hyper_2_43_chunk (cost=0.00..5,405.60 rows=281,660 width=4) (actual time=0.017..270.010 rows=478,822 loops=1)

31. 243.992 243.992 ↓ 1.7 478,522 1

Parallel Seq Scan on _hyper_2_22_chunk (cost=0.00..5,401.84 rows=281,484 width=4) (actual time=0.020..243.992 rows=478,522 loops=1)

32. 151.736 151.736 ↓ 1.7 416,952 1

Parallel Seq Scan on _hyper_2_42_chunk (cost=0.00..4,706.66 rows=245,266 width=4) (actual time=0.011..151.736 rows=416,952 loops=1)

33. 192.543 192.543 ↓ 1.7 370,093 1

Parallel Seq Scan on _hyper_2_44_chunk (cost=0.00..4,178.02 rows=217,702 width=4) (actual time=0.017..192.543 rows=370,093 loops=1)

34. 100.864 100.864 ↓ 1.7 366,140 1

Parallel Seq Scan on _hyper_2_25_chunk (cost=0.00..4,133.76 rows=215,376 width=4) (actual time=0.017..100.864 rows=366,140 loops=1)

35. 66.931 66.931 ↓ 1.7 341,994 1

Parallel Seq Scan on _hyper_2_24_chunk (cost=0.00..3,860.73 rows=201,173 width=4) (actual time=0.012..66.931 rows=341,994 loops=1)

36. 68.035 68.035 ↓ 1.7 240,850 1

Parallel Seq Scan on _hyper_2_18_chunk (cost=0.00..2,718.76 rows=141,676 width=4) (actual time=0.024..68.035 rows=240,850 loops=1)

37. 26.142 26.142 ↓ 1.7 71,083 1

Parallel Seq Scan on _hyper_2_19_chunk (cost=0.00..803.14 rows=41,814 width=4) (actual time=0.023..26.142 rows=71,083 loops=1)

38. 5.805 5.805 ↓ 1.7 38,615 1

Parallel Seq Scan on _hyper_2_26_chunk (cost=0.00..436.15 rows=22,715 width=4) (actual time=0.017..5.805 rows=38,615 loops=1)

39. 5.253 5.253 ↓ 1.7 32,357 1

Parallel Seq Scan on _hyper_2_27_chunk (cost=0.00..365.34 rows=19,034 width=4) (actual time=0.014..5.253 rows=32,357 loops=1)

40. 21.695 21.695 ↓ 1.7 30,419 1

Parallel Seq Scan on _hyper_2_29_chunk (cost=0.00..343.94 rows=17,894 width=4) (actual time=0.016..21.695 rows=30,419 loops=1)

41. 11.391 11.391 ↓ 1.7 25,373 1

Parallel Seq Scan on _hyper_2_28_chunk (cost=0.00..287.25 rows=14,925 width=4) (actual time=0.010..11.391 rows=25,373 loops=1)

42. 17.978 17.978 ↓ 1.7 24,126 1

Parallel Seq Scan on _hyper_2_20_chunk (cost=0.00..272.92 rows=14,192 width=4) (actual time=0.632..17.978 rows=24,126 loops=1)

43. 10.487 10.487 ↓ 1.7 23,110 1

Parallel Seq Scan on _hyper_2_30_chunk (cost=0.00..260.94 rows=13,594 width=4) (actual time=1.203..10.487 rows=23,110 loops=1)

44. 4.752 4.752 ↓ 1.7 20,071 1

Parallel Seq Scan on _hyper_2_13_chunk (cost=0.00..227.06 rows=11,806 width=4) (actual time=0.524..4.752 rows=20,071 loops=1)

45. 13.245 13.245 ↓ 1.7 16,566 1

Parallel Seq Scan on _hyper_2_31_chunk (cost=0.00..187.45 rows=9,745 width=4) (actual time=4.246..13.245 rows=16,566 loops=1)

46. 14.586 14.586 ↓ 1.7 14,086 1

Parallel Seq Scan on _hyper_2_23_chunk (cost=0.00..159.86 rows=8,286 width=4) (actual time=11.690..14.586 rows=14,086 loops=1)

47. 2.300 2.300 ↓ 1.7 8,196 1

Parallel Seq Scan on _hyper_2_32_chunk (cost=0.00..93.21 rows=4,821 width=4) (actual time=0.400..2.300 rows=8,196 loops=1)

48. 1.702 1.702 ↓ 1.7 6,214 1

Parallel Seq Scan on _hyper_2_17_chunk (cost=0.00..70.55 rows=3,655 width=4) (actual time=0.466..1.702 rows=6,214 loops=1)

49. 8.595 8.595 ↓ 1.7 6,205 1

Parallel Seq Scan on _hyper_2_35_chunk (cost=0.00..70.50 rows=3,650 width=4) (actual time=7.101..8.595 rows=6,205 loops=1)

50. 2.198 2.198 ↓ 1.7 6,096 1

Parallel Seq Scan on _hyper_2_33_chunk (cost=0.00..68.86 rows=3,586 width=4) (actual time=0.545..2.198 rows=6,096 loops=1)

51. 2.417 2.417 ↓ 1.7 5,531 1

Parallel Seq Scan on _hyper_2_36_chunk (cost=0.00..62.54 rows=3,254 width=4) (actual time=0.688..2.417 rows=5,531 loops=1)

52. 14.177 14.177 ↓ 1.7 4,038 1

Parallel Seq Scan on _hyper_2_37_chunk (cost=0.00..45.75 rows=2,375 width=4) (actual time=0.582..14.177 rows=4,038 loops=1)

53. 2.009 2.009 ↓ 1.7 3,701 1

Parallel Seq Scan on _hyper_2_34_chunk (cost=0.00..42.77 rows=2,177 width=4) (actual time=0.536..2.009 rows=3,701 loops=1)

54. 2.290 2.290 ↓ 1.7 3,128 1

Parallel Seq Scan on _hyper_2_21_chunk (cost=0.00..35.40 rows=1,840 width=4) (actual time=1.185..2.290 rows=3,128 loops=1)

55. 1.352 1.352 ↓ 1.7 2,409 1

Parallel Seq Scan on _hyper_2_16_chunk (cost=0.00..28.17 rows=1,417 width=4) (actual time=0.503..1.352 rows=2,409 loops=1)

56. 1.287 1.287 ↓ 1.7 1,981 1

Parallel Seq Scan on _hyper_2_38_chunk (cost=0.00..22.65 rows=1,165 width=4) (actual time=0.458..1.287 rows=1,981 loops=1)

57. 2.136 2.136 ↑ 68.0 16 1

Parallel Seq Scan on _hyper_2_14_chunk (cost=0.00..20.88 rows=1,088 width=4) (actual time=2.131..2.136 rows=16 loops=1)

58. 1.377 1.377 ↓ 1.7 1,517 1

Parallel Seq Scan on _hyper_2_40_chunk (cost=0.00..17.92 rows=892 width=4) (actual time=0.524..1.377 rows=1,517 loops=1)

59. 0.856 0.856 ↓ 1.7 401 1

Parallel Seq Scan on _hyper_2_39_chunk (cost=0.00..5.36 rows=236 width=4) (actual time=0.509..0.856 rows=401 loops=1)

60. 0.656 0.656 ↓ 1.7 103 1

Parallel Seq Scan on _hyper_2_15_chunk (cost=0.00..1.61 rows=61 width=4) (actual time=0.640..0.656 rows=103 loops=1)