--
-- PostgreSQL database dump
--

-- Dumped from database version 14.13 (Postgres.app)
-- Dumped by pg_dump version 14.11 (Homebrew)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.alembic_version (
    version_num character varying(32) NOT NULL
);


ALTER TABLE public.alembic_version OWNER TO jamie;

--
-- Name: asset_check_executions; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.asset_check_executions (
    id bigint NOT NULL,
    asset_key text,
    check_name text,
    partition text,
    run_id character varying(255),
    execution_status character varying(255),
    evaluation_event text,
    evaluation_event_timestamp timestamp without time zone,
    evaluation_event_storage_id bigint,
    materialization_event_storage_id bigint,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.asset_check_executions OWNER TO jamie;

--
-- Name: asset_check_executions_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.asset_check_executions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.asset_check_executions_id_seq OWNER TO jamie;

--
-- Name: asset_check_executions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.asset_check_executions_id_seq OWNED BY public.asset_check_executions.id;


--
-- Name: asset_daemon_asset_evaluations; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.asset_daemon_asset_evaluations (
    id bigint NOT NULL,
    evaluation_id bigint,
    asset_key text,
    asset_evaluation_body text,
    num_requested integer,
    num_skipped integer,
    num_discarded integer,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.asset_daemon_asset_evaluations OWNER TO jamie;

--
-- Name: asset_daemon_asset_evaluations_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.asset_daemon_asset_evaluations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.asset_daemon_asset_evaluations_id_seq OWNER TO jamie;

--
-- Name: asset_daemon_asset_evaluations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.asset_daemon_asset_evaluations_id_seq OWNED BY public.asset_daemon_asset_evaluations.id;


--
-- Name: asset_event_tags; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.asset_event_tags (
    id bigint NOT NULL,
    event_id bigint,
    asset_key text NOT NULL,
    key text NOT NULL,
    value text,
    event_timestamp timestamp without time zone
);


ALTER TABLE public.asset_event_tags OWNER TO jamie;

--
-- Name: asset_event_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.asset_event_tags_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.asset_event_tags_id_seq OWNER TO jamie;

--
-- Name: asset_event_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.asset_event_tags_id_seq OWNED BY public.asset_event_tags.id;


--
-- Name: asset_keys; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.asset_keys (
    id bigint NOT NULL,
    asset_key character varying(512),
    last_materialization text,
    last_run_id character varying(255),
    asset_details text,
    wipe_timestamp timestamp without time zone,
    last_materialization_timestamp timestamp without time zone,
    tags text,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    cached_status_data text
);


ALTER TABLE public.asset_keys OWNER TO jamie;

--
-- Name: asset_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.asset_keys_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.asset_keys_id_seq OWNER TO jamie;

--
-- Name: asset_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.asset_keys_id_seq OWNED BY public.asset_keys.id;


--
-- Name: bulk_actions; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.bulk_actions (
    id bigint NOT NULL,
    key character varying(32) NOT NULL,
    status character varying(255) NOT NULL,
    "timestamp" timestamp without time zone NOT NULL,
    body text,
    action_type character varying(32),
    selector_id text
);


ALTER TABLE public.bulk_actions OWNER TO jamie;

--
-- Name: bulk_actions_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.bulk_actions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.bulk_actions_id_seq OWNER TO jamie;

--
-- Name: bulk_actions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.bulk_actions_id_seq OWNED BY public.bulk_actions.id;


--
-- Name: concurrency_limits; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.concurrency_limits (
    id bigint NOT NULL,
    concurrency_key character varying(512) NOT NULL,
    "limit" integer NOT NULL,
    update_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.concurrency_limits OWNER TO jamie;

--
-- Name: concurrency_limits_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.concurrency_limits_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.concurrency_limits_id_seq OWNER TO jamie;

--
-- Name: concurrency_limits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.concurrency_limits_id_seq OWNED BY public.concurrency_limits.id;


--
-- Name: concurrency_slots; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.concurrency_slots (
    id bigint NOT NULL,
    concurrency_key text NOT NULL,
    run_id text,
    step_key text,
    deleted boolean NOT NULL,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.concurrency_slots OWNER TO jamie;

--
-- Name: concurrency_slots_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.concurrency_slots_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.concurrency_slots_id_seq OWNER TO jamie;

--
-- Name: concurrency_slots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.concurrency_slots_id_seq OWNED BY public.concurrency_slots.id;


--
-- Name: daemon_heartbeats; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.daemon_heartbeats (
    id bigint NOT NULL,
    daemon_type character varying(255) NOT NULL,
    daemon_id character varying(255),
    "timestamp" timestamp without time zone NOT NULL,
    body text
);


ALTER TABLE public.daemon_heartbeats OWNER TO jamie;

--
-- Name: daemon_heartbeats_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.daemon_heartbeats_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.daemon_heartbeats_id_seq OWNER TO jamie;

--
-- Name: daemon_heartbeats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.daemon_heartbeats_id_seq OWNED BY public.daemon_heartbeats.id;


--
-- Name: dynamic_partitions; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.dynamic_partitions (
    id bigint NOT NULL,
    partitions_def_name text NOT NULL,
    partition text NOT NULL,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.dynamic_partitions OWNER TO jamie;

--
-- Name: dynamic_partitions_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.dynamic_partitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dynamic_partitions_id_seq OWNER TO jamie;

--
-- Name: dynamic_partitions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.dynamic_partitions_id_seq OWNED BY public.dynamic_partitions.id;


--
-- Name: event_logs; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.event_logs (
    id bigint NOT NULL,
    run_id character varying(255),
    event text NOT NULL,
    dagster_event_type text,
    "timestamp" timestamp without time zone,
    step_key text,
    asset_key text,
    partition text
);


ALTER TABLE public.event_logs OWNER TO jamie;

--
-- Name: event_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.event_logs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.event_logs_id_seq OWNER TO jamie;

--
-- Name: event_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.event_logs_id_seq OWNED BY public.event_logs.id;


--
-- Name: instance_info; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.instance_info (
    id bigint NOT NULL,
    run_storage_id text
);


ALTER TABLE public.instance_info OWNER TO jamie;

--
-- Name: instance_info_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.instance_info_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.instance_info_id_seq OWNER TO jamie;

--
-- Name: instance_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.instance_info_id_seq OWNED BY public.instance_info.id;


--
-- Name: instigators; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.instigators (
    id bigint NOT NULL,
    selector_id character varying(255),
    repository_selector_id character varying(255),
    status character varying(63),
    instigator_type character varying(63),
    instigator_body text,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    update_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.instigators OWNER TO jamie;

--
-- Name: instigators_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.instigators_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.instigators_id_seq OWNER TO jamie;

--
-- Name: instigators_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.instigators_id_seq OWNED BY public.instigators.id;


--
-- Name: job_ticks; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.job_ticks (
    id bigint NOT NULL,
    job_origin_id character varying(255),
    selector_id character varying(255),
    status character varying(63),
    type character varying(63),
    "timestamp" timestamp without time zone,
    tick_body text,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    update_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.job_ticks OWNER TO jamie;

--
-- Name: job_ticks_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.job_ticks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.job_ticks_id_seq OWNER TO jamie;

--
-- Name: job_ticks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.job_ticks_id_seq OWNED BY public.job_ticks.id;


--
-- Name: jobs; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    job_origin_id character varying(255),
    selector_id character varying(255),
    repository_origin_id character varying(255),
    status character varying(63),
    job_type character varying(63),
    job_body text,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    update_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.jobs OWNER TO jamie;

--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.jobs_id_seq OWNER TO jamie;

--
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- Name: kvs; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.kvs (
    id bigint NOT NULL,
    key text NOT NULL,
    value text
);


ALTER TABLE public.kvs OWNER TO jamie;

--
-- Name: kvs_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.kvs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.kvs_id_seq OWNER TO jamie;

--
-- Name: kvs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.kvs_id_seq OWNED BY public.kvs.id;


--
-- Name: pending_steps; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.pending_steps (
    id bigint NOT NULL,
    concurrency_key text NOT NULL,
    run_id text,
    step_key text,
    priority integer,
    assigned_timestamp timestamp without time zone,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.pending_steps OWNER TO jamie;

--
-- Name: pending_steps_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.pending_steps_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pending_steps_id_seq OWNER TO jamie;

--
-- Name: pending_steps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.pending_steps_id_seq OWNED BY public.pending_steps.id;


--
-- Name: run_tags; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.run_tags (
    id bigint NOT NULL,
    run_id character varying(255),
    key text,
    value text
);


ALTER TABLE public.run_tags OWNER TO jamie;

--
-- Name: run_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.run_tags_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.run_tags_id_seq OWNER TO jamie;

--
-- Name: run_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.run_tags_id_seq OWNED BY public.run_tags.id;


--
-- Name: runs; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.runs (
    id bigint NOT NULL,
    run_id character varying(255),
    snapshot_id character varying(255),
    pipeline_name text,
    mode text,
    status character varying(63),
    run_body text,
    partition text,
    partition_set text,
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    update_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    start_time double precision,
    end_time double precision
);


ALTER TABLE public.runs OWNER TO jamie;

--
-- Name: runs_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.runs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.runs_id_seq OWNER TO jamie;

--
-- Name: runs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.runs_id_seq OWNED BY public.runs.id;


--
-- Name: secondary_indexes; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.secondary_indexes (
    id bigint NOT NULL,
    name character varying(512),
    create_timestamp timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    migration_completed timestamp without time zone
);


ALTER TABLE public.secondary_indexes OWNER TO jamie;

--
-- Name: secondary_indexes_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.secondary_indexes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.secondary_indexes_id_seq OWNER TO jamie;

--
-- Name: secondary_indexes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.secondary_indexes_id_seq OWNED BY public.secondary_indexes.id;


--
-- Name: snapshots; Type: TABLE; Schema: public; Owner: jamie
--

CREATE TABLE public.snapshots (
    id bigint NOT NULL,
    snapshot_id character varying(255) NOT NULL,
    snapshot_body bytea NOT NULL,
    snapshot_type character varying(63) NOT NULL
);


ALTER TABLE public.snapshots OWNER TO jamie;

--
-- Name: snapshots_id_seq; Type: SEQUENCE; Schema: public; Owner: jamie
--

CREATE SEQUENCE public.snapshots_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.snapshots_id_seq OWNER TO jamie;

--
-- Name: snapshots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jamie
--

ALTER SEQUENCE public.snapshots_id_seq OWNED BY public.snapshots.id;


--
-- Name: asset_check_executions id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_check_executions ALTER COLUMN id SET DEFAULT nextval('public.asset_check_executions_id_seq'::regclass);


--
-- Name: asset_daemon_asset_evaluations id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_daemon_asset_evaluations ALTER COLUMN id SET DEFAULT nextval('public.asset_daemon_asset_evaluations_id_seq'::regclass);


--
-- Name: asset_event_tags id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_event_tags ALTER COLUMN id SET DEFAULT nextval('public.asset_event_tags_id_seq'::regclass);


--
-- Name: asset_keys id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_keys ALTER COLUMN id SET DEFAULT nextval('public.asset_keys_id_seq'::regclass);


--
-- Name: bulk_actions id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.bulk_actions ALTER COLUMN id SET DEFAULT nextval('public.bulk_actions_id_seq'::regclass);


--
-- Name: concurrency_limits id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.concurrency_limits ALTER COLUMN id SET DEFAULT nextval('public.concurrency_limits_id_seq'::regclass);


--
-- Name: concurrency_slots id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.concurrency_slots ALTER COLUMN id SET DEFAULT nextval('public.concurrency_slots_id_seq'::regclass);


--
-- Name: daemon_heartbeats id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.daemon_heartbeats ALTER COLUMN id SET DEFAULT nextval('public.daemon_heartbeats_id_seq'::regclass);


--
-- Name: dynamic_partitions id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.dynamic_partitions ALTER COLUMN id SET DEFAULT nextval('public.dynamic_partitions_id_seq'::regclass);


--
-- Name: event_logs id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.event_logs ALTER COLUMN id SET DEFAULT nextval('public.event_logs_id_seq'::regclass);


--
-- Name: instance_info id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.instance_info ALTER COLUMN id SET DEFAULT nextval('public.instance_info_id_seq'::regclass);


--
-- Name: instigators id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.instigators ALTER COLUMN id SET DEFAULT nextval('public.instigators_id_seq'::regclass);


--
-- Name: job_ticks id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.job_ticks ALTER COLUMN id SET DEFAULT nextval('public.job_ticks_id_seq'::regclass);


--
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);


--
-- Name: kvs id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.kvs ALTER COLUMN id SET DEFAULT nextval('public.kvs_id_seq'::regclass);


--
-- Name: pending_steps id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.pending_steps ALTER COLUMN id SET DEFAULT nextval('public.pending_steps_id_seq'::regclass);


--
-- Name: run_tags id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.run_tags ALTER COLUMN id SET DEFAULT nextval('public.run_tags_id_seq'::regclass);


--
-- Name: runs id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.runs ALTER COLUMN id SET DEFAULT nextval('public.runs_id_seq'::regclass);


--
-- Name: secondary_indexes id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.secondary_indexes ALTER COLUMN id SET DEFAULT nextval('public.secondary_indexes_id_seq'::regclass);


--
-- Name: snapshots id; Type: DEFAULT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.snapshots ALTER COLUMN id SET DEFAULT nextval('public.snapshots_id_seq'::regclass);


--
-- Data for Name: alembic_version; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.alembic_version (version_num) FROM stdin;
284a732df317
\.


--
-- Data for Name: asset_check_executions; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.asset_check_executions (id, asset_key, check_name, partition, run_id, execution_status, evaluation_event, evaluation_event_timestamp, evaluation_event_storage_id, materialization_event_storage_id, create_timestamp) FROM stdin;
\.


--
-- Data for Name: asset_daemon_asset_evaluations; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.asset_daemon_asset_evaluations (id, evaluation_id, asset_key, asset_evaluation_body, num_requested, num_skipped, num_discarded, create_timestamp) FROM stdin;
\.


--
-- Data for Name: asset_event_tags; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.asset_event_tags (id, event_id, asset_key, key, value, event_timestamp) FROM stdin;
1	14	["not_partitioned"]	dagster/data_version	db42fd64a12f649b0124893d80c33f73011ebe92a80444bf01e158774ba0ba8e	2024-10-21 16:38:41.08461
\.


--
-- Data for Name: asset_keys; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.asset_keys (id, asset_key, last_materialization, last_run_id, asset_details, wipe_timestamp, last_materialization_timestamp, tags, create_timestamp, cached_status_data) FROM stdin;
1	["not_partitioned"]	{"__class__": "EventLogRecord", "event_log_entry": {"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "StepMaterializationData", "asset_lineage": [], "materialization": {"__class__": "AssetMaterialization", "asset_key": {"__class__": "AssetKey", "path": ["not_partitioned"]}, "description": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "PathMetadataEntryData", "path": "/Users/jamie/temp_dagster_home/storage/not_partitioned"}, "label": "path"}], "partition": null, "tags": {"dagster/code_version": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "dagster/data_version": "db42fd64a12f649b0124893d80c33f73011ebe92a80444bf01e158774ba0ba8e"}}}, "event_type_value": "ASSET_MATERIALIZATION", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Materialized value not_partitioned.", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.08461, "user_message": "Materialized value not_partitioned."}, "storage_id": 14}	2464fea5-b2f4-437b-8461-5cd6d6572ff4	\N	\N	2024-10-21 12:38:41.08461	\N	2024-10-21 12:38:37.386848	\N
\.


--
-- Data for Name: bulk_actions; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.bulk_actions (id, key, status, "timestamp", body, action_type, selector_id) FROM stdin;
\.


--
-- Data for Name: concurrency_limits; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.concurrency_limits (id, concurrency_key, "limit", update_timestamp, create_timestamp) FROM stdin;
\.


--
-- Data for Name: concurrency_slots; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.concurrency_slots (id, concurrency_key, run_id, step_key, deleted, create_timestamp) FROM stdin;
\.


--
-- Data for Name: daemon_heartbeats; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.daemon_heartbeats (id, daemon_type, daemon_id, "timestamp", body) FROM stdin;
4	SCHEDULER	d881642b-0b88-430e-848a-8216cc5c3e20	2024-10-21 12:37:43.497843	{"__class__": "DaemonHeartbeat", "daemon_id": "d881642b-0b88-430e-848a-8216cc5c3e20", "daemon_type": "SCHEDULER", "errors": [], "timestamp": 1729528663.497843}
1	ASSET	d881642b-0b88-430e-848a-8216cc5c3e20	2024-10-21 12:38:43.704456	{"__class__": "DaemonHeartbeat", "daemon_id": "d881642b-0b88-430e-848a-8216cc5c3e20", "daemon_type": "ASSET", "errors": [], "timestamp": 1729528723.704456}
2	SENSOR	d881642b-0b88-430e-848a-8216cc5c3e20	2024-10-21 12:38:43.695185	{"__class__": "DaemonHeartbeat", "daemon_id": "d881642b-0b88-430e-848a-8216cc5c3e20", "daemon_type": "SENSOR", "errors": [], "timestamp": 1729528723.695185}
3	BACKFILL	d881642b-0b88-430e-848a-8216cc5c3e20	2024-10-21 12:38:43.872834	{"__class__": "DaemonHeartbeat", "daemon_id": "d881642b-0b88-430e-848a-8216cc5c3e20", "daemon_type": "BACKFILL", "errors": [], "timestamp": 1729528723.872834}
\.


--
-- Data for Name: dynamic_partitions; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.dynamic_partitions (id, partitions_def_name, partition, create_timestamp) FROM stdin;
\.


--
-- Data for Name: event_logs; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.event_logs (id, run_id, event, dagster_event_type, "timestamp", step_key, asset_key, partition) FROM stdin;
1	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "AssetMaterializationPlannedData", "asset_key": {"__class__": "AssetKey", "path": ["not_partitioned"]}, "partition": null, "partitions_subset": null}, "event_type_value": "ASSET_MATERIALIZATION_PLANNED", "logging_tags": {}, "message": "__ASSET_JOB intends to materialize asset [\\"not_partitioned\\"]", "pid": null, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": "not_partitioned", "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528717.3807418, "user_message": ""}	ASSET_MATERIALIZATION_PLANNED	2024-10-21 16:38:37.380742	not_partitioned	["not_partitioned"]	\N
2	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": null, "event_type_value": "PIPELINE_STARTING", "logging_tags": {}, "message": null, "pid": null, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 20, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528717.414009, "user_message": ""}	PIPELINE_STARTING	2024-10-21 16:38:37.414009	\N	\N	\N
3	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": null, "marker_start": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "TextMetadataEntryData", "text": "82986"}, "label": "pid"}]}, "event_type_value": "ENGINE_EVENT", "logging_tags": {}, "message": "Started process for run (pid: 82986).", "pid": null, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 20, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528719.392034, "user_message": ""}	ENGINE_EVENT	2024-10-21 16:38:39.392034	\N	\N	\N
4	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": null, "event_type_value": "PIPELINE_START", "logging_tags": {}, "message": "Started execution of run for \\"__ASSET_JOB\\".", "pid": 82986, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528719.518539, "user_message": "Started execution of run for \\"__ASSET_JOB\\"."}	PIPELINE_START	2024-10-21 16:38:39.518539	\N	\N	\N
5	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": null, "marker_start": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "TextMetadataEntryData", "text": "82986"}, "label": "pid"}, {"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "TextMetadataEntryData", "text": "['not_partitioned']"}, "label": "step_keys"}]}, "event_type_value": "ENGINE_EVENT", "logging_tags": {}, "message": "Executing steps using multiprocess executor: parent process (pid: 82986)", "pid": 82986, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528719.574795, "user_message": "Executing steps using multiprocess executor: parent process (pid: 82986)"}	ENGINE_EVENT	2024-10-21 16:38:39.574795	\N	\N	\N
6	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": null, "marker_start": "step_process_start", "metadata_entries": []}, "event_type_value": "STEP_WORKER_STARTING", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Launching subprocess for \\"not_partitioned\\".", "pid": 82986, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528719.587751, "user_message": "Launching subprocess for \\"not_partitioned\\"."}	STEP_WORKER_STARTING	2024-10-21 16:38:39.587751	not_partitioned	\N	\N
7	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": "step_process_start", "marker_start": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "TextMetadataEntryData", "text": "83044"}, "label": "pid"}]}, "event_type_value": "STEP_WORKER_STARTED", "logging_tags": {}, "message": "Executing step \\"not_partitioned\\" in subprocess.", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": "not_partitioned", "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528720.677435, "user_message": "Executing step \\"not_partitioned\\" in subprocess."}	STEP_WORKER_STARTED	2024-10-21 16:38:40.677435	not_partitioned	\N	\N
8	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": null, "marker_start": "resources", "metadata_entries": []}, "event_type_value": "RESOURCE_INIT_STARTED", "logging_tags": {}, "message": "Starting initialization of resources [io_manager].", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528720.729564, "user_message": "Starting initialization of resources [io_manager]."}	RESOURCE_INIT_STARTED	2024-10-21 16:38:40.729564	not_partitioned	\N	\N
9	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": "resources", "marker_start": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "PythonArtifactMetadataEntryData", "module": "dagster._core.storage.fs_io_manager", "name": "PickledObjectFilesystemIOManager"}, "label": "io_manager"}, {"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "TextMetadataEntryData", "text": "26ms"}, "label": "io_manager:init_time"}]}, "event_type_value": "RESOURCE_INIT_SUCCESS", "logging_tags": {}, "message": "Finished initialization of resources [io_manager].", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528720.773275, "user_message": "Finished initialization of resources [io_manager]."}	RESOURCE_INIT_SUCCESS	2024-10-21 16:38:40.773275	not_partitioned	\N	\N
10	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "ComputeLogsCaptureData", "external_stderr_url": null, "external_stdout_url": null, "external_url": null, "log_key": "hpnzfxjp", "step_keys": ["not_partitioned"]}, "event_type_value": "LOGS_CAPTURED", "logging_tags": {}, "message": "Started capturing logs in process (pid: 83044).", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528720.963532, "user_message": "Started capturing logs in process (pid: 83044)."}	LOGS_CAPTURED	2024-10-21 16:38:40.963532	\N	\N	\N
11	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": null, "event_type_value": "STEP_START", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Started execution of step \\"not_partitioned\\".", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.018494, "user_message": "Started execution of step \\"not_partitioned\\"."}	STEP_START	2024-10-21 16:38:41.018494	not_partitioned	\N	\N
12	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "StepOutputData", "metadata_entries": [], "step_output_handle": {"__class__": "StepOutputHandle", "mapping_key": null, "output_name": "result", "step_key": "not_partitioned"}, "type_check_data": {"__class__": "TypeCheckData", "description": null, "label": "result", "metadata_entries": [], "success": true}, "version": null}, "event_type_value": "STEP_OUTPUT", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Yielded output \\"result\\" of type \\"Any\\". (Type check passed).", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.040823, "user_message": "Yielded output \\"result\\" of type \\"Any\\". (Type check passed)."}	STEP_OUTPUT	2024-10-21 16:38:41.040823	not_partitioned	\N	\N
13	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": null, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.05668, "user_message": "Writing file at: /Users/jamie/temp_dagster_home/storage/not_partitioned using PickledObjectFilesystemIOManager..."}	\N	2024-10-21 16:38:41.05668	not_partitioned	\N	\N
14	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "StepMaterializationData", "asset_lineage": [], "materialization": {"__class__": "AssetMaterialization", "asset_key": {"__class__": "AssetKey", "path": ["not_partitioned"]}, "description": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "PathMetadataEntryData", "path": "/Users/jamie/temp_dagster_home/storage/not_partitioned"}, "label": "path"}], "partition": null, "tags": {"dagster/code_version": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "dagster/data_version": "db42fd64a12f649b0124893d80c33f73011ebe92a80444bf01e158774ba0ba8e"}}}, "event_type_value": "ASSET_MATERIALIZATION", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Materialized value not_partitioned.", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.08461, "user_message": "Materialized value not_partitioned."}	ASSET_MATERIALIZATION	2024-10-21 16:38:41.08461	not_partitioned	["not_partitioned"]	\N
15	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "HandledOutputData", "manager_key": "io_manager", "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "PathMetadataEntryData", "path": "/Users/jamie/temp_dagster_home/storage/not_partitioned"}, "label": "path"}], "output_name": "result"}, "event_type_value": "HANDLED_OUTPUT", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Handled output \\"result\\" using IO manager \\"io_manager\\"", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.180243, "user_message": "Handled output \\"result\\" using IO manager \\"io_manager\\""}	HANDLED_OUTPUT	2024-10-21 16:38:41.180243	not_partitioned	\N	\N
16	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "StepSuccessData", "duration_ms": 154.78366700699553}, "event_type_value": "STEP_SUCCESS", "logging_tags": {"job_name": "__ASSET_JOB", "op_name": "not_partitioned", "resource_fn_name": "None", "resource_name": "None", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned"}, "message": "Finished execution of step \\"not_partitioned\\" in 154ms.", "pid": 83044, "pipeline_name": "__ASSET_JOB", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}, "step_handle": {"__class__": "StepHandle", "key": "not_partitioned", "solid_handle": {"__class__": "SolidHandle", "name": "not_partitioned", "parent": null}}, "step_key": "not_partitioned", "step_kind_value": "COMPUTE"}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": "not_partitioned", "timestamp": 1729528721.194033, "user_message": "Finished execution of step \\"not_partitioned\\" in 154ms."}	STEP_SUCCESS	2024-10-21 16:38:41.194033	not_partitioned	\N	\N
17	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": null, "marker_start": null, "metadata_entries": [{"__class__": "EventMetadataEntry", "description": null, "entry_data": {"__class__": "TextMetadataEntryData", "text": "82986"}, "label": "pid"}]}, "event_type_value": "ENGINE_EVENT", "logging_tags": {}, "message": "Multiprocess executor: parent process exiting after 1.84s (pid: 82986)", "pid": 82986, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528721.4297469, "user_message": "Multiprocess executor: parent process exiting after 1.84s (pid: 82986)"}	ENGINE_EVENT	2024-10-21 16:38:41.429747	\N	\N	\N
18	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": null, "event_type_value": "PIPELINE_SUCCESS", "logging_tags": {}, "message": "Finished execution of run for \\"__ASSET_JOB\\".", "pid": 82986, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 10, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528721.45932, "user_message": "Finished execution of run for \\"__ASSET_JOB\\"."}	PIPELINE_SUCCESS	2024-10-21 16:38:41.45932	\N	\N	\N
19	2464fea5-b2f4-437b-8461-5cd6d6572ff4	{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "EngineEventData", "error": null, "marker_end": null, "marker_start": null, "metadata_entries": []}, "event_type_value": "ENGINE_EVENT", "logging_tags": {}, "message": "Process for run exited (pid: 82986).", "pid": null, "pipeline_name": "__ASSET_JOB", "solid_handle": null, "step_handle": null, "step_key": null, "step_kind_value": null}, "error_info": null, "level": 20, "message": "", "pipeline_name": "__ASSET_JOB", "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "step_key": null, "timestamp": 1729528721.5240781, "user_message": ""}	ENGINE_EVENT	2024-10-21 16:38:41.524078	\N	\N	\N
\.


