Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svv_schema_quota_state disk_usage int4
pg_catalog svv_schema_quota_state disk_usage_pct float8
pg_catalog svv_schema_quota_state quota int4
pg_catalog svv_schema_quota_state schema_id int4
pg_catalog svv_schema_quota_state schema_name name
pg_catalog svv_schema_quota_state schema_owner int4

View Text

SELECT sqs.schema_id,
       pgn.nspname AS schema_name,
       pgn.nspowner AS schema_owner,
       sqs.quota,
       sqs.disk_usage,
       round((CAST(sqs.disk_usage AS double precision) * CAST(100 AS double precision)) / CAST(sqs.quota AS double precision),
             CAST(2 AS numeric)) AS disk_usage_pct
FROM stv_schema_quota_state AS sqs
     INNER JOIN pg_namespace AS pgn ON CAST(sqs.schema_id AS oid) = pgn.oid


Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers