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 |
| lwtid | integer | Lightweight thread ID of the current thread |
| psessionid | bigint | Parent thread of the streaming thread |
| tlevel | integer | Level of the streaming thread, which 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 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.
