GS_SLOW_QUERY_INFO (Deprecated)
GS_SLOW_QUERY_INFO displays the slow query information that has been dumped on the current node. The data is dumped from the kernel to the system catalog. If the GUC parameter enable_resource_record is set to on, the system imports the query information from the kernel to the GS_WLM_SESSION_QUERY_INFO_ALL system catalog every 3 minutes. This operation occupies storage space and affects performance. You can check GS_SLOW_QUERY_INFO to view the slow query information that has been dumped. This view has been deprecated in this version.
Name |
Type |
Description |
---|---|---|
dbname |
text |
Database name. |
schemaname |
text |
Schema name. |
nodename |
text |
Node name. |
username |
text |
Username. |
queryid |
bigint |
Normalization ID. |
query |
text |
User statement. |
start_time |
timestamp with time zone |
Execution start time. |
finish_time |
timestamp with time zone |
Execution end time. |
duration |
bigint |
Execution duration (unit: ms). |
query_plan |
text |
Plan information. |
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 cache loading times. |
n_blocks_hit |
bigint |
Number of cache hits. |
db_time |
bigint |
Valid 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 statements (unit: μs). |
pl_compilation_time |
bigint |
Compilation time of PL/pgSQL statements (unit: μs). |
net_send_time |
bigint |
Network time (unit: μs). |
data_io_time |
bigint |
I/O time (unit: μs). |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.