--
-- Data for Name: instance_info; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.instance_info (id, run_storage_id) FROM stdin;
1	004fb01c-62fd-42fa-8ba9-c9fece207374
\.


--
-- Data for Name: instigators; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.instigators (id, selector_id, repository_selector_id, status, instigator_type, instigator_body, create_timestamp, update_timestamp) FROM stdin;
\.


--
-- Data for Name: job_ticks; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.job_ticks (id, job_origin_id, selector_id, status, type, "timestamp", tick_body, create_timestamp, update_timestamp) FROM stdin;
\.


--
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.jobs (id, job_origin_id, selector_id, repository_origin_id, status, job_type, job_body, create_timestamp, update_timestamp) FROM stdin;
\.


--
-- Data for Name: kvs; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.kvs (id, key, value) FROM stdin;
\.


--
-- Data for Name: pending_steps; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.pending_steps (id, concurrency_key, run_id, step_key, priority, assigned_timestamp, create_timestamp) FROM stdin;
\.


--
-- Data for Name: run_tags; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.run_tags (id, run_id, key, value) FROM stdin;
1	2464fea5-b2f4-437b-8461-5cd6d6572ff4	.dagster/repository	__repository__@backfill_multiple_iterations.py
2	2464fea5-b2f4-437b-8461-5cd6d6572ff4	.dagster/grpc_info	{"host": "localhost", "socket": "/var/folders/ns/r7rp0cg558zdj1yjm3p66qn80000gn/T/tmpf7rfg43p"}
\.


