Splunk Search

How to get average event size...

a212830
Champion

Is there a quick way (metadata? tstats?) to get the average event size for my events? Querying every event would take forever...

0 Karma

sloshburch
Splunk Employee
Splunk Employee

license_usage.log shows the size of the events...I usually use that so long as none were skipped.

0 Karma

Runals
Motivator

If you wanted a quick and dirty method you could do some math on the metrics logs (# events / size) but the larger your environment the less I trust the metrics log /shrug.

0 Karma

somesoni2
Revered Legend

AFAIK, Size of raw data is not stored in any metadata/tsidx, so only option would be to query raw data. May be run for a smaller period to avoid very long running query.

your base search | eval size=len(_raw) | stats avg(size)

twinspop
Influencer

Yep. Event size was important to my system at one point so I set-up an accelerated data model using the same eval you have shown above. With the ADM it's easy to grab stats based on sourcetype, source, index and/or host. Once the need passed, I disabled the acceleration.

0 Karma

a212830
Champion

Thanks. Is that bytes?

0 Karma

somesoni2
Revered Legend

Yes.......

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...