I have a materialized view named "hourly_metrics" on my table. It is a straightforward view that stores max, min, avg, stdedev and so on at hourly intervals. The thing here is that I also ...

I am using QuestDB Enterprise and I want to know which users are sending queries to the cluster and how long the queries take to execute. I know I can parse the information from the logs, but that's a ...

I am trying to import a CSV file to an existing table. The timestamps defined in the CSV file are in milliseconds. If I try to importing using the REST API or web interface I get an error on all ...

I am starting with QuestDB. I am trying a very simple example shown below. The system works for a few seconds, then it breaks with the connection failed error. Can someone please help me understand ...

I want to calculate Bollinger bands in QuestDB. I tried using directly the postgresql query seen at Preparing bollinger bands with postgresql - STDDEV and PARTITION BY, but I get an error. This is the ...

I’m using the latest version with he Go client on an AWS EC2 instance. I see more and more random tables created based on what looks like some of the payload/column values. This is happening random. ...

I'm working with a dataset where an IoT device sends a wh (watt-hour) value at discrete timestamps, identified by an operationId. I want to visualize this data by plotting the sum of average power per ...

I make a table: CREATE TABLE ‘MyTab’ ( index_time TIMESTAMP, ColA DOUBLE NULL, ColB DOUBLE NULL, ColC DOUBLE NULL, ColD DOUBLE NULL ) timestamp(index_time) PARTITION BY DAY WAL DEDUP UPSERT KEYS(...

What's the fastest way to query data? Typically I would use polars to just read directly with zero copy through their ConnectorX engine uri = "postgresql://username:password@server:port/database&...

I want to use QuestDB inside railway over internal IP, so I need to configure IPv6. If I configure QuestDB as http.net.bind.to=0.0.0.0:9000 is not accessible via curl http://[::1]:9000/ When I try to ...

I have data file CSV with 230 Million of rows daily and more. For each timestamp I have a value and a name, composed like a path MainFolder.SubFolder.SubSubFolder.Name I’m using the structure below, I’...

I wrote 1G parquet file into QuestDB and the result table size became 15G. The data seems to match, same row number, same column values. Why is it so much bigger in QuestDB? How can I make it smaller?

I am loading data from yesterday into a large table and I noticed ingestion was quite fast, but after finishing ingesting almost 800 million records, QuestDB was displaying only about 500 million rows ...

I have a script using psycopg to ingest data in QuestDB, as seen in the docs. After a while I see this error on the logs and the table is marked as suspended PGConnectionContext error [msg=`Invalid ...

I have a question regarding the SAMPLE BY query method, which live demo has in the OHLC downsample example. I copied the query down below /* Aggregations for the BTC-USDT for today downsampled in 15-...