NSIGHT SQLite SQL Schema

-- Text encoding used: UTF-8
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: CUBLAS_EVENTS
CREATE TABLE CUBLAS_EVENTS (
    start      INTEGER NOT NULL,
    [end]      INTEGER NOT NULL,
    eventClass INTEGER NOT NULL,
    globalTid  INTEGER,
    nameId     INTEGER NOT NULL
);


-- Table: CUDNN_EVENTS
CREATE TABLE CUDNN_EVENTS (
    start      INTEGER NOT NULL,
    [end]      INTEGER NOT NULL,
    eventClass INTEGER NOT NULL,
    globalTid  INTEGER,
    nameId     INTEGER NOT NULL
);


-- Table: CUPTI_ACTIVITY_KIND_KERNEL
CREATE TABLE CUPTI_ACTIVITY_KIND_KERNEL (
    start                INTEGER NOT NULL,
    [end]                INTEGER NOT NULL,
    deviceId             INTEGER NOT NULL,
    contextId            INTEGER NOT NULL,
    streamId             INTEGER NOT NULL,
    correlationId        INTEGER,
    globalPid            INTEGER,
    demangledName        INTEGER NOT NULL,
    shortName            INTEGER NOT NULL,
    launchType           INTEGER,
    cacheConfig          INTEGER,
    registersPerThread   INTEGER NOT NULL,
    gridX                INTEGER NOT NULL,
    gridY                INTEGER NOT NULL,
    gridZ                INTEGER NOT NULL,
    blockX               INTEGER NOT NULL,
    blockY               INTEGER NOT NULL,
    blockZ               INTEGER NOT NULL,
    staticSharedMemory   INTEGER NOT NULL,
    dynamicSharedMemory  INTEGER NOT NULL,
    localMemoryPerThread INTEGER NOT NULL,
    localMemoryTotal     INTEGER NOT NULL,
    gridId               INTEGER NOT NULL,
    sharedMemoryExecuted INTEGER
);


-- Table: CUPTI_ACTIVITY_KIND_MEMCPY
CREATE TABLE CUPTI_ACTIVITY_KIND_MEMCPY (
    start         INTEGER NOT NULL,
    [end]         INTEGER NOT NULL,
    deviceId      INTEGER NOT NULL,
    contextId     INTEGER NOT NULL,
    streamId      INTEGER NOT NULL,
    correlationId INTEGER,
    globalPid     INTEGER,
    bytes         INTEGER NOT NULL,
    copyKind      INTEGER NOT NULL,
    srcId         INTEGER,
    srcKind       INTEGER,
    dstKind       INTEGER,
    srcDeviceId   INTEGER,
    srcContextId  INTEGER,
    dstDeviceId   INTEGER,
    dstContextId  INTEGER
);


-- Table: CUPTI_ACTIVITY_KIND_MEMSET
CREATE TABLE CUPTI_ACTIVITY_KIND_MEMSET (
    start         INTEGER NOT NULL,
    [end]         INTEGER NOT NULL,
    deviceId      INTEGER NOT NULL,
    contextId     INTEGER NOT NULL,
    streamId      INTEGER NOT NULL,
    correlationId INTEGER,
    globalPid     INTEGER,
    value         INTEGER NOT NULL,
    bytes         INTEGER NOT NULL
);


-- Table: CUPTI_ACTIVITY_KIND_RUNTIME
CREATE TABLE CUPTI_ACTIVITY_KIND_RUNTIME (
    start         INTEGER NOT NULL,
    [end]         INTEGER NOT NULL,
    eventClass    INTEGER NOT NULL,
    globalTid     INTEGER,
    correlationId INTEGER,
    nameId        INTEGER NOT NULL,
    returnValue   INTEGER NOT NULL
);


-- Table: CUPTI_ACTIVITY_KIND_SYNCHRONIZATION
CREATE TABLE CUPTI_ACTIVITY_KIND_SYNCHRONIZATION (
    start         INTEGER NOT NULL,
    [end]         INTEGER NOT NULL,
    deviceId      INTEGER NOT NULL,
    contextId     INTEGER NOT NULL,
    streamId      INTEGER NOT NULL,
    correlationId INTEGER,
    globalPid     INTEGER,
    syncType      INTEGER NOT NULL,
    eventId       INTEGER NOT NULL
);


