PG_JOB_SINGLE¶
PG_JOB_SINGLE displays job information about the current node.
Name | Type | Description |
|---|---|---|
job_id | bigint | Job ID |
current_postgres_pid | bigint | If the current job has been executed, the PostgreSQL thread ID of this job is recorded. The default value is -1, indicating that the task is not executed or has been executed. |
log_user | name | User name of the job creator |
priv_user | name | User name of the job executor |
dbname | name | Name of the database where the job is executed |
node_name | name | CN node on which the job will be created and executed |
job_status | text | Status of the current job. The value range is r, s, f, or d. The default value is s. The indications are as follows:
Note
|
start_date | timestamp without time zone | Start time of the first job execution, precise to millisecond |
next_run_date | timestamp without time zone | Scheduled time of the next job execution, accurate to millisecond |
failure_count | smallint | Number of consecutive failures. |
interval | text | Job execution interval |
last_start_date | timestamp without time zone | Start time of the last job execution, accurate to millisecond |
last_end_date | timestamp without time zone | End time of the last job execution, accurate to millisecond |
last_suc_date | timestamp without time zone | Start time of the last successful job execution, accurate to millisecond |
this_run_date | timestamp without time zone | Start time of the ongoing job execution, accurate to millisecond |
nspname | name | Name of the namespace where a job is running |
what | text | Job content |