W dniu czwartek, 18 sierpnia 2016 22:37:28 UTC+2 użytkownik Sean Beckett napisał: > 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/msgid/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
Thanks for reply but I wasnt asking for this ;) But I have CQs with Group By time(30d) 7d and 1d, I would like check it when is next run going if I forgot for example or for someone else. Like have this info in show CONTINUOUS QUERIES, that last run was at TS and next is on TS. -- 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/84f1d420-b3a5-4e83-a6c9-a3bbd2608b4c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
