Help Center/GaussDB/Developer Guide(Distributed_V2.0-8.x)/System Catalogs and System Views/System Catalogs/SPM/GS_SPM_SQL
Updated on 2025-08-19 GMT+08:00
View PDF

GS_SPM_SQL

GS_SPM_SQL is a system catalog in the SPM feature. Currently, this feature is not supported in the distributed system. It is a system catalog used to store SPM information. Users with sysadmin permissions can read the system catalog, but only the initial user can write the system catalog.

Table 1 GS_SPM_SQL columns

Name

Type

Description

sql_namespace

oid

Schema OID.

sql_hash

bigint

Unique ID of the SQL statement in the SPM.

sql_text

text

SQL text string.

param_num

integer

Number of parameters required for SQL execution.

user

oid

OID of the login user.

creation_time

timestamp with time zone

Time when a record is created.

Parent topic:SPM