Help Center/ GaussDB/ Distributed_3.x/ Schemas/ DBE_PERF Schema/ Instance/ INSTANCE_TIME
Updated on 2024-05-07 GMT+08:00
View PDF

INSTANCE_TIME

Records the time consumption information on the current node. The 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/SQL stored procedure.
  • PL_COMPILATION_TIME: compilation time of the PL/SQL stored procedure.
  • NET_SEND_TIME: time spent on the network.
  • DATA_IO_TIME: I/O time spent.
Table 1 INSTANCE_TIME columns

Name

Type

Description

stat_id

integer

Statistics ID.

stat_name

text

Type name.

value

bigint

Time value (unit: μs).
Parent topic: Instance