Use TimescaleQuery data

About querying data

Querying data in Timescale works just like querying data in PostgreSQL. You can reuse your existing queries if you're moving from another PostgreSQL database.

Timescale also provides some additional features to help with data analysis:

  • Use PopSQL to work on data with centralized SQL queries, interactive visuals and real-time collaboration
  • The SkipScan feature speeds up DISTINCT queries
  • Hyperfunctions improve the experience of writing many data analysis queries
  • Function pipelines bring functional programming to SQL queries, making it easier to perform consecutive transformations of data

Keywords

queries

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousQuery dataNextSELECT data

Related Content

Query data
Query data in Timescale
SELECT data
Query data from a hypertable using a standard SELECT command
Get faster DISTINCT queries with SkipScan
Speed up DISTINCT queries by setting up a hypertable to take advantage of SkipScan
Perform advanced analytic queries
Perform advanced data analysis using native PostgreSQL queries and Timescale hyperfunctions
Alerting
Set up alerting with Timescale
Write data
Write data to TimescaleDB