Skip to content
🚀 Agentic Postgres: The first database built for agents 🤖
TimescaleDB - Timeseries database for PostgreSQL Docs
  • TigerData.com
  • Try for free
Get started
Try the key Tiger Data features
Start coding with Tiger Data
Create a Tiger Cloud service
About Tiger Data products
Tiger Data architecture for real-time analytics
Pricing plans and account management
Changelog
Use Tiger Data products
Hypertables
Hypercore
Continuous aggregates
Tutorials
Integrations
API Reference
Hypertables and chunks
Hypercore
Continuous aggregates
Data retention
Jobs and automation
UUIDv7 functions
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
Service configuration
Administration Functions
API Reference Tag Overview
Tiger Cloud REST API
Glossary
Compression (Old API, replaced by Hypercore)
Distributed hypertables (Sunsetted v2.14.x)
Import and sync
Integrate AI with Tiger Data
Other deployment options
Find a docs page
TimescaleDB API reference

Informational Views

Tiger Cloud: Performance, Scale, Enterprise, Free

Self-hosted products

MST

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

Information views
The full list of informational views available in TimescaleDB. Informational views provide detailed information about the state of your data, hypertables, chunks, and any jobs or policies you have in place
timescaledb_information.job_stats
Get information and statistics about automatically run jobs
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