galaxyproject / galaxyproject/gxadmin
purge job metrics table from time to time
Open
feature request
- Dominant language
- Shell
- Stars
- 24
- Forks
- 30
- Avg merge
- 3d 10h
- Merged PRs (30d)
- 5
Description
```
# Delete text job metrics for successful or old jobs (not useful for debugging).
# Delete numeric job metrics for old unsuccessful jobs (not useful for statistics or debugging).
DELETE FROM job_metric_text USING job WHERE job_id=job.id AND (job.state='ok' OR CURRENT_TIMESTAMP - job.update_time > '1 year');
VACUUM FULL job_metric_text;
DELETE FROM job_metric_numeric USING job WHERE job_id=job.id AND job.state IN ('deleted', 'error') AND CURRENT_TIMESTAMP - job.update_time > '1 year';
VACUUM FULL job_metric_numeric;
```
From @nsoranzo
Contributor guide
Assessment
This issue has not been assessed yet.