1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
--
-- Copyright 2019 The Android Open Source Project
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- https://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
DROP TABLE IF EXISTS {{table_name}}_stats;
CREATE TABLE {{table_name}}_stats (
process_name TEXT PRIMARY KEY,
min_value REAL,
max_value REAL,
avg_value REAL
);
INSERT INTO {{table_name}}_stats
SELECT
process.name AS process_name,
MIN(span.{{table_name}}_val) AS min_value,
MAX(span.{{table_name}}_val) AS max_value,
SUM(span.{{table_name}}_val * span.dur) / SUM(span.dur) AS avg_value
FROM {{table_name}}_span AS span JOIN process USING(upid)
WHERE process.name IS NOT NULL
GROUP BY 1
ORDER BY 1;
DROP VIEW IF EXISTS {{table_name}}_stats_proto;
CREATE VIEW {{table_name}}_stats_proto AS
SELECT
process_name,
AndroidMemoryMetric_Counter(
'min', min_value,
'max', max_value,
'avg', avg_value
) AS proto
FROM {{table_name}}_stats;
|