--
-- Data for Name: runs; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.runs (id, run_id, snapshot_id, pipeline_name, mode, status, run_body, partition, partition_set, create_timestamp, update_timestamp, start_time, end_time) FROM stdin;
1	2464fea5-b2f4-437b-8461-5cd6d6572ff4	dd6c6dd475cd4d91c23a9dbaf55eb56b2b1d0d25	__ASSET_JOB	\N	SUCCESS	{"__class__": "PipelineRun", "asset_check_selection": {"__frozenset__": []}, "asset_selection": {"__frozenset__": [{"__class__": "AssetKey", "path": ["not_partitioned"]}]}, "execution_plan_snapshot_id": "93b84fd7cd172f878122450c2dae6901be99048f", "external_pipeline_origin": {"__class__": "ExternalPipelineOrigin", "external_repository_origin": {"__class__": "ExternalRepositoryOrigin", "repository_location_origin": {"__class__": "ManagedGrpcPythonEnvRepositoryLocationOrigin", "loadable_target_origin": {"__class__": "LoadableTargetOrigin", "attribute": null, "executable_path": null, "module_name": null, "package_name": null, "python_file": "../jamie_examples/backfill_multiple_iterations.py", "working_directory": "/Users/jamie/dev/dagster"}, "location_name": "backfill_multiple_iterations.py"}, "repository_name": "__repository__"}, "pipeline_name": "__ASSET_JOB"}, "has_repository_load_data": false, "mode": null, "parent_run_id": null, "pipeline_code_origin": {"__class__": "PipelinePythonOrigin", "pipeline_name": "__ASSET_JOB", "repository_origin": {"__class__": "RepositoryPythonOrigin", "code_pointer": {"__class__": "FileCodePointer", "fn_name": "defs", "python_file": "../jamie_examples/backfill_multiple_iterations.py", "working_directory": "/Users/jamie/dev/dagster"}, "container_context": {}, "container_image": null, "entry_point": ["dagster"], "executable_path": "/Users/jamie/.pyenv/versions/3.11.1/envs/dagster-3.11/bin/python3"}}, "pipeline_name": "__ASSET_JOB", "pipeline_snapshot_id": "dd6c6dd475cd4d91c23a9dbaf55eb56b2b1d0d25", "root_run_id": null, "run_config": {}, "run_id": "2464fea5-b2f4-437b-8461-5cd6d6572ff4", "run_op_concurrency": null, "solid_selection": null, "solids_to_execute": null, "status": {"__enum__": "PipelineRunStatus.SUCCESS"}, "step_keys_to_execute": ["not_partitioned"], "tags": {".dagster/grpc_info": "{\\"host\\": \\"localhost\\", \\"socket\\": \\"/var/folders/ns/r7rp0cg558zdj1yjm3p66qn80000gn/T/tmpf7rfg43p\\"}"}}	\N	\N	2024-10-21 12:38:37.374203	2024-10-21 12:38:41.509902	1729528719.559257	1729528721.509902
\.


