explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zn15

Settings
# exclusive inclusive rows x rows loops node
1. 21.528 31,608.908 ↓ 43.8 8,758 1

Sort (cost=203,583.92..203,584.42 rows=200 width=164) (actual time=31,608.183..31,608.908 rows=8,758 loops=1)

  • Sort Key: ((count(DISTINCT s.userhandle))::integer) DESC NULLS LAST, (max(s.coursename))
  • Sort Method: quicksort Memory: 2,623kB
2. 1,591.350 31,587.380 ↓ 43.8 8,758 1

GroupAggregate (cost=203,559.47..203,576.27 rows=200 width=164) (actual time=29,942.253..31,587.380 rows=8,758 loops=1)

  • Group Key: s.courseslug
3. 1,268.138 29,996.030 ↓ 1,329.1 917,095 1

Sort (cost=203,559.47..203,561.20 rows=690 width=192) (actual time=29,942.210..29,996.030 rows=917,095 loops=1)

  • Sort Key: s.courseslug
  • Sort Method: quicksort Memory: 268,452kB
4. 99.039 28,727.892 ↓ 1,329.1 917,095 1

Subquery Scan on s (cost=203,337.24..203,526.94 rows=690 width=192) (actual time=26,075.297..28,727.892 rows=917,095 loops=1)

5. 2,056.798 28,628.853 ↓ 1,329.1 917,095 1

GroupAggregate (cost=203,337.24..203,520.04 rows=690 width=460) (actual time=26,075.296..28,628.853 rows=917,095 loops=1)

  • Group Key: d.plan_id, d.content_id, d.user_handle
6. 11,522.699 26,572.055 ↓ 303.5 2,093,497 1

Sort (cost=203,337.24..203,354.48 rows=6,898 width=228) (actual time=26,075.265..26,572.055 rows=2,093,497 loops=1)

  • Sort Key: d.plan_id, d.content_id, d.user_handle
  • Sort Method: quicksort Memory: 661,123kB
7. 216.187 15,049.356 ↓ 303.5 2,093,497 1

Subquery Scan on d (cost=202,759.46..202,897.42 rows=6,898 width=228) (actual time=13,386.255..15,049.356 rows=2,093,497 loops=1)

8. 5,252.937 14,833.169 ↓ 303.5 2,093,497 1

HashAggregate (cost=202,759.46..202,828.44 rows=6,898 width=544) (actual time=13,386.254..14,833.169 rows=2,093,497 loops=1)

  • Group Key: p.plan_id, p.display_name, t.team_name, m.user_handle, m.first_name, m.last_name, m.email, m.note, m.start_date, ('VideoCourse'::text), ((c.course_guid)::text), c.course_guid, (NULL::text), (NULL::text), c.slug, c.title, c.duration, (NULL::text), dcv.clip_view_duration, cp.percent_complete, dcv.rollup_date
9. 215.756 9,580.232 ↓ 303.5 2,093,498 1

Append (cost=2,668.38..202,397.32 rows=6,898 width=544) (actual time=54.832..9,580.232 rows=2,093,498 loops=1)

10. 990.322 8,927.586 ↓ 302.3 2,084,672 1

Nested Loop (cost=2,668.38..133,994.43 rows=6,896 width=439) (actual time=54.832..8,927.586 rows=2,084,672 loops=1)

11. 0.025 0.025 ↑ 1.0 1 1

Index Scan using plans_pkey on plans p (cost=0.41..8.43 rows=1 width=44) (actual time=0.024..0.025 rows=1 loops=1)

  • Index Cond: (plan_id = 'jpmctrial092315'::text)
12. 0.000 7,937.239 ↓ 302.3 2,084,672 1

