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

GS_SPM_ID_HASH_JOIN

The GS_SPM_ID_HASH_JOIN system catalog stores the relationship between unique_sql_id and sql_hash. Users with sysadmin permissions can read the system catalog, but only initial users can write data to the system catalog.

Table 1 GS_SPM_ID_HASH_JOIN columns

Name

Type

Description

unique_sql_id

bigint

Unique ID of an SQL statement in the database.

sql_hash

bigint

Unique ID of the SQL statement in the SPM.
Parent topic: SPM