--
-- Data for Name: secondary_indexes; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.secondary_indexes (id, name, create_timestamp, migration_completed) FROM stdin;
1	run_partitions	2024-10-21 12:37:40.354141	2024-10-21 12:37:40.342366
2	run_repo_label_tags	2024-10-21 12:37:40.402754	2024-10-21 12:37:40.385744
3	bulk_action_types	2024-10-21 12:37:40.455787	2024-10-21 12:37:40.439019
4	run_start_end_overwritten	2024-10-21 12:37:40.526003	2024-10-21 12:37:40.513725
5	asset_key_table	2024-10-21 12:37:40.648814	2024-10-21 12:37:40.638386
6	asset_key_index_columns	2024-10-21 12:37:40.683779	2024-10-21 12:37:40.671983
7	schedule_jobs_selector_id	2024-10-21 12:37:40.812837	2024-10-21 12:37:40.8024
8	schedule_ticks_selector_id	2024-10-21 12:37:40.904544	2024-10-21 12:37:40.890472
\.


--
-- Data for Name: snapshots; Type: TABLE DATA; Schema: public; Owner: jamie
--

COPY public.snapshots (id, snapshot_id, snapshot_body, snapshot_type) FROM stdin;
1	653890b7bc24ce4415c9f2704bf15f80c2bb8f65	\\x789ced5d5b73dbb815fe2b1cf5a1edccc6e19dc4be3989d375ebda99d8db4e679d6170b5d8a5482e49395177fcdf7b005212259332244bb2ecf5ce6c1252e0c1c177ae3800c8df075144135c965134f8d1187c8a739ec429bf4c715e0eb36af08331a0592ae29ba8a4433ec25139fde547e3f7c567dfab7697aa59fb799c24d19486bc1d9149f42b9f2802c7e9a48fd0d524576c48128c97b488f32ace5268908e93046ef2743c8a6e7132e6e5fca68879c25ad737f12d4fa3148fb8a42cbb839b75efb3ab38650d138ae4120fff809f8f8ecfff33b883b625c5092ea2e691a68f0a5a45392ef0488e6bdab96c7e5c1478727439c4393f32a9c5698884136217f92c4082993e13260f7c4a7c8b21ea9100876c7d3c0667715919993036ea6e23249b7b532037ec570bf9cf9f8fd7c2fe97c19a8c7c6949aa2ae2f4e6f112a8c96c0fd919bd5d215677a090789765c906086c36dabab7f97867971ae3bc7c7f7c76fcb963a05d4f5daa16eab977171767eaa97ebbfd9864b8d7c36d1f84babb390af3eb1dc2f0f1ece2f8ea011c4ed33da2203b9b6330bdda2102a7e70f8dff3c4b3926093fda08888de3d4a20f5860421392f38bf393e3776727ebb901d981f20135483fa7308e2369926f2e79c269951547847bccb342e2201efad875a8276cce29169e13524bf834082c8b78e8c9d0da02eb6ba95df4f3f9e9c5f97a384fbddcfaacdd938e7215f33132d3c44ec09dd00c981350247c44a96f231450177bc2c556e0738f3a07219e4d79dfb97c66fe777ddeee09086c6a3e448c0284080a2c66d998f2c0c4360b43d3a16108fffb8e6b05cc0c6cef20c4b319e73b174ee305d7e7ec9e68eaac673e466eba81ed50c41092b2c6c4b66cd3771d8fd8b6ed0654809986b67f18be6d63e6772ea079b6ba3e73bd325229bded322642866de2baa14b31a2c834b96d236e0576e843c20fbe928787613e9b71be4fe9acc7592d9aa9442d2288e50798636406a189b11f200fc1bf4c1a588485d4f7383389bd2351fcd249f4a3fc794e55e07152457991ddc68c4b58aa62cc5bbf28ea112ea3ff96591a95552129fd7ed7cb525c4605ff6d1c178a98c04929a94dd3571697324b53135b05fc542714cc0c3b083b9c7bdc272e3199637b1e115c20cf37ad10995830882d2692c23cbcb1f1742b43fbf280f5acad5cbad6727276f2feeaa26b8af0600967c694ed059669216161cf8671790eb32cd3b12dd7c3d4e19ee39a7e20e0f2a0347e2ac8556ad1f4a4a1168d8ecdb5e2f69e46d4de455bd2daa0ee53d2be1001e188078140810bded021823aa68779e8e010b9a0833641c23c28496bd9fff5a0e020215e5e4bdeafa776adaeeeee3abcc3e0e43ba7e38a1b38498cb2e27969c4a9818d12a49c7003faa7bc2c8f060f7a90388d9ac6dd4ec47585ed62ea79a68718b6206de3a18b61e603be20e026678e63db9e4577eb1faf0723fc5d16abe9b828785a5dcfc4b339721cd3a1824e2197c29f2c06a6c6385903be11f01caf04901098237206e6842c4bb8e0763d24ed88387ee85b81872d4c2ce6afe185b5cd609fb6193a56283c2c403398e9a3107b34109c098208a38127438de933123e3fdbecd2a19afcb8e04635e4465b090caed42b2b8c2a03edc245659463d2fcc84b632c2dd4f82ab2e2d79217b7bcf8aaa165f3d63d464a608a0be013db64c2b16cdfe7f05fc0436a99be292c026ac74ccfdd7b12f378a0ca1c7f4b7530520df79508696bfb3e4df0898b18079808491abd16e390c0016b716d27b498340fea09c7b74287518428417ee0737b638bd9e9b8f298fe9af0973832456c7960b2b2a46d9a5b2f886dc3349fb83aff6a9aafa6b91bd3542b26dab6b9f5959e6dd8e6132fcdbcdae6ab6deec636ebd5326de3dcfa32df368cf389977e5e8df3d53877639ceb1664b7be8cb80deb14b6e03e138cfa26b6901be050843ca0e03e026c5a367103d3f708fd0395de5fadf3b98dacd33ae50e646dd3d4b6827d9866bdc536b41ccff57d8720e6925010c12c4a42ee7861e03bc8b291077f3ae2a0ec52a7c6783d383dff78713de8a8345e0db991643737bcf8736954c38297c32c611a854378284af82d4ffa5cf40e6ba6d703866fca8a17bd43925cca0dcc936c5c34e3d31893fa7bc388b39e06e9eaf4d5e7d3f757d1e54fc79fd6dafbb8a4d73bdbaaff5ce38d14da76d576a7ec26f128ae3acb7b07c1edb21975676e8fde4ba469825b3eb0b12513143c743c87f9c4736d4ca9c00c114e09239813640bdf459c10840fca0435d798679140ae1e4f438d5c629652aaefcddc75d76297f4d74d1f06cd920c940afe4ecb2ce1faaebb3e91d59d69697b654d0dd395e55e35cc0a84408e13123b2438c0b6474d1305264c6f4ce6301b01439613facf50c336dde585d3ac1af2221a420e904c806cc9ef39d11abbc075b81b20b963c7a3c4763d982232e63b0eb7ad80084a5c00cfc2c161ee664bb2f4262ac669dab7cefdbc870752947a5fc5f2a1be4d7bcf7b88a0a611c3f14b565239c46d1aa296a7d6f689fbf5d4c08fc058585c30cff49cc01581b03d21d313ce3c44984720dfb10eca53ef366324b8040b88effb2f95285e82de502e87ad2b775d84f72af727deee7f08725f9ad7e03c4f26677272f389cba9c16f63feafcd974b777332612ba2d7de0efa22443ff8e5c3c9a7cf27ef8faf4e3e7cd1d80c8a8b5f214dab3260312b7b0b30bbdd28bbb801b66396f2ef2197d9a4d1ec9b3570c18de621232b0cc8528e8c7793e944e687ae761ad398e6a97b18ac7d9440cf5ab4f572efd68203cbf103cf0c386316ccd57c70e10eb26d9bba8e6513c7471639286bd969f6b46a76ab1decf455420bfcfdaa84ee62c921a9c46e979670357c54ad5a1bd27d0b5a6f4ff68b10f4e0e47b9ec434ae928951e69cc66252eff8ced83881e05165465ef024c34c9eb690bfccf7b41f191732207d8b65d7f25f5cc59aea5b66502cb78243d3595dad1eb0118b1969d9168256d36d0cd1c93815aa8b0f75b1cef86f468c6fb83464f710e444918d0cdc3caf7a344ab9ca52df30bec54962103ee5b7a1073dd44dbf3625c0afd3f671d96afa70606cda460dfbf7561edb2f96d1d67f3d4ddbabfe6bcf805f84fe3f22f869ad35af07e95e051d7a21735d1c1048d73c393931e11ab916a2340888e959b61014b1c3da3fa9994cd7126b8e96b54faf4c6f6d762aad332f9f1f951966df9a337d2ae7aecfab31704cd5501df22bc6a986a3a99f8bfbf6a3503bb06d1f52638e435780e402db31434e0321b04f1d147836253cd87f156e09887ae1a434384cae8d11408f6fc0e9af894543a41b091e228f218f739f995c80bf0c61be1df80294dac6243043244cea22b2eb995b5799bfd618a950ade2f8fce6524979fec3522176f187fb1dac1603f45ac510209513e09594860cc9192828fca5c8e89c9584f63d89bf6e7573c70288b3688453d0afa231db96f96bd9ec10cb25bf8297aace579b6f3cca133e02efb0be05cf0875c386b86912c7112c14dc425e881d9b3930d3713cd7a436dc0a439813fbba53686d3fbed7e8a23dc8e71d5d3ab5ebdd384eaa37a03022864c71022161649c5e188d8e42368a21ebadb2426a5aca9a42cd2d5c3549727d84526ddd837fe81c069f1940cf4e3fdd29b59ec669cb76af1aa77d60fbb9699ceca96f97d9784440a332313dfa2ea76c52bd4678229d95314f7292c96279103c5a29e7401004e42c8fd4277d4117c7455a2ba224fbb59d3c4965a4f9183227082c7ff9abcee9dec5446b593b17dec4f75a5f5dafbebaef9d570d8f75c46c9ff89600d082e34a4eb9db083587c06b2d93cfca06971c826e55e5e58f6fdfb28c9647f9a41a66e95156dcbc75de263129703179bbac76c36a94fc0914a9e2dfabf20d78cd37eae8f91b486b8619d3c96254fba86edf8bbef6f9f0fda37fac2c154c52edc56bcc5c422fd7b062d051751c5f4e3e64b662a8ec928ec18d1a15be29552d0437765d5b7d5d1651d4e49d16992c4d26357dc0e74dfd4c8ee3a229a8e850c1b4c8ca52bde5a4096a9998919c157ada8464c7d8603168981ac0d7beb5b9dae2bfb63b56a51fd55e52a9161ce3583d39e542e6bf7336ceb38ad797f04cc9a7d04a5473e909c6e90faa4475936404271a4a0650cfdd1d9d4435c19e5ad17abb05f542b37610dc6b68d69eb33eb7d0dc555de80a2e8f596359fbf5317a9aa22d93bd6a8af62b3f76a4295ad06933b957e8b4cb218764643b2fdcca4dbc3d9b727577d1ead99336fcfb528a4d5fbd3f7850d4cdf5e2dbc65befd45f580bd41dee86ef1c97309dffed81d78edfdbc5f564ef335d66642d74b6f4f258ed77047eb9bb937d350b6791222f8705693de52b3e5cd2acdf49eecfa7cd973f60b24054ef33262db22b85c4e2324ff064f92325e02a882cccc4e93cb8b79672fa24d1ea75e1cb256ae1b0987ec5e531670b4730732a629cc4ff5ba6d70c6869201d625ef1a1894d519bbe537d056c2b3f2eb18c5bcbc0bba1dbca7be6b5b19cf2de0766cf172b364573f606f41570aefe4ac563f07cc48be1b5019d71df8768e7271f36c5b37969f90a34577ddce131586efc16776d244fd39538c2a475d819d937c5724a70359ead565a989e5f5cfd348dcc5da036cc68a3d2eabf0f99be94675360e6b173052e0fa4398f51b5c7bc925e1bd739ff9db0d61900cf652e3ea6d5b85819f879ce53262b1f97d3d6edb80fb978cca238bdcd2896c8d7943ae60e97b2e1e9acdd5468719a8fab4831d3f3e0a96cd1e262e1c155274140c06c020d621ad12c9178b7a613e31c06cf01966c5c49427dbd5fa89f7fc2294b668ad63cd25a1a8469ce1c8c5e9eeebea869478baf11cef385594e4d01664e332a7d07ce16fbea3d9606aa3a50058c7bc54d7d81accff4d2e9b1455e978f963d0d8b1d27c016d9ec3a22b60d565fd5bb2d868e536af7bb593ec6f6341ad3258407205960f6cb5d5f90ba29703e5ce82b8a8e2f2f4faea2bf5fbc9344e4e726f1cd829b9ec6da8c71f5649f84ff090d3e70b13248d65b72569239534d5a84eaca66a426caeaa9fba1e3f54078f781f08d995bae81297b9b7d5ba37e5eb69b6e565929d1cf4da32793e9d39e5bb82f841d6cf1e8d8cca1645664105c1ab437dbf8b320fa256f31735d71aa8257b922bd530ef3c3bc693bb7a3d928cfcab802bf3373860bfeb3e3760ff9ad6bd893ed0eee25d884987e2c9a483f77c5ed72d962d5aab3871581b7f56b5f26d844f5550cd6c9c023389cc7d316a62b0f9c34c9456d144dab68e6be6653168da0ff4755b2b6ec9732eb5791bf7c9177cc525ec5fe32c5fe24e1a463faf5aa5f2f53bf96c5fe72330835139f5ffe1f6255d519	PIPELINE
2	dd6c6dd475cd4d91c23a9dbaf55eb56b2b1d0d25	\\x789ced5d5b73db3616fe2b1cedc3eece340e6fe0a56f4ee26cbdf5da99d8dd9d9d3ac3e07260b1a14895a49ca89dfcf73d00a98b655186644956b2eeb44d480107c077ae000e883f7b49c2335a5549d2fbd1eabd4b8790a5395ce67458f58bbaf783d5e3452ed39ba4e27d18d0a49afcf2a3f5e7ddbaaf75b94b5d6cbe3ecdb2644243bd4ed838f904634de0381f7711ba1a0f7537140901152fd3619d163916c84759862f211f0d925b9a8da09abd94296462eef926bd853cc9e9001465d51cbe6c5a9f3ea5b9683ba1492ef4e167fcf9e8f8fcbfbdaf58b6e234a365d25669dba8b15432a4251da8714d1a57c58fcb928e8f2efb74084736778047b1f422eac781086329ec40481bc280b3c01131272ca491581f8fde595ad55621ad8d9adb08c9f6dd04c80ddb3542fefdfbe3b5b0ffb5b766473ecc71aa2ed3fce6f11c68c86c0fd929bd5d21d634a091785514d906086c36daa6b5d978a78f06e3bc7c7d7c76fc7ec94097d5bad42574bd57171767ba56b7debecd0ada69e1b60f42d3dc0c85d9f30e61787b76717cf5000ea7f91e51508dcd30983ced1081d3f387c67f5ee4405906471b01b1b19fba6b03ee74c21092f38bf393e3576727eb9901d580b6010d48bfe4388e23a5922f2e21035e17e51103228813312f8628a0bec78974013895c48bb823031e868ec348fc64686da1eb6b895df2cbf9e9c5f97a384facdcfa5dbbc71d6d2a666314b64dbd10bcc80e8517f2580631e7811bc721f729913e75c20008f70e823d9bf67de7fc99dadff5fb768f41a853b321d2388c6316878e705cca21b4a92ba2c8f67814e17f81e73ba1b043971c047b36ebf9ce99d35ac1f57b768f354dd4331b23d87ee87a3c1671ac784d99ebb876e07b84b9aeeb875ca29a466e7018b66de3ceef9c41b36875fdce75f24887f4ae2f848c047599ef473ea7318f6d1b5c37062774a300037eb495101d86fa6cd6f37d7267bd9e35ac9970d4619239414881c67618d99406614c62fc9bcd43878988070484cddc1db1e2d7a544dfaa9f6754251d6575322c8bdb548082a52e4730f78ba69ed02af9ad2af2a4aa4b45e9cfaf9d5d4aaba484df4769a989499a558ada247c1569a5a2343db1d5c04f6442c32ca817530f8040c07c660bcf2584499031096c278a6d2a05fa163b56cc3cbcb141be95a17d78407bd6162e536d39393b797d75b16c8af0e012ceb4532e091ddb89a543898be3229e701cdb731d9f50ee01f17c3b08253e1e94c44f18b94a2cda960cc4a295b19954dcde9388c6ba1873da18d47d723a903264104318ca38f4d11a7a4c72cf2614228f46b18f32e8b258da07c56923fdbfee95801c82ea5af5fd7aa2d7fae9ebd725d6a177f205f8a8068b669955d530acac34b7a855219733b0b07d0e5575d47bd082a479d2165e6e447c5fba3ee584d82416d4c1b00d229fe2cc076d41083608cf735de2f0dddac7ebde807e518bd57c549690d7d753f66c8e1c50ded7d069e472fcbf48b153239aad01df00fb9cae0490319c238240758a1d47fa687649acf4887941143821a10e658e08d6b0c2c66ab04fdd8c3c2792844a940c61077144090f2508c96226784894abb103c1a26f4f3797c950437e548255f7c19a17020bb47815a55517285db4acad6ac4da1fa1b2464a43ad8fb2283f5550de42f9d140ca66a53b9494e11417c167ae2da4e7b84100f84f081177ecc0960e43b11336f1f71ec43c1ea86a483fe72618e982fb0a848ca57d9f2af8c48b18071808291a9d1ae3b1d0436df15d2f7284520f4ea417389127781c7316076100eec61ab3d3710d53fe2983ef71649ad8e2c0d4ca92b16a6e7d416c1baaf9c4abf3cfaaf9ac9abb514dbd6362ac9b5bdfe9d9866e3ef1d6ccb36e3eebe66e74b3d92d3356cead6ff36d43399f78ebe759399f957337cab9ee82ecd6b711b7a19dd29510082978605327f6431ac908428ee623a4b6e3323fb403c2f8ffd1d2fbb3767e6b235baa9d2a03d958358db5601faad9a4d8468e47fc20f0582c7c16492685c359041e89c2c08b1d3726f87f4f1e945e9aac315ef74ecfdf5e5cf796ac345ef5c1ca8a9b1b28ff5a5975bf84aa5f64c260e1102b2519dc42d665a277b8667add13f4a6aaa1ec1c92eaa54a601e17a3b21d9fc198f49f1b7a9cf524c854a6afde9fbebe4a2e7f3a7eb756eee3825cef2c55ff5bf5378a69db15db9d76374b0769bd7479ef207abba846cb23b747e71219aae0960f6c6c490525441ef144c088ef52ce25153103ce04a3c06257067e0c8cc5f4a054d0708f79ea09d4eef1c4d5a82d66c5a5e6ddd45c2fdbec52f6ba6dc3e24556a050e19f795564606eba9b1359cb232d63ab6c2861a6bcdcab8439117325a5d20129884dbcd097a1748954420f82c44c10865ae41c9484edd60e315a4122d2fbbbbfdafc5c6268c0410ddb90efc608ef97efcc0ba9ef09d7911e38c2878847a18db35a4a414624908e0b01890e8bef8696a551ea3645657e177cf26ab3ec96a5f92db32df77ef1b9cd0da2f8d4ecb7a349fa9cd67d9d2c548e720383d4d44bbbe6b5dc0d5d37001b8046be640442d7b323e0a19434e05e1c12973308c3a7cc3d50403406b8b20023106b80d0d31ba8d6c5a225b21c0988622262023819b4414a874518058481f47dea5216dae8cb6deec76cd7a95279512b3dab5305c45458560284a3af539c6868f5845ae1248bd22a5074f00fec26d426d95058be4348c0770895e007b613b38080eb79be4bd0ce08496204cd263873f6835d439316c980e6c8f9b255a839c534d2a63e554e1d2797dae6368a950e86190c506fd7d7ad29a1e5b0c560dbccf3a4882438315a42cf155e080283009bbbf82a8a5c9f06aea9dd37b5b07bb5fb4f7c78e010fcfdc22c890e87d9f84c4d95de819a68fc3e827f6fbef9ba9b730e5b61bd7172e977c1fadeaf6f4edebd3f797d7c75f2e683416a292d3f4199d40576b1a83a9773766b30ef061c4bece37ffa50f7a1b4da38a589349a4aca75a02f3ab25e8d27d3a21f969533b293bad63d0cd63e9860a62dc672b9776da1a1e30521b1d109080c3020c0d0dd8b5dd7e5bee7b8cc0b62871d94b6ecf4f8cbaab9b2f124c75c248cc0dfaf48986ebd1c9248ec76a38ad6fd47ad7c1b43ba6f469b65787f178cee9d7c1966294feb6c6c5543e0a91c37f9e3851865e83ceac21a96901554a8b31bea975986fc9175a11cd2e75435adfe06dad7d49f0b8b539558ae26369355ba66c0562aa7a45559745a6db3297a27eb54ea26de344b7fd66f05b33ed3ca52cda393936531c078bfa9af5bb42ab567d3bcc0094196590c26fd6de9610b4dd18fed82e2c749f9b49a2bfab0636ccb266df7efed63ce7fa6c658fecd246daff21ffa1ef861ac8ea211ce5c9fd80146b481e781eb840c8dba1f53c7a1e1f721ff8f707e463bd7eb41ba57461b4f790f89d1ebaf022e8da55f8dd2ac7e81164da6a8cb63b40b03ebf4c26a572cd05e50b44b18ee2a33958b3694bec5a7d68c35476674aa06fec5e4f0df7439a423b3c334e831933863deee55e28c0fe87d6b12a75aeaca2a180d184a542127471d955355e235a063b57465cd16a3b3f1dd095cdd471785ff56502b3fcc9a935d288ba3326f045191fd38bfc8ad84910f47092f4679fdb7bf9b9ce6babb20be289d77bebcf43c035e6f06bcef9df6b68fcdfae9fc093f05002f81d62a289a47a83df4d74899aaab0a5c0258fdba1e563fbe7c290a5e1d0dc775bfc88f8af2e6a5f7324b5949cbf1cb45b1ebd783ec2f2848357ca9ab1768355fe8a3862f06c8b34298ac69ebf24953be137de3f380fb47ff586b2aaaa4cebd68d55c41af561931be6d8e5faa4d22b5766de98d033e42336ad5189aea6895b67add687d13b86a6aeacd1c9922cfc60d7dc4e745536748d3b20d794da8505e1655a54fb5b74ead905392d3507c9e906a985a224509d303f8d8b57ada68fcc7f9867570aecb2b2af51dc338d23527bd5093865937ce8b1a9a47ac53c1045a85ea50598251fe839e44dc6405a399819021d43373c7c74943b0239a5f2f3bc4cc351b3bc1bdba66e3bdc56fcd352fdb055ee65c1eb30ab6f6e702cc24c59827fb95141c87448b1b092fa601950e096d8a8ae005ea29662c600c43d6c34a1e78b2f9e1de9dd0950a1a8ba132d9ca2e0e710a8361dd64f1a68df25481c6df63adc64ca7f970a472a954ef26a658fbae2c2b3ea3bb60f86b7a93ab4c2ba36f9d20b5aecd7b4e057142c709241344068c7a1c703a82bae3e17cd8f12971231f4ca73ac6f2b85f2d31dd86ff2eb46463a9db96bc516c15670649bf1895d938d169141df911a6e2f2eda8eeb640cc8afc26c1882aef5aa4305ec73ac82fb82d24eb3cd110bf5df1405a89a0e9b37a3d02bf87ed93b9009a7947533fb457ef68fc99a01d794723e88c3bb957e88c531fbf8bc0c234fc5689ff1d89fca699f766fa640cff7e85c234a4fe7e85622139e14163bbf6915243f930e5c4bee463d3eb5c7a0f72bd7dbe7b83c5dc3d2d7732424c87bbe13d160aa6f37f3c7095c5bd331c4ff68decc58eac85ce963e486efcddd90f5fbfaab6daf489449357c3aa8694c38acbb0da2c0ed5fbf349f1c54bb1ee1035bb1a6b8eec4a2689b41a6674bc78f1155a0da6367fd37c6634e6166cba3831d76a73c3507b1b964e1f292737833de6bcfa8022fd9466e91f8bf4da012d0c64099b575c5eb4296a937b3a56c0b6f2c2a245dce6147c39745bb9bbc418cb49dfbbc0ecb805695334a7b76aac8073f5cd478fc1f311978d18033aed7d17a24baf11da14cff6228c1568aeba30e831586e7c33883192a7f94a1ccf0b75fc658967df14cb09c1d578ce9532c2f4fce2eaa789675e066adb196354e6daef42a62be4d9149899ef5c81cb0361ce6344ed31d79c18e33aebff52589b0800862a2c1ff17a54ae74fc30845ca8ddd5cb49e979bf8f73b55424697e5b70aa906f282d99465caa82a7d37213a6e9bd8544776652f143c31c31c6e1a43c19d0e1f0ce14a36912271ac98ac5c0a6d0aad54264624f6f1f7ef8da253c37251df6efb49424c797972757c93f2f5e2922ea6a517ab30abec50b48cf9a1a3a6452539904d9c83f25d355aa96822c8b3f2057bf27535568ca2f969c965968f85895feb9f9cc854eee5691e3220e1f9ac1e32bc8ebe9289254c1dd0bd017c7360b19777d0ebeef10742b6e68fb4c3a44463677198b64406670cff7ad8550ff50a9d338ed39dab9107e5008d0e876c9ccbfb0c01b902b15bc395aba92cc992e3247a859044c7490af6b754d1e9e3f90b0f881848d3bb7b8bea367e0d3bb669afaaadce468e74a8ebe6f0b3d194f9ff6e4cd7d26ec20057649b2abe65959a08568d1deec98ec1dd62f58d4a9714f736da4aa15b655bb9437b3a2f37e8917836151a535dae6a9bbb8e36196bcee20bf75097bc2fc850e82ad135e806885f72c46f5bd2a0b585ce822f3e67b7e79e0ee2cbd6b986d0c3037ca95eb8428deca8a3462da964aa606651a00ddf7feb3c7ff01b562d599	PIPELINE
3	93b84fd7cd172f878122450c2dae6901be99048f	\\x789cb554c16e1a3110fd9568cf555568a04a6e5114a912aa82447b426864d643b0f0daae3d9b7683f8f7ceec7a9740a1b75ee7bd791ebf79f6be0028ad4a09a0b8bf299e7e635993f16e6e955b3815d2d653f1e1a65091cc46959420604c26116ae653ac91416cbb7c04a72a1499aab664800bc64188be44d6ef49a2669c21a32cec9cffe520912269db9fce3213701868d192b857377c8a29a1522118f792a4f1c0f5a0223a1ac45c6dad5423be1a5f278848b101458455a0a129a2d20df89a42dd1579844df46fe812523bc672253cbe6fc834781503bc4b03184c406b1c42ca868111730aada7e554ebdb2f9352dfeabb5139feaceef45a6d26135c4fa6ebf17aa43fe9f1446e35b46675ee1ff5e7eeb049403e3b28975b168ea9419622def02e5699dc4eb5bfb2d4051364a9dd0af29597d2ca4708f35c5510e37436065d5d758a223463e0e3e3f3b7f98fef4f85d8502129ad4881618f07e5a3b7ff1cebb9a5f5c369f5c29789404d40c8b33db846a03e62111387ac6857ec39936430fd9da1a3f4fcc8923827d96fb9c57297f5735e3aa02b9d693d0834c3768aa0687b790fe28449d0ea1c5f485f39e1dedf6c944d19ceb13e2d46fc599bf8fea971466aab39fc6c0fbf20f3867d471b536f8d86ad72da5e78500b41bf76e03b272f2cbd7b4bd995c36175269df37da1b1cdebd5f3193c1e7f3d72ffe9165c2195ff8bc3eaf00730bcb8a8	EXECUTION_PLAN
\.


