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