GS_INSTANCE_TIME

GS_INSTANCE_TIME records time consumption information of the current 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_EXECUTION_TIME: execution 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.

Table 1 GS_INSTANCE_TIME columns