inner_join (view)
13 rows where VRAM = 8
This data as json, CSV (advanced)
Suggested facets: PARTITION, NODES, STATE, name
| PARTITION | AVAIL | TIMELIMIT | NODES | STATE | NODELIST | name | VRAM |
|---|---|---|---|---|---|---|---|
| p4000 | up | 1-00:00:00 | 15 | alloc | c[0-1,3,8-19] | p4000 | 8 |
| p4000 | up | 1-00:00:00 | 1 | idle | c2 | p4000 | 8 |
| rtx2070 | up | 1-00:00:00 | 5 | alloc | c[69-73] | rtx2070 | 8 |
| 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 | 1 | drain | c38 | rtx2060super | 8 |
| rtx2060super | up | 1-00:00:00 | 15 | alloc | c[21,25,32,34,39-42,44-47,58-59,68] | rtx2060super | 8 |
| rtx2060super | up | 1-00:00:00 | 5 | idle | c[37,43,48-49,78] | rtx2060super | 8 |
| rtx2080super | up | 1-00:00:00 | 1 | alloc | c22 | rtx2080super | 8 |
| rtx2080super | up | 1-00:00:00 | 1 | idle | c23 | rtx2080super | 8 |
| rtx3060ti | up | 1-00:00:00 | 2 | alloc | c[27,77] | rtx3060ti | 8 |
| rtx4060ti8g | up | 1-00:00:00 | 5 | alloc | c[20-22,26-27] | rtx4060ti8g | 8 |
| 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;