Real time update

Hello, correct me if I am wrong, does Grafana have to query all the data in the time range at a given refresh rate? I would like to query just the most recent steps and add them to the time series while the ones I do not need stop getting displayed. Is it a query issue or is it something Grafana simply cannot do?

I would like to have a refresh rate of about 0.1s on a 30s time series of 10hz sampled data, hosted and visualized locally over a raspberry pi postgres db.

Maybe this is not possible? I keep getting errors.

Thank you very much