select name, namespace, active, succeeded, failed, completions, start_time, completion_time, age(coalesce(completion_time, current_timestamp), start_time) as duration, active_deadline_seconds, parallelism, selector, labels, annotationsfrom kubernetes_job;
select name, namespace, start_time, age(coalesce(completion_time, current_timestamp), start_time) as duration, active, succeeded, failedfrom kubernetes_jobwhere active > 0;
select namespace, name as pod_name, phase, cs ->> 'name' as container_name, cs ->> 'image' as image, cs ->> 'ready' as ready, cs_state as state, cs ->> 'started' as started, cs ->> 'restartCount' as restartsfrom kubernetes_pod, jsonb_array_elements(container_statuses) as cs, jsonb_object_keys(cs -> 'state') as cs_stateorder by namespace, name, container_name;
Parameter | Description |
---|---|
SQL statement | The SQL statement we wish to use to query the resource. |
Output format | Representation of the output result. The possible options are “Table”, “CSV” or “JSON”. |
Was this page helpful?