Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| sched_name | varchar | 120 | null |
|
|
{“what”:“Scheduler instance name that fired the trigger; part of composite key.”,“why”:“Distinguishes rows from different schedulers in a shared table.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.598612647+00:00”} |
||
| entry_id | varchar | 95 | null |
|
|
{“what”:“Unique identifier for this firing event within the scheduler.”,“why”:“Uniquely identifies a firing record for updates and deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.645826313+00:00”} |
||
| trigger_name | varchar | 200 | null |
|
|
{“what”:“Name of the trigger that caused this firing.”,“why”:“Identifies which trigger is running; needed for job lookup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.660694942+00:00”} |
||
| trigger_group | varchar | 200 | null |
|
|
{“what”:“Group name of the fired trigger.”,“why”:“Groups triggers for management; used with trigger_name to locate trigger definition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.689721104+00:00”} |
||
| instance_name | varchar | 200 | null |
|
|
{“what”:“Name of the scheduler instance that is executing the trigger.”,“why”:“Tracks which node is handling the job; essential for failover and load balancing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.722419019+00:00”} |
||
| fired_time | int8 | 19 | null |
|
|
{“what”:“Epoch milliseconds when the trigger fired.”,“why”:“Used to compute execution duration and detect hung jobs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.761781220+00:00”} |
||
| sched_time | int8 | 19 | √ | null |
|
|
{“what”:“Epoch milliseconds when the trigger was scheduled to fire.”,“why”:“Shows delay between scheduled and actual fire time; helps monitor scheduling accuracy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.875557343+00:00”} |
|
| priority | int4 | 10 | null |
|
|
{“what”:“Priority of the fired trigger; higher value runs first.”,“why”:“Determines execution order when multiple triggers fire simultaneously.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.903458324+00:00”} |
||
| state | varchar | 16 | null |
|
|
{“what”:“Current state of the firing, e.g., ACQUIRED or EXECUTING.”,“why”:“Tracks lifecycle of the firing; needed for recovery and cleanup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.961555155+00:00”} |
||
| job_name | varchar | 200 | √ | null |
|
|
{“what”:“Name of the job that the trigger is associated with.”,“why”:“Links firing to job details; used for job recovery and monitoring.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.109492439+00:00”} |
|
| job_group | varchar | 200 | √ | null |
|
|
{“what”:“Group name of the associated job.”,“why”:“Identifies job group; used with job_name to locate job definition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.264518838+00:00”} |
|
| is_nonconcurrent | bool | 1 | √ | null |
|
|
{“what”:“True if the job disallows concurrent execution.”,“why”:“Prevents overlapping executions; needed to enforce concurrency policy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.374717307+00:00”} |
|
| requests_recovery | bool | 1 | √ | null |
|
|
{“what”:“True if the job should be re-executed after a scheduler failure.”,“why”:“Determines if the job must be recovered; critical for durability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.965992916+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_qrtz_fired_triggers | Primary key | Asc/Asc | sched_name + entry_id |
| idx_qrtz_ft_inst_job_req_rcvry | Performance | Asc/Asc/Asc | sched_name + instance_name + requests_recovery |
| idx_qrtz_ft_j_g | Performance | Asc/Asc/Asc | sched_name + job_name + job_group |
| idx_qrtz_ft_jg | Performance | Asc/Asc | sched_name + job_group |
| idx_qrtz_ft_t_g | Performance | Asc/Asc/Asc | sched_name + trigger_name + trigger_group |
| idx_qrtz_ft_tg | Performance | Asc/Asc | sched_name + trigger_group |
| idx_qrtz_ft_trig_inst_name | Performance | Asc/Asc | sched_name + instance_name |