CQs are executed on a pre-determined schedule, as determined by the RESAMPLE EVERY...FOR... clause in the CREATE CONTINUOUS QUERY statement. https://docs.influxdata.com/influxdb/v0.13/query_language/continuous_queries/#the-create-continuous-query-statement
CREATE CQ... SELECT...GROUP BY time(5m) END The above CQ will run once every 5 minutes, on the round-number time boundaries, (e.g. 00:00, 00:05, 00:10, etc.), over the previous 5 minutes. It leads to the system running the "SELECT... WHERE time >= 00:00 and time < 00:05" query at or just after 00:05. CREATE CQ RESAMPLE EVERY 1m SELECT...GROUP BY time(5m) END The above CQ will run once every minute, on the round-number time boundaries, (e.g. 00:00, 00:01, 00:02, etc.), over the previous round number boundary 5 minutes. It leads to the system running a "SELECT... WHERE time >= 00:00 and time < 00:05" query at or just after 00:01, 00:02, 00:03, 00:04, and 00:05. At 00:06 the system will run "SELECT... WHERE time >= 00:05 and time < 00:10". CREATE CQ RESAMPLE EVERY 1m FOR 10m SELECT...GROUP BY time(5m) END The above CQ will run once every minute, on the round-number time boundaries, (e.g. 00:00, 00:01, 00:02, etc.), over the previous *ten minutes, *e.g two round number boundary 5 minute intervals. It leads to the system running a "SELECT... WHERE time >= 00:00 and time < 00:05" query AND a "SELECT...WHERE time >= 23:55 and time < 00:00" query at or just after 00:01, 00:02, 00:03, 00:04, and 00:05. At 00:06 the system will run "SELECT... WHERE time >= 00:05 and time < 00:10" and "SELECT...WHERE time >= 00:00 and time < 00:05". On Wed, Aug 17, 2016 at 9:50 AM, <[email protected]> wrote: > Hi, > > like in topic, I have continous queries, but I dont know how can I check > time of next run for them ? Is it possible ? > Also is it possible to run one of them faster ? > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ms > gid/influxdb/ddb04032-e5a3-49ad-a00d-fd8b060136c4%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvP-QGNzEoE2%3DeLRhpf-DPUPfF22xo4m4T5Vsv2kK3mnDw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
