vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0849.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

5.3 KiB
Raw Permalink Blame History

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: effective time spent by jobs in multi-core scenarios
  • CPU_TIME: CPU time spent
  • EXECUTION_TIME: time spent within executors
  • 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: I/O time spent
Table 1 PV_INSTANCE_TIME columns

Name

Type

Description

stat_id

integer

Type ID

stat_name

text

Running time type name

value

bigint

Running time value
Parent topic: System Views