This page provides information about the schemas in the database.
Name | Type |
---|---|
schema_id | int8 |
schema | varchar |
owner_user_id | int8 |
owner | varchar |
quota | int8 |
idle | interval |
objects::tables | int8 |
objects:views:normal | int8 |
objects:views:late-binding | int8 |
objects:views:materialized | int8 |
objects::procedures | int8 |
objects::functions | int8 |
store:blocks:sorted | int8 |
store:blocks:unsorted | int8 |
store:blocks:total | int8 |
store:rows:sorted | int8 |
store:rows:unsorted | int8 |
store:rows:total | int8 |
i/o:bytes read:disk | int8 |
i/o:bytes read:network | int8 |
i/o:rows:inserted | int8 |
i/o:rows:deleted | int8 |
related pages | varchar |
The schema ID. This column is emitted in CSV exports only.
The schema name.
The owner user ID. This column is emitted in CSV exports only.
The owner user name.
Maximum number of megabytes permitted to the schema.
Duration since the start of most recent table access in
stl_delete
, stl_insert
and
stl_scan
, which is to say, the time since the table last
had rows deleted, inserted, or was scanned. If empty, there are no
records in any of these system tables within the time period being
examined by the page.
The number of tables owned by users in the group, present in the schema, or owned by the user (depending on which page you’re on, to be viewing this column).
The number of normal views owned by users in the group, present in the schema, or owned by the user (depending on which page you’re on, to be viewing this column).
The number of late-binding views owned by users in the group, present in the schema, or owned by the user (depending on which page you’re on, to be viewing this column).
The number of materialized views owned by users in the group, present in the schema, or owned by the user (depending on which page you’re on, to be viewing this column).
The number of procedures owned by users in the group, present in the schema, or owned by the user (depending on which page you’re on, to be viewing this column).
The number of functions owned by users in the group, present in the schema, or owned by the user (depending on which page you’re on, to be viewing this column).
The number of sorted blocks.
The number of unsorted blocks.
The total number of blocks.
The number of sorted rows.
The number of unsorted rows.
The total number of rows.
This column then shows the total number of bytes read from disk, as
best I can judge the types indicated in stl_scan
.
This column then shows the total number of bytes read from network,
as best I can judge the types indicated in stl_scan
.
Importantly, it only counts the receive side of network
activity - the step is scan
, after all, not
broadcast
, so we’re not counting bytes twice.
The number of rows inserted into the table.
For tables with all
distribution, this is the physical
number of rows (i.e. one per node), not the logical number of rows.
The number of rows deleted from the table.
For tables with all
distribution, this is the physical
number of rows (i.e. one per node), not the logical number of rows.