inner_join (view)

3 rows where PARTITION = "rtx2060super"

✎ View and edit SQL

This data as json, CSV (advanced)

PARTITION AVAIL TIMELIMIT NODES STATE NODELIST name VRAM
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW inner_join AS SELECT *
FROM nodes
INNER JOIN [nvidia-gpus] ON nodes.PARTITION = [nvidia-gpus].name;