--
-- Name: asset_check_executions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.asset_check_executions_id_seq', 1, false);


--
-- Name: asset_daemon_asset_evaluations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.asset_daemon_asset_evaluations_id_seq', 1, false);


--
-- Name: asset_event_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.asset_event_tags_id_seq', 1, true);


--
-- Name: asset_keys_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.asset_keys_id_seq', 2, true);


--
-- Name: bulk_actions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.bulk_actions_id_seq', 1, false);


--
-- Name: concurrency_limits_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.concurrency_limits_id_seq', 1, false);


--
-- Name: concurrency_slots_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.concurrency_slots_id_seq', 1, false);


--
-- Name: daemon_heartbeats_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.daemon_heartbeats_id_seq', 10, true);


--
-- Name: dynamic_partitions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.dynamic_partitions_id_seq', 1, false);


--
-- Name: event_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.event_logs_id_seq', 19, true);


--
-- Name: instance_info_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.instance_info_id_seq', 1, true);


--
-- Name: instigators_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.instigators_id_seq', 1, false);


--
-- Name: job_ticks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.job_ticks_id_seq', 1, false);


--
-- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.jobs_id_seq', 1, false);


--
-- Name: kvs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.kvs_id_seq', 1, false);


--
-- Name: pending_steps_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.pending_steps_id_seq', 1, false);


