Contains information about the performance of all currently active gateway client connections. It contains a copy of data from the _esp_clients stream. Monitoring data is available only if the time-granularity option is set in the project configuration (CCR) file.
| Column | Type | Description |
|---|---|---|
| Handle | long | A unique integer ID of the connection. |
| user_name | string | The user name to log in to the connection, shown once the user is authenticated. |
| IP | string | The address of the client machine, as a string. |
| host | string | The symbolic host name of the client machine, if available. If not available, host is the IP address of the client machine. |
| port | integer | The TCP port number from which the connection originates. |
| login_time | timestamp | The time the server accepts (but does not authenticate) the connection, in GMT. |
| conn_tag | string | The user-set symbolic connection tag name. If not set by the user, conn_tag is NULL. |
| cpu_pct | float | The CPU usage, as a percentage, by the client's gateway thread since the last update. |
| last_update | date | The time of the current update. |
| subscribed | integer | The status of a subscription to a stream, 1 if subscribed, otherwise 0. |
| sub_trans_per_sec | float | The client's performance, in transactions per second, received by the client since the last update. |
| sub_rows_per_sec | float | The client's performance, in data rows per second, received by the client since the last update. |
| sub_inc_trans | long | The number of transactions, envelopes, or messages received by the client since the last update. |
| sub_inc_rows | long | The number of data rows received by the client since the last update. |
| sub_total_trans | long | The total number of transactions, envelopes, or messages received by the client. |
| sub_total_rows | long | The total number of data rows received by the client. |
| sub_dropped_rows | long | The total number of data rows dropped in the gateway because they were not read quickly enough by the client. For lossy subscriptions. |
| sub_accum_size | integer | The current number of rows collected in the accumulator to be sent in the next pulse. For pulsed subscriptions. |
| sub_queue | integer | The number of rows queued for transmission to the client. |
| sub_queue_fill_pct | float | The current sub_queue, as a percentage, relative to the queue size limit. If sub_queue_fill_pct reaches 100 percent, any future attempts to post data to this client are blocked, propagating the flow control back to the source of the post. |
| sub_work_queue | integer | The number of rows for transmission to the client that are being transferred from the proper queue to the socket buffer. The rows can be regrouped by envelopes. |
| pub_trans_per_sec | float | The client's performance, in transactions per second, sent by the client since the last update. Envelopes and any service messages count as transactions. |
| pub_rows_per_sec | float | The client's performance, in data rows per second, sent by the client since the last update. |
| pub_inc_trans | long | The number of transactions, envelopes, or messages sent by the client since the last update. |
| pub_inc_rows | long | The number of data rows sent by the client since the last update. |
| pub_total_trans | long | The total number of transactions, envelopes, or messages sent by the client. |
| pub_total_rows | long | The total number of data rows sent by the client. |
| pub_stream_id | long | The numeric ID of the stream to which the client is trying to currently publish data. Typically, pub_stream_id is -1, meaning the client is not trying to currently publish data. |