INSTANCE_TIME

INSTANCE_TIME records time consumption information on the current database node. The time consumption information is classified into the following types:

• DB_TIME: effective time spent by jobs in multi-core scenarios
• CPU_TIME: CPU time cost.
• EXECUTION_TIME: time spent in the executor.
• PARSE_TIME: time spent on parsing SQL statements
• PLAN_TIME: time spent on generating plans
• REWRITE_TIME: time spent on rewriting SQL statements
• PL_COMPILATION_TIME: compilation time of the PL/pgSQL stored procedure.
• PL_COMPILATION_TIME: compilation time of the PL/pgSQL stored procedure
• NET_SEND_TIME: time spent on the network
• DATA_IO_TIME: time spent on I/Os.
• SRT1_Q: Q报文件执行耗时
• SRT2_SIMPLE_QUERY
• SRT3_ANALYZE_REWRITE
• SRT4_PLAN_QUERY
• SRT5_LIGHT_QUERY
• SRT6_P
• SRT7_B
• SRT8_E
• SRT9_D
• SRT10_S
• SRT11_C
• SRT12_U
• SRT13_BEFORE_QUERY
• SRT14_AFTER_QUERY
• RTT_UNKNOWN

Table 1 INSTANCE_TIME columns