SUMMARY_STATEMENT
Obtain full information about the executed statements (normalized SQL statements) on the primary database node, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name. |
| node_id | integer | Node ID. The value is 0 in centralized mode. |
| user_name | name | Username. If the user who runs the query statement does not exist, *REMOVED_USER* is displayed. |
| 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 logical reads. |
| n_blocks_hit | bigint | Number of memory hits. |
| n_soft_parse | bigint | Number of soft parsing times. |
| n_hard_parse | bigint | Number of hard parsing times. |
| db_time | bigint | Valid internal database 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. |
| 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). |
| parent_unique_sql_id | bigint | Unique ID of the parent SQL statement. The value is 0 for a non-stored procedure substatement. |
| lock_wait_time | bigint | SQL lock waiting time (unit: μs). |
| total_used_memory | bigint | Total memory used by normalized statements, in MB. |
| max_used_memory | integer | Maximum memory usage of a single statement, in MB. |
| min_used_memory | integer | Minimum memory usage of a single statement, in MB. |
| db_name | name | Name of the database connected to the backend. If the database where the query statement is executed does not exist, *REMOVED_DB* is displayed. |
| db_id | db_id | OID of the database that the backend is connected to. |
