Version: latest

Protocol Statistics ​

Aggregates execution count and elapsed time by protocol message type between begin/end snapshots, and computes the percentage of instance DB_TIME. Node-wide report, which can be viewed in node mode for detail or all report types.

Table 1 Protocol message type mapping

No.

Report name (Message Type)

Meaning

1

Simple Query

Simple-query protocol path (Q message): elapsed time and execution count

2

Parse

Extended-query Parse phase

3

Bind

Extended-query Bind phase

4

Execute

Extended-query Execute phase

5

Describe

Extended-query Describe phase

6

Sync

Extended-query Sync phase

7

Close

Extended-query Close phase

8

Batch Bind-Execute

Batch Bind-Execute path (U message): elapsed time and execution count

Table 2 Columns in Protocol Message Statistics

Column

Description

Message Type

Protocol message type (see the mapping above).

Exec Count

Execution-count delta between snapshots (end − begin n_calls).

Total Time(s)

Total elapsed time in seconds (converted from microsecond delta).

Avg Time(ms)

Average elapsed time in milliseconds; 0 when Exec Count is 0.

% of DB Time

Percentage of the instance DB_TIME delta.

Rows are ordered by Total Time descending. Exec Count and elapsed time may be 0 when there is no activity for that message type.