Redshift Observatory

System Table Tracker

System view pg_catalog.svv_schema_quota_state version 1.0.52931 / 2023-07-07

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