--
-- Name: run_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.run_tags_id_seq', 2, true);


--
-- Name: runs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.runs_id_seq', 1, true);


--
-- Name: secondary_indexes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.secondary_indexes_id_seq', 8, true);


--
-- Name: snapshots_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jamie
--

SELECT pg_catalog.setval('public.snapshots_id_seq', 3, true);


--
-- Name: alembic_version alembic_version_pkc; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.alembic_version
    ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num);


--
-- Name: asset_check_executions asset_check_executions_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_check_executions
    ADD CONSTRAINT asset_check_executions_pkey PRIMARY KEY (id);


--
-- Name: asset_daemon_asset_evaluations asset_daemon_asset_evaluations_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_daemon_asset_evaluations
    ADD CONSTRAINT asset_daemon_asset_evaluations_pkey PRIMARY KEY (id);


--
-- Name: asset_event_tags asset_event_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_event_tags
    ADD CONSTRAINT asset_event_tags_pkey PRIMARY KEY (id);


--
-- Name: asset_keys asset_keys_asset_key_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_keys
    ADD CONSTRAINT asset_keys_asset_key_key UNIQUE (asset_key);


--
-- Name: asset_keys asset_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.asset_keys
    ADD CONSTRAINT asset_keys_pkey PRIMARY KEY (id);


