Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ PV_SESSION_TIME
Updated on 2025-08-19 GMT+08:00
View PDF

PV_SESSION_TIME

PV_SESSION_TIME displays the running time of session threads and time consumed in each execution phase.

Table 1 PV_SESSION_TIME columns

Name

Type

Description

sessid

text

Thread ID and start time.

stat_id

integer

Statistics ID.

stat_name

text

Name of the session type.

  • 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/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.

value

bigint

Session value.
Parent topic: System Views