lttng-export-maps(1) (v2.16)

GENERAL OPTIONS

lttng [GENERAL OPTIONS] export-maps [--session=SESSION] [--format=sqlite]
$
{ lttng export-maps; echo 'SELECT * FROM vmap;' } | sqlite3 :memory:
CREATE TABLE channels (
  id   INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  type TEXT NOT NULL CHECK (type IN ('kernel', 'user')),
  UNIQUE (name, type)
);

CREATE TABLE groups (
  id          INTEGER PRIMARY KEY,
  channel_id  INTEGER NOT NULL REFERENCES channels(id),
  type        TEXT NOT NULL
              CHECK (type IN ('kernel-global', 'user-per-user',
                              'user-per-process', 'shared')),
  owner_id    INTEGER,
  owner_name  TEXT,
  value_type  TEXT NOT NULL
              CHECK (value_type IN ('signed-int-32', 'signed-int-64')),
  CHECK ((owner_id IS NULL) =
         (type NOT IN ('user-per-user', 'user-per-process')))
);

CREATE TABLE keys (
  id   INTEGER PRIMARY KEY,
  name TEXT NOT NULL UNIQUE
);

CREATE TABLE entries (
  group_id     INTEGER NOT NULL REFERENCES groups(id),
  part_id      INTEGER,
  key_id       INTEGER NOT NULL REFERENCES keys(id),
  value        INTEGER NOT NULL,
  has_overflow INTEGER NOT NULL CHECK (has_overflow IN (0, 1))
);

CREATE VIEW vmap AS
SELECT c.name AS channel_name,
       c.type AS channel_type,
       g.type AS group_type,
       g.owner_id,
       g.owner_name,
       g.value_type,
       e.part_id,
       k.name AS key,
       e.value,
       e.has_overflow
FROM entries e
JOIN groups g   ON e.group_id   = g.id
JOIN channels c ON g.channel_id = c.id
JOIN keys k     ON e.key_id     = k.id;

SET sql_mode = 'NO_BACKSLASH_ESCAPES';

$
sqlite3 -init <(lttng export-maps) :memory:
$
lttng export-maps --session=my-session > maps.sql
$
 
 
 
 
 
 
{ lttng export-maps; cat << EOF
  SELECT key, SUM(value) AS total FROM vmap
  WHERE channel_name = 'my-counters'
  GROUP BY key
  ORDER BY total DESC;
EOF
} | sqlite3 :memory:
$
 
 
 
 
 
 
 
{ lttng export-maps; cat << EOF
  SELECT key, SUM(value) AS total FROM vmap
  WHERE channel_name = 'my-counters'
  GROUP BY key
  ORDER BY total DESC
  LIMIT 10;
EOF
} | sqlite3 :memory:
$
 
 
 
 
 
{ lttng export-maps; cat << EOF
  SELECT part_id, value FROM vmap
  WHERE channel_name = 'my-counters' AND key = 'myapp:my_event'
  ORDER BY part_id;
EOF
} | sqlite3 :memory:
$
 
 
 
 
 
 
 
{ lttng export-maps; cat << EOF
  SELECT key, SUM(value) AS total FROM vmap
  WHERE channel_name = 'my-counters'
    AND group_type = 'kernel-global'
    AND key GLOB 'sched_*'
  GROUP BY key;
EOF
} | sqlite3 :memory:
$
 
 
 
 
 
 
 
 
{ lttng export-maps; cat << EOF
  SELECT owner_id AS pid, owner_name AS command, SUM(value) AS total
  FROM vmap
  WHERE channel_name = 'my-counters' AND group_type = 'user-per-process'
  GROUP BY owner_id
  ORDER BY total DESC
  LIMIT 10;
EOF
} | sqlite3 :memory:
$
 
 
{ lttng export-maps;
  echo 'SELECT * FROM vmap WHERE has_overflow = 1;'
} | sqlite3 :memory:

lttng-export-maps(1) (v2.16)

Options

NAME

SYNOPSIS

DESCRIPTION

SQL SCHEMA

OPTIONS

Recording target

Output

Program information

EXIT STATUS

ENVIRONMENT

FILES

EXAMPLES

RESOURCES

COPYRIGHT

THANKS

SEE ALSO