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
|
CN ID. On a DN, this parameter indicates the ID of the node that delivers the unique SQL statement, that is, the value of cn_id in the key of the unique query.
|
unique_query
|
text
|
Standardized text string of the unique SQL statement
|
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.
|
final_block_sessionid
|
bigint
|
ID of the blocked session at the source end
|
wait_status
|
text
|
Provides more details about an event column.
|
global_sessionid
|
text
|
Global session ID
|