Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).


Records the occurrence, timestamp, XID, and other useful information when a schema quota is exceeded.

STL_SCHEMA_QUOTA_VIOLATIONS is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Some or all of the data in this table can also be found in the SYS monitoring view SYS_SCHEMA_QUOTA_VIOLATIONS. The data in the SYS monitoring view is formatted to be easier to use and understand. We recommend that you use the SYS monitoring view for your queries.

Table columns

Column name Data type Description
ownerid integer The ID of the schema owner.
xid bigint The transaction ID associated with the statement.
pid integer The process ID associated with the statement.
userid integer The ID of the user who generated the entry.
schema_id integer The namespace or schema ID.
schema_name character (128) The namespace or schema name.
quota integer The amount of disk space (in MB) that the schema can use.
disk_usage integer The disk space (in MB) that is currently used by the schema.
disk_usage_pct double precision The disk space percentage that is currently used by the schema out of the configured quota.
timestamp timestamp without time zone The time when the violation occurred.

Sample queries

The following query shows the result of quota violation:

SELECT userid, TRIM(SCHEMA_NAME) "schema_name", quota, disk_usage, disk_usage_pct, timestamp FROM stl_schema_quota_violations WHERE SCHEMA_NAME = 'sales_schema' ORDER BY timestamp DESC;

This query returns the following sample output for the specified schema:

userid | schema_name | quota | disk_usage | disk_usage_pct |timestamp -------+--------------+-------+------------+----------------+---------------------------- 104 | sales_schema | 2048 | 2798 | 136.62 | 2020-04-20 20:09:25.494723 (1 row)