HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

SUMMARY_STATEMENT

SUMMARY_STATEMENT obtains all information about execution statements (normalized SQL statements) on the primary database node and other database nodes.

Table 1 SUMMARY_STATEMENT columns

Name Type Description
node_name name Database process name
node_id integer ID of a node
user_name name Username
user_id oid OID of the user
unique_sql_id bigint ID of the normalized SQL statement
query text Normalized SQL statement
Note: The length is controlled by track_activity_query_size.
n_calls bigint Number of calls
min_elapse_time bigint Minimum execution time of the SQL statement in the kernel (unit: μs)
max_elapse_time bigint Maximum execution time of the SQL statement in the kernel (unit: μs)
total_elapse_time bigint Total execution time of the SQL statement in the kernel (unit: μs)
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
n_soft_parse bigint Number of soft parsing times
n_hard_parse bigint Number of hard parsing times
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 column can be used to analyze the network overhead of SQL in a distributed system. This column 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 column can be used to analyze the network overhead of SQL in a distributed system. This column 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 column can be used to analyze the network overhead of SQL in a distributed system. This column 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 column can be used to analyze the network overhead of SQL in a distributed system. This column is not supported in a standalone mode. Example: {"time":xxx, "n_calls":xxx, "size":xxx}.
last_updated timestamp with time zone Last time when the statement was updated
sort_count bigint Sorting count
sort_time bigint Sorting duration (unit: μs)
sort_mem_used bigint Size of work memory used during sorting (unit: KB)
sort_spill_count bigint Count of file writing when data is flushed to disks during sorting
sort_spill_size bigint File size used when data is flushed to disks during sorting (unit: KB)
hash_count bigint Hashing count
hash_time bigint Hashing duration (unit: μs)
hash_mem_used bigint Size of work memory used during hashing (unit: KB)
hash_spill_count bigint Count of file writing when data is flushed to disks during hashing
hash_spill_size bigint File size used when data is flushed to disks during hashing (unit: KB)
Copyright © 2011-2024 www.enmotech.com All rights reserved.