russorat on bundler
russorat on master
Bump json from 1.8.1 to 2.3.1 … Merge pull request #1 from infl… (compare)
dependabot[bot] on bundler
Bump json from 1.8.1 to 2.3.1 … (compare)
hello there! A query question. Do you know if it is possible to sum the total sum of two independent measurements in a single query? For instance, for query
select sum(value) from metric_1_traffic_in,metric_2_traffic_in where time > now() - 1h ; the following is returned:
name: metric_1_traffic_in time sum ---- --- 1573034400000000000 308346.88 name: metric_2_traffic_in time sum ---- --- 1573034400000000000 150405.12000000002
Is there a way to have 308346.88 + 150405.12000000002 in a single result row?
Hello All ! I’d like to understand what would be the efficient query to filter a large number of tag values while performing a group by . Here’s an example
Let’s assume we have 5000 hosts which have telegraf running and all of them send their metrics to an influxdb located elsewhere . Lets take the “CPU” telegraf metric for example . Now I’d like to fetch the average CPU consumed for a list of hosts which can be say around 300 . Now “host” is a tag for each metric which is unique for each host.
What would be the most efficient way to query influx to just get the average cpu for the last 1 day for 300 specific hosts?
Lets say the tag values for host are host1,host2,host3 etc
I currently know of only 2 methods
1) Just chain the OR statements
select mean(usage_system) from cpu where time > now() - 1d where host=‘host1’ or host=‘host2’ or … (for 300 hosts) group by host
select mean(usage_system) from cpu where time > now() - 1d where host ~= /host1|host2|host3|…(300hosts)/ group by host
I find both of them highly inefficient . Is there a better way to do this?
client.WriteAPItakes org, bucket but not sure, doesn't seem necessary?