PG_GTT_RELSTATS
PG_GTT_RELSTATS displays basic information about all global temporary tables of the current session by invoking pg_get_gtt_relstats.
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.