--
-- Name: bulk_actions bulk_actions_key_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.bulk_actions
    ADD CONSTRAINT bulk_actions_key_key UNIQUE (key);


--
-- Name: bulk_actions bulk_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.bulk_actions
    ADD CONSTRAINT bulk_actions_pkey PRIMARY KEY (id);


--
-- Name: concurrency_limits concurrency_limits_concurrency_key_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.concurrency_limits
    ADD CONSTRAINT concurrency_limits_concurrency_key_key UNIQUE (concurrency_key);


--
-- Name: concurrency_limits concurrency_limits_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.concurrency_limits
    ADD CONSTRAINT concurrency_limits_pkey PRIMARY KEY (id);


--
-- Name: concurrency_slots concurrency_slots_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.concurrency_slots
    ADD CONSTRAINT concurrency_slots_pkey PRIMARY KEY (id);


--
-- Name: daemon_heartbeats daemon_heartbeats_daemon_type_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.daemon_heartbeats
    ADD CONSTRAINT daemon_heartbeats_daemon_type_key UNIQUE (daemon_type);


--
-- Name: daemon_heartbeats daemon_heartbeats_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.daemon_heartbeats
    ADD CONSTRAINT daemon_heartbeats_pkey PRIMARY KEY (id);


--
-- Name: dynamic_partitions dynamic_partitions_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.dynamic_partitions
    ADD CONSTRAINT dynamic_partitions_pkey PRIMARY KEY (id);


