_ESP_Streams_Monitor
Contains information about the performance of streams, and a copy of data from the _ESP_Streams stream. Monitoring data is available only if the time-granularity option in the project configuration (CCR) file is set to greater than 0. The frequency of updates corresponds to the value of the time-granularity option. For example, if set to 1, an update is published every second, if set to 30, an update is published every 30 seconds, and if set to 0, reporting is disabled.
| Column | Type | Description |
|---|---|---|
| stream | string | The name of the stream. |
| target | string | The name of the target element. |
| cpu_pct | float | Total CPU usage for the stream thread, as a percentage of a single CPU core. |
| trans_per_sec | float | The stream's performance, in transactions per second, since the last update. |
| rows_per_sec | float | The stream's performance, in rows per second, since the last update. |
| inc_trans | long | The number of transactions processed by the server since the last update. |
| inc_rows | long | The number of rows processed by the server since the last update. |
| queue | integer | The current input queue size. |
| store_rows | long | The current number of records in the stream's store. |
| last_update | seconddate | The time of the current update. |
| sequence | long | The sequence number of the current update. |
| posting_to_client | long | The numeric ID of the client connection to which the stream is trying to currently publish data. Typically, posting_to_client is -1, meaning the stream is not trying to currently publish data. |
| node_cpu_pct | float | Total CPU usage for the stream, as a percentage of all CPU cores on the machine. Total CPU usage equals system CPU usage plus user CPU usage. |
| node_cpu_pct_system | float | System CPU usage for the stream, as a percentage of all CPU cores on the machine. |
| node_cpu_pct_user | float | User CPU usage for the stream, as a percentage of all CPU cores on the machine. |
| cpu_time | interval | Total CPU time since the creation of the stream, in microseconds. Total CPU time equals system CPU time plus user CPU time. |
| cpu_time_system | interval | Total system CPU time, in microseconds, since the creation of the stream. |
| cpu_time_user | interval | Total user CPU time, in microseconds, since the creation of the stream. |
| time_since_start | interval | Duration of lapsed real time since the project was started, in microseconds. |