Skip to content
📣 Timescale at AWS Summit New York 🤝 Schedule a Meeting!
TimescaleDB - Timeseries database for PostgreSQL Docs
  • Timescale.com
  • Try for free
Get started
Try the key Timescale features
Start coding with Timescale
Create a Timescale service
About Timescale products
Timescale architecture for real-time analytics
Pricing plans and account management
Changelog
Use Timescale
Hypertables
Hypercore
Continuous aggregates
Timescale Cloud regions
Timescale Cloud services
Control user access to Timescale Cloud projects
Write data
Query data
About querying data
SELECT data
Perform DISTINCT queries with SkipScan
Perform advanced analytic queries
Troubleshooting
Time buckets
Schema management
Configuration
Import and ingest data
Alerting
Data retention
Tiered storage
Hyperfunctions
Metrics and logging
High availability and read replication
Maintenance and upgrades
PostgreSQL extensions
Backup, restore, and PITR
Jobs
Security
Timescale limitations
Troubleshoot Timescale
Compression (Old API, replaced by Hypercore)
Tutorials
Integrations
API Reference
Migrate and sync data to Timescale Cloud
AI and Vector: pgai on Timescale
Other deployment options
Find a docs page
Use Timescale

Query data

Timescale Cloud: Performance, Scale, Enterprise

Self-hosted products

MST

Timescale hypertables are PostgreSQL tables. That means you can query them with standard SQL commands. In addition to the extra benefits you get from Timescale architecture and query planning, use PopSQL to work on data with centralized SQL queries, interactive visuals and real-time collaboration

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

Keywords

queries

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

PreviousDelete dataNextAbout querying data

Related Content

SELECT data
Query data from a hypertable in Timescale Cloud using the 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
Querying data in Timescale Cloud works just like querying data in PostgreSQL, which means you can reuse your existing queries from another PostgreSQL database
Perform advanced analytic queries
Perform real-time data analysis using native PostgreSQL queries and Timescale Cloud hyperfunctions
Jobs in Timescale Cloud
Increase efficiency and reduce overhead by automating routine tasks. Set up custom jobs on top of Timescale Cloud policies. Learn how to create them in your service