explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YPQy

Settings
# exclusive inclusive rows x rows loops node
1. 292.585 1,791,296.705 ↓ 4,219.5 16,878 1

Sort (cost=473,796.24..473,796.25 rows=4 width=1,489) (actual time=1,791,287.018..1,791,296.705 rows=16,878 loops=1)

  • Sort Key: base.id
  • Sort Method: quicksort Memory: 50966kB
2. 126.844 1,791,004.120 ↓ 4,219.5 16,878 1

Nested Loop Left Join (cost=276,210.81..473,796.20 rows=4 width=1,489) (actual time=8,658.779..1,791,004.120 rows=16,878 loops=1)

3. 50.334 1,790,725.374 ↓ 4,219.5 16,878 1

Hash Left Join (cost=276,210.39..473,779.62 rows=4 width=1,122) (actual time=8,658.001..1,790,725.374 rows=16,878 loops=1)

  • Hash Cond: (course.id = course_11.joinid)
4. 62.228 1,790,286.641 ↓ 4,219.5 16,878 1

Nested Loop Left Join (cost=265,084.80..462,651.35 rows=4 width=1,058) (actual time=8,269.535..1,790,286.641 rows=16,878 loops=1)

5. 47.636 1,788,452.223 ↓ 8,439.0 16,878 1

Hash Left Join (cost=265,084.38..462,646.55 rows=2 width=1,058) (actual time=8,268.690..1,788,452.223 rows=16,878 loops=1)

  • Hash Cond: (course.id = course_8.joinid)
6. 62.492 1,788,140.430 ↓ 8,439.0 16,878 1

Hash Left Join (cost=254,167.35..451,728.23 rows=2 width=994) (actual time=8,004.363..1,788,140.430 rows=16,878 loops=1)

  • Hash Cond: (course.id = course_24.joinid)
7. 47.313 1,787,813.962 ↓ 8,439.0 16,878 1

Nested Loop Left Join (cost=245,131.59..442,691.62 rows=2 width=930) (actual time=7,740.377..1,787,813.962 rows=16,878 loops=1)

8. 107.454 1,787,699.137 ↓ 8,439.0 16,878 1

Nested Loop Left Join (cost=245,131.17..442,686.39 rows=2 width=771) (actual time=7,740.373..1,787,699.137 rows=16,878 loops=1)

9. 913,025.572 1,786,882.807 ↓ 8,439.0 16,878 1

Nested Loop Left Join (cost=245,130.74..442,681.15 rows=2 width=612) (actual time=7,740.363..1,786,882.807 rows=16,878 loops=1)

  • Join Filter: (user_2.joinid = auser.id)
  • Rows Removed by Join Filter: 1978650733
10. 45.049 14,463.231 ↓ 8,439.0 16,878 1

Nested Loop Left Join (cost=179,473.24..357,774.67 rows=2 width=548) (actual time=5,470.914..14,463.231 rows=16,878 loops=1)

11. 47.875 14,232.524 ↓ 8,439.0 16,878 1

Nested Loop Left Join (cost=179,472.95..357,770.61 rows=2 width=546) (actual time=5,470.904..14,232.524 rows=16,878 loops=1)

12. 46.048 13,661.431 ↓ 16,878.0 16,878 1

Nested Loop Left Join (cost=179,472.52..357,671.18 rows=1 width=547) (actual time=5,470.880..13,661.431 rows=16,878 loops=1)

13. 61.542 13,547.871 ↓ 16,878.0 16,878 1

Nested Loop (cost=179,472.10..357,666.49 rows=1 width=523) (actual time=5,470.582..13,547.871 rows=16,878 loops=1)

14. 59.318 13,283.793 ↓ 16,878.0 16,878 1

Nested Loop Left Join (cost=179,471.82..357,664.11 rows=1 width=482) (actual time=5,470.071..13,283.793 rows=16,878 loops=1)

15. 52.113 13,055.695 ↓ 16,878.0 16,878 1

Nested Loop Left Join (cost=179,471.38..357,564.68 rows=1 width=475) (actual time=5,470.041..13,055.695 rows=16,878 loops=1)

16. 59.304 12,834.802 ↓ 16,878.0 16,878 1

Nested Loop Left Join (cost=179,470.95..357,465.24 rows=1 width=468) (actual time=5,469.656..12,834.802 rows=16,878 loops=1)

17. 54.002 12,606.718 ↓ 16,878.0 16,878 1

Nested Loop (cost=179,470.51..357,365.81 rows=1 width=461) (actual time=5,469.640..12,606.718 rows=16,878 loops=1)

  • Join Filter: (organisation.id = org_type_15.organisationid)
