How do you clean up the grate tables?

[mbp]

After years of usage, the tables, especially ScriptsRunErrors, is growing. Is there a feature in grate to cleanup entries older than e.g. 1 year or similar? Or does anyone have some scripts that can cleanup these tables, without breaking any behaviour of grate?

[wokket]

There's nothing baked in as peoples requirements re: record keeping vary.

Things like the ScriptsRunErrors table should be perfectly fine to remove older rows if they're of no use to you, although I'd generally try and keep a 'most recent' version of each script just in case.

[mbp]

OK, thank you. So in my case I might go for something like this.

delete from grate."ScriptsRun" where entry_date <= NOW() - INTERVAL '2 years';
delete from grate."ScriptsRunErrors" where entry_date <= NOW() - INTERVAL '2 years';
delete from grate."Version" where entry_date <= NOW() - INTERVAL '2 years';
delete from grate."GrateScriptsRun" where entry_date <= NOW() - INTERVAL '2 years';
delete from grate."GrateScriptsRunErrors" where entry_date <= NOW() - INTERVAL '2 years';
delete from grate."GrateVersion" where entry_date <= NOW() - INTERVAL '2 years';

[wokket]

I'd be careful with ScriptsRun (and GrateScriptsRun I guess) that you don't remove the initial RunOnce script records and trigger issues on the next deploy. Given the Grate* tables are internal I wouldn't have expected there to be many rows in those tables?