Minimum Sample By Interval

[nicholas-a-guerra]

To reproduce

When configuring this plugin, it would be very helpful to be able to set a minimal interval used by the sample by variable. As of now, if you you zoom into enough and it reduces the sample by interval smaller than the frequency of ingestion, then aggregate functions will likely have unintended consequences. This is can be shown in this use case below:

If you view the queries that the sample by variable creates, it shows that the first image corresponds to a 1s sample by and the second is a 500T. The data ingestion rate it only once per second though. And as such the aggregate calculations come back incorrect for 500T.

The postgres grafana plugin fixes this by having a minimum interval option in the configuration like below:

https://grafana.com/docs/grafana/latest/datasources/postgres/#min-time-interval

QuestDB version:

8.2.1

Grafana version:

11.3.0

Plugin version:

0.1.3

OS, in case of Docker specify Docker and the Host OS:

Docker | Ubuntu

Full Name:

Nick Guerra

Affiliation:

Kronus Engineering

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response

[javier]

Thanks! Just a note that this is not a bug of the plugin, and that the postgresql config options goes at the connection level, in case we want to replicate it