--
-- Name: event_logs event_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.event_logs
    ADD CONSTRAINT event_logs_pkey PRIMARY KEY (id);


--
-- Name: instance_info instance_info_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.instance_info
    ADD CONSTRAINT instance_info_pkey PRIMARY KEY (id);


--
-- Name: instigators instigators_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.instigators
    ADD CONSTRAINT instigators_pkey PRIMARY KEY (id);


--
-- Name: instigators instigators_selector_id_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.instigators
    ADD CONSTRAINT instigators_selector_id_key UNIQUE (selector_id);


--
-- Name: job_ticks job_ticks_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.job_ticks
    ADD CONSTRAINT job_ticks_pkey PRIMARY KEY (id);


--
-- Name: jobs jobs_job_origin_id_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_job_origin_id_key UNIQUE (job_origin_id);


--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- Name: kvs kvs_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.kvs
    ADD CONSTRAINT kvs_pkey PRIMARY KEY (id);


--
-- Name: pending_steps pending_steps_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.pending_steps
    ADD CONSTRAINT pending_steps_pkey PRIMARY KEY (id);


--
-- Name: run_tags run_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.run_tags
    ADD CONSTRAINT run_tags_pkey PRIMARY KEY (id);


--
-- Name: runs runs_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.runs
    ADD CONSTRAINT runs_pkey PRIMARY KEY (id);


--
-- Name: runs runs_run_id_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.runs
    ADD CONSTRAINT runs_run_id_key UNIQUE (run_id);


--
-- Name: secondary_indexes secondary_indexes_name_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.secondary_indexes
    ADD CONSTRAINT secondary_indexes_name_key UNIQUE (name);


--
-- Name: secondary_indexes secondary_indexes_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.secondary_indexes
    ADD CONSTRAINT secondary_indexes_pkey PRIMARY KEY (id);


--
-- Name: snapshots snapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.snapshots
    ADD CONSTRAINT snapshots_pkey PRIMARY KEY (id);


--
-- Name: snapshots snapshots_snapshot_id_key; Type: CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.snapshots
    ADD CONSTRAINT snapshots_snapshot_id_key UNIQUE (snapshot_id);


--
-- Name: idx_asset_check_executions; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_asset_check_executions ON public.asset_check_executions USING btree (asset_key, check_name, materialization_event_storage_id, partition);


--
-- Name: idx_asset_check_executions_unique; Type: INDEX; Schema: public; Owner: jamie
--

CREATE UNIQUE INDEX idx_asset_check_executions_unique ON public.asset_check_executions USING btree (asset_key, check_name, run_id, partition);


--
-- Name: idx_asset_daemon_asset_evaluations_asset_key_evaluation_id; Type: INDEX; Schema: public; Owner: jamie
--

CREATE UNIQUE INDEX idx_asset_daemon_asset_evaluations_asset_key_evaluation_id ON public.asset_daemon_asset_evaluations USING btree (asset_key, evaluation_id);


--
-- Name: idx_asset_event_tags; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_asset_event_tags ON public.asset_event_tags USING btree (asset_key, key, value);


--
-- Name: idx_asset_event_tags_event_id; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_asset_event_tags_event_id ON public.asset_event_tags USING btree (event_id);


--
-- Name: idx_bulk_actions; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_bulk_actions ON public.bulk_actions USING btree (key);


--
-- Name: idx_bulk_actions_action_type; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_bulk_actions_action_type ON public.bulk_actions USING btree (action_type);


--
-- Name: idx_bulk_actions_selector_id; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_bulk_actions_selector_id ON public.bulk_actions USING btree (selector_id);


--
-- Name: idx_bulk_actions_status; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_bulk_actions_status ON public.bulk_actions USING btree (status);


--
-- Name: idx_dynamic_partitions; Type: INDEX; Schema: public; Owner: jamie
--

CREATE UNIQUE INDEX idx_dynamic_partitions ON public.dynamic_partitions USING btree (partitions_def_name, partition);


--
-- Name: idx_event_type; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_event_type ON public.event_logs USING btree (dagster_event_type, id);


--
-- Name: idx_events_by_asset; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_events_by_asset ON public.event_logs USING btree (asset_key, dagster_event_type, id) WHERE (asset_key IS NOT NULL);


--
-- Name: idx_events_by_asset_partition; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_events_by_asset_partition ON public.event_logs USING btree (asset_key, dagster_event_type, partition, id) WHERE ((asset_key IS NOT NULL) AND (partition IS NOT NULL));


--
-- Name: idx_events_by_run_id; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_events_by_run_id ON public.event_logs USING btree (run_id, id);


--
-- Name: idx_job_tick_status; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_job_tick_status ON public.job_ticks USING btree (job_origin_id, status);


--
-- Name: idx_job_tick_timestamp; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_job_tick_timestamp ON public.job_ticks USING btree (job_origin_id, "timestamp");


--
-- Name: idx_kvs_keys_unique; Type: INDEX; Schema: public; Owner: jamie
--

CREATE UNIQUE INDEX idx_kvs_keys_unique ON public.kvs USING btree (key);


--
-- Name: idx_pending_steps; Type: INDEX; Schema: public; Owner: jamie
--

CREATE UNIQUE INDEX idx_pending_steps ON public.pending_steps USING btree (concurrency_key, run_id, step_key);


--
-- Name: idx_run_partitions; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_run_partitions ON public.runs USING btree (partition_set, partition);


--
-- Name: idx_run_range; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_run_range ON public.runs USING btree (status, update_timestamp, create_timestamp);


--
-- Name: idx_run_status; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_run_status ON public.runs USING btree (status);


--
-- Name: idx_run_tags; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_run_tags ON public.run_tags USING btree (key, value);


--
-- Name: idx_run_tags_run_idx; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_run_tags_run_idx ON public.run_tags USING btree (run_id, id);


--
-- Name: idx_runs_by_job; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_runs_by_job ON public.runs USING btree (pipeline_name, id);


--
-- Name: idx_step_key; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_step_key ON public.event_logs USING btree (step_key);


--
-- Name: idx_tick_selector_timestamp; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX idx_tick_selector_timestamp ON public.job_ticks USING btree (selector_id, "timestamp");


--
-- Name: ix_asset_daemon_asset_evaluations_evaluation_id; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX ix_asset_daemon_asset_evaluations_evaluation_id ON public.asset_daemon_asset_evaluations USING btree (evaluation_id);


--
-- Name: ix_instigators_instigator_type; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX ix_instigators_instigator_type ON public.instigators USING btree (instigator_type);


--
-- Name: ix_job_ticks_job_origin_id; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX ix_job_ticks_job_origin_id ON public.job_ticks USING btree (job_origin_id);


--
-- Name: ix_jobs_job_type; Type: INDEX; Schema: public; Owner: jamie
--

CREATE INDEX ix_jobs_job_type ON public.jobs USING btree (job_type);


--
-- Name: runs fk_runs_snapshot_id_snapshots_snapshot_id; Type: FK CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.runs
    ADD CONSTRAINT fk_runs_snapshot_id_snapshots_snapshot_id FOREIGN KEY (snapshot_id) REFERENCES public.snapshots(snapshot_id);


--
-- Name: run_tags run_tags_run_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jamie
--

ALTER TABLE ONLY public.run_tags
    ADD CONSTRAINT run_tags_run_id_fkey FOREIGN KEY (run_id) REFERENCES public.runs(run_id) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--

