gp_size_of_schema_disk
The gp_toolkit.gp_size_of_schema_disk view shows schema sizes for the public schema and the user-created schemas in the current database.
This view is accessible to all users.
However, non‑superusers will be able to see only the schemas that they have permission to access.
| Column | Description |
|---|---|
sosdnsp |
The name of the schema |
sosdschematablesize |
The total size of tables in the schema in bytes |
sosdschemaidxsize |
The total size of indexes in the schema in bytes |