Database growth

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) 7.9.3

  • what are you trying to achieve. Our POSTGRES DB is growing and we identified below tables are growing
    public.project_measures | 72 GB
    public.ce_task_input | 25 GB
    public.file_sources | 6908 MB
    public.issues | 3576 MB
    public.projects | 1270 MB
    public.ce_scanner_context | 560 MB
    public.issue_changes | 545 MB
    public.webhook_deliveries | 90 MB

  • what have you tried so far to achieve this – Vacuum DB but still the same result DB is not shrinking or size is reducing…

We need steps to reduce the DB size in a healthy way, we have also deleted some unused projects say around 100 projects but still the space is same.

How to reduce the tables project_measures and ce_task_input ?


Have you tried adjusting your housekeeping settings?