inner_join (view)
4 rows where NODES = 2
This data as json, CSV (advanced)
Suggested facets: TIMELIMIT, STATE, VRAM
PARTITION | AVAIL | TIMELIMIT | NODES | STATE | NODELIST | name | VRAM |
---|---|---|---|---|---|---|---|
rtx2080 | up | 1-00:00:00 | 2 | idle | c[24,28] | rtx2080 | 8 |
rtx3060ti | up | 1-00:00:00 | 2 | alloc | c[27,77] | rtx3060ti | 8 |
a6000 | up | 8-00:00:00 | 2 | alloc | c[30-31] | a6000 | 48 |
rtx4060ti8g | up | 1-00:00:00 | 2 | idle | c[28-29] | rtx4060ti8g | 8 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW inner_join AS SELECT * FROM nodes INNER JOIN [nvidia-gpus] ON nodes.PARTITION = [nvidia-gpus].name;