Skip to main content
admin_show_jobs(options=)[source]

Get a list of the current jobs in GPUdb.

Parameters

options (dict of str to str) –

Optional parameters. Allowed keys are:

  • show_async_jobs – If true, then the completed async jobs are also included in the response. By default, once the async jobs are completed they are no longer included in the jobs list. Allowed values are:

    • true

    • false

    The default value is ‘false’.

  • show_worker_info – If true, then information is also returned from worker ranks. By default only status from the head rank is returned. Allowed values are:

    • true

    • false

The default value is an empty dict ( ).

Returns

A dict with the following entries–

job_id (list of longs) –

The identifiers of the running or completed jobs.

status (list of str) –

The current status of each job.

endpoint_name (list of str) –

The endpoint each job is executing (e.g. “/insert/records”).

time_received (list of longs) –

The epoch time, in milliseconds, at which each job was received.

auth_id (list of str) –

The identifier of the submitting or execute-as user for each job.

source_ip (list of str) –

The IP address from which each job request originated.

query_text (list of str) –

The text of the query associated with each job, when applicable.

user_data (list of str) –

Arbitrary user-provided data associated with each job.

flags (list of str) –

Flags associated with each job.

info (dict of str to str) –

Additional information. Allowed keys are:

  • job_tag – The job tag specified by the user or if unspecified by user, an internally generated unique identifier for the job across clusters.

  • worker_info – Worker job information as JSON.

The default value is an empty dict ( ).