-- Table: ProcessStreams
CREATE TABLE ProcessStreams (
    globalPid  INTEGER NOT NULL,
    filenameId INTEGER NOT NULL,
    contentId  INTEGER NOT NULL
);


-- Table: PROFILER_OVERHEAD
CREATE TABLE PROFILER_OVERHEAD (
    start         INTEGER NOT NULL,
    [end]         INTEGER NOT NULL,
    globalTid     INTEGER,
    correlationId INTEGER,
    nameId        INTEGER NOT NULL,
    returnValue   INTEGER NOT NULL
);


-- Table: StringIds
CREATE TABLE StringIds (
    id    INTEGER NOT NULL
                  PRIMARY KEY,
    value TEXT    NOT NULL
);


-- Table: TARGET_INFO_CUDA_GPU
CREATE TABLE TARGET_INFO_CUDA_GPU (
    vmId                             INTEGER NOT NULL,
    name                             TEXT    NOT NULL,
    pciBusId                         TEXT,
    globalMemoryBandwidth            INTEGER NOT NULL,
    globalMemorySize                 INTEGER NOT NULL,
    constantMemorySize               INTEGER NOT NULL,
    l2CacheSize                      INTEGER NOT NULL,
    numThreadsPerWarp                INTEGER NOT NULL,
    coreClockRate                    INTEGER NOT NULL,
    numMemcpyEngines                 INTEGER NOT NULL,
    numMultiprocessors               INTEGER NOT NULL,
    maxIPC                           INTEGER NOT NULL,
    maxWarpsPerMultiprocessor        INTEGER NOT NULL,
    maxBlocksPerMultiprocessor       INTEGER NOT NULL,
    maxRegistersPerBlock             INTEGER NOT NULL,
    maxSharedMemoryPerBlock          INTEGER NOT NULL,
    maxThreadsPerBlock               INTEGER NOT NULL,
    maxBlockDimX                     INTEGER NOT NULL,
    maxBlockDimY                     INTEGER NOT NULL,
    maxBlockDimZ                     INTEGER NOT NULL,
    maxGridDimX                      INTEGER NOT NULL,
    maxGridDimY                      INTEGER NOT NULL,
    maxGridDimZ                      INTEGER NOT NULL,
    computeCapabilityMajor           INTEGER NOT NULL,
    computeCapabilityMinor           INTEGER NOT NULL,
    deviceId                         INTEGER NOT NULL,
    pid                              INTEGER,
    maxSharedMemoryPerMultiprocessor INTEGER,
    maxRegistersPerMultiprocessor    INTEGER
);


-- Table: TARGET_INFO_CUDA_NULL_STREAM
CREATE TABLE TARGET_INFO_CUDA_NULL_STREAM (
    streamId  INTEGER NOT NULL,
    hwId      INTEGER NOT NULL,
    vmId      INTEGER NOT NULL,
    processId INTEGER NOT NULL,
    deviceId  INTEGER NOT NULL,
    contextId INTEGER NOT NULL
);


-- Table: TARGET_INFO_CUDA_STREAM
CREATE TABLE TARGET_INFO_CUDA_STREAM (
    streamId  INTEGER NOT NULL,
    hwId      INTEGER NOT NULL,
    vmId      INTEGER NOT NULL,
    processId INTEGER NOT NULL,
    contextId INTEGER NOT NULL,
    priority  INTEGER NOT NULL,
    flag      INTEGER NOT NULL
);


-- Table: TARGET_INFO_GPU
CREATE TABLE TARGET_INFO_GPU (
    vmId        INTEGER NOT NULL,
    deviceId    INTEGER NOT NULL,
    name        TEXT,
    busLocation TEXT,
    isDiscrete  INTEGER
);


-- Table: ThreadNames
CREATE TABLE ThreadNames (
    nameId    INTEGER NOT NULL,
    priority  INTEGER,
    globalTid INTEGER
);


COMMIT TRANSACTION;
PRAGMA foreign_keys = on;