dbname
|
name
|
Database name.
|
schemaname
|
name
|
Schema name.
|
origin_node
|
integer
|
Node name.
|
user_name
|
name
|
Username.
|
application_name
|
text
|
Name of the application that sends a request.
|
client_addr
|
text
|
IP address of the client that sends a request.
|
client_port
|
integer
|
Port number of the client that sends a request.
|
unique_query_id
|
bigint
|
ID of the normalized SQL statement.
|
debug_query_id
|
bigint
|
ID of the unique SQL statement.
|
query
|
text
|
Normalized SQL statement.
|
start_time
|
timestamp with time zone
|
Time when a statement starts.
|
finish_time
|
timestamp with time zone
|
Time when a statement ends.
|
slow_sql_threshold
|
bigint
|
Standard for slow SQL statement execution.
|
transaction_id
|
bigint
|
Transaction ID.
|
thread_id
|
bigint
|
ID of an execution thread.
|
session_id
|
bigint
|
Session ID of a user.
|
n_soft_parse
|
bigint
|
Number of soft parsing times. The value of n_soft_parse plus the value of n_hard_parse may be greater than the value of n_calls because the number of subqueries is not counted in the value of n_calls.
|
n_hard_parse
|
bigint
|
Number of hard parsing times. The value of n_soft_parse plus the value of n_hard_parse may be greater than the value of n_calls because the number of subqueries is not counted in the value of n_calls.
|
query_plan
|
text
|
Statement execution plan.
|
n_returned_rows
|
bigint
|
Number of rows in the result set returned by the SELECT statement.
|
n_tuples_fetched
|
bigint
|
Number of rows randomly scanned.
|
n_tuples_returned
|
bigint
|
Number of rows sequentially scanned.
|
n_tuples_inserted
|
bigint
|
Number of rows inserted.
|
n_tuples_updated
|
bigint
|
Number of rows updated.
|
n_tuples_deleted
|
bigint
|
Number of rows deleted.
|
n_blocks_fetched
|
bigint
|
Number of buffer block access times.
|
n_blocks_hit
|
bigint
|
Number of buffer block hits.
|
db_time
|
bigint
|
Valid DB time, which is accumulated if multiple threads are involved (unit: μs).
|
cpu_time
|
bigint
|
CPU time (unit: μs).
|
execution_time
|
bigint
|
Execution time in the executor (unit: μs).
|
parse_time
|
bigint
|
SQL parsing time (unit: μs).
|
plan_time
|
bigint
|
SQL plan generation time (unit: μs).
|
rewrite_time
|
bigint
|
SQL rewriting time (unit: μs).
|
pl_execution_time
|
bigint
|
Execution time of PL/pgSQL (unit: μs).
|
pl_compilation_time
|
bigint
|
Compilation time of PL/pgSQL (unit: μs).
|
data_io_time
|
bigint
|
I/O time (unit: μs).
|
net_send_info
|
text
|
Network status of messages sent through a physical connection, including the time (unit: μs), number of calls, and throughput (unit: byte). This field can be used to analyze the network overhead of SQL in a distributed system. This field is not supported in a standalone mode. Example: {"time":xxx, "n_calls":xxx, "size":xxx}.
|
net_recv_info
|
text
|
Network status of messages received through a physical connection, including the time (unit: μs), number of calls, and throughput (unit: byte). This field can be used to analyze the network overhead of SQL in a distributed system. This field is not supported in a standalone mode. Example: {"time":xxx, "n_calls":xxx, "size":xxx}.
|
net_stream_send_info
|
text
|
Network status of messages sent through a logical connection, including the time (unit: μs), number of calls, and throughput (unit: byte). This field can be used to analyze the network overhead of SQL in a distributed system. This field is not supported in a standalone mode. Example: {"time":xxx, "n_calls":xxx, "size":xxx}.
|
net_stream_recv_info
|
text
|
Network status of messages received through a logical connection, including the time (unit: μs), number of calls, and throughput (unit: byte). This field can be used to analyze the network overhead of SQL in a distributed system. This field is not supported in a standalone mode. Example: {"time":xxx, "n_calls":xxx, "size":xxx}.
|
lock_count
|
bigint
|
Number of locks.
|
lock_time
|
bigint
|
Time required for locking.
|
lock_wait_count
|
bigint
|
Number of lock waits.
|
lock_wait_time
|
bigint
|
Time required for lock waiting.
|
lock_max_count
|
bigint
|
Maximum number of locks.
|
lwlock_count
|
bigint
|
Number of lightweight locks (reserved).
|
lwlock_wait_count
|
bigint
|
Number of lightweight lock waits.
|
lwlock_time
|
bigint
|
Time required for lightweight locking (reserved).
|
lwlock_wait_time
|
bigint
|
Time required for lightweight locking.
|
details
|
bytea
|
List of statement lock events, which are recorded in time sequence. The number of records is affected by the track_stmt_details_size parameter.
Events include:
- Start locking.
- Complete locking.
- Start lock waiting.
- Complete lock waiting.
- Start unlocking.
- Complete unlocking.
- Start lightweight lock waiting.
- Complete lightweight lock waiting.
|
is_slow_sql
|
boolean
|
Whether the SQL statement is a slow SQL statement.
|
trace_id
|
text
|
Driver-specific trace ID, which is associated with an application request.
|