explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QWKn

Settings
# exclusive inclusive rows x rows loops node
1. 24.666 32,300.776 ↓ 496.1 7,441 1

Sort (cost=611,290.35..611,290.39 rows=15 width=1,191) (actual time=32,297.382..32,300.776 rows=7,441 loops=1)

  • Sort Key: d.name, rr.studentgroupnr, (to_char(lower(r.during), 'dd.mm.yy'::text)), (to_char(lower(r.during), 'hh24:mi'::text))
  • Sort Method: quicksort Memory: 1477kB
2. 30.730 32,276.110 ↓ 496.1 7,441 1

Aggregate (cost=611,289.91..611,290.06 rows=15 width=1,191) (actual time=32,269.717..32,276.11 rows=7,441 loops=1)

3. 12.191 32,245.380 ↓ 778.8 11,682 1

Append (cost=62,979.08..611,289.57 rows=15 width=1,191) (actual time=3,726.667..32,245.38 rows=11,682 loops=1)

4. 62.519 10,101.203 ↓ 11,462.0 11,462 1

Nested Loop (cost=62,979.08..157,442.8 rows=1 width=174) (actual time=3,726.665..10,101.203 rows=11,462 loops=1)

5. 0.000 9,932.724 ↓ 35,320.0 35,320 1

Gather (cost=62,978.8..157,442.47 rows=1 width=127) (actual time=3,726.63..9,932.724 rows=35,320 loops=1)

6. 74.340 10,010.080 ↓ 11,773.0 11,773 3

Nested Loop (cost=61,978.8..156,442.37 rows=1 width=127) (actual time=3,720.75..10,010.08 rows=11,773 loops=3)

7. 72.598 9,935.736 ↓ 304.4 11,870 3

Nested Loop (cost=61,978.51..156,429.37 rows=39 width=130) (actual time=3,720.717..9,935.736 rows=11,870 loops=3)

8. 79.429 9,863.134 ↓ 304.4 11,870 3

Nested Loop (cost=61,978.09..156,412.04 rows=39 width=121) (actual time=3,720.684..9,863.134 rows=11,870 loops=3)

9. 63.190 9,783.701 ↓ 304.4 11,870 3

Nested Loop (cost=61,977.67..156,393.8 rows=39 width=127) (actual time=3,720.647..9,783.701 rows=11,870 loops=3)

10. 19.960 9,720.508 ↓ 185.5 11,870 3

Hash Join (cost=61,977.38..156,374.56 rows=64 width=135) (actual time=3,720.567..9,720.508 rows=11,870 loops=3)

11. 20.404 9,631.139 ↑ 4.9 12,007 3

Hash Join (cost=60,635.31..154,720.76 rows=59,376 width=122) (actual time=3,650.735..9,631.139 rows=12,007 loops=3)

12. 21.665 9,562.151 ↑ 4.9 12,007 3

Hash Join (cost=57,620.63..151,550.21 rows=59,376 width=128) (actual time=3,601.352..9,562.151 rows=12,007 loops=3)

13. 18.071 9,215.303 ↑ 4.9 12,007 3

Hash Join (cost=43,084.1..136,857.82 rows=59,376 width=152) (actual time=3,274.431..9,215.303 rows=12,007 loops=3)

14. 7,347.202 9,196.995 ↑ 4.9 12,007 3

Hash Join (cost=43,077.68..136,691.19 rows=59,376 width=155) (actual time=3,274.158..9,196.995 rows=12,007 loops=3)

15. 511.702 1,105.513 ↑ 1.2 291,526 3

Hash Join (cost=14,753.98..26,862.46 rows=364,228 width=65) (actual time=442.588..1,105.513 rows=291,526 loops=3)

16. 156.674 156.674 ↑ 1.2 291,526 3

Seq Scan on reservation_student rr2 (cost=0..10,196.28 rows=364,228 width=30) (actual time=0.008..156.674 rows=291,526 loops=3)

