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]
140 строки
2.0 KiB
SQL
140 строки
2.0 KiB
SQL
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_metadata` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_metadata{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_string` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_string{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_node` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_node{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_process` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_process{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_thread` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_thread{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_agent` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_agent{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_queue` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_queue{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_stream` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_stream{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_pmc` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_pmc{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_code_object` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_code_object{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_info_kernel_symbol` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_info_kernel_symbol{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_track` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_track{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_event` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_event{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_arg` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_arg{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_pmc_event` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_pmc_event{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_region` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_region{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_sample` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_sample{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_kernel_dispatch` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_kernel_dispatch{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_memory_copy` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_memory_copy{{uuid}}`;
|
|
|
|
CREATE VIEW IF NOT EXISTS
|
|
`rocpd_memory_allocate` AS
|
|
SELECT
|
|
*
|
|
FROM
|
|
`rocpd_memory_allocate{{uuid}}`;
|