Spanner - How to find table size

Question

cloud spanner in database detail has: Total storage.

Can i take this value by query?

Also how to find tables sizes (by query). At the end of which will be total storage size.

Thank you

Answer 1

Cloud Spanner table sizes aren't currently exposed.

Answer 2

To get a general idea of the tables size porportions, we check the resulted avro files sizes when exporting the DB (we have a daily job for backup). Of-course it is not accurate since it's a whole different storage model.