Requesting queries with different execution intervals

[benbkim]

I'm submitting a ...

• [ ] bug report
• [x] feature request

What is the current behavior?

We would like to run queries with different execution times. For example, the query that checks table space fullness doesn’t need to run frequently. However, queries checks lock or app session info needs to run more frequently. I don’t see a way of running queries with different execution intervals. It seems all queries are running with the same execution intervals.

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem

What is the expected behavior?

What is the motivation / use case for changing the behavior?

Some queries do not need to run as frequently as others.

Please tell us about your environment:

We are using the latest Oracle Prometheus on Oracle 19c Version: X.Y.Z

[benbkim]

It would be very helpful to have this feature. Thank you.

[Pawel-Gosek]

I had the same issue and as a workaround I'm adding time constraints to some queries, like: "and (to_char(sysdate,'HH24')=10 and to_char(sysdate,'MI')<20)" Depending on your needs this could be doable this way.