Gather (cost=2,667.96..133,882.55 rows=6,896 width=283) (actual time=54.801..7,937.239 rows=2,084,672 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
13. 428.445 10,414.614 ↓ 241.9 694,891 3 / 3

Nested Loop Left Join (cost=1,667.96..132,192.95 rows=2,873 width=283) (actual time=48.281..10,414.614 rows=694,891 loops=3)

14. 372.215 2,342.372 ↓ 241.9 694,891 3 / 3

Hash Left Join (cost=1,667.28..112,081.10 rows=2,873 width=279) (actual time=48.228..2,342.372 rows=694,891 loops=3)

  • Hash Cond: (dcv.course_guid = c.course_guid)
15. 183.305 1,962.502 ↓ 241.9 694,891 3 / 3

Nested Loop (cost=1,067.84..111,474.12 rows=2,873 width=184) (actual time=40.478..1,962.502 rows=694,891 loops=3)

16. 25.321 138.002 ↓ 18.0 43,189 3 / 3

Hash Left Join (cost=1,067.15..23,821.34 rows=2,400 width=124) (actual time=40.433..138.002 rows=43,189 loops=3)

  • Hash Cond: ((m.plan_id = t.plan_id) AND (m.team_id = t.team_id))
17. 101.387 112.548 ↓ 18.0 43,189 3 / 3

Parallel Bitmap Heap Scan on members m (cost=1,039.29..23,780.88 rows=2,400 width=151) (actual time=40.189..112.548 rows=43,189 loops=3)

  • Recheck Cond: ((plan_id = 'jpmctrial092315'::text) AND (team_id = ANY ('{fd8f26a4-567c-43dd-91e5-9e12f94def34,9dabe225-61d4-43b3-b244-2b0973c51925,831821ce-4cfd-4331-8632-3192d17289cf,db43a12c-1c30-4ec0-805c-1a3689b56fef,211fdea1-527c-4696-8a2e-65af7283059e,90cd807a-2877-4e88-a762-2f93eba44a66,d5a9edc5-5616-4891-af4f-cbf85ed56d90,4be0bd36-4e25-4177-8b92-0e5e22d34d8d,9bf9ed58-ec08-46bd-a1a6-f4cc77e06221,f267e613-39f6-403c-91e0-56b089f71077,f62ad315-011b-4727-a578-c855315d8b10,d438e03f-a78d-4506-967b-ac9147ddeade,1f7736ff-d723-46c7-9951-1ef9b0af9066,cd4b8edf-95e5-4646-883d-a64d85346179,119337da-158e-4698-8c30-062f4e1dbe96,c333a56c-1728-40e6-9e44-cfa9143d5a1f,e058ce7e-65b6-4f6a-bcac-116254233a04,5155b70c-5aa5-40b4-816b-4a1d69bbb921,915801c2-64df-4521-bf13-9dccddfdce05,b9a12e47-5bb0-46b0-b266-fc36ed9f61e4,96b4f57c-aca2-443f-aae1-2c45e463810f,5b346427-ba79-4547-9682-4bc3117a4f73,a2237fb6-1e5d-491f-91b4-98714d573704,36864165-9c8e-4945-99e0-a142da749dc4,053fe40f-7066-4183-944f-1e7ad52e2008,aeb04793-d78b-46e8-9845-7446d3230c92,8ca4ea53-fa09-455b-a981-517eff27c13a,93889e7f-8b16-46d1-a3f3-f4adc980919f,0066e62a-9aee-45d2-b650-07a20b5d62e3,5abab5e5-4087-419b-b8c0-a221dd1f7b62,38788e2a-4352-425f-9447-1939eaf3486d,dfab1f18-3d5b-428d-8de2-031882a19c60,45878f04-2500-4870-86e3-3e0c9c186132,ac908666-a3d2-4847-813c-ccd257161f0c}'::text[])))
  • Filter: is_latest
  • Rows Removed by Filter: 5,606
  • Heap Blocks: exact=12,184
18. 11.161 11.161 ↓ 22.0 147,499 1 / 3

Bitmap Index Scan on members_plan_id_team_id_idx (cost=0.00..1,037.85 rows=6,704 width=0) (actual time=33.484..33.484 rows=147,499 loops=1)

  • Index Cond: ((plan_id = 'jpmctrial092315'::text) AND (team_id = ANY ('{fd8f26a4-567c-43dd-91e5-9e12f94def34,9dabe225-61d4-43b3-b244-2b0973c51925,831821ce-4cfd-4331-8632-3192d17289cf,db43a12c-1c30-4ec0-805c-1a3689b56fef,211fdea1-527c-4696-8a2e-65af7283059e,90cd807a-2877-4e88-a762-2f93eba44a66,d5a9edc5-5616-4891-af4f-cbf85ed56d90,4be0bd36-4e25-4177-8b92-0e5e22d34d8d,9bf9ed58-ec08-46bd-a1a6-f4cc77e06221,f267e613-39f6-403c-91e0-56b089f71077,f62ad315-011b-4727-a578-c855315d8b10,d438e03f-a78d-4506-967b-ac9147ddeade,1f7736ff-d723-46c7-9951-1ef9b0af9066,cd4b8edf-95e5-4646-883d-a64d85346179,119337da-158e-4698-8c30-062f4e1dbe96,c333a56c-1728-40e6-9e44-cfa9143d5a1f,e058ce7e-65b6-4f6a-bcac-116254233a04,5155b70c-5aa5-40b4-816b-4a1d69bbb921,915801c2-64df-4521-bf13-9dccddfdce05,b9a12e47-5bb0-46b0-b266-fc36ed9f61e4,96b4f57c-aca2-443f-aae1-2c45e463810f,5b346427-ba79-4547-9682-4bc3117a4f73,a2237fb6-1e5d-491f-91b4-98714d573704,36864165-9c8e-4945-99e0-a142da749dc4,053fe40f-7066-4183-944f-1e7ad52e2008,aeb04793-d78b-46e8-9845-7446d3230c92,8ca4ea53-fa09-455b-a981-517eff27c13a,93889e7f-8b16-46d1-a3f3-f4adc980919f,0066e62a-9aee-45d2-b650-07a20b5d62e3,5abab5e5-4087-419b-b8c0-a221dd1f7b62,38788e2a-4352-425f-9447-1939eaf3486d,dfab1f18-3d5b-428d-8de2-031882a19c60,45878f04-2500-4870-86e3-3e0c9c186132,ac908666-a3d2-4847-813c-ccd257161f0c}'::text[])))
19. 0.019 0.133 ↓ 5.7 34 3 / 3

Hash (cost=27.77..27.77 rows=6 width=71) (actual time=0.133..0.133 rows=34 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
20. 0.066 0.114 ↓ 5.7 34 3 / 3

Bitmap Heap Scan on plan_teams t (cost=4.47..27.77 rows=6 width=71) (actual time=0.060..0.114 rows=34 loops=3)

  • Recheck Cond: (plan_id = 'jpmctrial092315'::text)
  • Heap Blocks: exact=29
21. 0.048 0.048 ↓ 5.7 34 3 / 3

Bitmap Index Scan on plan_teams_pkey (cost=0.00..4.46 rows=6 width=0) (actual time=0.048..0.048 rows=34 loops=3)

  • Index Cond: (plan_id = 'jpmctrial092315'::text)
22. 1,641.195 1,641.195 ↓ 2.0 16 129,568 / 3

Index Scan using daily_course_views_plan_id_user_handle_idx on daily_course_views dcv (cost=0.69..36.44 rows=8 width=95) (actual time=0.016..0.038 rows=16 loops=129,568)

  • Index Cond: ((plan_id = 'jpmctrial092315'::text) AND (user_handle = m.user_handle))
  • Filter: ((rollup_date >= '2010-01-01'::date) AND (rollup_date <= '2021-01-01'::date))
  • Rows Removed by Filter: 0
23. 4.449 7.655 ↑ 1.1 11,177 3 / 3

Hash (cost=446.97..446.97 rows=12,197 width=111) (actual time=7.655..7.655 rows=11,177 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,740kB
24. 3.206 3.206 ↑ 1.1 11,177 3 / 3

Seq Scan on courses c (cost=0.00..446.97 rows=12,197 width=111) (actual time=0.012..3.206 rows=11,177 loops=3)

25. 7,643.797 7,643.797 ↑ 1.0 1 2,084,672 / 3

Index Only Scan using course_progress_plnid_userhandle_courseguid_percentcomplete_idx on course_progress cp (cost=0.69..7.00 rows=1 width=79) (actual time=0.011..0.011 rows=1 loops=2,084,672)

  • Index Cond: ((plan_id = m.plan_id) AND (plan_id = 'jpmctrial092315'::text) AND (user_handle = m.user_handle) AND (course_guid = c.course_guid))
  • Heap Fetches: 282,847
26. 1.170 67.039 ↓ 1,370.0 1,370 1

Nested Loop Left Join (cost=18,840.23..19,331.64 rows=1 width=467) (actual time=26.934..67.039 rows=1,370 loops=1)

  • Join Filter: (proj.id = pp.project_id)
  • Rows Removed by Join Filter: 347
27. 1.141 59.019 ↓ 1,370.0 1,370 1

Nested Loop Left Join (cost=18,839.81..19,329.63 rows=1 width=359) (actual time=26.915..59.019 rows=1,370 loops=1)

28. 1.583 55.138 ↓ 1,370.0 1,370 1

Nested Loop Left Join (cost=18,839.54..19,328.60 rows=1 width=209) (actual time=26.900..55.138 rows=1,370 loops=1)

29. 1.334 49.445 ↓ 1,370.0 1,370 1

Nested Loop (cost=18,839.12..19,322.48 rows=1 width=236) (actual time=26.879..49.445 rows=1,370 loops=1)

30. 0.698 42.631 ↓ 1,370.0 1,370 1

Nested Loop (cost=18,838.71..19,314.04 rows=1 width=215) (actual time=26.863..42.631 rows=1,370 loops=1)

31. 2.093 29.603 ↓ 24.9 1,370 1

Group (cost=18,838.15..18,838.98 rows=55 width=100) (actual time=26.829..29.603 rows=1,370 loops=1)

  • Group Key: task_completion.plan_id, task_completion.project_id, task_completion.user_handle, ((task_completion.completed_at)::date)
32. 14.350 27.510 ↓ 201.5 11,082 1

Sort (cost=18,838.15..18,838.29 rows=55 width=100) (actual time=26.827..27.510 rows=11,082 loops=1)

  • Sort Key: task_completion.project_id, task_completion.user_handle, ((task_completion.completed_at)::date)
  • Sort Method: quicksort Memory: 1,943kB
33. 11.480 13.160 ↓ 201.5 11,082 1

Bitmap Heap Scan on task_completion (cost=407.58..18,836.56 rows=55 width=100) (actual time=2.414..13.160 rows=11,082 loops=1)

  • Recheck Cond: (plan_id = 'jpmctrial092315'::text)
  • Filter: (((completed_at)::date >= '2010-01-01'::date) AND ((completed_at)::date <= '2021-01-01'::date))
  • Heap Blocks: exact=4,607
34. 1.680 1.680 ↓ 1.0 11,088 1

Bitmap Index Scan on task_completion_plan_id_completed_at_idx (cost=0.00..407.56 rows=11,085 width=0) (actual time=1.680..1.680 rows=11,088 loops=1)

  • Index Cond: (plan_id = 'jpmctrial092315'::text)
35. 12.330 12.330 ↑ 1.0 1 1,370

Index Scan using members_plan_id_user_handle_is_latest_idx on members m_1 (cost=0.56..8.62 rows=1 width=151) (actual time=0.008..0.009 rows=1 loops=1,370)

  • Index Cond: ((plan_id = 'jpmctrial092315'::text) AND (user_handle = task_completion.user_handle))
  • Filter: (team_id = ANY ('{fd8f26a4-567c-43dd-91e5-9e12f94def34,9dabe225-61d4-43b3-b244-2b0973c51925,831821ce-4cfd-4331-8632-3192d17289cf,db43a12c-1c30-4ec0-805c-1a3689b56fef,211fdea1-527c-4696-8a2e-65af7283059e,90cd807a-2877-4e88-a762-2f93eba44a66,d5a9edc5-5616-4891-af4f-cbf85ed56d90,4be0bd36-4e25-4177-8b92-0e5e22d34d8d,9bf9ed58-ec08-46bd-a1a6-f4cc77e06221,f267e613-39f6-403c-91e0-56b089f71077,f62ad315-011b-4727-a578-c855315d8b10,d438e03f-a78d-4506-967b-ac9147ddeade,1f7736ff-d723-46c7-9951-1ef9b0af9066,cd4b8edf-95e5-4646-883d-a64d85346179,119337da-158e-4698-8c30-062f4e1dbe96,c333a56c-1728-40e6-9e44-cfa9143d5a1f,e058ce7e-65b6-4f6a-bcac-116254233a04,5155b70c-5aa5-40b4-816b-4a1d69bbb921,915801c2-64df-4521-bf13-9dccddfdce05,b9a12e47-5bb0-46b0-b266-fc36ed9f61e4,96b4f57c-aca2-443f-aae1-2c45e463810f,5b346427-ba79-4547-9682-4bc3117a4f73,a2237fb6-1e5d-491f-91b4-98714d573704,36864165-9c8e-4945-99e0-a142da749dc4,053fe40f-7066-4183-944f-1e7ad52e2008,aeb04793-d78b-46e8-9845-7446d3230c92,8ca4ea53-fa09-455b-a981-517eff27c13a,93889e7f-8b16-46d1-a3f3-f4adc980919f,0066e62a-9aee-45d2-b650-07a20b5d62e3,5abab5e5-4087-419b-b8c0-a221dd1f7b62,38788e2a-4352-425f-9447-1939eaf3486d,dfab1f18-3d5b-428d-8de2-031882a19c60,45878f04-2500-4870-86e3-3e0c9c186132,ac908666-a3d2-4847-813c-ccd257161f0c}'::text[]))
36. 5.480 5.480 ↑ 1.0 1 1,370

Index Scan using plans_pkey on plans p_1 (cost=0.41..8.43 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=1,370)

  • Index Cond: (plan_id = 'jpmctrial092315'::text)
37. 4.110 4.110 ↑ 1.0 1 1,370

Index Scan using plan_teams_pkey on plan_teams t_1 (cost=0.42..4.85 rows=1 width=71) (actual time=0.003..0.003 rows=1 loops=1,370)

  • Index Cond: ((m_1.plan_id = plan_id) AND (plan_id = 'jpmctrial092315'::text) AND (m_1.team_id = team_id))
38. 2.740 2.740 ↑ 1.0 1 1,370

Index Scan using projects_pkey on projects proj (cost=0.27..1.01 rows=1 width=150) (actual time=0.002..0.002 rows=1 loops=1,370)

  • Index Cond: (task_completion.project_id = id)
39. 6.850 6.850 ↑ 1.0 1 1,370

Index Scan using project_progress_pkey on project_progress pp (cost=0.41..2.00 rows=1 width=101) (actual time=0.005..0.005 rows=1 loops=1,370)

  • Index Cond: ((m_1.plan_id = plan_id) AND (plan_id = 'jpmctrial092315'::text) AND (m_1.user_handle = user_handle))
40. 7.779 369.851 ↓ 7,456.0 7,456 1

Nested Loop Left Join (cost=46,874.92..49,002.27 rows=1 width=424) (actual time=149.187..369.851 rows=7,456 loops=1)

  • Join Filter: (iccp.interactive_course_id = ic.interactive_course_id)
  • Rows Removed by Join Filter: 7,700
41. 4.339 317.336 ↓ 7,456.0 7,456 1

Nested Loop Left Join (cost=46,874.37..48,998.86 rows=1 width=268) (actual time=149.160..317.336 rows=7,456 loops=1)

42. 8.840 305.541 ↓ 7,456.0 7,456 1

Nested Loop Left Join (cost=46,874.23..48,998.61 rows=1 width=188) (actual time=149.150..305.541 rows=7,456 loops=1)

43. 7.177 274.333 ↓ 7,456.0 7,456 1

Nested Loop (cost=46,873.81..48,992.50 rows=1 width=215) (actual time=149.130..274.333 rows=7,456 loops=1)

44. 10.349 237.332 ↓ 7,456.0 7,456 1

Nested Loop (cost=46,873.40..48,984.05 rows=1 width=195) (actual time=149.111..237.332 rows=7,456 loops=1)

45. 11.758 167.335 ↓ 30.6 7,456 1

Group (cost=46,872.84..46,876.50 rows=244 width=80) (actual time=149.064..167.335 rows=7,456 loops=1)

  • Group Key: page_activity.plan_id, page_activity.interactive_course_id, page_activity.user_handle, ((page_activity.activity_at)::date)
46. 96.586 155.577 ↓ 217.4 53,045 1

Sort (cost=46,872.84..46,873.45 rows=244 width=80) (actual time=149.061..155.577 rows=53,045 loops=1)

  • Sort Key: page_activity.interactive_course_id, page_activity.user_handle, ((page_activity.activity_at)::date)
  • Sort Method: quicksort Memory: 8,988kB
47. 53.656 58.991 ↓ 217.4 53,045 1

Bitmap Heap Scan on page_activity (cost=1,746.08..46,863.17 rows=244 width=80) (actual time=8.568..58.991 rows=53,045 loops=1)

  • Recheck Cond: (plan_id = 'jpmctrial092315'::text)
  • Filter: (((activity_at)::date >= '2010-01-01'::date) AND ((activity_at)::date <= '2021-01-01'::date))
  • Heap Blocks: exact=22,415
48. 5.335 5.335 ↓ 1.1 53,045 1

Bitmap Index Scan on page_activity_plan_id_activity_at_idx (cost=0.00..1,746.02 rows=48,729 width=0) (actual time=5.335..5.335 rows=53,045 loops=1)

  • Index Cond: (plan_id = 'jpmctrial092315'::text)
49. 59.648 59.648 ↑ 1.0 1 7,456

Index Scan using members_plan_id_user_handle_is_latest_idx on members m_2 (cost=0.56..8.62 rows=1 width=151) (actual time=0.008..0.008 rows=1 loops=7,456)

  • Index Cond: ((plan_id = 'jpmctrial092315'::text) AND (user_handle = page_activity.user_handle))
  • Filter: (team_id = ANY ('{fd8f26a4-567c-43dd-91e5-9e12f94def34,9dabe225-61d4-43b3-b244-2b0973c51925,831821ce-4cfd-4331-8632-3192d17289cf,db43a12c-1c30-4ec0-805c-1a3689b56fef,211fdea1-527c-4696-8a2e-65af7283059e,90cd807a-2877-4e88-a762-2f93eba44a66,d5a9edc5-5616-4891-af4f-cbf85ed56d90,4be0bd36-4e25-4177-8b92-0e5e22d34d8d,9bf9ed58-ec08-46bd-a1a6-f4cc77e06221,f267e613-39f6-403c-91e0-56b089f71077,f62ad315-011b-4727-a578-c855315d8b10,d438e03f-a78d-4506-967b-ac9147ddeade,1f7736ff-d723-46c7-9951-1ef9b0af9066,cd4b8edf-95e5-4646-883d-a64d85346179,119337da-158e-4698-8c30-062f4e1dbe96,c333a56c-1728-40e6-9e44-cfa9143d5a1f,e058ce7e-65b6-4f6a-bcac-116254233a04,5155b70c-5aa5-40b4-816b-4a1d69bbb921,915801c2-64df-4521-bf13-9dccddfdce05,b9a12e47-5bb0-46b0-b266-fc36ed9f61e4,96b4f57c-aca2-443f-aae1-2c45e463810f,5b346427-ba79-4547-9682-4bc3117a4f73,a2237fb6-1e5d-491f-91b4-98714d573704,36864165-9c8e-4945-99e0-a142da749dc4,053fe40f-7066-4183-944f-1e7ad52e2008,aeb04793-d78b-46e8-9845-7446d3230c92,8ca4ea53-fa09-455b-a981-517eff27c13a,93889e7f-8b16-46d1-a3f3-f4adc980919f,0066e62a-9aee-45d2-b650-07a20b5d62e3,5abab5e5-4087-419b-b8c0-a221dd1f7b62,38788e2a-4352-425f-9447-1939eaf3486d,dfab1f18-3d5b-428d-8de2-031882a19c60,45878f04-2500-4870-86e3-3e0c9c186132,ac908666-a3d2-4847-813c-ccd257161f0c}'::text[]))
50. 29.824 29.824 ↑ 1.0 1 7,456

Index Scan using plans_pkey on plans p_2 (cost=0.41..8.43 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=7,456)

  • Index Cond: (plan_id = 'jpmctrial092315'::text)
51. 22.368 22.368 ↑ 1.0 1 7,456

Index Scan using plan_teams_pkey on plan_teams t_2 (cost=0.42..4.85 rows=1 width=71) (actual time=0.003..0.003 rows=1 loops=7,456)

  • Index Cond: ((m_2.plan_id = plan_id) AND (plan_id = 'jpmctrial092315'::text) AND (m_2.team_id = team_id))
52. 7.456 7.456 ↑ 1.0 1 7,456

Index Scan using interactive_courses_pkey on interactive_courses ic (cost=0.14..0.24 rows=1 width=96) (actual time=0.001..0.001 rows=1 loops=7,456)

  • Index Cond: (interactive_course_id = page_activity.interactive_course_id)
53. 44.736 44.736 ↓ 2.0 2 7,456

Index Only Scan using course_progress_plnid_userhandle_icourseid_percentcomplete_idx on course_progress iccp (cost=0.55..3.39 rows=1 width=80) (actual time=0.005..0.006 rows=2 loops=7,456)

  • Index Cond: ((plan_id = m_2.plan_id) AND (plan_id = 'jpmctrial092315'::text) AND (user_handle = m_2.user_handle))
  • Heap Fetches: 533
Planning time : 11.599 ms
Execution time : 31,731.525 ms