Postgres/TimescaleDB

Setup

CREATE TABLE sensor_data (
        time TIMESTAMPTZ NOT NULL,
        topic TEXT,
        value DOUBLE PRECISION
);

SELECT create_hypertable('sensor_data', 'time');

Insert data via Node-RED

INSERT INTO sensor_data (time, topic, value)
VALUES (
    now(),
    '{{{ msg.topic }}}',
    '{{{ msg.payload }}}'
);

Get table size

SELECT hypertable_size('sensor_data');

List all databases

SELECT datname FROM pg_database
WHERE datistemplate = false;

List all tables

SELECT table_catalog,table_schema,table_name FROM information_schema.tables 
WHERE table_type = 'BASE TABLE' AND table_schema = 'public' 
ORDER BY table_type, table_name