Help Center/Data Warehouse Service/Standard Data Warehouse (9.1.0.x)/DWS System Catalogs and Views/System Views/PV_INSTANCE_TIME
Updated on 2025-10-09 GMT+08:00
View PDF

PV_INSTANCE_TIME

PV_INSTANCE_TIME collects statistics on the running time of processes and the time consumed in each execution phase, in microseconds.

PV_INSTANCE_TIME records time consumption information of the current node. The time consumption information is classified into the following types:

  • DB_TIME: time spent by a process on multi-core parallel computing
  • CPU_TIME: time spent by a process on the CPU core
  • EXECUTION_TIME: time spent on 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/O
Table 1 PV_INSTANCE_TIME columns

Column

Type

Description

stat_id

Integer

Type ID.

stat_name

Text

Name of the runtime type.

value

Bigint

Runtime value.

Parent Topic: System Views