I am executing one influxSQL query which is returning result in more than 1 minutes.
select SUM(call_duration) as total_duration,Count(Distinct(recipient_id)) as total_recipients from xyz where target_id = '1';
Separate queries like
select Count(Distinct(recipient_id)) as total_recipients from xyz where target_id = '1'; select SUM(call_duration) as total_duration from xyz where target_id = '1';
are also takes more than 1 minutes to result the return .
select MAX(call_duration), MIN(call_duration) from xyz where target_id = '1';
Return results very fast, in seconds like 3-4 seconds.
table(measurements) xyz is very large. there are more than 10 million records that matches this where condition.
call_duration and recipient_id are Fields while target_id is Tag
While MIN and MAX function returning results very fast, i suspect why SUM is taking more time?
InfluxDB version: 1.7.4
Machine Configuration - AWS EC2 - t2.medium (4 GB RAM)
[meta] dir = "/var/lib/influxdb/meta" [data] dir = "/var/lib/influxdb/data" wal-dir = "/var/lib/influxdb/wal" series-id-set-cache-size = 100 [coordinator] [retention] [shard-precreation] [monitor] [http] enabled = true auth-enabled = true log-enabled = true access-log-path = "/var/log/influxdb/http_access.log" write-tracing = false max-body-size = 0 max-concurrent-write-limit = 0 [logging] [subscriber] [[graphite]] [[collectd]] [[opentsdb]] [[udp]] [continuous_queries] [tls]
I think that result should returned in 5-6 seconds