Skip to content

Instantly share code, notes, and snippets.

@kovid-r

kovid-r/tsbs_questdb_timescaledb_generate_data.sql

Created August 17, 2021 11:06
Show Gist options
  • Save kovid-r/1cf9f6436a89dd71eb1406ee75200437 to your computer and use it in GitHub Desktop.
Save kovid-r/1cf9f6436a89dd71eb1406ee75200437 to your computer and use it in GitHub Desktop.
Download ZIP
Sample SQL queries for testing read loads on TimescaleDB and QuestDB via TSBS.
Raw
tsbs_questdb_timescaledb_generate_data.sql
# TimescaleDB Query
SELECT * FROM cpu WHERE usage_user > 90.0
AND time >= '2016-01-01 07:47:52.646325 +0000'
AND time < '2016-01-01 19:47:52.646325 +0000';
# QuestDB Query
SELECT * FROM cpu WHERE usage_user > 90.0
AND timestamp >= '2016-01-01T07:47:52Z'
AND timestamp < '2016-01-01T19:47:52Z';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment