timestats¶
Type of operation: Aggregate
Description¶
Aggregate resource columns at every point in time, based on (optional) grouping columns
Usage¶
timestats [ groupby ] ..., groupOrAggregateFunction ...
Argument |
Type |
Required |
Multiple |
---|---|---|---|
groupby |
fieldref |
Optional |
Can be multiple |
groupOrAggregateFunction |
expression |
Required |
Can be multiple |
Accelerable¶
timestats is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs, can be accelerated, making queries on the dataset respond faster.
Examples¶
timestats Count:count(1), group_by(server_name)
Group input resource by server name, calculating a count of rows for each slice of time per server name, returning a dataset with the 4 columns ‘valid_from’, ‘valid_to’, ‘server_name’, and ‘Count’. As opposed to timechart, this calculates values that change at any point in time, whereas timechart calculates aggregates per fixed bucket.