Skip to content
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 & chunks
Hypercore
Continuous aggregates
Data retention
Jobs and automation
Hyperfunctions
Informational views
timescaledb_information.chunks
timescaledb_information.chunk_compression_settings
timescaledb_information.continuous_aggregates
timescaledb_information.compression_settings
timescaledb_information.data_nodes
timescaledb_information.dimensions
timescaledb_information.hypertables
timescaledb_information.hypertable_compression_settings
timescaledb_information.jobs
timescaledb_information.job_stats
timescaledb_information.job_errors
timescaledb_information.job_history
timescaledb_experimental.policies
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 reference

Informational Views

TimescaleDB makes complex database features like partitioning and data retention easy to use with our comprehensive APIs. TimescaleDB works hard to provide detailed information about the state of your data, hypertables, chunks, and any jobs or policies you have in place.

These views provide the data and statistics you need to keep track of your database.

Keywords

information

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

PreviousState trackingNexttimescaledb_information.chunks

Related Content

timescaledb_information.job_stats
Get information and statistics about automatically run jobs
timescaledb_information.jobs
Get information about all jobs registered with the automatic scheduler
timescaledb_information.job_errors
Get information about background job errors
timescaledb_information.history
Get information about background job execution
hypertable_compression_stats()
Get hypertable statistics related to compression
hypertable_detailed_size()
Get detailed information about disk space used by a hypertable