Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PG_LIFECYCLE_DATA_DISTRIBUTE

Updated on 2023-04-14 GMT+08:00

View PDF

PG_LIFECYCLE_DATA_DISTRIBUTE

PG_LIFECYCLE_DATA_DISTRIBUTE displays the distribution of cold and hot data in a multi-temperature table of OBS.

**Table 1** PG_LIFECYCLE_DATA_DISTRIBUTE columns
Name	Type	Description
schemaname	name	Schema name
tablename	name	Current table name
nodename	name	Node name
hotpartition	text	Hot partition on the DN
coldpartition	text	Cold partition on the DN
switchablepartition	text	Switchable partition on the DN
hotdatasize	text	Data size of the hot partition on the DN
colddatasize	text	Data size of the cold partition on the DN
switchabledatasize	text	Data size of the switchable partition on the DN

Parent topic: System Views

Previous topic: PG_JOB_SINGLE

Next topic: PG_LOCKS

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.