— Table: public.processing_metrics

— DROP TABLE IF EXISTS public.processing_metrics;

CREATE TABLE IF NOT EXISTS public.processing_metrics
(
id uuid NOT NULL DEFAULT gen_random_uuid(),
job_id uuid,
operation_type character varying(50) COLLATE pg_catalog.”default” NOT NULL,
application_id uuid,
start_time timestamp without time zone NOT NULL,
end_time timestamp without time zone,
duration_seconds numeric(10,2),
status character varying(50) COLLATE pg_catalog.”default” DEFAULT ‘success’::character varying,
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT processing_metrics_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.processing_metrics
OWNER to pramod;
— Index: idx_processing_metrics_application

— DROP INDEX IF EXISTS public.idx_processing_metrics_application;

CREATE INDEX IF NOT EXISTS idx_processing_metrics_application
ON public.processing_metrics USING btree
(application_id ASC NULLS LAST)
WITH (fillfactor=100, deduplicate_items=True)
TABLESPACE pg_default;
— Index: idx_processing_metrics_job_id

— DROP INDEX IF EXISTS public.idx_processing_metrics_job_id;

CREATE INDEX IF NOT EXISTS idx_processing_metrics_job_id
ON public.processing_metrics USING btree
(job_id ASC NULLS LAST)
WITH (fillfactor=100, deduplicate_items=True)
TABLESPACE pg_default;
— Index: idx_processing_metrics_operation

— DROP INDEX IF EXISTS public.idx_processing_metrics_operation;

CREATE INDEX IF NOT EXISTS idx_processing_metrics_operation
ON public.processing_metrics USING btree
(operation_type COLLATE pg_catalog.”default” ASC NULLS LAST)
WITH (fillfactor=100, deduplicate_items=True)
TABLESPACE pg_default;