Fix table function docs
Change-Id: Ie3650eb50375299a6382fc8805a4a73ff520c071
diff --git a/infra/perfetto.dev/src/gen_stdlib_docs_md.py b/infra/perfetto.dev/src/gen_stdlib_docs_md.py
index f3cc421..3a61b37 100644
--- a/infra/perfetto.dev/src/gen_stdlib_docs_md.py
+++ b/infra/perfetto.dev/src/gen_stdlib_docs_md.py
@@ -138,9 +138,10 @@
self.view_funs.append(
f'''{name} | {arg_dict['type']} | {arg_dict['desc']}''')
self.view_funs.append('\n')
- self.view_funs.append('Column | Description\n' '------ | -----------')
- for name, desc in data['cols'].items():
- self.view_funs.append(f'{name} | {desc}')
+ self.view_funs.append('Column | Type | Description\n'
+ '------ | -- | -----------')
+ for name, column in data['cols'].items():
+ self.view_funs.append(f'{name} | {column["type"]} | {column["desc"]}')
self.view_funs.append('\n\n')
diff --git a/src/trace_processor/perfetto_sql/prelude/views.sql b/src/trace_processor/perfetto_sql/prelude/views.sql
index 6962bae..edcefe8 100644
--- a/src/trace_processor/perfetto_sql/prelude/views.sql
+++ b/src/trace_processor/perfetto_sql/prelude/views.sql
@@ -1,45 +1,45 @@
-CREATE VIEW counters AS
+CREATE VIEW counters AS
SELECT *
-FROM counter v
-JOIN counter_track t ON v.track_id = t.id
+FROM counter v
+JOIN counter_track t ON v.track_id = t.id
ORDER BY ts;
-CREATE VIEW slice AS
+CREATE VIEW slice AS
SELECT
- *,
- category AS cat,
- id AS slice_id
+ *,
+ category AS cat,
+ id AS slice_id
FROM internal_slice;
-CREATE VIEW instant AS
-SELECT ts, track_id, name, arg_set_id
-FROM slice
+CREATE VIEW instant AS
+SELECT ts, track_id, name, arg_set_id
+FROM slice
WHERE dur = 0;
-CREATE VIEW sched AS
-SELECT
+CREATE VIEW sched AS
+SELECT
*,
ts + dur as ts_end
FROM sched_slice;
-CREATE VIEW slices AS
+CREATE VIEW slices AS
SELECT * FROM slice;
-CREATE VIEW thread AS
-SELECT
+CREATE VIEW thread AS
+SELECT
id as utid,
*
FROM internal_thread;
-CREATE VIEW process AS
-SELECT
+CREATE VIEW process AS
+SELECT
id as upid,
- *
+ *
FROM internal_process;
-- This should be kept in sync with GlobalArgsTracker::AddArgSet.
-CREATE VIEW args AS
-SELECT
+CREATE VIEW args AS
+SELECT
*,
CASE value_type
WHEN 'int' THEN CAST(int_value AS text)