Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Logical Decoding/ GS_LOGICAL_PARTITION

Updated on 2025-05-29 GMT+08:00

View PDF

GS_LOGICAL_PARTITION

GS_LOGICAL_PARTITION records partitioned table information.

**Table 1** GS_LOGICAL_PARTITION columns
Column	Type	Description
partitionid	Oid	Partitioned table OID.
relname	name	Name of a partitioned table.
parttype	char	Partitioning type.
parentid	oid	OID of a parent table.
relfilenode	oid	Partitioned table relfilenode.
reltoastrelid	oid	OID of a TOAST table.
reltoastidxid	oid	OID of the TOAST index.
csnmin	bigint	CSN when a tuple is inserted.
csnmax	bigint	CSN when a tuple is updated or deleted.
originid	integer	Source identifier of a tuple.
createtime	timestamp with time zone	Timestamp when a tuple is inserted.
reltablespace	oid	Tablespace OID.
dbnode	oid	Database OID.

Parent topic: Logical Decoding

Previous topic: GS_LOGICAL_NAMESPACE

Next topic: GS_LOGICAL_TYPE

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.See the reply and handling status in My Cloud VOC.

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

For any further questions, feel free to contact us through the chatbot.