Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
physical_disk_performance¶
Provides provides raw data from performance counters that monitor hard or fixed disk drives on the system.
Platform support¶
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: physical_disk_performance
- Windows
Table schema¶
Name | Type | Description |
---|---|---|
name | TEXT | Name of the physical disk |
avg_disk_bytes_per_read | BIGINT | Average number of bytes transferred from the disk during read operations |
avg_disk_bytes_per_write | BIGINT | Average number of bytes transferred to the disk during write operations |
avg_disk_read_queue_length | BIGINT | Average number of read requests that were queued for the selected disk during the sample interval |
avg_disk_write_queue_length | BIGINT | Average number of write requests that were queued for the selected disk during the sample interval |
avg_disk_sec_per_read | INTEGER | Average time, in seconds, of a read operation of data from the disk |
avg_disk_sec_per_write | INTEGER | Average time, in seconds, of a write operation of data to the disk |
current_disk_queue_length | INTEGER | Number of requests outstanding on the disk at the time the performance data is collected |
percent_disk_read_time | BIGINT | Percentage of elapsed time that the selected disk drive is busy servicing read requests |
percent_disk_write_time | BIGINT | Percentage of elapsed time that the selected disk drive is busy servicing write requests |
percent_disk_time | BIGINT | Percentage of elapsed time that the selected disk drive is busy servicing read or write requests |
percent_idle_time | BIGINT | Percentage of time during the sample interval that the disk was idle |
Query examples¶
Select all the results for the given table.
SELECT * FROM physical_disk_performance;