timescaledb ​

Hypertable, chunk, and compression statistics:

Table of Contents ​

• pgexporter_timescaledb_chunk_age_distribution_chunk_count
• pgexporter_timescaledb_columnstore_health_total_columnstore_hypertables
• pgexporter_timescaledb_columnstore_health_unique_columnstore_hypertables
• pgexporter_timescaledb_compression_config_total_compressed_hypertables
• pgexporter_timescaledb_compression_config_unique_compressed_hypertables
• pgexporter_timescaledb_compression_effectiveness_avg_chunk_age_days
• pgexporter_timescaledb_compression_effectiveness_compressed_chunks
• pgexporter_timescaledb_compression_effectiveness_compression_ratio_pct
• pgexporter_timescaledb_compression_effectiveness_total_chunks
• pgexporter_timescaledb_hypertable_overview_compressed_hypertables
• pgexporter_timescaledb_hypertable_overview_dimension_types
• pgexporter_timescaledb_hypertable_overview_total_chunks
• pgexporter_timescaledb_hypertable_overview_total_hypertables
• pgexporter_timescaledb_job_health_failed_jobs
• pgexporter_timescaledb_job_health_paused_jobs
• pgexporter_timescaledb_job_health_running_jobs
• pgexporter_timescaledb_job_health_total_jobs
• pgexporter_timescaledb_recent_job_failures_seconds_since_failure

pgexporter_timescaledb_hypertable_overview_total_hypertables ​

The total number of hypertables defined in the database.

pgexporter_timescaledb_hypertable_overview_total_chunks ​

The total number of chunks across all hypertables in the database.

pgexporter_timescaledb_hypertable_overview_compressed_hypertables ​

The number of hypertables that have compression enabled.

pgexporter_timescaledb_hypertable_overview_dimension_types ​

Count of hypertables grouped by their dimension types in TimescaleDB.

pgexporter_timescaledb_job_health_total_jobs ​

The total number of TimescaleDB background jobs configured.

pgexporter_timescaledb_job_health_failed_jobs ​

The number of TimescaleDB background jobs that failed on their most recent execution.

pgexporter_timescaledb_job_health_running_jobs ​

Number of currently running background jobs in TimescaleDB.

pgexporter_timescaledb_job_health_paused_jobs ​

Number of paused background jobs in TimescaleDB.

pgexporter_timescaledb_compression_effectiveness_total_chunks ​

Total number of chunks for a TimescaleDB hypertable.

pgexporter_timescaledb_compression_effectiveness_compressed_chunks ​

Number of compressed chunks for a TimescaleDB hypertable.

pgexporter_timescaledb_compression_effectiveness_compression_ratio_pct ​

Compression ratio as percentage for TimescaleDB hypertable chunks.

pgexporter_timescaledb_compression_effectiveness_avg_chunk_age_days ​

Average age in days of compressed chunks in TimescaleDB.

pgexporter_timescaledb_compression_config_total_compressed_hypertables ​

Total number of compressed hypertables in TimescaleDB.

pgexporter_timescaledb_compression_config_unique_compressed_hypertables ​

Number of unique compressed hypertables in TimescaleDB.

pgexporter_timescaledb_columnstore_health_total_columnstore_hypertables ​

Total number of columnstore hypertables in TimescaleDB.

pgexporter_timescaledb_columnstore_health_unique_columnstore_hypertables ​

Number of unique columnstore hypertables in TimescaleDB.

pgexporter_timescaledb_recent_job_failures_seconds_since_failure ​

Time elapsed in seconds since the most recent job failure in TimescaleDB.

pgexporter_timescaledb_chunk_age_distribution_chunk_count ​

Number of chunks in each age category for TimescaleDB hypertables.