explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e370 : Optimization for: plan #76Bb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 10,888.145 ↓ 1.3 235 1

Group (cost=2,167,602.22..2,167,645.13 rows=180 width=9) (actual time=10,887.911..10,888.145 rows=235 loops=1)

  • Group Key: channel_events_004.vendor_device_id
2. 4.548 10,889.028 ↑ 1.5 244 1

Gather Merge (cost=2,167,602.22..2,167,644.23 rows=360 width=9) (actual time=10,887.910..10,889.028 rows=244 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.186 10,884.480 ↑ 2.2 81 3 / 3

Sort (cost=2,166,602.20..2,166,602.65 rows=180 width=9) (actual time=10,884.476..10,884.480 rows=81 loops=3)

  • Sort Key: channel_events_004.vendor_device_id
  • Sort Method: quicksort Memory: 35kB
  • Worker 0: Sort Method: quicksort Memory: 28kB
  • Worker 1: Sort Method: quicksort Memory: 28kB
4. 4,178.151 10,884.294 ↑ 2.2 81 3 / 3

Partial HashAggregate (cost=2,166,593.66..2,166,595.46 rows=180 width=9) (actual time=10,884.281..10,884.294 rows=81 loops=3)

  • Group Key: channel_events_004.vendor_device_id
5. 2,163.715 6,706.143 ↑ 1.2 32,220,379 3 / 3

Parallel Append (cost=0.00..2,065,906.50 rows=40,274,864 width=9) (actual time=0.012..6,706.143 rows=32,220,379 loops=3)

6. 317.860 317.860 ↓ 2.4 6,762,033 1 / 3

Parallel Seq Scan on channel_events_004 (cost=0.00..132,019.14 rows=2,817,514 width=9) (actual time=0.023..953.579 rows=6,762,033 loops=1)

7. 236.021 236.021 ↓ 2.4 5,997,822 1 / 3

Parallel Seq Scan on channel_events_027 (cost=0.00..113,457.93 rows=2,499,092 width=8) (actual time=0.006..708.064 rows=5,997,822 loops=1)

8. 284.846 284.846 ↓ 2.4 5,857,107 1 / 3

Parallel Seq Scan on channel_events_001 (cost=0.00..112,743.61 rows=2,440,461 width=8) (actual time=0.029..854.538 rows=5,857,107 loops=1)

9. 271.261 271.261 ↓ 2.4 5,457,231 1 / 3

Parallel Seq Scan on channel_events_015 (cost=0.00..101,879.46 rows=2,273,846 width=7) (actual time=0.031..813.782 rows=5,457,231 loops=1)

10. 246.070 246.070 ↓ 2.4 5,126,772 1 / 3

Parallel Seq Scan on channel_events_026 (cost=0.00..95,067.55 rows=2,136,155 width=6) (actual time=0.025..738.210 rows=5,126,772 loops=1)

11. 207.671 207.671 ↓ 2.4 4,083,531 1 / 3

Parallel Seq Scan on channel_events_002 (cost=0.00..80,274.71 rows=1,701,471 width=9) (actual time=0.030..623.012 rows=4,083,531 loops=1)

12. 194.998 194.998 ↓ 2.4 3,941,505 1 / 3

Parallel Seq Scan on channel_events_020 (cost=0.00..75,898.86 rows=1,641,886 width=8) (actual time=0.020..584.993 rows=3,941,505 loops=1)

13. 191.644 191.644 ↓ 2.4 3,866,076 1 / 3

Parallel Seq Scan on channel_events_008 (cost=0.00..73,551.65 rows=1,610,865 width=8) (actual time=0.019..574.933 rows=3,866,076 loops=1)

14. 189.658 189.658 ↓ 2.4 3,779,145 1 / 3

Parallel Seq Scan on channel_events_035 (cost=0.00..71,641.48 rows=1,573,748 width=9) (actual time=0.029..568.974 rows=3,779,145 loops=1)

15. 183.124 183.124 ↓ 2.4 3,580,395 1 / 3

Parallel Seq Scan on channel_events_009 (cost=0.00..71,625.31 rows=1,491,831 width=10) (actual time=0.027..549.373 rows=3,580,395 loops=1)

16. 157.898 157.898 ↓ 2.4 3,227,079 1 / 3

Parallel Seq Scan on channel_events_038 (cost=0.00..60,285.23 rows=1,345,123 width=8) (actual time=0.027..473.693 rows=3,227,079 loops=1)

17. 141.627 141.627 ↓ 2.4 2,954,763 1 / 3

Parallel Seq Scan on channel_events_023 (cost=0.00..57,182.51 rows=1,231,151 width=8) (actual time=0.026..424.881 rows=2,954,763 loops=1)

18. 116.193 116.193 ↓ 2.4 2,480,118 1 / 3

Parallel Seq Scan on channel_events_030 (cost=0.00..46,463.82 rows=1,033,382 width=7) (actual time=0.028..348.579 rows=2,480,118 loops=1)

19. 116.333 116.333 ↓ 2.4 2,386,641 1 / 3

Parallel Seq Scan on channel_events_041 (cost=0.00..44,635.76 rows=994,476 width=8) (actual time=0.029..349.000 rows=2,386,641 loops=1)

20. 114.829 114.829 ↑ 1.3 766,192 3 / 3

Parallel Seq Scan on channel_events_034 (cost=0.00..43,514.78 rows=957,878 width=9) (actual time=0.021..114.829 rows=766,192 loops=3)

21. 112.248 112.248 ↓ 1.2 1,129,114 2 / 3

Parallel Seq Scan on channel_events_042 (cost=0.00..42,452.42 rows=940,942 width=8) (actual time=0.018..168.372 rows=1,129,114 loops=2)

22. 108.351 108.351 ↓ 2.4 2,149,080 1 / 3

Parallel Seq Scan on channel_events_016 (cost=0.00..40,833.50 rows=895,450 width=9) (actual time=0.010..325.052 rows=2,149,080 loops=1)

23. 103.414 103.414 ↓ 2.4 2,091,603 1 / 3

Parallel Seq Scan on channel_events_044 (cost=0.00..39,589.31 rows=871,531 width=9) (actual time=0.009..310.242 rows=2,091,603 loops=1)

24. 98.488 98.488 ↓ 2.4 1,959,702 1 / 3

Parallel Seq Scan on channel_events_039 (cost=0.00..38,657.07 rows=816,507 width=14) (actual time=0.010..295.464 rows=1,959,702 loops=1)

25. 102.090 102.090 ↓ 2.4 2,044,167 1 / 3

Parallel Seq Scan on channel_events_013 (cost=0.00..38,583.36 rows=851,736 width=8) (actual time=0.009..306.269 rows=2,044,167 loops=1)

26. 95.124 95.124 ↓ 2.4 1,792,308 1 / 3

Parallel Seq Scan on channel_events_010 (cost=0.00..37,076.95 rows=746,795 width=13) (actual time=0.013..285.372 rows=1,792,308 loops=1)

27. 62.356 62.356 ↓ 2.4 1,712,628 1 / 3

Parallel Seq Scan on channel_events_049 (cost=0.00..35,219.95 rows=713,595 width=12) (actual time=0.005..187.069 rows=1,712,628 loops=1)

28. 83.824 83.824 ↓ 2.4 1,679,448 1 / 3

Parallel Seq Scan on channel_events_024 (cost=0.00..34,751.70 rows=699,770 width=14) (actual time=0.013..251.472 rows=1,679,448 loops=1)

29. 68.457 68.457 ↓ 2.4 1,860,954 1 / 3

Parallel Seq Scan on channel_events_046 (cost=0.00..34,720.97 rows=775,398 width=7) (actual time=0.005..205.372 rows=1,860,954 loops=1)

30. 86.758 86.758 ↓ 2.4 1,831,458 1 / 3

Parallel Seq Scan on channel_events_029 (cost=0.00..33,651.07 rows=763,108 width=6) (actual time=0.014..260.274 rows=1,831,458 loops=1)

31. 58.448 58.448 ↓ 2.4 1,604,469 1 / 3

Parallel Seq Scan on channel_events_037 (cost=0.00..32,990.29 rows=668,529 width=12) (actual time=0.004..175.344 rows=1,604,469 loops=1)

32. 56.686 56.686 ↓ 2.4 1,540,437 1 / 3

Parallel Seq Scan on channel_events_036 (cost=0.00..31,059.49 rows=641,849 width=10) (actual time=0.006..170.058 rows=1,540,437 loops=1)

33. 81.327 81.327 ↓ 2.4 1,632,339 1 / 3

Parallel Seq Scan on channel_events_012 (cost=0.00..30,531.41 rows=680,141 width=7) (actual time=0.009..243.982 rows=1,632,339 loops=1)

34. 81.064 81.064 ↓ 2.4 1,578,630 1 / 3

Parallel Seq Scan on channel_events_007 (cost=0.00..30,138.62 rows=657,762 width=10) (actual time=0.014..243.191 rows=1,578,630 loops=1)

35. 56.955 56.955 ↓ 2.4 1,554,744 1 / 3

Parallel Seq Scan on channel_events_050 (cost=0.00..29,455.10 rows=647,810 width=9) (actual time=0.005..170.866 rows=1,554,744 loops=1)

36. 72.533 72.533 ↓ 2.4 1,535,199 1 / 3

Parallel Seq Scan on channel_events_003 (cost=0.00..28,481.66 rows=639,666 width=6) (actual time=0.008..217.598 rows=1,535,199 loops=1)

37. 53.150 53.150 ↓ 2.4 1,040,733 1 / 3

Parallel Seq Scan on channel_events_005 (cost=0.00..22,280.39 rows=433,639 width=25) (actual time=0.014..159.450 rows=1,040,733 loops=1)

38. 35.946 35.946 ↓ 2.4 994,881 1 / 3

Parallel Seq Scan on channel_events_048 (cost=0.00..18,950.34 rows=414,534 width=9) (actual time=0.004..107.839 rows=994,881 loops=1)

39. 25.892 25.892 ↓ 2.4 718,416 1 / 3

Parallel Seq Scan on channel_events_021 (cost=0.00..14,168.40 rows=299,340 width=14) (actual time=0.004..77.676 rows=718,416 loops=1)

40. 20.311 20.311 ↓ 2.4 549,504 1 / 3

Parallel Seq Scan on channel_events_040 (cost=0.00..11,764.60 rows=228,960 width=25) (actual time=0.004..60.932 rows=549,504 loops=1)

41. 15.822 15.822 ↓ 2.4 397,212 1 / 3

Parallel Seq Scan on channel_events_033 (cost=0.00..8,504.05 rows=165,505 width=25) (actual time=0.002..47.465 rows=397,212 loops=1)

42. 16.339 16.339 ↓ 2.4 397,140 1 / 3

Parallel Seq Scan on channel_events_032 (cost=0.00..8,502.75 rows=165,475 width=25) (actual time=0.002..49.016 rows=397,140 loops=1)

43. 11.472 11.472 ↓ 2.4 303,678 1 / 3

Parallel Seq Scan on channel_events_022 (cost=0.00..6,368.32 rows=126,532 width=21) (actual time=0.004..34.417 rows=303,678 loops=1)

44. 12.315 12.315 ↓ 2.4 234,258 1 / 3

Parallel Seq Scan on channel_events_006 (cost=0.00..5,015.07 rows=97,608 width=25) (actual time=0.017..36.944 rows=234,258 loops=1)

45. 7.985 7.985 ↓ 2.4 217,227 1 / 3

Parallel Seq Scan on channel_events_014 (cost=0.00..4,651.11 rows=90,511 width=25) (actual time=0.004..23.955 rows=217,227 loops=1)

46. 7.983 7.983 ↓ 2.4 217,056 1 / 3

Parallel Seq Scan on channel_events_019 (cost=0.00..4,647.40 rows=90,440 width=25) (actual time=0.003..23.949 rows=217,056 loops=1)

47. 7.813 7.813 ↓ 2.4 211,683 1 / 3

Parallel Seq Scan on channel_events_018 (cost=0.00..4,532.01 rows=88,201 width=25) (actual time=0.003..23.439 rows=211,683 loops=1)

48. 7.446 7.446 ↓ 2.4 188,118 1 / 3

Parallel Seq Scan on channel_events_028 (cost=0.00..3,942.82 rows=78,382 width=21) (actual time=0.003..22.339 rows=188,118 loops=1)

49. 6.723 6.723 ↓ 2.4 180,876 1 / 3

Parallel Seq Scan on channel_events_045 (cost=0.00..3,872.65 rows=75,365 width=25) (actual time=0.004..20.169 rows=180,876 loops=1)

50. 3.912 3.912 ↓ 1.7 94,908 1 / 3

Parallel Seq Scan on channel_events_031 (cost=0.00..2,195.28 rows=55,828 width=25) (actual time=0.002..11.735 rows=94,908 loops=1)

51. 3.745 3.745 ↓ 1.7 91,350 1 / 3

Parallel Seq Scan on channel_events_025 (cost=0.00..2,112.35 rows=53,735 width=25) (actual time=0.003..11.234 rows=91,350 loops=1)

52. 2.965 2.965 ↓ 1.7 80,262 1 / 3

Parallel Seq Scan on channel_events_011 (cost=0.00..1,856.13 rows=47,213 width=25) (actual time=0.003..8.896 rows=80,262 loops=1)

53. 2.926 2.926 ↓ 1.7 77,970 1 / 3

Parallel Seq Scan on channel_events_047 (cost=0.00..1,803.65 rows=45,865 width=25) (actual time=0.003..8.779 rows=77,970 loops=1)

54. 1.526 1.526 ↓ 1.7 41,670 1 / 3

Parallel Seq Scan on channel_events_017 (cost=0.00..929.12 rows=24,512 width=12) (actual time=0.003..4.577 rows=41,670 loops=1)

55. 0.002 0.002 ↓ 1.5 6 1 / 3

Parallel Seq Scan on channel_events_043 (cost=0.00..1.04 rows=4 width=32) (actual time=0.004..0.005 rows=6 loops=1)

Planning time : 0.707 ms
Execution time : 10,889.209 ms