How to find the size of single row in crate db

CrateDB
4

you can calculated an average required disk size like this:

SELECT 
  schema_name,
  table_name,
  SUM(num_docs),
  SUM(size),
  SUM(size) / SUM(num_docs)::DOUBLE as avg_size_in_bytes
FROM sys.shards
where PRIMARY
GROUP BY 1,2
2 Likes