Help Center/ GaussDB/ Centralized_3.x/ System Catalogs and System Views/ System Views/ PG_GTT_RELSTATS
Updated on 2024-05-07 GMT+08:00
View PDF

PG_GTT_RELSTATS

PG_GTT_RELSTATS displays basic information about all global temporary tables of the current session by calling 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.
Parent topic: System Views