Help Center > > Developer Guide

PG_TOTAL_SCHEMA_INFO

Updated at: Jul 14, 2021 GMT+08:00

PG_TOTAL_SCHEMA_INFO displays the storage usage of all schemas in each database. This view is valid only if use_workload_manager is set to on.

Column

Type

Description

schemaid

oid

Schema OID

schemaname

text

Schema name

databaseid

oid

Database OID

databasename

name

Database name

usedspace

bigint

Size of the permanent table storage space used by the schema, in bytes.

permspace

bigint

Upper limit of the permanent table storage space of the schema, in bytes.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel