HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

STATEMENT_HISTORY

STATEMENT_HISTORY displays information about execution statements on the current node. To query system catalogs, you must have the sysadmin permission.

Table 1 STATEMENT_HISTORY columns

Name Type Description
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 is started.
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 can be used to analyze the network overhead of SQL statements in a distributed system and is not supported in standalone system. 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 lock waiting.
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.

Note:

To facilitate cleanup of this table, the TRUNCATE command is allowed to empty the table.

Copyright © 2011-2024 www.enmotech.com All rights reserved.