Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
  • Try for free
Install TimescaleDB
Getting started
TimescaleDB
Overview
How-to Guides
Connecting to TimescaleDB
Hypertables
Distributed hypertables
Time buckets
Write data
Data migration
Ingest data from other sources
Query data
About querying data
SELECT data
Perform DISTINCT queries with SkipScan
Perform advanced analytic queries
Troubleshooting
Configuration
Schema management
Compression
Data retention
Continuous aggregates
User-defined actions
Alerting
Backup and restore
Upgrade TimescaleDB
Hyperfunctions
Multi-node
Replication and High Availability
Additional tooling
Uninstall TimescaleDB
Troubleshoot TimescaleDB
Tutorials
Code quick starts
Contribute to TimescaleDB
Contribute to documentation
Compare TimescaleDB Editions
API Reference
Timescale Cloud
Managed Service for TimescaleDB
Promscale
Try for free
TimescaleDBHow-to guides
Versions:

Querying data

TimescaleDB hypertables are PostgreSQL tables. That means you can query them with standard SQL commands. In addition, you get extra benefits from TimescaleDB architecture and query planning.

  • About querying data
  • Select data with SELECT
  • Get faster DISTINCT queries with SkipScan
  • Perform advanced analytic queries

Found an issue on this page?

Report an issue!

Keywords

queries
PreviousIngesting data with TimescaleDB parallel copyNextAbout querying data

Related Content

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
Troubleshooting queries
Suggestions for troubleshooting common problems in queries
About querying data
How to query data in TimescaleDB
Perform advanced analytic queries
Perform advanced data analysis using native PostgreSQL queries and TimescaleDB hyperfunctions
Query data in distributed hypertables
How to query data in distributed hypertables