TimescaleDB vs InfluxDB

Audits hypertable chunk compression efficiency and identifies uncompressed chunks exceeding retention policy windows.

-- Inspect hypertable chunk counts, compression status, and disk savings
SELECT
  hypertable_name,
  num_chunks,
  ROUND(uncompressed_total_bytes / 1024 / 1024 / 1024.0, 2) AS uncompressed_gb,
  ROUND(compressed_total_bytes / 1024 / 1024 / 1024.0, 2) AS compressed_gb,
  ROUND(
    (1.0 - (compressed_total_bytes::numeric / NULLIF(uncompressed_total_bytes, 0))) * 100,
    2
  ) AS compression_ratio_pct
FROM timescaledb_information.hypertables
ORDER BY uncompressed_total_bytes DESC;

-- Identify uncompressed chunks older than 7 days
SELECT chunk_name, hypertable_name, range_start, range_end, is_compressed
FROM timescaledb_information.chunks
WHERE is_compressed = false
  AND range_end < (NOW() - INTERVAL '7 days')
ORDER BY range_end ASC
LIMIT 10;

Monitors series cardinality creation rates and query duration to catch tag explosions before memory exhaustion occurs.

# Query monitoring bucket for TSI series creation and query durations
influx query '
from(bucket: "_monitoring")
  |> range(start: -1h)
  |> filter(fn: (r) => r._measurement == "storage_tsi_series_created" or r._measurement == "query_duration_seconds")
  |> aggregateWindow(every: 5m, fn: mean)
  |> yield(name: "telemetry")
'

# Audit series cardinality per bucket on disk (v2/v3)
influx inspect report-tsi \
  --bucket-id 0123456789abcdef \
  --data-dir /var/lib/influxdb2/engine/data/ \
  --detailed