best_available_gpus (view)
1 row where VRAM = 6
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW best_available_gpus AS SELECT DISTINCT [nvidia-gpus].name, [nvidia-gpus].VRAM -- [nvidia-gpus].name FROM [nvidia-gpus] JOIN nodes ON [nvidia-gpus].name = nodes.PARTITION WHERE nodes.STATE = 'idle' ORDER BY [nvidia-gpus].VRAM DESC;