get chunk size + start, end for given table in timescaledb

chunk-details.sql

WITH size AS (
  SELECT
    concat(chunk_schema, '.', chunk_name) AS name,
    round(table_bytes / (1024 * 1024.0), 2) AS table_megs,
    round(index_bytes / (1024 * 1024.0), 2) AS index_megs,
    round(total_bytes / (1024 * 1024.0), 2) AS total_megs
  FROM
    chunks_detailed_size ('%%table%%')
  ORDER BY
    chunk_name,
    node_name
),
timerange AS (
  SELECT
    *
  FROM
    chunks_tstz
  WHERE
    hypertable::text = '%%table%%'
)
SELECT
  chunk,
  table_megs,
  index_megs,
  total_megs,
  time_range
FROM
  size s
  INNER JOIN timerange t ON s.name = t.chunk::text
ORDER BY
  time_range DESC

source of chunks_tstz view: https://github.com/timescale/timescaledb-extras/blob/master/views/chunks.sql