GS_ASP
GS_ASP displays the persistent ACTIVE SESSION PROFILE samples. This catalog can be queried only in the system database but cannot be queried in the user database.
| Name | Type | Description |
|---|---|---|
| sampleid | bigint | Sample ID. |
| sample_time | timestamp with time zone | Sampling time. |
| need_flush_sample | Boolean | Specifies whether the sample needs to be flushed to disks.
|
| databaseid | oid | Database ID. |
| thread_id | bigint | Thread ID. |
| sessionid | bigint | Session ID. |
| start_time | timestamp with time zone | Start time of a session. |
| event | text | Event name. For key events in the kernel, see Table 2, 15.3.67-Table 3 List of wait events corresponding to lightweight locks, Table 4, and Table 5. For details about the impact of each transaction lock on services, see LOCK. |
| lwtid | integer | Lightweight thread ID of the current thread. |
| psessionid | bigint | Parent thread of the streaming thread. |
| tlevel | integer | Level of the streaming thread. The value corresponds to the level (ID) of the execution plan. |
| smpid | integer | Concurrent thread ID in SMP execution mode. |
| userid | oid | ID of a session user. |
| application_name | text | Name of an application. |
| client_addr | inet | IP address of a client. |
| client_hostname | text | Name of a client. |
| client_port | integer | TCP port number used by a client to communicate with the backend. |
| query_id | bigint | Debug query ID. |
| unique_query_id | bigint | Unique query ID. |
| user_id | oid | User ID in the key of the unique query. |
| cn_id | integer | ID of the node that delivers the unique SQL statement. cn_id is in the key of the unique query. |
| unique_query | text | Standardized unique SQL text string. |
| locktag | text | Information of a lock that the session waits for, which can be parsed using locktag_decode. |
| lockmode | text | Mode of a lock that the session waits for.
|
| block_sessionid | bigint | Blocks a session from obtaining the session ID of a lock if the session is waiting for the lock. |
| wait_status | text | Provides more details about an event column. |
| global_sessionid | text | Global session ID. |
| xact_start_time | timestamp with time zone | Start time of the transaction. |
| query_start_time | timestamp with time zone | Time when the statement starts to be executed. |
| state | text | Current transaction state. The options are as follows:
|
| event_start_time | timestamp with time zone | Start time of a wait event. |
| current_xid | xid | ID of the current transaction. |
| top_xid | xid | ID of the top-level transaction that is being executed. |
| instance_name | text | DN to which the record belongs. |
| parent_unique_sql_id | bigint | SQL_Id of the parent statement that calls the statement. |
| control_status | text | The value is under_cpu_throttle when CPU resource for abnormal SQL statements is controlled. Otherwise, the value is normal. |
| top_unique_query_id | bigint | This column displays the unique_query_id of the top-level SQL statement of the stored procedure. |
| top_unique_query | text | This column displays the unique_query of the top-level SQL statement of the stored procedure. |