18. 55.774 11,826.962 ↓ 24.4 16,878 1

Hash Left Join (cost=179,470.08..288,446.40 rows=693 width=477) (actual time=5,469.589..11,826.962 rows=16,878 loops=1)

  • Hash Cond: (local_order_item_event.signupid = signups.id)
19. 49.464 10,735.377 ↓ 25.7 16,878 1

Nested Loop Left Join (cost=160,361.44..247,021.91 rows=656 width=477) (actual time=4,430.378..10,735.377 rows=16,878 loops=1)

20. 55.482 8,458.017 ↓ 25.7 16,878 1

Nested Loop Left Join (cost=160,361.00..181,792.89 rows=656 width=470) (actual time=4,425.726..8,458.017 rows=16,878 loops=1)

21. 40.128 8,064.975 ↓ 25.7 16,878 1

Hash Left Join (cost=160,360.58..180,290.17 rows=656 width=425) (actual time=4,425.684..8,064.975 rows=16,878 loops=1)

  • Hash Cond: (local_order_payment.classid = seatreservationitem.id)
  • Join Filter: ((local_order_payment.class)::text = 'promotion'::text)
  • Rows Removed by Join Filter: 835
22. 37.573 7,965.935 ↓ 25.7 16,878 1

Hash Left Join (cost=159,195.87..179,123.74 rows=656 width=432) (actual time=4,366.320..7,965.935 rows=16,878 loops=1)

  • Hash Cond: (COALESCE(sessions.roomid, event.roomid) = studio_hierarchy.roomid)
23. 60.563 7,924.861 ↓ 25.7 16,878 1

Nested Loop Left Join (cost=159,104.13..179,022.98 rows=656 width=440) (actual time=4,362.786..7,924.861 rows=16,878 loops=1)

24. 41.797 7,763.030 ↓ 25.7 16,878 1

Hash Join (cost=159,103.71..177,515.25 rows=656 width=416) (actual time=4,362.769..7,763.030 rows=16,878 loops=1)

  • Hash Cond: (event.facetofaceid = facetoface.id)
25. 37.539 7,711.669 ↓ 25.5 16,994 1

Hash Left Join (cost=158,793.40..177,203.19 rows=667 width=390) (actual time=4,353.176..7,711.669 rows=16,994 loops=1)

  • Hash Cond: (base.itemclassid = session_role_user_teacher.sessionid)
26. 42.160 7,229.536 ↓ 28.8 16,994 1

Nested Loop Left Join (cost=138,166.26..156,574.50 rows=591 width=358) (actual time=3,908.452..7,229.536 rows=16,994 loops=1)

27. 64.667 7,170.382 ↓ 28.8 16,994 1

Nested Loop Left Join (cost=138,165.97..155,340.83 rows=591 width=358) (actual time=3,908.449..7,170.382 rows=16,994 loops=1)

28. 182.362 6,510.925 ↓ 28.8 16,994 1

Hash Join (cost=138,165.68..154,107.16 rows=591 width=358) (actual time=3,908.441..6,510.925 rows=16,994 loops=1)

  • Hash Cond: (base.shiptoorgid = organisation.id)
29. 315.703 3,996.758 ↑ 1.0 299,545 1

Hash Left Join (cost=44,967.97..59,767.46 rows=302,955 width=239) (actual time=1,575.889..3,996.758 rows=299,545 loops=1)

  • Hash Cond: (base.itemclassid = facetoface_sessions_dates.sessionid)
30. 271.937 3,351.526 ↑ 1.0 299,545 1

Hash Left Join (cost=34,895.44..48,899.34 rows=302,955 width=207) (actual time=1,246.334..3,351.526 rows=299,545 loops=1)

  • Hash Cond: (base.prospectid = prospect.id)
31. 314.335 3,079.221 ↑ 1.0 299,545 1

Hash Left Join (cost=34,884.38..48,093.02 rows=302,955 width=170) (actual time=1,245.945..3,079.221 rows=299,545 loops=1)

  • Hash Cond: (base.paymentid = local_order_payment.id)
32. 304.510 2,164.592 ↑ 1.0 299,545 1

Hash Left Join (cost=19,506.52..31,919.89 rows=302,955 width=155) (actual time=639.038..2,164.592 rows=299,545 loops=1)

  • Hash Cond: (base.itemclassid = sessions.id)
33. 319.268 1,824.161 ↑ 1.0 299,545 1

