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.
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
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
Wow. Great stuff!