Madsen, Jonathan
0e93099fd7
* [rocprofv3] rocpd SQLite3 database output support
* Move counters xml and yaml to source/share/rocprofiler-sdk
- more representative of install hierarchy
* Add share/rocprofiler-sdk/rocpd SQL files
* Experimental rocprofiler-sdk SQL API
* rocprofv3 default output format is rocpd
* Fix rocpd event ids for counter collection w/o kernel dispatch
* Remove fktable entries from rocpd_tables.sql
* Fix rocpd schema path
* Fix install component for roctx python bindings
* rocprofiler-sdk-rocpd
- create include/rocprofiler-sdk-rocpd
- create rocprofiler-sdk-rocpd library, package, etc.
- default all "guid" fields to "{{guid}}" in tables
- remove "{{view_uuid}}" support (always unused)
* Migrate rocprofv3 to use rocprofiler-sdk-rocpd
* Fix missing foreign key reference
* Revert change
* Fix cmake comment
* Fix maybe-uninitialized compiler warning
* Fix maybe-uninitialized compiler warning
* Add logging to rocpd_sql_load_schema
* Improve string sanitization when inserting json strings
* Initialize rocpd logging on rocprofiler-sdk-rocpd library load
* Revert lib/output/generatePerfetto.cpp changes
* [temporary] Tweak rocprofv3-test-list-avail-trace-execute test log level
* Update get_install_path for lib/rocprofiler-sdk-rocpd/sql.cpp
- try to resolve issues on RHEL/SLES for dladdr
* Update lib/common/logging.cpp
- enable environ overrides
* dlsym for rocpd_sql_load_schema
* Make dl_info.dli_fname lexically normal
* Implement node_info alternatives if /etc/machine-id does not exist
* Misc include fixes
* SHA256 and UUIDv7 support
* Implement UUIDv7 in generateRocpd.cpp
* Support push/pop environment variables
* Minor tweak
* Fix glog segfaults when unsetting glog env
* Updated CHANGELOG
* Updates tests/pytest-packages
- rocpd_reader.py: RocpdReader
* Update tests / marker_views.sql
- add test_rocpd_data
* Update rocpd_tables.sql
- Use AUTOINCREMENT
- insert "uuid" and "guid" into rocpd_metadata
* Minor updates to generateRocpd.cpp
- don't quote GUID
- use sqlite3_open_v2
- use sqlite3_close_v2
* Update execute_raw_sql_statements_impl
- uses sqlite3_last_insert_rowid for autoincrement
* Update SQL deferred_transaction
- CI check for nullptr to connection
* Apply suggestions from code review
Co-authored-by: Welton, Benjamin <Benjamin.Welton@amd.com>
* Code review updates
- formatting
- replace if with switch
- remove loop for {{uuid}}
* Fix pmc_groups handling in rocprofv3
* Address code review feedback
- Include rocm_version in rocprofv3 version info
- Note `--version` option for `rocprofv3` in CHANGELOG.md
- remove commented out code
* Fix packaging dependencies
* Fix install package step of CI workflow
* Fix install package step of CI workflow
---------
Co-authored-by: Jonathan R. Madsen <jonathanrmadsen@gmail.com>
Co-authored-by: Welton, Benjamin <Benjamin.Welton@amd.com>
[ROCm/rocprofiler-sdk commit: 7afedc63be]
374 строки
15 KiB
SQL
374 строки
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}}");
|