-
Notifications
You must be signed in to change notification settings - Fork 106
pipeline-manager: pipeline monitoring events #5446
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
base: main
Are you sure you want to change the base?
Changes from all commits
File filter
Filter by extension
Conversations
Jump to
Diff view
Diff view
There are no files selected for viewing
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -0,0 +1,16 @@ | ||
| -- Regularly the status of the pipeline is observed and stored in this table. | ||
| -- The rows in this table are regularly cleaned up to prevent it growing unbound. | ||
|
Contributor
There was a problem hiding this comment. Choose a reason for hiding this commentThe reason will be displayed to describe this comment to others. Learn more. unbounded |
||
| CREATE TABLE IF NOT EXISTS pipeline_monitor_event ( | ||
| id UUID PRIMARY KEY NOT NULL, -- Unique event identifier. | ||
| pipeline_id UUID NOT NULL, -- Identifier of the pipeline the event corresponds to. | ||
| recorded_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() NOT NULL, -- Timestamp when status recording started. | ||
| resources_status VARCHAR NOT NULL, -- Resources status. | ||
| resources_status_details VARCHAR NOT NULL, -- Resources status details. | ||
| resources_desired_status VARCHAR NOT NULL, -- Resources desired status. | ||
| runtime_status VARCHAR NULL, -- Runtime status (only set during deployment). | ||
| runtime_status_details VARCHAR NULL, -- Runtime status details (only set during deployment). | ||
| runtime_desired_status VARCHAR NULL, -- Runtime desired status (only set during deployment). | ||
| program_status VARCHAR NOT NULL, -- Program status. | ||
| storage_status VARCHAR NOT NULL, -- Storage status. | ||
| FOREIGN KEY (pipeline_id) REFERENCES pipeline(id) ON DELETE CASCADE | ||
| ); | ||
|
There was a problem hiding this comment. Choose a reason for hiding this commentThe reason will be displayed to describe this comment to others. Learn more. No index on CREATE INDEX ON pipeline_monitor_event (pipeline_id, recorded_at DESC);This covers the list ( |
||
Uh oh!
There was an error while loading. Please reload this page.