Difference between revisions of "Cleaning out too big"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) (Created page with "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 ...") |
Kevin Wilkie (Talk | contribs) |
||
Line 1: | Line 1: | ||
The following sql commands will clean out data that has been ingested but too big for reporting bigint | The following sql commands will clean out data that has been ingested but too big for reporting bigint | ||
− | delete from summarytrafficgroups where firstseen>gettimeimmutable(' | + | delete from summarytrafficgroups where firstseen>gettimeimmutable('7 day') and srcbytes> 1000000000000 or dstbytes>1000000000000; |
− | delete from summarytraffic where firstseen>gettimeimmutable(' | + | delete from summarytraffic where firstseen>gettimeimmutable('7 day') and bytes>1000000000000; |
− | delete from interfacestats where firstseen>gettimeimmutable(' | + | delete from interfacestats where firstseen>gettimeimmutable('7 day') and bpsin>1000000000000or bpsout>1000000000000; |
− | delete from summaryinterfaces where firstseen>gettimeimmutable(' | + | delete from summaryinterfaces where firstseen>gettimeimmutable('7 day') and bytesin> 1000000000000 or bytesout>1000000000000; |
− | delete from summarytrafficinterfacein where firstseen>gettimeimmutable(' | + | delete from summarytrafficinterfacein where firstseen>gettimeimmutable('7 day') and bytes>1000000000000; |
− | delete from summarytrafficinterfaceout where firstseen>gettimeimmutable(' | + | delete from summarytrafficinterfaceout where firstseen>gettimeimmutable('7 day') and bytes>1000000000000; |
+ | |||
+ | |||
+ | delete from summarytrafficgroups where firstseen>gettimeimmutable('7 day') and srcbytes<0 or dstbytes<0; | ||
+ | delete from summarytraffic where firstseen>gettimeimmutable('7 day') and bytes<0; | ||
+ | delete from interfacestats where firstseen>gettimeimmutable('7 day') and bpsin<0 or bpsout<0; | ||
+ | delete from summaryinterfaces where firstseen>gettimeimmutable('7 day') and bytesin<0 or bytesout<0; | ||
+ | delete from summarytrafficinterfacein where firstseen>gettimeimmutable('7 day') and bytes<0; | ||
+ | delete from summarytrafficinterfaceout where firstseen>gettimeimmutable('7 day') and bytes<0; |
Latest revision as of 08:57, 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('7 day') and srcbytes> 1000000000000 or dstbytes>1000000000000; delete from summarytraffic where firstseen>gettimeimmutable('7 day') and bytes>1000000000000; delete from interfacestats where firstseen>gettimeimmutable('7 day') and bpsin>1000000000000or bpsout>1000000000000; delete from summaryinterfaces where firstseen>gettimeimmutable('7 day') and bytesin> 1000000000000 or bytesout>1000000000000; delete from summarytrafficinterfacein where firstseen>gettimeimmutable('7 day') and bytes>1000000000000; delete from summarytrafficinterfaceout where firstseen>gettimeimmutable('7 day') and bytes>1000000000000;
delete from summarytrafficgroups where firstseen>gettimeimmutable('7 day') and srcbytes<0 or dstbytes<0; delete from summarytraffic where firstseen>gettimeimmutable('7 day') and bytes<0; delete from interfacestats where firstseen>gettimeimmutable('7 day') and bpsin<0 or bpsout<0; delete from summaryinterfaces where firstseen>gettimeimmutable('7 day') and bytesin<0 or bytesout<0; delete from summarytrafficinterfacein where firstseen>gettimeimmutable('7 day') and bytes<0; delete from summarytrafficinterfaceout where firstseen>gettimeimmutable('7 day') and bytes<0;