explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZN9x

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 10,335.200 118,226.072 ↑ 12.9 61,489 1

GroupAggregate (cost=24,838,037.97..77,382,960.85 rows=793,986 width=380) (actual time=89,337.753..118,226.072 rows=61,489 loops=1)

  • Group Key: cu.id, ces.id, cf.fid, st.id, tm.id, cr.id, sh.id
2.          

CTE fd

3. 0.251 2.457 ↑ 1.0 1 1

Aggregate (cost=2,309.71..2,309.72 rows=1 width=8) (actual time=2.456..2.457 rows=1 loops=1)

4. 2.206 2.206 ↑ 1.0 297 1

Seq Scan on students_list_bck (cost=0.00..2,308.97 rows=297 width=8) (actual time=0.017..2.206 rows=297 loops=1)

5.          

Initplan (for GroupAggregate)

6. 2.461 2.461 ↑ 1.0 1 1

CTE Scan on fd (cost=0.00..0.02 rows=1 width=8) (actual time=2.460..2.461 rows=1 loops=1)

7. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on fd fd_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

8. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on fd fd_2 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

9. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on fd fd_3 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

10. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on fd fd_4 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=1)

11. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on fd fd_5 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

12. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on fd fd_6 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

13. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on fd fd_7 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

14. 15,568.357 93,745.930 ↓ 4.7 3,703,700 1

Sort (cost=24,835,728.09..24,837,713.05 rows=793,986 width=380) (actual time=89,337.329..93,745.930 rows=3,703,700 loops=1)

  • Sort Key: cu.id, ces.id, cf.fid, st.id, tm.id, cr.id, sh.id
  • Sort Method: external merge Disk: 1155456kB
15. 7,337.927 78,177.573 ↓ 4.7 3,703,700 1

Nested Loop Left Join (cost=399,234.61..24,619,514.90 rows=793,986 width=380) (actual time=18,239.787..78,177.573 rows=3,703,700 loops=1)

16. 7,068.957 30,145.058 ↓ 14.0 3,699,508 1

