PG_GTT_RELSTATS
PG_GTT_RELSTATS displays basic information about all global temporary tables of the current session by invoking pg_get_gtt_relstats.
Table 1 PG_GTT_RELSTATS columns
Name | Type | Description |
---|
schemaname | name | Schema name |
tablename | name | Name of a global temporary table |
relfilenode | oid | ID of a file object |
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 |
openGauss 2025-04-27 07:52:57