Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
  • Try for free
Get started
Use Timescale
Services
Clouds and regions
Resources
PostgreSQL extensions
Connecting to Timescale
Hypertables
Distributed hypertables
About distributed hypertables
Create distributed hypertables
Insert data
Query data
Alter and drop distributed hypertables
Create foreign keys on distributed hypertables
Use triggers in distributed hypertables
Troubleshooting
Time buckets
Write data
Ingest data from other sources
Migration
Query data
Configuration
Schema management
Compression
Data retention
Continuous aggregates
High availability and replication
User-defined actions
Alerting
VPC
Backup and restore
Billing and account management
Metrics and logging
User Management
Upgrades
Hyperfunctions
Data tiering
Security
Timescale limitations
Troubleshoot Timescale
Tutorials
Code quick starts
API Reference
Other deployment options
About Timescale
Find a docs page
Use TimescaleDistributed hypertables

Query data in distributed hypertables

You can query a distributed hypertable just as you would query a standard hypertable or PostgreSQL table. For more information, see the section on writing data.

Queries perform best when the access node can push transactions down to the data nodes. To ensure that the access node can push down transactions, check that the enable_partitionwise_aggregate setting is set to on for the access node. By default, it is off.

If you want to use continuous aggregates on your distributed hypertable, see the continuous aggregates section for more information.

Keywords

distributed hypertablesmulti-nodequeriesTimescaleManaged Service for TimescaleDBself-hosted TimescaleDB

Found an issue on this page?

Report an issue!
PreviousInsert dataNextAlter and drop distributed hypertables

Related Content

Distributed hypertables
Distributed hypertables help you horizontally scale your data storage in multi-node clusters
Use triggers on distributed hypertables
How to set up triggers on a distributed hypertable
About distributed hypertables
Learn how distributed hypertables work in multi-node Timescale
Create distributed hypertables
Create a distributed hypertable in a multi-node Timescale instance
Querying data
Query data in Timescale
SELECT data
Query data from a hypertable using a standard SELECT command