Cleaning out too big

From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 08:29, 1 April 2021 by Kevin Wilkie (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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;