Quiz Submission Data taking up too much space

[Josh Kraemer]

Hi,

The quiz_submission_events tables in our Postgres database for Canvas have consumed 20+ GB in the past few months.

This has only been a recent problem and I'm wondering what I can do to safely eliminate the data and prevent the data increase. We only have around 800 students taking quizzes in Canvas.

Any ideas?

[Cody Cutrer]

Josh,

As long as you have delayed jobs running, it will automatically drop data older than 6 months. So you should reach a steady state soon.

Cody Cutrer

Software Engineer

Instructure

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Josh Kraemer]

Thanks for the reply. Delayed jobs are running, and it looks like the quiz_submission_events tables over 6 months old are deleted.

However, because the tables are filling up so quickly, I need to manually delete the data older than 1 month. For example: The table quiz_submission_events_2016_8 is 20GB in size.

I didn't need to do this until a couple of months ago and I don't recall anything changing drastically (ie - number of students, server configuration, etc).

Thoughts?

However, I'm still trying to figure out why the quiz_submission_events tables are filling up so quickly. This started happening a few months. 

[Josh Kraemer]

I'm still noticing some issues with the quiz submission events. QuizSubmissionEventsApiController#create is consuming a lot of resources, and the quiz_submission_events_xxxx_xx tables are filling up at a rate of 20+ GB per month.

Anything to check?