17. 279.159 437.137 ↑ 1.2 235,061 3

Hash (cost=10,348.19..10,348.19 rows=293,719 width=45) (actual time=437.136..437.137 rows=235,061 loops=3)

18. 157.978 157.978 ↑ 1.2 235,061 3

Seq Scan on reservation r2 (cost=0..10,348.19 rows=293,719 width=45) (actual time=0.016..157.978 rows=235,061 loops=3)

19. 95.990 744.280 ↑ 1.8 67,925 3

Hash (cost=26,806.09..26,806.09 rows=121,409 width=112) (actual time=744.279..744.28 rows=67,925 loops=3)

20. 87.263 648.290 ↑ 1.8 67,925 3

Hash Join (cost=14,378.76..26,806.09 rows=121,409 width=112) (actual time=205.832..648.29 rows=67,925 loops=3)

21. 274.403 547.613 ↑ 1.8 67,925 3

Hash Join (cost=14,019.68..26,128.16 rows=121,409 width=65) (actual time=192.314..547.613 rows=67,925 loops=3)

22. 161.033 161.033 ↑ 1.2 291,526 3

Seq Scan on reservation_student rr (cost=0..10,196.28 rows=364,228 width=30) (actual time=0.011..161.033 rows=291,526 loops=3)

23. 28.987 112.177 ↑ 4.1 23,715 3

Hash (cost=12,551.09..12,551.09 rows=97,906 width=45) (actual time=112.177..112.177 rows=23,715 loops=3)

24. 83.190 83.190 ↑ 4.1 23,715 3

Seq Scan on reservation r (cost=0..12,551.09 rows=97,906 width=45) (actual time=37.501..83.19 rows=23,715 loops=3)

  • Filter: (lower(during) > CURRENT_TIMESTAMP)
25. 6.768 13.414 ↑ 1.0 8,937 3

Hash (cost=247.37..247.37 rows=8,937 width=47) (actual time=13.413..13.414 rows=8,937 loops=3)

26. 6.646 6.646 ↑ 1.0 8,937 3

Seq Scan on studentgroup sg (cost=0..247.37 rows=8,937 width=47) (actual time=0.254..6.646 rows=8,937 loops=3)

27. 0.111 0.237 ↑ 1.0 152 3

Hash (cost=4.52..4.52 rows=152 width=17) (actual time=0.237..0.237 rows=152 loops=3)

28. 0.126 0.126 ↑ 1.0 152 3

Seq Scan on department d (cost=0..4.52 rows=152 width=17) (actual time=0.03..0.126 rows=152 loops=3)

29. 179.607 325.183 ↑ 1.2 171,507 3

Hash (cost=11,857.9..11,857.9 rows=214,290 width=31) (actual time=325.182..325.183 rows=171,507 loops=3)

30. 145.576 145.576 ↑ 1.2 171,507 3

Seq Scan on activitytime t2 (cost=0..11,857.9 rows=214,290 width=31) (actual time=0.015..145.576 rows=171,507 loops=3)

31. 27.573 48.584 ↑ 1.8 29,320 3

Hash (cost=2,368.19..2,368.19 rows=51,719 width=23) (actual time=48.583..48.584 rows=29,320 loops=3)

32. 21.011 21.011 ↑ 1.8 29,320 3

Seq Scan on activity a2 (cost=0..2,368.19 rows=51,719 width=23) (actual time=0.014..21.011 rows=29,320 loops=3)

33. 37.663 69.409 ↓ 1.0 43,411 3

Hash (cost=691.03..691.03 rows=43,403 width=13) (actual time=69.409..69.409 rows=43,411 loops=3)

34. 31.746 31.746 ↓ 1.0 43,411 3

Seq Scan on studentgroupcourse cc2 (cost=0..691.03 rows=43,403 width=13) (actual time=0.029..31.746 rows=43,411 loops=3)

35. 0.003 0.003 ↑ 1.0 1 35,609

