Postgres TimeScale database understandings

[pogie_email_cz_]

Hi everyone, we'd like to optimize data in our Building Operation WorkStation. We have many units, which inserts stats into TimeScale Postgres database under Windows. 

Parameter "Delta" says "if there is value more than this parameter, write to DB", otherwise write stats into DB after "Maximum log interval" value.

The problem is, if the value delta is wrongly set, there are thousands of inserts into DB and the DB grow up quickly. 

Now we'd like to create SQL query, which returns "first 20 from TimeScaleDB with the highest frequency inserted value in the specific interval (for example 14 days).

The query itself is simple. The problem is in DB, which is very complex and not intuitive. Now my question is:

Does exist any other way how to determine units with the most inserts in the whole TimeScale DB?

OR 

Does exist technical specification of Building Operation WorkStation, which specify postresql database specification and operation insertion?

Our system is running on:

Building Operation WorkStation version 3.2.1.630

Postgres 1.9.1

TimeScale 11_1.7.4

Thank you

Regards

Jiri

[Hilll]

TimescaleDB is an open-source database invented to make SQL scalable for time-series data. It’s a relatively new database system. TimescaleDB has been introduced to the market two years ago and reached version 1.0 in September 2018. Nevertheless, it’s engineered on top of a mature RDBMS system. TimescaleDB is packaged as a PostgreSQL extension. All code is licensed under the Apache-2 open-source license, Target Card Balance Now with the exception of some source code related to the time-series enterprise features licensed under the Timescale License (TSL).