I have the following table. It is stored as a TimescaleDB hypertable. Data rate is 1 row per second. CREATE TABLE electricity_data ( "time" timestamptz NOT NULL, meter_id integer REFERENCES meters NOT NULL, import_low double precision, import_normal double precision, export_low…
I'm trying to build a pandas df with an SQL postgres timescale db query and this works below but the problem is the query builds an enourmous file for the one point I am after /5231/REGCHG total_power. The data has…
I have a script trying to restart postgresql docker container: DOCKER_CONTAINER_NAME="timescaledb" docker restart -t 1 $DOCKER_CONTAINER_NAME timeout 9000000s bash -c "until docker exec $DOCKER_CONTAINER_NAME pg_isready ; do sleep 1 ; done" However, this line (with any -t number) docker restart…
I have a table tab1 in timescale db which has 3 columns tag, time, value. time and tag make up the pk for the table: (time, tag). There are more than 500 lakhs (50 000 000) of rows. I need…
I have 'stock_price_15m' table which stores 15 minute OHLC candlestick data. niftydb=# d stock_price_15m; Table "public.stock_price_15m" Column | Type | Collation | Nullable | Default ----------+--------------------------+-----------+----------+--------- stock_id | integer | | not null | dt | timestamp with time zone…
I'm facing issues with a jsonb ARRAY column in PostgreSQL. I need to sum this column for each row. Expected Result: index sum(snx_wavelenghts) 1 223123 2 223123
Description So, I'm working on a project that stores sensor measurements from multiple devices in PostgreSQL+TimescaleDB database. The structure of the table (hypertable): column_name type comment identifier text device identifier key text name of the metric value_num double precision numeric…
I have below price audit table in timescale db. When I get new price I should calculate minimum price in last 30 days. But our price data not daily. In every price changes I write date and price to table.…
I want to subract additional time in $__timeFilter in grafana. Like if I have selected Last 7 days, I want to run 2 queries which do a comparison like one query gives me avg cpu utilization for last 7 days…
Environment: Hardware: 8Core, 32GB as a guest OS in VMWare 1TB for data in VSAN Software OS: CentOS 7 64bit JDK version: 11.0.7 PostgreSQL version: 13 Timescaledb version: 2.3.0 PostgreSQL JDBC version: 42.2.18 I have already run timescaledb-tune to optimize…