Skip to content

Update High Traffic table list

Max Orefice requested to merge morefice/update-high-traffic-list into master

What does this MR do and why?

This MR updates our High Traffic tables list with new tables > 10 GB.

I've used the following command on a thin clone to get those numbers 👇

SELECT pg_size_pretty( pg_total_relation_size(TABLE_NAME));
table name size
approvals 10 GB
deployment_merge_requests 10 GB
diff_note_positions 18 GB
pm_package_version_licenses 14 GB
merge_request_user_mentions 17 GB
oauth_access_grants 23 GB
oauth_access_tokens 108 GB
pm_package_versions 11 GB
pm_package_version_licenses 14 GB
project_statistics 13 GB
sbom_occurrences 16 GB
security_scans 35 GB
user_agent_details 11 GB
vulnerability_finding_links 91 GB

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Max Orefice

Merge request reports