This message was deleted.

Eg 2: Per dataSource total size -

❯ curl '<http://localhost:8888/druid/v2/sql>' \
  -H 'Accept: application/json, text/plain, */*' \
  -H 'Accept-Language: en-GB,en-US;q=0.9,en;q=0.8' \
  -H 'Connection: keep-alive' \
  -H 'Content-Type: application/json' \
  -H 'Origin: <http://localhost:8888>' \
  -H 'Referer: <http://localhost:8888/unified-console.html>' \
  -H 'Sec-Fetch-Dest: empty' \
  -H 'Sec-Fetch-Mode: cors' \
  -H 'Sec-Fetch-Site: same-origin' \
  -H 'Sec-GPC: 1' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36' \
  --data-raw '{"query":"SELECT\ndatasource,\nSUM(\"size\") FILTER (WHERE is_published = 1 AND is_overshadowed = 0) AS total_data_size \nFROM sys.segments\nGROUP BY 1\nORDER BY 1"}' \
  --compressed |json_pp -json_opt pretty,canonical