> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Informational views overview

> 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

export const TIMESCALE_DB = 'TimescaleDB';

export const CAGG = 'continuous aggregate';

export const CHUNK = 'chunk';

export const HYPERTABLE = 'hypertable';

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

These informational views query {TIMESCALE_DB}'s internal catalog—system tables that store metadata
about your database objects, configurations, and jobs. When you create a {HYPERTABLE}, add a
retention policy, or schedule a job, {TIMESCALE_DB} registers this information in its catalog. The
views provide a convenient, user-friendly interface to access this metadata without directly querying
internal tables.

## Samples

### Get all hypertables in your database

View all {HYPERTABLE}s with their size and compression status:

```sql theme={"dark"}
SELECT hypertable_name,
       num_dimensions,
       num_chunks,
       compression_enabled
FROM timescaledb_information.hypertables;
```

### Check chunk information for a hypertable

View all {CHUNK}s for a specific {HYPERTABLE}:

```sql theme={"dark"}
SELECT chunk_name,
       range_start,
       range_end,
       is_compressed
FROM timescaledb_information.chunks
WHERE hypertable_name = 'conditions'
ORDER BY range_start DESC;
```

### Monitor background jobs

View all scheduled jobs and their next execution time:

```sql theme={"dark"}
SELECT job_id,
       application_name,
       schedule_interval,
       next_start
FROM timescaledb_information.jobs
ORDER BY next_start;
```

### Check job execution history

View recent job runs and their success/failure status:

```sql theme={"dark"}
SELECT job_id,
       last_run_started_at,
       last_successful_finish,
       last_run_status,
       total_runs,
       total_failures
FROM timescaledb_information.job_stats
ORDER BY last_run_started_at DESC
LIMIT 10;
```

### View continuous aggregate details

Get information about all {CAGG}s:

```sql theme={"dark"}
SELECT view_name,
       view_definition,
       materialized_only,
       compression_enabled,
       finalized
FROM timescaledb_information.continuous_aggregates;
```

### Check compression settings

View compression settings for all {HYPERTABLE}s:

```sql theme={"dark"}
SELECT hypertable,
       segmentby,
       orderby,
       compress_interval_length
FROM timescaledb_information.hypertable_compression_settings
ORDER BY hypertable;
```

## Available views

### Hypertable and chunk information

* [`timescaledb_information.chunks`][chunks]: get metadata about {HYPERTABLE} {CHUNK}s
* [`timescaledb_information.dimensions`][dimensions]: get information on the dimensions of {HYPERTABLE}s
* [`timescaledb_information.hypertables`][hypertables]: get metadata about {HYPERTABLE}s

### Compression information

* [`timescaledb_information.chunk_compression_settings`][chunk_compression_settings]: get information about compression
  settings for all {CHUNK}s
* [`timescaledb_information.compression_settings`][compression_settings]: get information about compression settings
  for {HYPERTABLE}s (deprecated)
* [`timescaledb_information.hypertable_compression_settings`][hypertable_compression_settings]: get information about
  compression settings for all {HYPERTABLE}s

### Continuous aggregates

* [`timescaledb_information.continuous_aggregates`][continuous_aggregates]: get metadata and settings information for
  {CAGG}s

### Jobs and policies

* [`timescaledb_information.job_errors`][job_errors]: get information about background job errors
* [`timescaledb_information.job_history`][job_history]: get information about background job execution
* [`timescaledb_information.job_stats`][job_stats]: get information and statistics about automatically run jobs
* [`timescaledb_information.jobs`][jobs]: get information about all jobs registered with the automatic scheduler
* [`timescaledb_experimental.policies`][policies]: get information about all policies set on {CAGG}s

[chunk_compression_settings]: /api-reference/timescaledb/informational-views/chunk_compression_settings

[chunks]: /api-reference/timescaledb/informational-views/chunks

[compression_settings]: /api-reference/timescaledb/informational-views/compression_settings

[continuous_aggregates]: /api-reference/timescaledb/informational-views/continuous_aggregates

[dimensions]: /api-reference/timescaledb/informational-views/dimensions

[hypertable_compression_settings]: /api-reference/timescaledb/informational-views/hypertable_compression_settings

[hypertables]: /api-reference/timescaledb/informational-views/hypertables

[job_errors]: /api-reference/timescaledb/informational-views/job_errors

[job_history]: /api-reference/timescaledb/informational-views/job_history

[job_stats]: /api-reference/timescaledb/informational-views/job_stats

[jobs]: /api-reference/timescaledb/informational-views/jobs

[policies]: /api-reference/timescaledb/informational-views/policies