Index Only Scan using course_pkey on course c2 (cost=0.28..0.3 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=35,609)

  • Index Cond: (id = (a2.courseid)::text)
36. 0.004 0.004 ↑ 1.0 1 35,609

Index Scan using activitytime_pkey on activitytime t (cost=0.42..0.47 rows=1 width=31) (actual time=0.004..0.004 rows=1 loops=35,609)

  • Index Cond: ((id)::text = (rr.activitytimeid)::text)
37. 0.004 0.004 ↑ 1.0 1 35,609

Index Scan using activity_pkey on activity a (cost=0.42..0.44 rows=1 width=38) (actual time=0.004..0.004 rows=1 loops=35,609)

  • Index Cond: ((id)::text = (t.activityid)::text)
38. 0.004 0.004 ↑ 1.0 1 35,609

Index Scan using studentgroupcourse_pkey on studentgroupcourse cc (cost=0.29..0.32 rows=1 width=13) (actual time=0.004..0.004 rows=1 loops=35,609)

  • Index Cond: (((courseid)::text = (a.courseid)::text) AND (studentgroupnr = rr.studentgroupnr))
39. 105.960 105.960 ↑ 1.0 1 35,320

Index Only Scan using course_pkey on course c (cost=0.28..0.3 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=35,320)

  • Index Cond: (id = (a.courseid)::text)
40. 1,988.343 11,818.888 ↓ 7.5 98 1

Hash Join (cost=237,815.69..278,119.73 rows=13 width=174) (actual time=9,949.393..11,818.888 rows=98 loops=1)

41. 93.897 490.008 ↓ 1.0 2,813 1

Hash Join (cost=17,996.67..31,933.74 rows=2,681 width=116) (actual time=266.145..490.008 rows=2,813 loops=1)

42. 19.603 19.603 ↓ 1.0 43,411 1

Seq Scan on studentgroupcourse cc_1 (cost=0..691.03 rows=43,403 width=13) (actual time=0.01..19.603 rows=43,411 loops=1)

43. 6.138 264.314 ↓ 6.4 7,047 1

Hash (cost=17,982.87..17,982.87 rows=1,104 width=125) (actual time=264.313..264.314 rows=7,047 loops=1)

44. 5.373 258.176 ↓ 6.4 7,047 1

Gather (cost=1,133.38..17,982.87 rows=1,104 width=125) (actual time=206.908..258.176 rows=7,047 loops=1)

45. 3.213 252.803 ↓ 5.1 2,349 3

Hash Join (cost=133.38..16,872.47 rows=460 width=125) (actual time=202.734..252.803 rows=2,349 loops=3)

46. 9.356 249.370 ↓ 5.1 2,349 3

Nested Loop (cost=126.96..16,864.81 rows=460 width=128) (actual time=202.416..249.37 rows=2,349 loops=3)

47. 7.965 240.012 ↓ 5.1 2,349 3

Nested Loop (cost=126.68..16,725.45 rows=460 width=81) (actual time=202.386..240.012 rows=2,349 loops=3)

48. 2.386 232.038 ↓ 1.4 504 3

Nested Loop (cost=126.25..16,537.01 rows=371 width=119) (actual time=201.353..232.038 rows=504 loops=3)

49. 3.419 229.649 ↓ 1.4 504 3

Nested Loop (cost=125.97..16,425.49 rows=371 width=119) (actual time=201.287..229.649 rows=504 loops=3)

50. 3.140 226.225 ↓ 1.4 504 3

Nested Loop (cost=125.55..15,235.48 rows=371 width=127) (actual time=201.258..226.225 rows=504 loops=3)

51. 10.602 223.081 ↓ 1.4 504 3

Nested Loop (cost=125.13..15,067.12 rows=371 width=118) (actual time=201.22..223.081 rows=504 loops=3)

52. 84.518 212.471 ↓ 1.4 1,118 3

Hash Join (cost=124.71..14,535.42 rows=812 width=73) (actual time=7.281..212.471 rows=1,118 loops=3)

