explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ndcZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 14,929.399 ↓ 7.2 1,444 1

Finalize GroupAggregate (cost=933,367.10..933,419.27 rows=200 width=16) (actual time=14,928.767..14,929.399 rows=1,444 loops=1)

  • Group Key: (date_trunc('day'::text, to_timestamp((ts_trackingmessagesraw.tmr_date)::double precision)))
2. 0.000 14,938.434 ↓ 3.8 1,510 1

Gather Merge (cost=933,367.10..933,413.77 rows=400 width=16) (actual time=14,928.750..14,938.434 rows=1,510 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.522 44,716.428 ↓ 2.5 503 3

Sort (cost=932,367.08..932,367.58 rows=200 width=16) (actual time=14,905.442..14,905.476 rows=503 loops=3)

  • Sort Key: (date_trunc('day'::text, to_timestamp((ts_trackingmessagesraw.tmr_date)::double precision)))
  • Sort Method: quicksort Memory: 102kB
  • Worker 0: Sort Method: quicksort Memory: 33kB
  • Worker 1: Sort Method: quicksort Memory: 33kB
4. 10,416.192 44,715.906 ↓ 2.5 503 3

Partial HashAggregate (cost=932,355.93..932,359.43 rows=200 width=16) (actual time=14,905.224..14,905.302 rows=503 loops=3)

  • Group Key: date_trunc('day'::text, to_timestamp((ts_trackingmessagesraw.tmr_date)::double precision))
5. 19,339.068 34,299.714 ↑ 1.3 14,679,788 3

Result (cost=0.00..840,603.42 rows=18,350,502 width=8) (actual time=0.048..11,433.238 rows=14,679,788 loops=3)

6. 4,741.822 14,960.646 ↑ 1.3 14,679,788 3

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

7. 0.014 0.014 ↓ 0.0 0 1

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

8. 739.681 739.681 ↓ 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.024..739.681 rows=2,954,876 loops=1)

9. 732.206 732.206 ↓ 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.049..732.206 rows=2,814,928 loops=1)

10. 669.638 669.638 ↓ 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=0.033..669.638 rows=2,777,193 loops=1)

11. 690.700 690.700 ↓ 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.037..690.700 rows=2,735,626 loops=1)

12. 716.482 716.482 ↓ 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.065..716.482 rows=2,727,264 loops=1)

13. 548.892 548.892 ↓ 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.032..548.892 rows=2,725,122 loops=1)

14. 589.517 589.517 ↓ 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.040..589.517 rows=2,659,292 loops=1)

15. 780.537 780.537 ↓ 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.045..780.537 rows=2,630,325 loops=1)

16. 536.656 536.656 ↓ 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.041..536.656 rows=2,484,047 loops=1)

17. 522.318 522.318 ↓ 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.041..522.318 rows=2,377,803 loops=1)

18. 550.317 550.317 ↑ 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.050..183.439 rows=787,078 loops=3)

19. 545.550 545.550 ↓ 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.034..272.775 rows=1,046,806 loops=2)

20. 337.772 337.772 ↓ 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.017..337.772 rows=1,668,063 loops=1)

21. 293.530 293.530 ↓ 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.012..293.530 rows=1,430,436 loops=1)

22. 253.715 253.715 ↓ 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.013..253.715 rows=1,293,563 loops=1)

23. 185.396 185.396 ↓ 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.011..185.396 rows=884,813 loops=1)

24. 182.822 182.822 ↓ 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.013..182.822 rows=842,790 loops=1)

25. 136.303 136.303 ↓ 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.011..136.303 rows=824,350 loops=1)

26. 160.141 160.141 ↓ 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=0.013..160.141 rows=808,507 loops=1)

27. 150.970 150.970 ↓ 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.010..150.970 rows=760,589 loops=1)

28. 112.868 112.868 ↓ 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.014..112.868 rows=530,699 loops=1)

29. 146.960 146.960 ↓ 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.051..146.960 rows=615,517 loops=1)

30. 77.737 77.737 ↓ 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.019..77.737 rows=478,822 loops=1)

31. 108.369 108.369 ↓ 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.018..108.369 rows=478,522 loops=1)

32. 152.822 152.822 ↓ 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.022..152.822 rows=416,952 loops=1)

33. 64.755 64.755 ↓ 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.012..64.755 rows=370,093 loops=1)

34. 61.276 61.276 ↓ 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.014..61.276 rows=366,140 loops=1)

35. 47.942 47.942 ↓ 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.010..47.942 rows=341,994 loops=1)

36. 32.991 32.991 ↓ 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.012..32.991 rows=240,850 loops=1)

37. 10.056 10.056 ↓ 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.010..10.056 rows=71,083 loops=1)

38. 5.223 5.223 ↓ 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.015..5.223 rows=38,615 loops=1)

39. 4.445 4.445 ↓ 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.027..4.445 rows=32,357 loops=1)

40. 4.464 4.464 ↓ 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.013..4.464 rows=30,419 loops=1)

41. 3.727 3.727 ↓ 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.035..3.727 rows=25,373 loops=1)

42. 4.069 4.069 ↓ 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.031..4.069 rows=24,126 loops=1)

43. 21.471 21.471 ↓ 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=0.010..21.471 rows=23,110 loops=1)

44. 10.742 10.742 ↓ 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.009..10.742 rows=20,071 loops=1)

45. 2.233 2.233 ↓ 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=0.008..2.233 rows=16,566 loops=1)

46. 1.816 1.816 ↓ 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=0.008..1.816 rows=14,086 loops=1)

47. 0.999 0.999 ↓ 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.010..0.999 rows=8,196 loops=1)

48. 7.769 7.769 ↓ 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.009..7.769 rows=6,214 loops=1)

49. 0.768 0.768 ↓ 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=0.011..0.768 rows=6,205 loops=1)

50. 0.780 0.780 ↓ 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.008..0.780 rows=6,096 loops=1)

51. 0.686 0.686 ↓ 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.010..0.686 rows=5,531 loops=1)

52. 0.514 0.514 ↓ 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.010..0.514 rows=4,038 loops=1)

53. 0.623 0.623 ↓ 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.032..0.623 rows=3,701 loops=1)

54. 0.483 0.483 ↓ 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=0.010..0.483 rows=3,128 loops=1)

55. 8.158 8.158 ↓ 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.013..8.158 rows=2,409 loops=1)

56. 0.416 0.416 ↓ 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.020..0.416 rows=1,981 loops=1)

57. 0.007 0.007 ↑ 68.0 16 1

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

58. 0.330 0.330 ↓ 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.019..0.330 rows=1,517 loops=1)

59. 0.119 0.119 ↓ 1.7 401 1

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

60. 0.049 0.049 ↓ 1.7 103 1

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

Planning time : 7.828 ms