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
Create your first Timescale service
Try the key Timescale features
Start coding with Timescale
About Timescale products
Timescale architecture for real-time analytics
Pricing plans and account management
Changelog
Use Timescale
Hypertables
Hypercore
Continuous aggregates
Tutorials
Integrations
API Reference
Hypertables and chunks
CREATE TABLE
create_hypertable (old API)
create_hypertable (even older API)
show_chunks
drop_chunks
reorder_chunk
split_chunk
merge_chunks
move_chunk
add_reorder_policy
remove_reorder_policy
attach_tablespace
detach_tablespace
detach_tablespaces
show_tablespaces
set_chunk_time_interval
set_integer_now_func
add_dimension
add_dimension (old interface)
enable_chunk_skipping
disable_chunk_skipping
create_index (transaction per chunk)
hypertable_size
hypertable_approximate_size
hypertable_detailed_size
hypertable_approximate_detailed_size
hypertable_index_size
chunks_detailed_size
Hypercore
Continuous aggregates
Data retention
Jobs and automation
Hyperfunctions
Informational views
Configuration
Administration Functions
API Reference Tag Overview
Compression (Old API, replaced by Hypercore)
Distributed hypertables (Sunsetted v2.14.x)
Migrate and sync data to Timescale Cloud
AI and Vector: pgai on Timescale
Other deployment options
Find a docs page
TimescaleDB API referenceHypertables and chunks

split_chunk()

CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.

Timescale Cloud: Performance, Scale, Enterprise

Self-hosted products

MST

Split a large chunk at a specific point in time.

Required arguments

NameTypeDescription
chunkREGCLASSName of the chunk to split.
split_atTIMESTAMPTZTimestamp to split the chunk at.

Returns

This function returns void.

Sample usage

Split a chunk at a specific time:

CALL split_chunk('chunk_1', split_at => '2025-03-01 00:00');

Keywords

chunkshypertablessplit

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

Previousreorder_chunkNextmerge_chunks

Related Content

Hypertables and chunks
Timescale Cloud API reference for dealing with hypertables and chunks. Includes all SQL functions and views related to managing hypertables, chunks, dimensions, tablespaces, and indexing
move_chunk()
Move a chunk and its indexes to a different tablespace
show_chunks()
Show the chunks belonging to a hypertable
CREATE INDEX (Transaction Per Chunk)
Create a hypertable index using a separate transaction for each chunk
add_dimension()
Add a space-partitioning dimension to a hypertable
reorder_chunk()
Reorder rows in a chunk