reporting on db connect downloads

[a212830]

Hi,

Is there a way to show how long it takes db connect to complete each tail? I' like to graph this, so we can make adjustments as needed.

[ziegfried · Accepted solution]

Yes, the internal log of DB Connect contains that information. Here are a few search you can use:

Get aggregated information for the inputs for the selected timerange (Duration, Number of Invocations, Number of results):

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | stats count as number_of_invocations avg(duration) as avg_duration min(duration) as min_duration max(duration) as max_duration avg(resultCount) as avg_results_per_invocation sum(resultCount) as total_results by input | eval avg_duration=tostring(round(avg_duration),"duration") | eval min_duration=tostring(min_duration,"duration") | eval max_duration=tostring(max_duration,"duration") 

Or print duration of invocations over time:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart avg(duration) by input

Number of invocations over time (chart):

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart count by input

Avg. invocations per minute per input:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | bucket _time span=1m | stats count as per_minute by _time,input | timechart avg(per_minute) by input

Number of (indexed) results over time:

index=_internal sourcetype=dbx_debug logger="Scheduler" input=* | timechart sum(resultCount) by input

[a212830]

Wow. Great stuff!