PG_GTT_RELSTATS
PG_GTT_RELSTATS displays basic information about all global temporary tables of the current session by calling pg_get_gtt_relstats(). Data is inherited from a centralized global temporary table. The query result of the distributed global temporary table on a CN is not meaningful, and the query result on a DN is empty. Therefore, it is not recommended in distributed mode.
Name |
Type |
Description |
---|---|---|
schemaname |
name |
Schema name. |
tablename |
name |
Name of a global temporary table. |
relfilenode |
oid |
File object ID. |
relpages |
integer |
Number of disk pages of a global temporary table. |
reltuples |
real |
Number of records in a global temporary table. |
relallvisible |
integer |
Number of pages that are marked as all visible. |
relfrozenxid |
xid |
All transaction IDs before this one have been replaced with a permanent (frozen) transaction ID in the table. |
relminmxid |
xid |
Reserved. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.