Hash Join (cost=18,352.54..29,970.52 rows=302,955 width=147) (actual time=602.900..1,824.161 rows=299,545 loops=1)

  • Hash Cond: (base.itemclassid = event.sessionid)
34. 318.016 1,470.475 ↑ 1.0 299,545 1

Hash Left Join (cost=17,383.52..24,835.87 rows=302,955 width=131) (actual time=568.122..1,470.475 rows=299,545 loops=1)

  • Hash Cond: (base.orderid = local_order.id)
35. 385.373 977.824 ↑ 1.0 299,545 1

Hash Right Join (cost=12,588.63..19,245.70 rows=302,955 width=112) (actual time=392.138..977.824 rows=299,545 loops=1)

  • Hash Cond: (local_order_item_event.orderlineid = base.id)
36. 204.212 204.212 ↑ 1.0 299,552 1

Seq Scan on mdl_local_order_item_event local_order_item_event (cost=0.00..5,861.75 rows=302,975 width=24) (actual time=0.026..204.212 rows=299,552 loops=1)

37. 192.232 388.239 ↑ 1.0 282,802 1

Hash (cost=9,053.02..9,053.02 rows=282,849 width=96) (actual time=388.239..388.239 rows=282,802 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 36688kB
38. 196.007 196.007 ↑ 1.0 282,802 1

Seq Scan on mdl_local_order_items base (cost=0.00..9,053.02 rows=282,849 width=96) (actual time=0.093..196.007 rows=282,802 loops=1)

  • Filter: ((bookingstatus <> 10) AND ((itemclass)::text = 'event'::text))
  • Rows Removed by Filter: 7
39. 73.602 174.635 ↑ 1.0 123,223 1

Hash (cost=3,253.84..3,253.84 rows=123,284 width=35) (actual time=174.635..174.635 rows=123,223 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 9688kB
40. 101.033 101.033 ↑ 1.0 123,223 1

Seq Scan on mdl_local_order local_order (cost=0.00..3,253.84 rows=123,284 width=35) (actual time=0.086..101.033 rows=123,223 loops=1)

41. 14.495 34.418 ↑ 1.0 27,823 1

Hash (cost=621.23..621.23 rows=27,823 width=24) (actual time=34.418..34.418 rows=27,823 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1774kB
42. 19.923 19.923 ↑ 1.0 27,823 1

Seq Scan on mdl_local_event event (cost=0.00..621.23 rows=27,823 width=24) (actual time=0.043..19.923 rows=27,823 loops=1)

43. 12.301 35.921 ↑ 1.0 24,399 1

Hash (cost=848.99..848.99 rows=24,399 width=16) (actual time=35.921..35.921 rows=24,399 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1400kB
44. 23.620 23.620 ↑ 1.0 24,399 1

Seq Scan on mdl_facetoface_sessions sessions (cost=0.00..848.99 rows=24,399 width=16) (actual time=0.020..23.620 rows=24,399 loops=1)

45. 303.210 600.294 ↑ 1.0 531,683 1

Hash (cost=8,731.83..8,731.83 rows=531,683 width=23) (actual time=600.294..600.294 rows=531,683 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 36834kB
46. 297.084 297.084 ↑ 1.0 531,683 1

Seq Scan on mdl_local_order_payment local_order_payment (cost=0.00..8,731.83 rows=531,683 width=23) (actual time=0.116..297.084 rows=531,683 loops=1)

47. 0.147 0.368 ↑ 1.0 269 1

Hash (cost=7.69..7.69 rows=269 width=45) (actual time=0.367..0.368 rows=269 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
48. 0.221 0.221 ↑ 1.0 269 1

Seq Scan on mdl_local_prospects prospect (cost=0.00..7.69 rows=269 width=45) (actual time=0.021..0.221 rows=269 loops=1)

49. 14.712 329.529 ↓ 139.1 27,823 1

Hash (cost=10,070.03..10,070.03 rows=200 width=40) (actual time=329.529..329.529 rows=27,823 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1812kB
50. 23.226 314.817 ↓ 139.1 27,823 1

Subquery Scan on facetoface_sessions_dates (cost=10,016.03..10,070.03 rows=200 width=40) (actual time=213.945..314.817 rows=27,823 loops=1)

51. 193.244 291.591 ↓ 139.1 27,823 1

HashAggregate (cost=10,016.03..10,068.03 rows=200 width=40) (actual time=213.943..291.591 rows=27,823 loops=1)

  • Group Key: mdl_facetoface_sessions_dates.sessionid
52. 39.130 98.347 ↑ 1.0 30,905 1

HashAggregate (cost=1,517.16..1,826.21 rows=30,905 width=40) (actual time=80.317..98.347 rows=30,905 loops=1)

  • Group Key: mdl_facetoface_sessions_dates.sessionid, ((mdl_facetoface_sessions_dates.timestart)::text)
53. 22.350 59.217 ↑ 1.0 30,905 1

Append (cost=0.00..1,362.63 rows=30,905 width=40) (actual time=0.086..59.217 rows=30,905 loops=1)

54. 20.081 20.081 ↑ 1.0 26,918 1

Seq Scan on mdl_facetoface_sessions_dates (cost=0.00..639.77 rows=26,918 width=40) (actual time=0.084..20.081 rows=26,918 loops=1)

55. 16.786 16.786 ↑ 1.0 3,987 1

Seq Scan on mdl_local_core_snapshots lcsfsd (cost=0.00..413.81 rows=3,987 width=40) (actual time=1.688..16.786 rows=3,987 loops=1)

  • Filter: ((tablename)::text = 'facetoface_sessions_dates'::text)
  • Rows Removed by Filter: 4566
56. 22.498 2,331.805 ↓ 43.4 18,394 1

Hash (cost=93,192.41..93,192.41 rows=424 width=119) (actual time=2,331.805..2,331.805 rows=18,394 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2085kB
57. 24.876 2,309.307 ↓ 43.4 18,394 1

Nested Loop (cost=4,196.65..93,192.41 rows=424 width=119) (actual time=54.553..2,309.307 rows=18,394 loops=1)

58. 14.927 1,898.157 ↓ 43.4 18,394 1

Nested Loop (cost=4,196.23..90,126.91 rows=424 width=79) (actual time=53.771..1,898.157 rows=18,394 loops=1)

59. 0.008 0.206 ↑ 1.0 1 1

Nested Loop (cost=0.00..6.05 rows=1 width=64) (actual time=0.159..0.206 rows=1 loops=1)

60. 0.141 0.141 ↑ 1.0 1 1

Seq Scan on mdl_course_info_field course_27_fielddefault (cost=0.00..4.42 rows=1 width=32) (actual time=0.099..0.141 rows=1 loops=1)

  • Filter: (id = 27)
  • Rows Removed by Filter: 33
61. 0.057 0.057 ↑ 1.0 1 1

Seq Scan on mdl_org_type_info_field org_type_27_fielddefault (cost=0.00..1.61 rows=1 width=32) (actual time=0.053..0.057 rows=1 loops=1)

  • Filter: (id = 27)
  • Rows Removed by Filter: 48
62. 1,842.134 1,883.024 ↓ 43.4 18,394 1

Bitmap Heap Scan on mdl_org_type_info_data salesarea (cost=4,196.23..90,116.62 rows=424 width=15) (actual time=53.597..1,883.024 rows=18,394 loops=1)

  • Recheck Cond: (fieldid = 15)
  • Filter: (data = '1041'::text)
  • Rows Removed by Filter: 198026
  • Heap Blocks: exact=76882
63. 40.890 40.890 ↑ 1.0 216,420 1

Bitmap Index Scan on mdl_org_type_info_data_import_fieldid_idx (cost=0.00..4,196.13 rows=227,159 width=0) (actual time=40.889..40.890 rows=216,420 loops=1)

  • Index Cond: (fieldid = 15)
64. 386.274 386.274 ↑ 1.0 1 18,394

Index Scan using mdl_org_import_pkey on mdl_org organisation (cost=0.42..7.23 rows=1 width=40) (actual time=0.021..0.021 rows=1 loops=18,394)

  • Index Cond: (id = salesarea.organisationid)
65. 594.790 594.790 ↑ 1.0 1 16,994

Index Scan using mdl_locaordeinvo_id_pk on mdl_local_order_invoice invoice (cost=0.29..2.09 rows=1 width=16) (actual time=0.035..0.035 rows=1 loops=16,994)

  • Index Cond: (id = base.invoiceid)
66. 16.994 16.994 ↓ 0.0 0 16,994

Index Scan using mdl_locaordeinvo_id_pk on mdl_local_order_invoice credit (cost=0.29..2.09 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=16,994)

  • Index Cond: (id = base.creditid)
67. 6.527 444.594 ↓ 1.0 11,768 1

Hash (cost=20,480.05..20,480.05 rows=11,767 width=40) (actual time=444.594..444.594 rows=11,768 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 784kB
68. 8.987 438.067 ↓ 1.0 11,768 1

Subquery Scan on session_role_user_teacher (cost=17,302.96..20,480.05 rows=11,767 width=40) (actual time=399.054..438.067 rows=11,768 loops=1)

69. 80.389 429.080 ↓ 1.0 11,768 1

HashAggregate (cost=17,302.96..20,362.38 rows=11,767 width=40) (actual time=399.052..429.080 rows=11,768 loops=1)

  • Group Key: roles.sessionid
70. 14.601 348.691 ↑ 1.0 12,457 1

Hash Join (cost=13,565.53..13,846.14 rows=12,457 width=23) (actual time=328.869..348.691 rows=12,457 loops=1)

  • Hash Cond: (roles.userid = u.id)
71. 7.324 7.324 ↑ 1.0 12,457 1

Seq Scan on mdl_facetoface_session_roles roles (cost=0.00..247.91 rows=12,457 width=16) (actual time=0.037..7.324 rows=12,457 loops=1)

  • Filter: (roleid = 4)
  • Rows Removed by Filter: 16
72. 80.437 326.766 ↑ 1.0 131,668 1

Hash (cost=11,919.68..11,919.68 rows=131,668 width=23) (actual time=326.766..326.766 rows=131,668 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 9250kB
73. 246.329 246.329 ↑ 1.0 131,668 1

Seq Scan on mdl_user u (cost=0.00..11,919.68 rows=131,668 width=23) (actual time=1.842..246.329 rows=131,668 loops=1)

74. 2.347 9.564 ↑ 1.0 3,925 1

Hash (cost=261.25..261.25 rows=3,925 width=42) (actual time=9.563..9.564 rows=3,925 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 331kB
75. 7.217 7.217 ↑ 1.0 3,925 1

Seq Scan on mdl_facetoface facetoface (cost=0.00..261.25 rows=3,925 width=42) (actual time=0.064..7.217 rows=3,925 loops=1)

76. 101.268 101.268 ↑ 1.0 1 16,878

Index Scan using mdl_org_import_pkey on mdl_org reporganisation (cost=0.42..2.30 rows=1 width=40) (actual time=0.006..0.006 rows=1 loops=16,878)

  • Index Cond: (id = local_order.bookerorgid)
77. 1.401 3.501 ↑ 1.0 3,144 1

Hash (cost=52.44..52.44 rows=3,144 width=16) (actual time=3.501..3.501 rows=3,144 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 180kB
78. 2.100 2.100 ↑ 1.0 3,144 1

Seq Scan on mdl_local_studio_hierarchy studio_hierarchy (cost=0.00..52.44 rows=3,144 width=16) (actual time=0.075..2.100 rows=3,144 loops=1)

79. 19.868 58.912 ↑ 1.0 34,387 1

Hash (cost=734.87..734.87 rows=34,387 width=16) (actual time=58.911..58.912 rows=34,387 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2124kB
80. 39.044 39.044 ↑ 1.0 34,387 1

Seq Scan on mdl_local_seat_rsrv_iface_order_items seatreservationitem (cost=0.00..734.87 rows=34,387 width=16) (actual time=0.026..39.044 rows=34,387 loops=1)

81. 337.560 337.560 ↓ 0.0 0 16,878

Index Scan using dt_user_pkey on mdl_user auser (cost=0.42..2.29 rows=1 width=53) (actual time=0.020..0.020 rows=0 loops=16,878)

  • Index Cond: (id = local_order_item_event.userid)
82. 2,227.896 2,227.896 ↑ 2.0 1 16,878

Index Scan using mdl_org_type_info_data_import_organisationid_idx on mdl_org_type_info_data org_type_35 (cost=0.43..99.41 rows=2 width=15) (actual time=0.127..0.132 rows=1 loops=16,878)

  • Index Cond: (organisationid = organisation.id)
  • Filter: (fieldid = 35)
  • Rows Removed by Filter: 47
83. 156.294 1,035.811 ↑ 1.0 268,940 1

Hash (cost=15,708.09..15,708.09 rows=272,044 width=8) (actual time=1,035.811..1,035.811 rows=268,940 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 14602kB
84. 207.854 879.517 ↑ 1.0 268,940 1

Subquery Scan on signups (cost=10,267.21..15,708.09 rows=272,044 width=8) (actual time=511.025..879.517 rows=268,940 loops=1)

85. 340.422 671.663 ↑ 1.0 268,940 1

HashAggregate (cost=10,267.21..12,987.65 rows=272,044 width=24) (actual time=511.024..671.663 rows=268,940 loops=1)

  • Group Key: mdl_facetoface_signups.id, mdl_facetoface_signups.sessionid, mdl_facetoface_signups.userid
86. 187.772 331.241 ↑ 1.0 268,940 1

Append (cost=0.00..8,226.88 rows=272,044 width=24) (actual time=0.063..331.241 rows=268,940 loops=1)

87. 139.431 139.431 ↑ 1.0 262,368 1

Seq Scan on mdl_facetoface_signups (cost=0.00..5,391.72 rows=265,472 width=24) (actual time=0.062..139.431 rows=262,368 loops=1)

88. 4.038 4.038 ↑ 1.0 6,572 1

Seq Scan on mdl_local_f2f_deleted_signups (cost=0.00..114.72 rows=6,572 width=24) (actual time=0.045..4.038 rows=6,572 loops=1)

89. 725.754 725.754 ↑ 1.0 1 16,878

Index Scan using mdl_org_type_info_data_import_organisationid_idx on mdl_org_type_info_data org_type_15 (cost=0.43..99.44 rows=1 width=8) (actual time=0.021..0.043 rows=1 loops=16,878)

  • Index Cond: (organisationid = base.shiptoorgid)
  • Filter: ((data ~~* '%1041%'::text) AND (fieldid = 15))
  • Rows Removed by Filter: 47
90. 168.780 168.780 ↑ 2.0 1 16,878

Index Scan using mdl_org_type_info_data_import_organisationid_idx on mdl_org_type_info_data org_type_7 (cost=0.43..99.41 rows=2 width=15) (actual time=0.006..0.010 rows=1 loops=16,878)

  • Index Cond: (organisationid = organisation.id)
  • Filter: (fieldid = 7)
  • Rows Removed by Filter: 47
91. 168.780 168.780 ↑ 2.0 1 16,878

Index Scan using mdl_org_type_info_data_import_organisationid_idx on mdl_org_type_info_data org_type_4 (cost=0.43..99.41 rows=2 width=15) (actual time=0.006..0.010 rows=1 loops=16,878)

  • Index Cond: (organisationid = organisation.id)
  • Filter: (fieldid = 4)
  • Rows Removed by Filter: 47
92. 168.780 168.780 ↑ 2.0 1 16,878

Index Scan using mdl_org_type_info_data_import_organisationid_idx on mdl_org_type_info_data org_type_27 (cost=0.43..99.41 rows=2 width=15) (actual time=0.005..0.010 rows=1 loops=16,878)

  • Index Cond: (organisationid = organisation.id)
  • Filter: (fieldid = 27)
  • Rows Removed by Filter: 47
93. 202.536 202.536 ↑ 1.0 1 16,878

Index Scan using mdl_cour_id_pk on mdl_course course (cost=0.28..2.38 rows=1 width=49) (actual time=0.012..0.012 rows=1 loops=16,878)

  • Index Cond: (id = facetoface.course)
94. 67.512 67.512 ↑ 1.0 1 16,878

Index Scan using mdl_org_import_pkey on mdl_org studio (cost=0.42..4.69 rows=1 width=40) (actual time=0.004..0.004 rows=1 loops=16,878)

  • Index Cond: (id = studio_hierarchy.orgid)
95. 523.218 523.218 ↑ 2.0 1 16,878

Index Scan using mdl_org_type_info_data_import_organisationid_idx on mdl_org_type_info_data org_type_6 (cost=0.43..99.41 rows=2 width=15) (actual time=0.005..0.031 rows=1 loops=16,878)

  • Index Cond: (organisationid = organisation.id)
  • Filter: (fieldid = 6)
  • Rows Removed by Filter: 47
96. 185.658 185.658 ↓ 0.0 0 16,878

Index Scan using mdl_locaseatrsrvifacorde_id_pk on mdl_local_seat_rsrv_iface_orders seatreservationorder (cost=0.29..2.03 rows=1 width=18) (actual time=0.011..0.011 rows=0 loops=16,878)

  • Index Cond: (id = seatreservationitem.orderid)
97. 857,466.396 859,394.004 ↓ 1.8 117,233 16,878

Materialize (cost=65,657.50..83,156.58 rows=63,633 width=72) (actual time=0.089..50.918 rows=117,233 loops=16,878)

98. 89.655 1,927.608 ↓ 1.8 117,233 1

Subquery Scan on user_2 (cost=65,657.50..82,838.41 rows=63,633 width=72) (actual time=1,489.292..1,927.608 rows=117,233 loops=1)

99. 1,092.271 1,837.953 ↓ 1.8 117,233 1

HashAggregate (cost=65,657.50..82,202.08 rows=63,633 width=72) (actual time=1,489.290..1,837.953 rows=117,233 loops=1)

  • Group Key: cfid.userid, (cfid.data)::character varying
100. 146.588 745.682 ↓ 1.0 117,240 1

Hash Right Join (cost=33,302.25..35,876.05 rows=116,790 width=72) (actual time=533.438..745.682 rows=117,240 loops=1)

  • Hash Cond: (cfidp.dataid = cfid.id)
101. 66.784 66.784 ↑ 1.0 112,301 1

Seq Scan on mdl_user_info_data_param cfidp (cost=0.00..2,279.01 rows=112,301 width=40) (actual time=0.057..66.784 rows=112,301 loops=1)

102. 206.743 532.310 ↓ 1.0 117,233 1

Hash (cost=31,842.38..31,842.38 rows=116,790 width=175) (actual time=532.310..532.310 rows=117,233 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 128373kB
103. 325.567 325.567 ↓ 1.0 117,233 1

Seq Scan on mdl_user_info_data cfid (cost=0.00..31,842.38 rows=116,790 width=175) (actual time=0.040..325.567 rows=117,233 loops=1)

  • Filter: (fieldid = 2)
  • Rows Removed by Filter: 685997
104. 708.876 708.876 ↓ 0.0 0 16,878

Index Scan using mdl_userinfodata_usefie_uix on mdl_user_info_data user_10 (cost=0.42..2.62 rows=1 width=167) (actual time=0.042..0.042 rows=0 loops=16,878)

  • Index Cond: ((userid = auser.id) AND (fieldid = 10))
105. 67.512 67.512 ↓ 0.0 0 16,878

Index Scan using mdl_userinfodata_usefie_uix on mdl_user_info_data user_60 (cost=0.42..2.62 rows=1 width=167) (actual time=0.004..0.004 rows=0 loops=16,878)

  • Index Cond: ((userid = auser.id) AND (fieldid = 60))
106. 2.383 263.976 ↓ 1.2 3,894 1

Hash (cost=8,993.85..8,993.85 rows=3,353 width=72) (actual time=263.976..263.976 rows=3,894 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 525kB
107. 3.064 261.593 ↓ 1.2 3,894 1

Subquery Scan on course_24 (cost=8,088.54..8,993.85 rows=3,353 width=72) (actual time=248.604..261.593 rows=3,894 loops=1)

108. 26.245 258.529 ↓ 1.2 3,894 1

HashAggregate (cost=8,088.54..8,960.32 rows=3,353 width=72) (actual time=248.602..258.529 rows=3,894 loops=1)

  • Group Key: cfid_1.courseid, (cfid_1.data)::character varying
109. 28.359 232.284 ↓ 1.0 3,894 1

Hash Right Join (cost=5,721.80..7,129.23 rows=3,762 width=73) (actual time=174.703..232.284 rows=3,894 loops=1)

  • Hash Cond: (cfidp_1.dataid = cfid_1.id)
110. 29.267 29.267 ↓ 1.0 61,345 1

Seq Scan on mdl_course_info_data_param cfidp_1 (cost=0.00..1,246.41 rows=61,341 width=41) (actual time=0.032..29.267 rows=61,345 loops=1)

111. 3.438 174.658 ↓ 1.0 3,894 1

Hash (cost=5,674.77..5,674.77 rows=3,762 width=296) (actual time=174.658..174.658 rows=3,894 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 429kB
112. 168.980 171.220 ↓ 1.0 3,894 1

Bitmap Heap Scan on mdl_course_info_data cfid_1 (cost=73.58..5,674.77 rows=3,762 width=296) (actual time=2.526..171.220 rows=3,894 loops=1)

  • Recheck Cond: (fieldid = 24)
  • Heap Blocks: exact=2553
113. 2.240 2.240 ↓ 1.0 3,894 1

Bitmap Index Scan on mdl_courinfodata_fie_ix (cost=0.00..72.64 rows=3,762 width=0) (actual time=2.240..2.240 rows=3,894 loops=1)

  • Index Cond: (fieldid = 24)
114. 4.477 264.157 ↓ 1.3 6,385 1

Hash (cost=10,853.86..10,853.86 rows=5,054 width=72) (actual time=264.156..264.157 rows=6,385 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1294kB
115. 4.972 259.680 ↓ 1.3 6,385 1

Subquery Scan on course_8 (cost=9,489.28..10,853.86 rows=5,054 width=72) (actual time=238.337..259.680 rows=6,385 loops=1)

116. 54.780 254.708 ↓ 1.3 6,385 1

HashAggregate (cost=9,489.28..10,803.32 rows=5,054 width=72) (actual time=238.336..254.708 rows=6,385 loops=1)

  • Group Key: cfid_2.courseid, (cfid_2.data)::character varying
117. 34.842 199.928 ↓ 1.1 6,835 1

Hash Right Join (cost=6,531.70..7,939.13 rows=6,079 width=73) (actual time=137.209..199.928 rows=6,835 loops=1)

  • Hash Cond: (cfidp_2.dataid = cfid_2.id)
118. 27.960 27.960 ↓ 1.0 61,345 1

Seq Scan on mdl_course_info_data_param cfidp_2 (cost=0.00..1,246.41 rows=61,341 width=41) (actual time=0.021..27.960 rows=61,345 loops=1)

119. 5.514 137.126 ↓ 1.1 6,385 1

Hash (cost=6,455.72..6,455.72 rows=6,079 width=296) (actual time=137.126..137.126 rows=6,385 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1126kB
120. 129.448 131.612 ↓ 1.1 6,385 1

Bitmap Heap Scan on mdl_course_info_data cfid_2 (cost=115.53..6,455.72 rows=6,079 width=296) (actual time=2.526..131.612 rows=6,385 loops=1)

  • Recheck Cond: (fieldid = 8)
  • Heap Blocks: exact=3340
121. 2.164 2.164 ↓ 1.1 6,385 1

Bitmap Index Scan on mdl_courinfodata_fie_ix (cost=0.00..114.01 rows=6,079 width=0) (actual time=2.164..2.164 rows=6,385 loops=1)

  • Index Cond: (fieldid = 8)
122. 1,772.190 1,772.190 ↑ 2.0 1 16,878

Index Scan using mdl_facesignstat_sig_ix on mdl_facetoface_signups_status status (cost=0.42..2.38 rows=2 width=16) (actual time=0.101..0.105 rows=1 loops=16,878)

  • Index Cond: (signupid = signups.id)
  • Filter: (superceded = 0)
  • Rows Removed by Filter: 0
123. 10.658 388.399 ↓ 1.2 6,385 1

Hash (cost=11,059.56..11,059.56 rows=5,282 width=72) (actual time=388.399..388.399 rows=6,385 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 6888kB
124. 4.923 377.741 ↓ 1.2 6,385 1

Subquery Scan on course_11 (cost=9,633.42..11,059.56 rows=5,282 width=72) (actual time=352.473..377.741 rows=6,385 loops=1)

125. 216.132 372.818 ↓ 1.2 6,385 1

HashAggregate (cost=9,633.42..11,006.74 rows=5,282 width=72) (actual time=352.471..372.818 rows=6,385 loops=1)

  • Group Key: cfid_3.courseid, (cfid_3.data)::character varying
126. 36.533 156.686 ↓ 1.9 12,255 1

Hash Right Join (cost=6,589.40..7,996.83 rows=6,418 width=73) (actual time=96.479..156.686 rows=12,255 loops=1)

  • Hash Cond: (cfidp_3.dataid = cfid_3.id)
127. 23.752 23.752 ↓ 1.0 61,345 1

Seq Scan on mdl_course_info_data_param cfidp_3 (cost=0.00..1,246.41 rows=61,341 width=41) (actual time=0.021..23.752 rows=61,345 loops=1)

128. 11.196 96.401 ↑ 1.0 6,385 1

Hash (cost=6,509.17..6,509.17 rows=6,418 width=296) (actual time=96.401..96.401 rows=6,385 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 6520kB
129. 82.861 85.205 ↑ 1.0 6,385 1

Bitmap Heap Scan on mdl_course_info_data cfid_3 (cost=122.16..6,509.17 rows=6,418 width=296) (actual time=2.721..85.205 rows=6,385 loops=1)

  • Recheck Cond: (fieldid = 11)
  • Heap Blocks: exact=3697
130. 2.344 2.344 ↑ 1.0 6,386 1

Bitmap Index Scan on mdl_courinfodata_fie_ix (cost=0.00..120.55 rows=6,418 width=0) (actual time=2.343..2.344 rows=6,386 loops=1)

  • Index Cond: (fieldid = 11)
131. 151.902 151.902 ↑ 1.0 1 16,878

Index Scan using mdl_courinfodata_fiecou_uix on mdl_course_info_data course_27 (cost=0.42..4.12 rows=1 width=288) (actual time=0.009..0.009 rows=1 loops=16,878)

  • Index Cond: ((fieldid = 27) AND (courseid = course.id))
Planning time : 434.848 ms
Execution time : 1,791,389.162 ms