53. 122.972 122.972 ↓ 1.2 125,878 3

Seq Scan on activitytime t_1 (cost=0..11,857.9 rows=107,145 width=30) (actual time=0.01..122.972 rows=125,878 loops=3)

  • Filter: (NOT COALESCE(nostudent, false))
54. 2.813 4.981 ↓ 1.0 3,900 3

Hash (cost=75.98..75.98 rows=3,898 width=43) (actual time=4.98..4.981 rows=3,900 loops=3)

55. 2.168 2.168 ↓ 1.0 3,900 3

Seq Scan on jointactivitytime flw (cost=0..75.98 rows=3,898 width=43) (actual time=0.015..2.168 rows=3,900 loops=3)

56. 0.008 0.008 ↓ 0.0 0 3,353

Index Scan using reservation_activitytimeid_idx on reservation r_1 (cost=0.42..0.63 rows=2 width=45) (actual time=0.007..0.008 rows=0 loops=3,353)

  • Index Cond: ((activitytimeid)::text = (t_1.id)::text)
  • Filter: (lower(during) > CURRENT_TIMESTAMP)
57. 0.004 0.004 ↑ 1.0 1 1,513

Index Scan using activity_pkey on activity a_1 (cost=0.42..0.45 rows=1 width=38) (actual time=0.004..0.004 rows=1 loops=1,513)

  • Index Cond: ((id)::text = (t_1.activityid)::text)
58. 0.005 0.005 ↑ 1.0 1 1,513

Index Scan using activitytime_pkey on activitytime flwat (cost=0.42..3.21 rows=1 width=30) (actual time=0.005..0.005 rows=1 loops=1,513)

  • Index Cond: ((id)::text = (flw.uscheduledactivitytimeid)::text)
59. 0.003 0.003 ↑ 1.0 1 1,513

Index Only Scan using course_pkey on course c_1 (cost=0.28..0.3 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1,513)

  • Index Cond: (id = (a_1.courseid)::text)
60. 0.009 0.009 ↓ 5.0 5 1,513

Index Only Scan using reservation_student_pkey on reservation_student rr_1 (cost=0.42..0.5 rows=1 width=30) (actual time=0.006..0.009 rows=5 loops=1,513)

  • Index Cond: ((activitytimeid = (r_1.activitytimeid)::text) AND (weeknumberid = r_1.weeknumberid))
61. 0.002 0.002 ↑ 1.0 1 7,047

Index Scan using studentgroup_pkey on studentgroup sg_1 (cost=0.29..0.3 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=7,047)

  • Index Cond: (nr = rr_1.studentgroupnr)
62. 0.105 0.220 ↑ 1.0 152 3

Hash (cost=4.52..4.52 rows=152 width=17) (actual time=0.22..0.22 rows=152 loops=3)

63. 0.115 0.115 ↑ 1.0 152 3

Seq Scan on department d_1 (cost=0..4.52 rows=152 width=17) (actual time=0.023..0.115 rows=152 loops=3)

64.          

SubPlan (forHash Join)

65. 112.194 112.194 ↑ 1.0 1 37,398

Index Scan using activity_pkey on activity activity (cost=0.42..4.44 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=37,398)

  • Index Cond: ((id)::text = (flwat.activityid)::text)
66. 3,241.402 9,331.675 ↓ 2.0 4,365,096 1

Hash (cost=165,955.59..165,955.59 rows=2,224,034 width=65) (actual time=9,331.674..9,331.675 rows=4,365,096 loops=1)

67. 2,795.984 6,090.273 ↓ 2.0 4,365,096 1

Hash Join (cost=98,725.98..165,955.59 rows=2,224,034 width=65) (actual time=3,270.412..6,090.273 rows=4,365,096 loops=1)

68. 25.678 25.678 ↓ 1.0 43,411 1

Seq Scan on studentgroupcourse cc2_1 (cost=0..691.03 rows=43,403 width=13) (actual time=0.012..25.678 rows=43,411 loops=1)

