[slurm-users] [EXTERNAL] Re: Cluster usage, filtered by partition

Greg Wickham greg.wickham at kaust.edu.sa
Wed May 12 09:30:58 UTC 2021

Hi Diego,

Disclaimer: A little bit of shameless self-promotion.

We're using an application I wrote to inject slurm accounting records into a PostreSQL database. The
data is extracted from Slurm using "sacct".

From there it's possible to use SQL queries to mine the raw slurm data.


This tool _only_ injects Slurm data into PostgreSQL, unlike XDMoD (which can do this and more).

However the a big benefit for us is sminer can inject records into an existing database (no need for a separate database).

CSV dumps can be obtained using native PostgreSQL commands.

Graphs are created using python scripts (querying the data) and then plotted with gnuplot.



-----Original Message-----
From: slurm-users <slurm-users-bounces at lists.schedmd.com> on behalf of Diego Zuccato <diego.zuccato at unibo.it>
Reply to: Slurm User Community List <slurm-users at lists.schedmd.com>
Date: Wednesday, 12 May 2021 at 11:57 am
To: Slurm User Community List <slurm-users at lists.schedmd.com>, "Renfro, Michael" <Renfro at tntech.edu>
Subject: [EXTERNAL] Re: [slurm-users] Cluster usage, filtered by partition

    Il 11/05/21 21:20, Renfro, Michael ha scritto:

    > In a word, nothing that's guaranteed to be stable. I got my start from 
    > this reply on the XDMoD list in November 2019. Worked on 8.0:
    Tks for the hint.
    XDMoD seems interesting and I'll try to have a look. But a scientific 
    report w/o access to the bare numbers is definitely a no-no :)

    Diego Zuccato
    DIFA - Dip. di Fisica e Astronomia
    Servizi Informatici
    Alma Mater Studiorum - Università di Bologna
    V.le Berti-Pichat 6/2 - 40127 Bologna - Italy
    tel.: +39 051 20 95786

More information about the slurm-users mailing list