Difference between revisions of "Cleaning out too big"

Revision as of 08:29, 1 April 2021

The following sql commands will clean out data that has been ingested but too big for reporting bigint

delete from summarytrafficgroups  where firstseen>gettimeimmutable('1 day') and srcbytes> 24515054763250 or dstbytes>24515054763250;
delete from summarytraffic where firstseen>gettimeimmutable('1 day') and bytes>24515054763250;
delete from interfacestats where firstseen>gettimeimmutable('1 day') and bpsin>24515054763250 or bpsout>24515054763250;
delete from summaryinterfaces where firstseen>gettimeimmutable('1 day') and bytesin> 24515054763250 or bytesout>24515054763250;
delete from summarytrafficinterfacein where firstseen>gettimeimmutable('1 day') and bytes>24515054763250;
delete from summarytrafficinterfaceout where firstseen>gettimeimmutable('1 day') and bytes>24515054763250;