STATEMENT_HISTORY
Displays information about statements executed on the current node. To query a view, you must have the SYSADMIN or MONADMIN permission. The result can be queried only in the system database but cannot be queried in the user database.
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 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 column is not supported in standalone mode. |
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 is not supported in standalone mode. |
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 is not supported in standalone mode. |
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 is not supported in standalone mode. |
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:
|
is_slow_sql |
Boolean |
Specifies whether the SQL statement is a slow SQL statement. |
trace_id |
text |
Driver-specific trace ID, which is associated with an application request. |
advise |
text |
Risks which may cause slow SQL statements. (Multiple risks may exist at the same time.)
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.