TimescaleDB size sensor

Configuration
1

Hello all,

I run TimescaleDB and want to create a mb size sensor. I tried everyting but its keep saying that my SQL query is invalid.

thumbnail_IMG_9548
thumbnail_IMG_9548481×640 81.2 KB

thumbnail_IMG_9549
thumbnail_IMG_9549481×640 92.4 KB

I tried:

  • postgresql://user:password@host/dsmrreader
  • postgresql://user:password@ip/dsmrreader
  • postgresql://user:password@ip/timescale

for the query:

  • SELECT (pg_database_size(‘dsmrreader’)/1024/1024) as db_size;
  • SELECT (pg_database_size(‘dsmrreader’)/1024/1024) as db_size
  • SELECT (pg_size_pretty(‘dsmrreader’)/1024/1024) as db_size;
    All kind of combinations but getting the error everytime. Someone know the solution? Thnx! :pray: