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. .. code-block:: sql SELECT * FROM physical_disk_performance;