Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs

Updated on 2025-06-12 GMT+08:00

View PDF

System Catalogs

GS_BLOCKLIST_QUERY

GS_BLOCKLIST_SQL

GS_OBSSCANINFO

GS_RESPOOL_RESOURCE_HISTORY

GS_WLM_INSTANCE_HISTORY

GS_WLM_OPERATOR_INFO

GS_WLM_SESSION_INFO

GS_WLM_USER_RESOURCE_HISTORY

PG_AGGREGATE

PG_AM

PG_AMOP

PG_AMPROC

PG_ATTRDEF

PG_ATTRIBUTE

PG_AUTHID

PG_AUTH_HISTORY

PG_AUTH_MEMBERS

PG_BLOCKLISTS

PG_CAST

PG_CLASS

PG_COLLATION

PG_CONSTRAINT

PG_CONVERSION

PG_DATABASE

PG_DB_ROLE_SETTING

PG_DEFAULT_ACL

PG_DEPEND

PG_DESCRIPTION

PG_ENUM

PG_EXCEPT_RULE

PG_EXTERNAL_NAMESPACE

PG_EXTENSION

PG_EXTENSION_DATA_SOURCE

PG_FINE_DR_INFO

PG_FOREIGN_DATA_WRAPPER

PG_FOREIGN_SERVER

PG_FOREIGN_TABLE

PG_INDEX

PG_INHERITS

PG_JOB_INFO

PG_JOBS

PG_LANGUAGE

PG_LARGEOBJECT

PG_LARGEOBJECT_METADATA

PG_MATVIEW

PG_NAMESPACE

PG_OBJECT

PG_OBSSCANINFO

PG_OPCLASS

PG_OPERATOR

PG_OPFAMILY

PG_PARTITION

PG_PLTEMPLATE

PG_PROC

PG_PUBLICATION

PG_PUBLICATION_NAMESPACE

PG_PUBLICATION_REL

PG_RANGE

PG_REDACTION_COLUMN

PG_REDACTION_POLICY

PG_RELFILENODE_SIZE

PG_RLSPOLICY

PG_RESOURCE_POOL

PG_REWRITE

PG_SECLABEL

PG_SHDEPEND

PG_SHDESCRIPTION

PG_SHSECLABEL

PG_STATISTIC

PG_STATISTIC_EXT

PG_STAT_OBJECT

PG_SUBSCRIPTION

PG_SYNONYM

PG_TABLESPACE

PG_TRIGGER

PG_TS_CONFIG

PG_TS_CONFIG_MAP

PG_TS_DICT

PG_TS_PARSER

PG_TS_TEMPLATE

PG_TYPE

PG_USER_MAPPING

PG_USER_STATUS

PG_WORKLOAD_ACTION

PGXC_CLASS

PGXC_GROUP

PGXC_NODE

PLAN_TABLE_DATA

SNAPSHOT

TABLES_SNAP_TIMESTAMP

System Catalogs for Performance View Snapshot

Parent Topic: GaussDB(DWS) System Catalogs and Views

Previous topic: Overview of System Catalogs and System Views

Next topic: GS_BLOCKLIST_QUERY

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel