KB to cleanup audit table https://kb.vmware.com/s/article/2106123 The KB is little old, for postgres the following should work DELETE from audit_trail WHERE event_time < '2022-09-01 06:00:00.000';
select event_type, count(*) as num from audit_trail group by event_type order by num desc This should give you the aggregates without having to rely on limits, the query should be pretty fast. I can...
See more...
select event_type, count(*) as num from audit_trail group by event_type order by num desc This should give you the aggregates without having to rely on limits, the query should be pretty fast. I can run the query in under 10 seconds on a 30GB db
