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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot