374 řádky
15 KiB
SQL
374 řádky
15 KiB
SQL
|
-- Enable foreign key support for cascading
|
||
|
|
PRAGMA foreign_keys = ON;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
"rocpd_metadata{{uuid}}" (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"tag" TEXT NOT NULL,
|
||
|
|
"value" TEXT NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_string{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"string" TEXT NOT NULL UNIQUE ON CONFLICT ABORT
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_node{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"hash" BIGINT NOT NULL UNIQUE,
|
||
|
|
"machine_id" TEXT NOT NULL UNIQUE,
|
||
|
|
"system_name" TEXT,
|
||
|
|
"hostname" TEXT,
|
||
|
|
"release" TEXT,
|
||
|
|
"version" TEXT,
|
||
|
|
"hardware_name" TEXT,
|
||
|
|
"domain_name" TEXT
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_process{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"ppid" INTEGER,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"init" BIGINT,
|
||
|
|
"fini" BIGINT,
|
||
|
|
"start" BIGINT,
|
||
|
|
"end" BIGINT,
|
||
|
|
"command" TEXT,
|
||
|
|
"environment" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_thread{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"ppid" INTEGER,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"tid" INTEGER NOT NULL,
|
||
|
|
"name" TEXT,
|
||
|
|
"start" BIGINT,
|
||
|
|
"end" BIGINT,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_agent{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"type" TEXT CHECK ("type" IN ('CPU', 'GPU')),
|
||
|
|
"absolute_index" INTEGER,
|
||
|
|
"logical_index" INTEGER,
|
||
|
|
"type_index" INTEGER,
|
||
|
|
"uuid" INTEGER,
|
||
|
|
"name" TEXT,
|
||
|
|
"model_name" TEXT,
|
||
|
|
"vendor_name" TEXT,
|
||
|
|
"product_name" TEXT,
|
||
|
|
"user_name" TEXT,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_queue{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"name" TEXT,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_stream{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"name" TEXT,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- 2993533, 2269219937, 2993533
|
||
|
|
-- 2993533, 2269219937, 2993533
|
||
|
|
-- Performance monitoring counters (PMC) descriptions
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_pmc{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"agent_id" INTEGER,
|
||
|
|
"target_arch" TEXT CHECK ("target_arch" IN ('CPU', 'GPU')),
|
||
|
|
"event_code" INT,
|
||
|
|
"instance_id" INTEGER,
|
||
|
|
"name" TEXT NOT NULL,
|
||
|
|
"symbol" TEXT NOT NULL,
|
||
|
|
"description" TEXT,
|
||
|
|
"long_description" TEXT DEFAULT "",
|
||
|
|
"component" TEXT,
|
||
|
|
"units" TEXT DEFAULT "",
|
||
|
|
"value_type" TEXT CHECK ("value_type" IN ('ABS', 'ACCUM', 'RELATIVE')),
|
||
|
|
"block" TEXT,
|
||
|
|
"expression" TEXT,
|
||
|
|
"is_constant" INTEGER,
|
||
|
|
"is_derived" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (agent_id) REFERENCES `rocpd_info_agent{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_code_object{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"agent_id" INTEGER,
|
||
|
|
"uri" TEXT,
|
||
|
|
"load_base" BIGINT,
|
||
|
|
"load_size" BIGINT,
|
||
|
|
"load_delta" BIGINT,
|
||
|
|
"storage_type" TEXT CHECK ("storage_type" IN ('FILE', 'MEMORY')),
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (agent_id) REFERENCES `rocpd_info_agent{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_info_kernel_symbol{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"code_object_id" INTEGER NOT NULL,
|
||
|
|
"kernel_name" TEXT,
|
||
|
|
"display_name" TEXT,
|
||
|
|
"kernel_object" INTEGER,
|
||
|
|
"kernarg_segment_size" INTEGER,
|
||
|
|
"kernarg_segment_alignment" INTEGER,
|
||
|
|
"group_segment_size" INTEGER,
|
||
|
|
"private_segment_size" INTEGER,
|
||
|
|
"sgpr_count" INTEGER,
|
||
|
|
"arch_vgpr_count" INTEGER,
|
||
|
|
"accum_vgpr_count" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (code_object_id) REFERENCES `rocpd_info_code_object{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Stores repetitive info for samples
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_track{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER,
|
||
|
|
"tid" INTEGER,
|
||
|
|
"name_id" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (tid) REFERENCES `rocpd_info_thread{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (name_id) REFERENCES `rocpd_string{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Storage for a region, instant, and counter
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_event{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"category_id" INTEGER,
|
||
|
|
"stack_id" INTEGER,
|
||
|
|
"parent_stack_id" INTEGER,
|
||
|
|
"correlation_id" INTEGER,
|
||
|
|
"call_stack" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
"line_info" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (category_id) REFERENCES `rocpd_string{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- stores arguments for events
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_arg{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"event_id" INTEGER NOT NULL,
|
||
|
|
"position" INTEGER NOT NULL,
|
||
|
|
"type" TEXT NOT NULL,
|
||
|
|
"name" TEXT NOT NULL,
|
||
|
|
"value" TEXT, -- TODO: discuss make it value_id and integer, refer to string table --
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Region with a start/stop on the same thread (CPU)
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_pmc_event{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"event_id" INTEGER,
|
||
|
|
"pmc_id" INTEGER NOT NULL,
|
||
|
|
"value" REAL DEFAULT 0.0,
|
||
|
|
"extdata" JSONB DEFAULT "{}",
|
||
|
|
FOREIGN KEY (pmc_id) REFERENCES `rocpd_info_pmc{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Region with a start/stop on the same thread (CPU)
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_region{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"tid" INTEGER NOT NULL,
|
||
|
|
"start" BIGINT NOT NULL,
|
||
|
|
"end" BIGINT NOT NULL,
|
||
|
|
"name_id" INTEGER NOT NULL,
|
||
|
|
"event_id" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (tid) REFERENCES `rocpd_info_thread{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (name_id) REFERENCES `rocpd_string{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Instantaneous sample
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_sample{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"track_id" INTEGER NOT NULL,
|
||
|
|
"timestamp" BIGINT NOT NULL,
|
||
|
|
"event_id" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (track_id) REFERENCES `rocpd_track{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_kernel_dispatch{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"tid" INTEGER,
|
||
|
|
"agent_id" INTEGER NOT NULL,
|
||
|
|
"kernel_id" INTEGER NOT NULL,
|
||
|
|
"dispatch_id" INTEGER NOT NULL,
|
||
|
|
"queue_id" INTEGER NOT NULL,
|
||
|
|
"stream_id" INTEGER NOT NULL,
|
||
|
|
"start" BIGINT NOT NULL,
|
||
|
|
"end" BIGINT NOT NULL,
|
||
|
|
"private_segment_size" INTEGER,
|
||
|
|
"group_segment_size" INTEGER,
|
||
|
|
"workgroup_size_x" INTEGER NOT NULL,
|
||
|
|
"workgroup_size_y" INTEGER NOT NULL,
|
||
|
|
"workgroup_size_z" INTEGER NOT NULL,
|
||
|
|
"grid_size_x" INTEGER NOT NULL,
|
||
|
|
"grid_size_y" INTEGER NOT NULL,
|
||
|
|
"grid_size_z" INTEGER NOT NULL,
|
||
|
|
"region_name_id" INTEGER,
|
||
|
|
"event_id" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (tid) REFERENCES `rocpd_info_thread{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (agent_id) REFERENCES `rocpd_info_agent{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (kernel_id) REFERENCES `rocpd_info_kernel_symbol{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (queue_id) REFERENCES `rocpd_info_queue{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (stream_id) REFERENCES `rocpd_info_stream{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (region_name_id) REFERENCES `rocpd_string{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_memory_copy{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"tid" INTEGER,
|
||
|
|
"start" BIGINT NOT NULL,
|
||
|
|
"end" BIGINT NOT NULL,
|
||
|
|
"name_id" INTEGER NOT NULL,
|
||
|
|
"dst_agent_id" INTEGER,
|
||
|
|
"dst_address" INTEGER,
|
||
|
|
"src_agent_id" INTEGER,
|
||
|
|
"src_address" INTEGER,
|
||
|
|
"size" INTEGER NOT NULL,
|
||
|
|
"queue_id" INTEGER,
|
||
|
|
"stream_id" INTEGER,
|
||
|
|
"region_name_id" INTEGER,
|
||
|
|
"event_id" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (tid) REFERENCES `rocpd_info_thread{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (name_id) REFERENCES `rocpd_string{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (dst_agent_id) REFERENCES `rocpd_info_agent{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (src_agent_id) REFERENCES `rocpd_info_agent{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (stream_id) REFERENCES `rocpd_info_stream{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (queue_id) REFERENCES `rocpd_info_queue{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (region_name_id) REFERENCES `rocpd_string{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Memory allocations (real memory, virtual memory, and scratch memory)
|
||
|
|
CREATE TABLE IF NOT EXISTS
|
||
|
|
`rocpd_memory_allocate{{uuid}}` (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"guid" TEXT DEFAULT "{{guid}}" NOT NULL,
|
||
|
|
"nid" INTEGER NOT NULL,
|
||
|
|
"pid" INTEGER NOT NULL,
|
||
|
|
"tid" INTEGER,
|
||
|
|
"agent_id" INTEGER,
|
||
|
|
"type" TEXT CHECK ("type" IN ('ALLOC', 'FREE', 'REALLOC', 'RECLAIM')),
|
||
|
|
"level" TEXT CHECK ("level" IN ('REAL', 'VIRTUAL', 'SCRATCH')),
|
||
|
|
"start" BIGINT NOT NULL,
|
||
|
|
"end" BIGINT NOT NULL,
|
||
|
|
"address" INTEGER,
|
||
|
|
"size" INTEGER NOT NULL,
|
||
|
|
"queue_id" INTEGER,
|
||
|
|
"stream_id" INTEGER,
|
||
|
|
"event_id" INTEGER,
|
||
|
|
"extdata" JSONB DEFAULT "{}" NOT NULL,
|
||
|
|
FOREIGN KEY (nid) REFERENCES `rocpd_info_node{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (pid) REFERENCES `rocpd_info_process{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (tid) REFERENCES `rocpd_info_thread{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (agent_id) REFERENCES `rocpd_info_agent{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (stream_id) REFERENCES `rocpd_info_stream{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (queue_id) REFERENCES `rocpd_info_queue{{uuid}}` (id) ON UPDATE CASCADE,
|
||
|
|
FOREIGN KEY (event_id) REFERENCES `rocpd_event{{uuid}}` (id) ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
INSERT INTO
|
||
|
|
`rocpd_metadata{{uuid}}` ("tag", "value")
|
||
|
|
VALUES
|
||
|
|
("schema_version", "3"),
|
||
|
|
("uuid", "{{uuid}}"),
|
||
|
|
("guid", "{{guid}}");
|