Other Functions
plan_seed()
Description: Obtains the seed value of the previous query statement (internal use).
Return type: int
pg_stat_get_env()
Description: Obtains the environment variable information of the current node. Only the sysadmin and monitor admin users can access the environment variable information.
Return type: record
Example:
postgres=# select pg_stat_get_env(); pg_stat_get_env --------------------------------------------------------------------------------------------------------------------------------------- (coordinator1,localhost,144773,49100,/data1/GaussDB_Kernel_TRUNK/install,/data1/GaussDB_Kernel_TRUNK/install/data/coordinator1,pg_log) (1 row)pg_catalog.plancache_clean()
Description: Clears the global plan cache that is not used on nodes.
Return type: bool
pg_catalog.plancache_status()
Description: Displays information about the global plan cache on nodes. The information returned by the function is the same as that in GLOBAL_PLANCACHE_STATUS.
Return type: record
textlen()
Description: Provides the method of querying the logical length of text.
Return type: int
threadpool_status()
Description: Displays the status of worker threads and sessions in the thread pool.
Return type: record
get_local_active_session()
Description: Provides sampling records of the historical active session status stored in the memory of the current node.
Return type: record
get_global_active_session()
Description: Provides sampling records of the historical active session status stored in the memory of all nodes.
Return type: record
get_global_gs_asp()
Description: Provides sampling records of the historical active session status stored in the gs_asp system catalog of all nodes.
Return type: record
get_datanode_active_session()
Description: Provides sampling records of historical active session status stored in the memory of other nodes in the database of the primary node.
Return type: record
get_datanode_active_session_hist()
Description: Provides sampling records of historical active session status stored in the gs_asp system catalog of other nodes in the database of the primary node.
Return type: record
pg_stat_get_thread()
Description: Provides information about the status of all threads under the current node.
Return type: record
pg_stat_get_sql_count()
Description: Provides the counts of the SELECT, UPDATE, INSERT, DELETE, and MERGE INTO statements executed on the current node.
Return type: record
pg_stat_get_data_senders()
Description: Provides detailed information about the data-copy sending thread active at the moment.
Return type: record
generate_wdr_report(begin_snap_id Oid, end_snap_id Oid, int report_type, int report_scope, int node_name)
Description: Generates system diagnosis reports based on two snapshots.
Return type: record
Table 1 generate_wdr_report parameter description
create_wdr_snapshot(stat text, dbid Oid)
Description: Manually generates system diagnosis snapshots.
Return type: record
Table 2 create_wdr_snapshot parameter description
Specifies the name of the node for each snapshot. By default, the status information of all nodes is collected.
ID of the database whose status information is to be collected.
reset_unique_sql
Description: Clears the Unique SQL statements in the memory of the database node. (The sysadmin permission is required.)
Return type: bool
Table 3 reset_unique_sql parameter description
Clearance scope type. The options are as follows:
wdr_xdb_query(db_name_str text, query text)
Description: Provides the capability of executing cross-database queries at local. For example, when connecting to the Postgres database, access tables in the test database.
select col1 from wdr_xdb_query('dbname=test','select col1 from t1') as dd(col1 int);Return type: record
pg_wlm_jump_queue(pid int)
Description: Moves a task to the top of the primary database node queue.
Return type: Boolean
- true: success
- false: failure
gs_wlm_switch_cgroup(pid int, cgroup text)
Description: Moves a job to other Cgroup to improve the job priority.
Return type: Boolean
- true: success
- false: failure
pv_session_memctx_detail(threadid tid, MemoryContextName text)
Description: Record information about the memory context MemoryContextName of the thread tid into the threadid_timestamp.log file in the $GAUSSLOG/pg_log/${node_name}/dumpmem directory. threadid can be obtained from sessid in the PV_SESSION_MEMORY_DETAIL table. In the officially released version, only the MemoryContextName that is an empty string (two single quotation marks indicate that the input is an empty string) is accepted. In this case, all memory context information is recorded. Otherwise, no operation is performed. For the DEBUG version for internal development and test personnel to debug, you can specify the MemoryContextName to be counted. In this case, all the memory usage of the context is recorded in the specified file. Only the administrator can execute this function.
Return type: Boolean
- true: success
- false: failure
pg_shared_memctx_detail(MemoryContextName text)
Description: Record information about the memory context MemoryContextName into the threadid_timestamp.log file in the $GAUSSLOG/pg_log/${node_name}/dumpmem directory. This function is provided only for internal development and test personnel to debug in the DEBUG version. Calling this function in the officially released version does not involve any operation. Only the administrator can execute this function.
Return type: Boolean
- true: success
- false: failure
local_bgwriter_stat()
Description: Displays the information about pages flushed by the bgwriter thread of this instance, number of pages in the candidate buffer chain, and buffer elimination information.
Return type: record
local_ckpt_stat()
Description: Displays the information about checkpoints and flushing pages of the current instance.
Return type: record
local_double_write_stat()
Description: Displays the doublewrite file status of the current instance.
Return type: record
local_single_flush_dw_stat()
Description: Displays the elimination of dual-write files on a single page in the instance.
Return type: record
local_pagewriter_stat()
Description: Displays the page flushing information and checkpoint information of the current instance.
Return type: record
local_redo_stat()
Description: Displays the replay status of the current standby instance.
Return type: record
Note: The returned replay status includes the current replay position and the replay position of the minimum restoration point.
local_recovery_status()
Description: Displays log flow control information about the primary and standby instances.
Return type: record
local_rto_status()
Description: Displays log flow control information about the primary and standby instances.
Return type: record
gs_wlm_node_recover(boolean isForce)
Description: Obtains top SQL query statement-level statistics recorded in the current memory. If the input parameter is not 0, the information is cleared from the memory.
Return type: record
gs_cgroup_map_ng_conf(group name)
Description: Reads the Cgroup configuration file of a specified logical database.
Return type: record
gs_wlm_switch_cgroup(sess_id int8, cgroup name)
Description: Switches the control group of a specified session.
Return type: record
hdfs_fdw_handler()
Description: Rewrites a foreign table. It is a function to be defined when a foreign table is defined.
Return type: record
hdfs_fdw_validator(text[], oid)
Description: Rewrites a foreign table. It is a function to be defined when a foreign table is defined.
Return type: record
comm_client_info()
Description: Queries information about active client connections of a single node.
Return type: SETOF record
pg_sync_cstore_delta(text)
Description: Synchronizes the delta table structure of a specified column-store table with that of the column-store primary table.
Return type: bigint
pg_sync_cstore_delta()
Description: Synchronizes the delta table structure of all column-store tables with that of the column-store primary table.
Return type: bigint
gs_create_log_tables()
Description: Creates foreign tables and views for run logs and performance logs.
Return type: void
Example:
postgres=# select gs_create_log_tables(); gs_create_log_tables ---------------------- (1 row)dbe_perf.get_global_full_sql_by_timestamp(start_timestamp timestamp with time zone, end_timestamp timestamp with time zone)
Description: Obtains full SQL information at the database level.
Return type: record
Table 4 dbe_perf.get_global_full_sql_by_timestamp parameter description
dbe_perf.get_global_slow_sql_by_timestamp(start_timestamp timestamp with time zone, end_timestamp timestamp with time zone)
Description: Obtains slow SQL information at the database level.
Return type: record
Table 5 dbe_perf.get_global_slow_sql_by_timestamp parameter description
statement_detail_decode(detail text, format text, pretty boolean)
Description: Parses the details column in a full or slow SQL statement.
Return type: text
Table 6 statement_detail_decode parameter description
A set of events generated by the SQL statement (unreadable).