flux-account-view-job-records(1)
SYNOPSIS
flux account view-job-records [OPTIONS]
DESCRIPTION
flux account view-job-records will display completed job records
stored in the flux-accounting database's jobs table. The table can be
filtered to show job records by multiple parameters to only return a subset of
job records.
- -u/--user
Only return jobs submitted by a certain username.
- -j/--jobid
Return a job record for a specific job ID. The job ID can be of any accepted Flux locally unique ID.
- -a/--after-start-time
Return jobs that have started after a certain time. The timestamp can be in seconds-since-epoch or a human readable timestamp (e.g.
'01/01/2025','2025-01-01 08:00:00','Jan 1, 2025 8am').
- -b/--before-end-time
Return jobs that have completed before a certain time. The timestamp can be in seconds-since-epoch or a human readable timestamp (e.g.
'01/01/2025','2025-01-01 08:00:00','Jan 1, 2025 8am').
- --project
Return jobs that were run under a certain project.
- -B/--bank
Return jobs that were run under a certain bank.
- -d/--requested-duration
Return jobs that fit a certain requested duration's criteria by passing an expression. Multiple filters can be passed to refine the
requested_durationcolumn by. Expressions can be started with any of the following operators:<,<=,=,>=, or>.
- -e/--actual-duration
Return jobs that fit a certain actual duration's criteria by passing an expression. Multiple filters can be passed to refine the
actual_durationcolumn by. Expressions can be started with any of the following operators:<,<=,=,>=, or>.
- -D/--duration-delta
Return jobs that fit a certain duration delta's criteria by passing an expression. Multiple filters can be passed to refine the
duration_deltacolumn by. Expressions can be started with any of the following operators:<,<=,=,>=, or>.
- -o/--format
Specify output format using Python's string format syntax. The available fields are: (jobid,username,userid,t_submit,t_run,t_inactive,nnodes project,bank)
EXAMPLES
Passing a job ID will return just the job record for that specific ID:
$ flux account view-job-records --jobid fPeYLgX
jobid | username | userid | t_submit | t_run | t_inactive | nnodes | project | bank
14965276672 | 5001 | 5001 | 1750178607.79 | 1750178607.82 | 1750178607.88 | 1 | * | bankA
Or filtered to show jobs from a certain time range:
$ flux account view-job-records --after-start-time="2025-05-01 08:00:00"
jobid | username | userid | t_submit | t_run | t_inactive | nnodes | project | bank
17297309696 | 5001 | 5001 | 1750178934.61 | 1750178934.63 | 1750178934.74 | 1 | * | bankA
15015608320 | 5001 | 5001 | 1750178934.47 | 1750178934.49 | 1750178934.69 | 1 | * | bankA
And customized using Python's string format syntax:
$ flux account view-job-records -o "{userid:<8} || {t_inactive:<12.3f}"
userid || t_inactive
5001 || 1750178788.333
5001 || 1750178788.419
5001 || 1750178788.238
5001 || 1750178788.147
5001 || 1750178789.810
To filter the jobs table by duration values, you can pass an expression:
$ flux account view-job-records -d "< 60"
The above will filter job records with a requested duration less than 60 seconds long.
Multiple expressions can be passed to further filter the requested_duration
column:
$ flux account view-job-records -d "> 60" "< 1200"
Both requested duration and actual duration can be passed to search for certain jobs:
$ flux account view-job-records -d "< 60" -e "> 30" "< 45"
The duration delta can also be passed as a search criteria when filtering the
jobs table:
$ flux account view-job-records -D "< 10"
This will only show jobs with a duration delta of less than 10 seconds.