best_available_gpus (view)

8 rows

✎ View and edit SQL

This data as json, CSV (advanced)

VRAM 3 ✖

name VRAM
a4000 16
p4000 8
rtx2070 8
rtx2080 8
rtx2060super 8
rtx2080super 8
rtx4060ti8g 8
rtx2060 6

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;