Schemas v1

Description

This page provides information about the schemas in the database.

Columns

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

Column Descriptions

schema_id

The schema ID. This column is emitted in CSV exports only.

schema

The schema name.

owner_user_id

The owner user ID. This column is emitted in CSV exports only.

owner

The owner user name.

quota

Maximum number of megabytes permitted to the schema.

idle

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.

objects::tables

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

objects:views:normal

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

objects:views:late-binding

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

objects:views:materialized

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

objects::procedures

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

objects::functions

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

store:blocks:sorted

The number of sorted blocks.

store:blocks:unsorted

The number of unsorted blocks.

store:blocks:total

The total number of blocks.

store:rows:sorted

The number of sorted rows.

store:rows:unsorted

The number of unsorted rows.

store:rows:total

The total number of rows.

i/o:bytes read:disk

This column then shows the total number of bytes read from disk, as best I can judge the types indicated in stl_scan.

i/o:bytes read:network

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.

i/o:rows:inserted

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.

i/o:rows:deleted

The number of rows deleted from the table.