Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Other System Views> PV_INSTANCE_TIME
Updated on 2024-06-03 GMT+08:00
View PDF

PV_INSTANCE_TIME

PV_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 spent
  • EXECUTION_TIME: time spent in executors
  • PARSE_TIME: time spent in parsing SQL statements
  • PLAN_TIME: time spent on generating plans
  • REWRITE_TIME: time spent for SQL rewriting
  • 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 PV_INSTANCE_TIME columns

Name

Category

Description

stat_id

integer

Statistics ID

stat_name

text

Type name

value

bigint

Time value, in μs
Parent topic: Other System Views