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 ;