69. 657.344 3,268.611 ↓ 1.8 784,002 1

Hash (cost=88,993.56..88,993.56 rows=437,074 width=52) (actual time=3,268.61..3,268.611 rows=784,002 loops=1)

70. 5.679 2,611.267 ↓ 1.8 784,002 1

Gather (cost=32,221.27..88,993.56 rows=437,074 width=52) (actual time=798.626..2,611.267 rows=784,002 loops=1)

71. 359.221 2,605.588 ↓ 1.4 261,334 3

Hash Join (cost=31,221.27..44,286.16 rows=182,114 width=52) (actual time=793.667..2,605.588 rows=261,334 loops=3)

72. 377.109 2,236.869 ↓ 1.4 261,334 3

Hash Join (cost=30,965.87..43,552.43 rows=182,114 width=52) (actual time=784.021..2,236.869 rows=261,334 loops=3)

73. 468.504 1,808.732 ↓ 1.4 261,334 3

Hash Join (cost=27,951.19..40,059.68 rows=182,114 width=58) (actual time=732.178..1,808.732 rows=261,334 loops=3)

74. 432.007 879.854 ↓ 1.4 261,334 3

Hash Join (cost=13,197.21..24,349.61 rows=182,114 width=60) (actual time=268.424..879.854 rows=261,334 loops=3)

75. 179.813 179.813 ↑ 1.2 291,526 3

Seq Scan on reservation_student rr2_1 (cost=0..10,196.28 rows=364,228 width=30) (actual time=0.012..179.813 rows=291,526 loops=3)

76. 142.216 268.034 ↓ 1.2 125,878 3

Hash (cost=11,857.9..11,857.9 rows=107,145 width=30) (actual time=268.033..268.034 rows=125,878 loops=3)

77. 125.818 125.818 ↓ 1.2 125,878 3

Seq Scan on activitytime t2_1 (cost=0..11,857.9 rows=107,145 width=30) (actual time=0.013..125.818 rows=125,878 loops=3)

  • Filter: (NOT COALESCE(nostudent, false))
78. 295.763 460.374 ↑ 1.2 235,061 3

Hash (cost=10,348.19..10,348.19 rows=293,719 width=45) (actual time=460.373..460.374 rows=235,061 loops=3)

79. 164.611 164.611 ↑ 1.2 235,061 3

Seq Scan on reservation r2_1 (cost=0..10,348.19 rows=293,719 width=45) (actual time=0.016..164.611 rows=235,061 loops=3)

80. 28.487 51.028 ↑ 1.8 29,320 3

Hash (cost=2,368.19..2,368.19 rows=51,719 width=23) (actual time=51.027..51.028 rows=29,320 loops=3)

81. 22.541 22.541 ↑ 1.8 29,320 3

Seq Scan on activity a2_1 (cost=0..2,368.19 rows=51,719 width=23) (actual time=0.014..22.541 rows=29,320 loops=3)

82. 5.021 9.498 ↑ 1.0 7,386 3

Hash (cost=163.07..163.07 rows=7,386 width=8) (actual time=9.498..9.498 rows=7,386 loops=3)

83. 4.477 4.477 ↑ 1.0 7,386 3

Index Only Scan using course_pkey on course c2_1 (cost=0.28..163.07 rows=7,386 width=8) (actual time=0.057..4.477 rows=7,386 loops=3)

84.          

SubPlan (forHash Join)

85. 1.243 8.862 ↑ 1.0 2 211

Nested Loop (cost=14.45..15.21 rows=2 width=8) (actual time=0.032..0.042 rows=2 loops=211)

86. 0.633 6.119 ↑ 1.0 2 211

Unique (cost=14.03..14.04 rows=2 width=14) (actual time=0.026..0.029 rows=2 loops=211)

87. 1.477 5.486 ↑ 1.0 2 211

