Product DocumentationAppearance
sys.drive_summary
This system view returns a summary of storage information for the drives on each worker node.
| Column Name | Data Type | Description |
|---|---|---|
| worker_id | uuid | Worker node identifier. |
| chassis_id | integer | 0 for a single-chassis appliance; 0 or 1 for a dual-chassis appliance. |
| drive | bigint | Drive number or name on the worker. |
| total_bytes | bigint | Total number of bytes of storage available. |
| bytes_used | bigint | Total number of bytes of storage in use. |
| drive_wear | bigint | A percentage that describes the health of the drive. 0 means there is no wear on the drive. |
Example
yellowbrick_test=# select * from sys.drive_summary where chassis_id=0 order by 3;
worker_id | chassis_id | drive | total_bytes | bytes_used | drive_wear
--------------------------------------+------------+-------+---------------+--------------+------------
00000000-0000-0000-0000-38b8ebd00c1c | 0 | 0 | 2048347078656 | 356606017536 | 0
00000000-0000-0000-0000-38b8ebd00c6c | 0 | 0 | 2048347078656 | 345254133760 | 0
00000000-0000-0000-0000-38b8ebd00bf9 | 0 | 0 | 2048347078656 | 339386302464 | 0
00000000-0000-0000-0000-38b8ebd007fd | 0 | 0 | 2048347078656 | 357673467904 | 0
00000000-0000-0000-0000-38b8ebd00c35 | 0 | 0 | 2048347078656 | 429966491648 | 0
00000000-0000-0000-0000-38b8ebd00c0d | 0 | 0 | 2048347078656 | 365672005632 | 0
00000000-0000-0000-0000-38b8ebd00c58 | 0 | 0 | 2048347078656 | 315751399424 | 0
00000000-0000-0000-0000-38b8ebd00c53 | 0 | 0 | 2048347078656 | 326126010368 | 0
00000000-0000-0000-0000-38b8ebd00ca8 | 0 | 0 | 2048347078656 | 328330117120 | 0
00000000-0000-0000-0000-38b8ebd00c30 | 0 | 0 | 2048347078656 | 327034077184 | 0
00000000-0000-0000-0000-38b8ebd00c2b | 0 | 0 | 2048347078656 | 359581876224 | 0
00000000-0000-0000-0000-38b8ebd00c2b | 0 | 1 | 2048347078656 | 356343873536 | 0
00000000-0000-0000-0000-38b8ebd00c6c | 0 | 1 | 2048347078656 | 344658542592 | 0
00000000-0000-0000-0000-38b8ebd00c1c | 0 | 1 | 2048347078656 | 363593728000 | 0
00000000-0000-0000-0000-38b8ebd00c58 | 0 | 1 | 2048347078656 | 317699653632 | 0
00000000-0000-0000-0000-38b8ebd00c53 | 0 | 1 | 2048347078656 | 327791149056 | 0
00000000-0000-0000-0000-38b8ebd007fd | 0 | 1 | 2048347078656 | 360108261376 | 0
00000000-0000-0000-0000-38b8ebd00bf9 | 0 | 1 | 2048347078656 | 342580264960 | 0
00000000-0000-0000-0000-38b8ebd00c35 | 0 | 1 | 2048347078656 | 427101782016 | 0
00000000-0000-0000-0000-38b8ebd00c30 | 0 | 1 | 2048347078656 | 331408736256 | 0
00000000-0000-0000-0000-38b8ebd00c0d | 0 | 1 | 2048347078656 | 362717118464 | 0
00000000-0000-0000-0000-38b8ebd00ca8 | 0 | 1 | 2048347078656 | 330909614080 | 0
...