STL_SCHEMA_QUOTA_VIOLATIONS
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)
