inner_join (view)
8 rows where STATE = "idle"
This data as json, CSV (advanced)
PARTITION | AVAIL | TIMELIMIT | NODES | STATE | NODELIST | name | VRAM |
---|---|---|---|---|---|---|---|
p4000 | up | 1-00:00:00 | 1 | idle | c2 | p4000 | 8 |
rtx2060 | up | 1-00:00:00 | 6 | idle | c[29,51-52,60-62] | rtx2060 | 6 |
rtx2070 | up | 1-00:00:00 | 10 | idle | c[50,63-67,74-76,79] | rtx2070 | 8 |
rtx2080 | up | 1-00:00:00 | 2 | idle | c[24,28] | rtx2080 | 8 |
rtx2060super | up | 1-00:00:00 | 5 | idle | c[37,43,48-49,78] | rtx2060super | 8 |
rtx2080super | up | 1-00:00:00 | 1 | idle | c23 | rtx2080super | 8 |
a4000 | up | 1-00:00:00 | 3 | idle | c[6-7,36] | a4000 | 16 |
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;