Merge Right Join (cost=399,225.10..411,954.76 rows=264,662 width=376) (actual time=18,239.748..30,145.058 rows=3,699,508 loops=1)

  • Merge Cond: ((sbd.user_id = (COALESCE(pd1.user_id, pd2.user_id))) AND (acd.sis_id = ((cr.sis_fid)::text)) AND (tmd.sis_id = ((tm.sis_fid)::text)))
  • Filter: ((COALESCE(pd1.updated_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $6) OR (COALESCE(pd2.updated_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $7) OR (st.updated_at > $8) OR (COALESCE(en.updated_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $9) OR (COALESCE(ese.updated_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $10) OR (COALESCE(sbd.created_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $11) OR (COALESCE(asd.created_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $12) OR (COALESCE(crd.created_at, '2000-01-01 00:00:00+01'::timestamp with time zone) > $13))
  • Rows Removed by Filter: 4718
17. 5,433.855 17,092.022 ↓ 3.8 1,223,617 1

Sort (cost=299,207.09..300,011.74 rows=321,861 width=84) (actual time=14,777.115..17,092.022 rows=1,223,617 loops=1)

  • Sort Key: sbd.user_id, acd.sis_id, tmd.sis_id
  • Sort Method: external merge Disk: 108272kB
18. 4,770.419 11,658.167 ↓ 3.8 1,223,617 1

Hash Join (cost=109,507.06..254,359.62 rows=321,861 width=84) (actual time=4,450.420..11,658.167 rows=1,223,617 loops=1)

  • Hash Cond: (sbf.submission_id = sbd.id)
19. 2,437.571 2,437.571 ↑ 1.0 4,873,887 1

Seq Scan on raw_submissions_facts sbf (cost=0.00..71,357.87 rows=4,873,887 width=16) (actual time=0.010..2,437.571 rows=4,873,887 loops=1)

20. 1,044.353 4,450.177 ↓ 3.8 1,223,617 1

Hash (cost=101,082.80..101,082.80 rows=321,861 width=84) (actual time=4,450.177..4,450.177 rows=1,223,617 loops=1)

  • Buckets: 262144 (originally 262144) Batches: 8 (originally 2) Memory Usage: 30721kB
21. 1,323.097 3,405.824 ↓ 3.8 1,223,617 1

Nested Loop (cost=217.19..101,082.80 rows=321,861 width=84) (actual time=6.998..3,405.824 rows=1,223,617 loops=1)

22. 10.880 56.164 ↓ 2.4 9,339 1

Hash Join (cost=216.76..3,373.58 rows=3,870 width=42) (actual time=6.977..56.164 rows=9,339 loops=1)

  • Hash Cond: (asd.course_id = crd.id)
23. 14.599 41.009 ↓ 1.6 9,339 1

Hash Join (cost=131.75..3,227.50 rows=5,966 width=32) (actual time=2.697..41.009 rows=9,339 loops=1)

  • Hash Cond: (asd.assignment_group_id = agf.assignment_group_id)
24. 23.726 23.726 ↓ 1.0 16,126 1

Seq Scan on raw_assignments_dim asd (cost=0.00..2,975.93 rows=16,045 width=40) (actual time=0.007..23.726 rows=16,126 loops=1)

  • Filter: (status = 'published'::text)
  • Rows Removed by Filter: 28668
25. 1.082 2.684 ↑ 1.0 2,163 1

Hash (cost=104.71..104.71 rows=2,163 width=8) (actual time=2.684..2.684 rows=2,163 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
26. 1.602 1.602 ↑ 1.0 2,163 1

Seq Scan on raw_assignment_groups_facts agf (cost=0.00..104.71 rows=2,163 width=8) (actual time=0.008..1.602 rows=2,163 loops=1)

  • Filter: (group_weight > '0'::double precision)
  • Rows Removed by Filter: 3654
27. 0.692 4.275 ↓ 1.4 1,313 1

Hash (cost=73.63..73.63 rows=910 width=26) (actual time=4.275..4.275 rows=1,313 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 88kB
28. 1.340 3.583 ↓ 1.4 1,313 1

Hash Join (cost=3.73..73.63 rows=910 width=26) (actual time=0.095..3.583 rows=1,313 loops=1)

  • Hash Cond: (crd.term_id = tmd.id)
29. 1.428 2.228 ↓ 1.4 1,313 1

Hash Join (cost=2.53..59.92 rows=910 width=30) (actual time=0.075..2.228 rows=1,313 loops=1)

  • Hash Cond: (crd.account_id = acd.id)
30. 0.733 0.733 ↑ 1.0 1,403 1

Seq Scan on raw_courses_dim crd (cost=0.00..43.03 rows=1,403 width=32) (actual time=0.004..0.733 rows=1,403 loops=1)

31. 0.031 0.067 ↑ 1.0 48 1

Hash (cost=1.93..1.93 rows=48 width=14) (actual time=0.067..0.067 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
32. 0.036 0.036 ↑ 1.0 48 1

Seq Scan on raw_accounts_dim acd (cost=0.00..1.93 rows=48 width=14) (actual time=0.007..0.036 rows=48 loops=1)

  • Filter: (status <> 'deleted'::text)
  • Rows Removed by Filter: 26
33. 0.011 0.015 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=12) (actual time=0.015..0.015 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.004 0.004 ↑ 1.0 9 1

Seq Scan on raw_terms_dim tmd (cost=0.00..1.09 rows=9 width=12) (actual time=0.002..0.004 rows=9 loops=1)

35. 2,026.563 2,026.563 ↑ 1.3 131 9,339

Index Scan using raw_dim_submissions_assignment_id_idx on raw_submissions_dim sbd (cost=0.43..23.50 rows=175 width=50) (actual time=0.010..0.217 rows=131 loops=9,339)

  • Index Cond: (assignment_id = asd.id)
  • Filter: (status <> 'deleted'::text)
  • Rows Removed by Filter: 7
36. 1,851.760 5,984.079 ↓ 13.4 3,704,226 1

Materialize (cost=100,018.02..101,395.06 rows=275,408 width=334) (actual time=3,460.146..5,984.079 rows=3,704,226 loops=1)

37. 2,183.604 4,132.319 ↑ 1.1 247,478 1

Sort (cost=100,018.02..100,706.54 rows=275,408 width=334) (actual time=3,460.140..4,132.319 rows=247,478 loops=1)

  • Sort Key: (COALESCE(pd1.user_id, pd2.user_id)), ((cr.sis_fid)::text), ((tm.sis_fid)::text)
  • Sort Method: external merge Disk: 68312kB
38. 474.923 1,948.715 ↑ 1.1 247,478 1

Hash Right Join (cost=24,597.10..32,772.74 rows=275,408 width=334) (actual time=1,163.803..1,948.715 rows=247,478 loops=1)

  • Hash Cond: (en.student_id = st.id)
39. 210.401 576.672 ↓ 1.1 245,387 1

Hash Right Join (cost=7,904.71..12,470.89 rows=228,101 width=41) (actual time=266.606..576.672 rows=245,387 loops=1)

  • Hash Cond: (ese.enroll_id = en.id)
40. 60.410 105.691 ↑ 1.0 59,738 1

Hash Left Join (cost=219.44..3,964.22 rows=59,738 width=23) (actual time=5.892..105.691 rows=59,738 loops=1)

  • Hash Cond: (ese.event_session_id = es.id)
41. 39.411 39.411 ↑ 1.0 59,738 1

Seq Scan on events_sessions_enrolls ese (cost=0.00..2,923.38 rows=59,738 width=21) (actual time=0.005..39.411 rows=59,738 loops=1)

42. 1.426 5.870 ↑ 1.0 3,084 1

Hash (cost=180.89..180.89 rows=3,084 width=10) (actual time=5.870..5.870 rows=3,084 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 159kB
43. 2.970 4.444 ↑ 1.0 3,084 1

Hash Left Join (cost=6.64..180.89 rows=3,084 width=10) (actual time=0.163..4.444 rows=3,084 loops=1)

  • Hash Cond: (es.event_id = ev.id)
44. 1.324 1.324 ↑ 1.0 3,084 1

Seq Scan on events_sessions es (cost=0.00..131.84 rows=3,084 width=8) (actual time=0.003..1.324 rows=3,084 loops=1)

45. 0.070 0.150 ↑ 1.0 162 1

Hash (cost=4.62..4.62 rows=162 width=6) (actual time=0.150..0.150 rows=162 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
46. 0.080 0.080 ↑ 1.0 162 1

Seq Scan on events ev (cost=0.00..4.62 rows=162 width=6) (actual time=0.005..0.080 rows=162 loops=1)

47. 130.244 260.580 ↑ 1.0 228,101 1

Hash (cost=4,834.01..4,834.01 rows=228,101 width=22) (actual time=260.580..260.580 rows=228,101 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 15414kB
48. 130.336 130.336 ↑ 1.0 228,101 1

Seq Scan on enrolls en (cost=0.00..4,834.01 rows=228,101 width=22) (actual time=0.013..130.336 rows=228,101 loops=1)

49. 62.370 897.120 ↑ 1.2 61,873 1

Hash (cost=15,766.37..15,766.37 rows=74,082 width=297) (actual time=897.120..897.120 rows=61,873 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 16715kB
50. 65.875 834.750 ↑ 1.2 61,873 1

Hash Join (cost=11,713.40..15,766.37 rows=74,082 width=297) (actual time=627.210..834.750 rows=61,873 loops=1)

  • Hash Cond: (st.center_id = sh.id)
51. 106.520 768.826 ↑ 1.2 61,873 1

Hash Right Join (cost=11,711.66..14,746.00 rows=74,082 width=282) (actual time=627.153..768.826 rows=61,873 loops=1)

  • Hash Cond: (pd2.unique_name = (cu.mail)::text)
52. 35.220 35.220 ↑ 1.0 71,019 1

Seq Scan on raw_pseudonym_dim pd2 (cost=0.00..2,027.19 rows=71,019 width=58) (actual time=0.006..35.220 rows=71,019 loops=1)

53. 61.900 627.086 ↓ 1.5 61,786 1

Hash (cost=11,205.95..11,205.95 rows=40,456 width=258) (actual time=627.086..627.086 rows=61,786 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 14984kB
54. 66.257 565.186 ↓ 1.5 61,786 1

Hash Join (cost=7,949.48..11,205.95 rows=40,456 width=258) (actual time=311.620..565.186 rows=61,786 loops=1)

  • Hash Cond: (st.course_id = cr.id)
55. 64.930 498.893 ↓ 1.5 61,786 1

Hash Join (cost=7,946.97..10,647.17 rows=40,456 width=216) (actual time=311.576..498.893 rows=61,786 loops=1)

  • Hash Cond: (st.term_id = tm.id)
56. 69.453 433.940 ↓ 1.5 61,786 1

Hash Join (cost=7,945.58..10,089.51 rows=40,456 width=201) (actual time=311.546..433.940 rows=61,786 loops=1)

  • Hash Cond: (cf.customer_id = cu.id)
57. 38.067 137.204 ↑ 1.0 26,087 1

Hash Left Join (cost=2,914.93..4,575.32 rows=26,347 width=32) (actual time=84.206..137.204 rows=26,087 loops=1)

  • Hash Cond: ((cf.fid)::text = pd1.sis_user_id)
58. 18.771 18.771 ↑ 1.0 26,087 1

Seq Scan on customers_fids cf (cost=0.00..1,133.45 rows=26,347 width=8) (actual time=3.764..18.771 rows=26,087 loops=1)

  • Filter: (data_source_id = 'sis'::text)
  • Rows Removed by Filter: 35267
59. 37.454 80.366 ↑ 1.8 38,501 1

Hash (cost=2,027.19..2,027.19 rows=71,019 width=34) (actual time=80.366..80.366 rows=38,501 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3552kB
60. 42.912 42.912 ↑ 1.0 71,019 1

Seq Scan on raw_pseudonym_dim pd1 (cost=0.00..2,027.19 rows=71,019 width=34) (actual time=0.007..42.912 rows=71,019 loops=1)

61. 48.850 227.283 ↓ 1.3 61,357 1

Hash (cost=4,427.52..4,427.52 rows=48,251 width=173) (actual time=227.283..227.283 rows=61,357 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 9855kB
62. 70.111 178.433 ↓ 1.3 61,357 1

Hash Join (cost=2,311.35..4,427.52 rows=48,251 width=173) (actual time=72.548..178.433 rows=61,357 loops=1)

  • Hash Cond: (st.customer_id = cu.id)
63. 35.809 35.809 ↑ 1.0 61,357 1

Seq Scan on students st (cost=0.00..1,403.57 rows=61,357 width=43) (actual time=0.005..35.809 rows=61,357 loops=1)

64. 19.357 72.513 ↓ 1.0 26,009 1

Hash (cost=1,986.55..1,986.55 rows=25,984 width=130) (actual time=72.513..72.513 rows=26,009 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 3411kB
65. 30.007 53.156 ↓ 1.0 26,009 1

Hash Join (cost=1.38..1,986.55 rows=25,984 width=130) (actual time=0.054..53.156 rows=26,009 loops=1)

  • Hash Cond: (cu.enabled_status_id = ces.id)
66. 23.126 23.126 ↑ 1.0 33,042 1

Seq Scan on customers cu (cost=0.00..1,601.42 rows=33,042 width=74) (actual time=0.006..23.126 rows=33,042 loops=1)

67. 0.018 0.023 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=56) (actual time=0.023..0.023 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
68. 0.005 0.005 ↑ 1.0 17 1

Seq Scan on customer_enabled_status ces (cost=0.00..1.17 rows=17 width=56) (actual time=0.003..0.005 rows=17 loops=1)

69. 0.003 0.023 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=19) (actual time=0.023..0.023 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 0.020 0.020 ↑ 1.0 17 1

Seq Scan on terms tm (cost=0.00..1.17 rows=17 width=19) (actual time=0.004..0.020 rows=17 loops=1)

71. 0.014 0.036 ↑ 1.0 23 1

Hash (cost=2.23..2.23 rows=23 width=42) (actual time=0.036..0.036 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
72. 0.022 0.022 ↑ 1.0 23 1

Seq Scan on courses cr (cost=0.00..2.23 rows=23 width=42) (actual time=0.006..0.022 rows=23 loops=1)

73. 0.028 0.049 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=19) (actual time=0.049..0.049 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
74. 0.021 0.021 ↑ 1.0 33 1

Seq Scan on shops sh (cost=0.00..1.33 rows=33 width=19) (actual time=0.012..0.021 rows=33 loops=1)

75. 3,620.469 40,694.588 ↓ 0.0 0 3,699,508

Nested Loop Anti Join (cost=9.50..91.41 rows=3 width=4) (actual time=0.011..0.011 rows=0 loops=3,699,508)

  • Join Filter: ((od2.customer_id = od.customer_id) AND (ol2.product_id = ol.product_id))
  • Rows Removed by Join Filter: 1
76. 6,906.575 29,596.064 ↓ 0.0 0 3,699,508

Nested Loop (cost=4.75..32.27 rows=3 width=12) (actual time=0.008..0.008 rows=0 loops=3,699,508)

77. 14,798.032 22,197.048 ↓ 0.0 0 3,699,508

Bitmap Heap Scan on orders od (cost=4.33..23.51 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=3,699,508)

  • Recheck Cond: (customer_id = cu.id)
  • Filter: (last_order_state_id = 13)
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=15073397
78. 7,399.016 7,399.016 ↑ 1.2 4 3,699,508

Bitmap Index Scan on orders_customer_id_idx (cost=0.00..4.33 rows=5 width=0) (actual time=0.002..0.002 rows=4 loops=3,699,508)

  • Index Cond: (customer_id = cu.id)
79. 492.441 492.441 ↑ 2.0 2 164,147

Index Scan using orders_lines_order_id_idx on orders_lines ol (cost=0.42..8.72 rows=4 width=12) (actual time=0.002..0.003 rows=2 loops=164,147)

  • Index Cond: (order_id = od.id)
80. 1,928.980 7,478.055 ↑ 1.1 9 276,965

Materialize (cost=4.75..58.61 rows=10 width=8) (actual time=0.006..0.027 rows=9 loops=276,965)

81. 1,814.900 5,549.075 ↓ 1.1 11 149,975

Nested Loop (cost=4.75..58.56 rows=10 width=8) (actual time=0.009..0.037 rows=11 loops=149,975)

82. 1,049.825 1,349.775 ↑ 1.0 4 149,975

Bitmap Heap Scan on orders od2 (cost=4.33..23.52 rows=4 width=8) (actual time=0.005..0.009 rows=4 loops=149,975)

  • Recheck Cond: (customer_id = cu.id)
  • Filter: (last_order_state_id = ANY ('{2,4,16,17}'::integer[]))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=664852
83. 299.950 299.950 ↓ 1.4 7 149,975

Bitmap Index Scan on orders_customer_id_idx (cost=0.00..4.33 rows=5 width=0) (actual time=0.002..0.002 rows=7 loops=149,975)

  • Index Cond: (customer_id = cu.id)
84. 2,384.400 2,384.400 ↑ 1.3 3 596,100

Index Scan using orders_lines_order_id_idx on orders_lines ol2 (cost=0.42..8.72 rows=4 width=8) (actual time=0.002..0.004 rows=3 loops=596,100)

  • Index Cond: (order_id = od2.id)
85.          

SubPlan (for GroupAggregate)

86. 368.934 14,142.470 ↑ 1.0 1 61,489

Aggregate (cost=66.03..66.04 rows=1 width=1) (actual time=0.229..0.230 rows=1 loops=61,489)

87. 860.846 13,773.536 ↓ 1.4 7 61,489

HashAggregate (cost=65.92..65.97 rows=5 width=9) (actual time=0.221..0.224 rows=7 loops=61,489)

  • Group Key: fsb.id
88. 1,487.151 12,912.690 ↓ 2.6 13 61,489

Nested Loop Left Join (cost=0.71..65.89 rows=5 width=9) (actual time=0.046..0.210 rows=13 loops=61,489)

89. 975.436 9,776.751 ↓ 2.6 13 61,489

Nested Loop (cost=0.29..23.64 rows=5 width=8) (actual time=0.042..0.159 rows=13 loops=61,489)

90. 1,465.625 3,320.406 ↓ 2.0 2 61,489

Nested Loop (cost=0.29..16.67 rows=1 width=8) (actual time=0.028..0.054 rows=2 loops=61,489)

  • Join Filter: (fst.term_id = ftm.id)
  • Rows Removed by Join Filter: 37
91. 307.445 307.445 ↓ 3.0 3 61,489

Index Scan using students_customer_id_idx on students fst (cost=0.29..15.38 rows=1 width=12) (actual time=0.003..0.005 rows=3 loops=61,489)

  • Index Cond: (customer_id = st.customer_id)
  • Filter: (course_id = st.course_id)
  • Rows Removed by Filter: 0
92. 1,547.336 1,547.336 ↓ 2.0 12 193,417

Seq Scan on terms ftm (cost=0.00..1.21 rows=6 width=4) (actual time=0.001..0.008 rows=12 loops=193,417)

  • Filter: (enroll_from_date <= tm.enroll_from_date)
  • Rows Removed by Filter: 5
93. 5,480.909 5,480.909 ↓ 1.2 6 127,463

Seq Scan on subjects fsb (cost=0.00..6.93 rows=5 width=8) (actual time=0.010..0.043 rows=6 loops=127,463)

  • Filter: (mandatory_for_fct AND (course_id = st.course_id))
  • Rows Removed by Filter: 308
94. 1,648.788 1,648.788 ↓ 0.0 0 824,394

Index Scan using enrolls_student_id_subject_id_key on enrolls fen (cost=0.42..8.44 rows=1 width=13) (actual time=0.002..0.002 rows=0 loops=824,394)

  • Index Cond: ((student_id = fst.id) AND (subject_id = fsb.id))
Planning time : 27.145 ms
Execution time : 118,417.478 ms