GS_ASP
GS_ASP displays the persistent ACTIVE SESSION PROFILE samples. This system catalog can be queried only in the system library.
| 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 | Specified event name. |
| 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 the 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 | A CN ID indicates a CN from which the unique SQL statement is obtained. The cn_id is in the key of the unique query. |
| unique_query | text | Standardized UniqueSQL text string. |
| locktag | text | Information of a lock that the session waits for. It 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 the 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 statement state. The value can be active, idle in transaction, fastpath function call, idle in transaction (aborted), disabled, or retrying. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
