aboutsummaryrefslogtreecommitdiff
path: root/user_activity_benchmarks/select_hot_functions.sql
diff options
context:
space:
mode:
authorZhizhou Yang <zhizhouy@google.com>2017-07-21 16:06:55 -0700
committerZhizhou Yang <zhizhouy@google.com>2017-07-21 16:10:53 -0700
commit4307f4735e9a4e3189e8d43f7493bb677a4d06ba (patch)
treebf139ee25415cecde142e95791edba3803b2452a /user_activity_benchmarks/select_hot_functions.sql
parent7091edfaa0ec531905b7d914e9307cd74caf02ea (diff)
parent978b96a8b02935d40e3a2c57cd033dbedd8980e9 (diff)
downloadtoolchain-utils-o-iot-preview-5.tar.gz
Merge branch 'aosp/mirror-chromium-master' into update_utilsandroid-o-iot-preview-5o-iot-preview-5
Update toolchain_utils from ChromeOS side, which includes: initializing Android toolchain benchmark suite and other changes since last merging. Bug: None. Test: None. Change-Id: I9cd74f4377a8109872414636342be0b9f5df2db5
Diffstat (limited to 'user_activity_benchmarks/select_hot_functions.sql')
-rw-r--r--user_activity_benchmarks/select_hot_functions.sql27
1 files changed, 0 insertions, 27 deletions
diff --git a/user_activity_benchmarks/select_hot_functions.sql b/user_activity_benchmarks/select_hot_functions.sql
deleted file mode 100644
index d121d619..00000000
--- a/user_activity_benchmarks/select_hot_functions.sql
+++ /dev/null
@@ -1,27 +0,0 @@
--- Collects the function, with its file, the object and inclusive count value.
--- The limits here are entirely arbitrary.
--- For more background, look at
--- https://sites.google.com/a/google.com/cwp/about/callgraphs.
-SELECT
- frame.function_name AS function,
- frame.filename AS file,
- frame.load_module_path AS dso,
- sum(frame.inclusive_count) AS inclusive_count
-FROM
- -- Collect the data stored in CWP over the last 30 days.
- FLATTEN(chromeos_wide_profiling.sampledb.cycles.callgraph.last30days, frame)
-WHERE
- meta.cros.report_id % UINT64("1") == 0
- -- The reports were collected periodically.
- AND meta.cros.collection_info.trigger_event == 1
- AND `profile.duration_usec` < 2100000
- -- The reports were from a busy machine.
- AND session.total_count > 2000
- -- The reports are from the gnawty board, x86_64 architecture.
- AND meta.cros.board == "gnawty"
- AND meta.cros.cpu_architecture == "x86_64"
- -- The reports include callchain data.
- AND left(meta.cros.version, 4) > "6970"
- GROUP BY function, dso, file
-ORDER BY `inclusive_count` DESC
-LIMIT 50000 ;