Cleaning out too big
From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 08:29, 1 April 2021 by Kevin Wilkie (Talk | contribs)
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;