Search for a command to run...
pg_gtt_attached_pid(relOid)
Description: Displays all thread pids that are using the specified global temporary table.
Parameters: OID of the global temporary table.
Return value type: record
Example:
copy code openGauss=# select * from pg_gtt_attached_pid(74069);
relid | pid
-------+-----------------
74069 | 139648170456832
74069 | 139648123270912 (2 rows)
No comments yet. Be the first to comment.
to_char(numeric/smallint/integer/bigint/double precision/real[, fmt]) Description: Convert an integer or floating point value to a string in the specified format. The optional parameter fmt can be of the following categories: decimal characters, "gro...
to_char(datetime/interval [, fmt]) Description: Convert a DATETIME or INTERVAL value of type DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE to TEXT type according to the format specified by fmt. The optional parameter fmt...
db4ai_predict_by_bool (text, VARIADIC "any") Description: Get the model whose return value is Boolean for model inference task. This function is an internal call function. It is recommended to use the syntax PREDICT BY directly for inference tasks. P...
define sequence ⚫ The sequence can generate a set of equally spaced values, which can be incremented automatically, mainly used for the primary key of the table. The SQL statements involved are shown in the table below. Create a sequence ⚫ Function...