Information of druid segments for a given data source

druid_segment_statistics.sql

SELECT
  "start",
  "end",
  version,
  COUNT(*) AS num_segments,
  AVG("num_rows") AS avg_num_rows,
  MIN("num_rows") AS min_num_rows,
  max("num_rows") AS max_num_rows,
  SUM("num_rows") AS total_num_rows,
  MIN("size") / 1024 / 1024 AS min_size,
  MAX("size") / 1024 / 1024 AS max_size,
  AVG("size") / 1024 / 1024 AS avg_size,
  SUM("size") / 1024 / 1024 AS total_size,
  MAX("partition_num") AS partitions_count
FROM
  sys.segments A
WHERE
  datasource = '<DATA_SOURCE_NAME>' 
  AND is_published = 1
  -- AND is_realtime = 1
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3 DESC