inner_join (view)
6 rows where NODES = 1
This data as json, CSV (advanced)
Suggested facets: PARTITION, STATE, name, VRAM
| PARTITION | AVAIL | TIMELIMIT | NODES | STATE | NODELIST | name | VRAM |
|---|---|---|---|---|---|---|---|
| p4000 | up | 1-00:00:00 | 1 | idle | c2 | p4000 | 8 |
| rtx2060super | up | 1-00:00:00 | 1 | drain | c38 | rtx2060super | 8 |
| rtx2080super | up | 1-00:00:00 | 1 | alloc | c22 | rtx2080super | 8 |
| rtx2080super | up | 1-00:00:00 | 1 | idle | c23 | rtx2080super | 8 |
| a100 | up | 1-00:00:00 | 1 | alloc | c33 | a100 | 80 |
| rtx4060ti16g | up | 1-00:00:00 | 1 | alloc | c25 | rtx4060ti16g | 16 |
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;