SQL query to see storage usage by course (incl. student uploads etc.)

Re: SQL query to see storage usage by course (incl. student uploads etc.)

by Visvanath Ratnaweera -
Number of replies: 1
Picture of Particularly helpful Moodlers Picture of Translators
Did you debug the issue? You can post the findings in the support forum at the bottom of the plug-in page https://moodle.org/plugins/report_coursesize itself or post them in the forum General plugins https://moodle.org/mod/forum/view.php?id=44.

4 TB is a terrible size for moodledata. Did you investigate whether all that is genuine/legitimate? Either way I don't think the plug-in scans moodledata. The file sizes are stored in the database.
Average of ratings: Useful (1)
In reply to Visvanath Ratnaweera

Re: SQL query to see storage usage by course (incl. student uploads etc.)

by Hariharasudhan A S -
Hi, I was able to figure out why my server has 4TB of moodledata. Has to do with the Annotate PDF plugin. Even though I reset my course, the files created by Annotate PDF remains without showing up in the UI. I found a temporary solution in the last comment here: https://tracker.moodle.org/browse/MDL-69570

Seems to be discussed here: https://moodle.org/mod/forum/discuss.php?d=412169

I am still not able to install any plugins on my installation. Might have to do with slow disk speed, planning to move to Nvme SSD's soon. As for my initial query of finding the course size, 3.20 in the list of SQL contributed reports worked as suggested by Rick above.
Average of ratings: -