I was explaining that it is fairly easy to determine the next time a CQ will run, although I agree it would be a good feature to add to something like SHOW CONTINUOUS QUERIES. Perhaps you can open a companion issue to https://github.com/influxdata/influxdb/issues/5187, which is for showing the last time it ran.
On Fri, Aug 19, 2016 at 12:42 AM, <[email protected]> wrote: > 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. > -- 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/CALGqCvOCCfCreDUKj_CfMLs0ukmr4CBn7esf5QfHWhXfEb0J9w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
