Table harbinger.public.job_metrics_logs
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('job_metrics_logs_id_seq'::regclass)
job_name text 2147483647
job_description text 2147483647
frequency text 2147483647  √  null
script_path text 2147483647
hostname text 2147483647
success bool 1
run_output jsonb 2147483647
run_duration interval 49,6
run_start timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc job_metrics_logs_id
job_name + run_start Performance Desc/Desc job_metrics_logs_inx