Persisted aggregation does not work as expected for Postgres.

[janithcmw]

Describe the issue:
There is an issue in the SQL queries which emits for the Postgres database based on the persisted aggregation.

How to reproduce:
Enable persisted aggregation and start the servers, let the aggregation happen for the granularity higher than DAYS.

Expected behavior:
The server should not throw errors in the aggregation process.

Environment information

• Not relevant

[isharak]

This issue is being closed due to extended inactivity. Please feel free to reopen it if further attention is needed. Thank you for helping us keep the issue list relevant and focused!