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.