Sort (cost=14.03..14.03 rows=2 width=14) (actual time=0.025..0.026 rows=2 loops=211)

  • Sort Key: ((activitytime.activityid)::text)
  • Sort Method: quicksort Memory: 25kB
88. 1.243 4.009 ↑ 1.0 2 211

Nested Loop (cost=0.7..14.02 rows=2 width=14) (actual time=0.011..0.019 rows=2 loops=211)

89. 1.266 1.266 ↑ 1.0 2 211

Index Scan using jointactivitytime_scheduledactivitytimeid_idx on jointactivitytime jointactivitytime (cost=0.28..5.14 rows=2 width=22) (actual time=0.004..0.006 rows=2 loops=211)

  • Index Cond: ((scheduledactivitytimeid)::text = (r_1.activitytimeid)::text)
90. 1.500 1.500 ↑ 1.0 1 500

Index Scan using activitytime_pkey on activitytime activitytime (cost=0.42..4.44 rows=1 width=30) (actual time=0.003..0.003 rows=1 loops=500)

  • Index Cond: ((id)::text = (jointactivitytime.uscheduledactivitytimeid)::text)
91. 1.500 1.500 ↑ 1.0 1 500

Index Scan using activity_pkey on activity activity_1 (cost=0.42..0.59 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=500)

  • Index Cond: ((id)::text = (activitytime.activityid)::text)
92. 0.667 10,313.098 ↓ 122.0 122 1

Nested Loop (cost=164,933.84..175,726.82 rows=1 width=174) (actual time=9,781.992..10,313.098 rows=122 loops=1)

93. 0.440 10,312.187 ↓ 122.0 122 1

Nested Loop (cost=164,933.69..175,726.64 rows=1 width=104) (actual time=9,781.959..10,312.187 rows=122 loops=1)

94. 0.417 10,310.855 ↓ 223.0 223 1

Nested Loop (cost=164,933.4..175,726.3 rows=1 width=140) (actual time=9,781.937..10,310.855 rows=223 loops=1)

95. 0.000 10,309.546 ↓ 223.0 223 1

Nested Loop (cost=164,932.98..175,725.86 rows=1 width=146) (actual time=9,781.924..10,309.546 rows=223 loops=1)

96. 76.613 10,335.062 ↓ 223.0 223 1

Gather (cost=164,932.56..175,722.65 rows=1 width=154) (actual time=9,781.909..10,335.062 rows=223 loops=1)

97. 5.139 10,258.449 ↓ 74.0 74 3

Nested Loop (cost=163,932.56..174,722.55 rows=1 width=154) (actual time=9,775.681..10,258.449 rows=74 loops=3)

98. 5.244 10,253.306 ↑ 1.2 895 3

Nested Loop (cost=163,932.14..174,239.15 rows=1,058 width=161) (actual time=9,744.644..10,253.306 rows=895 loops=3)

99. 24.714 10,248.058 ↑ 1.2 895 3

Hash Join (cost=163,931.72..173,744.34 rows=1,058 width=167) (actual time=9,744.592..10,248.058 rows=895 loops=3)

100. 110.712 10,218.642 ↑ 3.7 37,829 3

Hash Join (cost=163,807.02..169,943.89 rows=139,559 width=200) (actual time=9,733.32..10,218.642 rows=37,829 loops=3)

101. 143.861 10,098.896 ↑ 2.6 112,679 3

Hash Join (cost=163,551.62..168,931.28 rows=288,363 width=193) (actual time=9,724.243..10,098.896 rows=112,679 loops=3)

102. 153.144 9,946.176 ↑ 2.6 112,679 3

Merge Join (cost=163,296.22..167,918.49 rows=288,363 width=193) (actual time=9,715.337..9,946.176 rows=112,679 loops=3)

103. 25.529 9,662.792 ↑ 4.9 12,007 3

Sort (cost=159,261.93..159,410.37 rows=59,376 width=180) (actual time=9,655.207..9,662.792 rows=12,007 loops=3)

  • Sort Key: rr_2.studentgroupnr
  • Sort Method: quicksort Memory: 3895kB
