Global Temporary Table Functions
pg_get_gtt_relstats(relOid)
Description: Displays basic information about a global temporary table specified by the current session.
Parameter: OID of the global temporary table
Return type: record
Example:
gaussdb=# SELECT * FROM pg_get_gtt_relstats(74069);
relfilenode | relpages | reltuples | relallvisible | relfrozenxid | relminmxid
-------------+----------+-----------+---------------+--------------+------------
74069 | 58 | 13000 | 0 | 11151 | 0
(1 row)
pg_get_gtt_statistics(relOid, attnum, ''::text)
Description: Displays statistics about a single column in a global temporary table specified by the current session.
Parameter: OID and the attnum attribute of the global temporary table
Return type: record
Example:
gaussdb=# SELECT * FROM pg_get_gtt_statistics(74069,1,''::text);
starelid | starelkind | staattnum | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stanumbers1 | stanumbers2 | stanumbers3 | stanu
mbers4 | stanumbers5 |
stavalues1
| stavalues2 | stavalues3 | stavalues4 | stavalues5 | stadndistinct | staextinfo
----------+------------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+------
-------+-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------+------------+------------+------------+------------+---------------+------------
74069 | c | 1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | | {1} | |
| | {1,130,260,390,520,650,780,910,1040,1170,1300,1430,1560,1690,1820,1950,2080,2210,2340,2470,2600,2730,2860,2990,3120,3250,3380,3510,3640,3770,3900,4030,4160,4290,4420,4550,4680,4810,4940,5070,5200,5330,5460,5590,57
20,5850,5980,6110,6240,6370,6500,6630,6760,6890,7020,7150,7280,7410,7540,7670,7800,7930,8060,8190,8320,8450,8580,8710,8840,8970,9100,9230,9360,9490,9620,9750,9880,10010,10140,10270,10400,10530,10660,10790,10920,11050,11180,11310,11440,1
1570,11700,11830,11960,12090,12220,12350,12480,12610,12740,12870,13000} | | | | | 0 |
(1 row)
pg_gtt_attached_pid(relOid)
Description: Displays PIDs and session IDs of all threads that are using the specified global temporary table. If the thread pool is enabled and the session that is using the global temporary table is in the detach state, the PID is 0 and sessionid indicates the session ID.
Parameter: OID of the global temporary table
Return type: record
Example:
gaussdb=# SELECT * FROM pg_gtt_attached_pid(74069);
relid | pid | sessionid
-------+-----------------+-----------------
74069 | 139648170456832 | 139648170456832
74069 | 139648123270912 | 139648123270912
(2 rows)
dbe_perf.get_global_full_sql_by_timestamp(start_timestamp timestamp, end_timestamp timestamp)
Description: Obtains full SQL information at the instance level.
Return type: record
Parameter |
Type |
Description |
---|---|---|
start_timestamp |
timestamp |
Start point of the SQL start time range. |
end_timestamp |
timestamp |
End point of the SQL start time range. |
dbe_perf.get_global_slow_sql_by_timestamp(start_timestamp timestamp, end_timestamp timestamp)
Description: Obtains slow SQL information at the instance level.
Return type: record
Parameter |
Type |
Description |
---|---|---|
start_timestamp |
timestamp |
Start point of the SQL start time range. |
end_timestamp |
timestamp |
End point of the SQL start time range. |
statement_detail_decode(detail text, format text, pretty bool)
Parses the details column in a full or slow SQL statement.
Parameter |
Type |
Description |
---|---|---|
detail |
text |
Set of events generated by the SQL statement (unreadable). |
format |
text |
Parsing output format. The value is plaintext or json. |
pretty |
bool |
Specifies whether to display the text in pretty format when format is set to plaintext. The options are as follows:
|
pg_list_gtt_relfrozenxids()
Description: Displays the frozen XID of each session.
If the value of pid is 0, the earliest frozen XID of all sessions is displayed.
Parameter: none
Return type: record
Example:
gaussdb=# SELECT * FROM pg_list_gtt_relfrozenxids();
pid | relfrozenxid
-----------------+--------------
139648123270912 | 11151
139648170456832 | 11155
0 | 11151
(3 rows)
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot