STL_SCHEMA_QUOTA_VIOLATIONS

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

Superusers can see all the records. Schema owners can only see records related to the schemas they own.

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)