104. 18.620 9,637.263 ↑ 4.9 12,007 3

Hash Join (cost=60,628.89..154,554.13 rows=59,376 width=180) (actual time=3,633.715..9,637.263 rows=12,007 loops=3)

105. 21.179 9,569.324 ↑ 4.9 12,007 3

Hash Join (cost=57,614.21..151,383.57 rows=59,376 width=186) (actual time=3,583.622..9,569.324 rows=12,007 loops=3)

106. 7,342.570 9,222.730 ↑ 4.9 12,007 3

Hash Join (cost=43,077.68..136,691.19 rows=59,376 width=155) (actual time=3,256.555..9,222.73 rows=12,007 loops=3)

107. 515.294 1,121.380 ↑ 1.2 291,526 3

Hash Join (cost=14,753.98..26,862.46 rows=364,228 width=65) (actual time=449.472..1,121.38 rows=291,526 loops=3)

108. 162.257 162.257 ↑ 1.2 291,526 3

Seq Scan on reservation_student rr2_2 (cost=0..10,196.28 rows=364,228 width=30) (actual time=0.006..162.257 rows=291,526 loops=3)

109. 283.169 443.829 ↑ 1.2 235,061 3

Hash (cost=10,348.19..10,348.19 rows=293,719 width=45) (actual time=443.828..443.829 rows=235,061 loops=3)

110. 160.660 160.660 ↑ 1.2 235,061 3

Seq Scan on reservation r2_2 (cost=0..10,348.19 rows=293,719 width=45) (actual time=0.014..160.66 rows=235,061 loops=3)

111. 98.723 758.780 ↑ 1.8 67,925 3

Hash (cost=26,806.09..26,806.09 rows=121,409 width=112) (actual time=758.78..758.78 rows=67,925 loops=3)

112. 89.569 660.057 ↑ 1.8 67,925 3

Hash Join (cost=14,378.76..26,806.09 rows=121,409 width=112) (actual time=206.126..660.057 rows=67,925 loops=3)

113. 282.155 557.741 ↑ 1.8 67,925 3

Hash Join (cost=14,019.68..26,128.16 rows=121,409 width=65) (actual time=193.272..557.741 rows=67,925 loops=3)

114. 162.739 162.739 ↑ 1.2 291,526 3

Seq Scan on reservation_student rr_2 (cost=0..10,196.28 rows=364,228 width=30) (actual time=0.01..162.739 rows=291,526 loops=3)

115. 29.608 112.847 ↑ 4.1 23,715 3

Hash (cost=12,551.09..12,551.09 rows=97,906 width=45) (actual time=112.846..112.847 rows=23,715 loops=3)

116. 83.239 83.239 ↑ 4.1 23,715 3

Seq Scan on reservation r_2 (cost=0..12,551.09 rows=97,906 width=45) (actual time=37.908..83.239 rows=23,715 loops=3)

  • Filter: (lower(during) > CURRENT_TIMESTAMP)
117. 6.501 12.747 ↑ 1.0 8,937 3

Hash (cost=247.37..247.37 rows=8,937 width=47) (actual time=12.746..12.747 rows=8,937 loops=3)

118. 6.246 6.246 ↑ 1.0 8,937 3

Seq Scan on studentgroup sg_2 (cost=0..247.37 rows=8,937 width=47) (actual time=0.027..6.246 rows=8,937 loops=3)

119. 180.086 325.415 ↑ 1.2 171,507 3

Hash (cost=11,857.9..11,857.9 rows=214,290 width=31) (actual time=325.415..325.415 rows=171,507 loops=3)

120. 145.329 145.329 ↑ 1.2 171,507 3

Seq Scan on activitytime t2_2 (cost=0..11,857.9 rows=214,290 width=31) (actual time=0.015..145.329 rows=171,507 loops=3)

121. 27.914 49.319 ↑ 1.8 29,320 3

