Hi,
To best review this we would need to see the table definition of all these tables.
But one factor here is probably also going to be the high number of shards in relation to the size of the tables, please take a look at Sharding and partitioning guide for time-series data - Tutorials - CrateDB Community