SYS_SCHEMA_QUOTA_VIOLATIONS
Records the occurrence, transaction ID, and other useful information when a schema quota is exceeded. This system table is a translation of STL_SCHEMA_QUOTA_VIOLATIONS.
r_SYS_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.
Table columns
| Column name | Data type | Description |
|---|---|---|
| owner_id | integer | The ID of the schema owner. |
| user_id | integer | The ID of the user who generated the entry. |
| transaction_id | bigint | The transaction ID associated with the statement. |
| session_id | integer | The process ID associated with the statement. |
| 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. |
| record_time | timestamp without time zone | The time when the violation occurred. |
Sample
queries
The following query shows the result of a quota violation:
SELECT user_id, TRIM(schema_name) "schema_name", quota, disk_usage, record_time FROM
sys_schema_quota_violations WHERE SCHEMA_NAME = 'sales_schema' ORDER BY timestamp DESC;
This query returns the following sample output for the specified schema:
user_id| schema_name | quota | disk_usage | record_time
-------+--------------+-------+------------+----------------------------
104 | sales_schema | 2048 | 2798 | 2020-04-20 20:09:25.494723
(1 row)