Hash (cost=2,368.19..2,368.19 rows=51,719 width=23) (actual time=49.319..49.319 rows=29,320 loops=3)

122. 21.405 21.405 ↑ 1.8 29,320 3

Seq Scan on activity a2_2 (cost=0..2,368.19 rows=51,719 width=23) (actual time=0.015..21.405 rows=29,320 loops=3)

123. 103.228 130.240 ↓ 3.0 130,044 3

Sort (cost=4,034.26..4,142.76 rows=43,403 width=13) (actual time=60.084..130.24 rows=130,044 loops=3)

  • Sort Key: cc_2.studentgroupnr
  • Sort Method: quicksort Memory: 3574kB
124. 27.012 27.012 ↓ 1.0 43,411 3

Seq Scan on studentgroupcourse cc_2 (cost=0..691.03 rows=43,403 width=13) (actual time=0.037..27.012 rows=43,411 loops=3)

125. 4.703 8.859 ↑ 1.0 7,386 3

Hash (cost=163.07..163.07 rows=7,386 width=8) (actual time=8.859..8.859 rows=7,386 loops=3)

126. 4.156 4.156 ↑ 1.0 7,386 3

Index Only Scan using course_pkey on course c2_2 (cost=0.28..163.07 rows=7,386 width=8) (actual time=0.028..4.156 rows=7,386 loops=3)

127. 4.684 9.034 ↑ 1.0 7,386 3

Hash (cost=163.07..163.07 rows=7,386 width=8) (actual time=9.033..9.034 rows=7,386 loops=3)

128. 4.350 4.350 ↑ 1.0 7,386 3

Index Only Scan using course_pkey on course c_2 (cost=0.28..163.07 rows=7,386 width=8) (actual time=0.056..4.35 rows=7,386 loops=3)

129. 2.651 4.702 ↓ 1.0 3,900 3

Hash (cost=75.98..75.98 rows=3,898 width=43) (actual time=4.702..4.702 rows=3,900 loops=3)

130. 2.051 2.051 ↓ 1.0 3,900 3

Seq Scan on jointactivitytime flw_1 (cost=0..75.98 rows=3,898 width=43) (actual time=0.02..2.051 rows=3,900 loops=3)

131. 0.004 0.004 ↑ 1.0 1 2,686

Index Scan using activitytime_pkey on activitytime t_2 (cost=0.42..0.47 rows=1 width=31) (actual time=0.004..0.004 rows=1 loops=2,686)

  • Index Cond: ((id)::text = (rr_2.activitytimeid)::text)
132. 0.004 0.004 ↑ 1.0 1 2,686

Index Scan using activity_pkey on activity a_2 (cost=0.42..0.44 rows=1 width=38) (actual time=0.003..0.004 rows=1 loops=2,686)

  • Index Cond: ((id)::text = (t_2.activityid)::text)
133. 0.892 0.892 ↑ 1.0 1 223

Index Scan using activitytime_pkey on activitytime flwat_1 (cost=0.42..3.21 rows=1 width=30) (actual time=0.004..0.004 rows=1 loops=223)

  • Index Cond: ((id)::text = (flw_1.uscheduledactivitytimeid)::text)
134. 0.892 0.892 ↑ 1.0 1 223

Index Scan using activity_pkey on activity aa (cost=0.42..0.44 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=223)

  • Index Cond: ((id)::text = (flwat_1.activityid)::text)
135. 0.892 0.892 ↑ 1.0 1 223

Index Scan using studentgroupcourse_pkey on studentgroupcourse cc2_2 (cost=0.29..0.32 rows=1 width=13) (actual time=0.004..0.004 rows=1 loops=223)

  • Index Cond: (((courseid)::text = (aa.courseid)::text) AND (studentgroupnr = rr_2.studentgroupnr))
136. 0.244 0.244 ↑ 1.0 1 122

Index Scan using department_pkey on department d_2 (cost=0.14..0.16 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=122)

  • Index Cond: ((id)::text = (sg_2.ownerid)::text)