The Ahana Workload Analyzer processed 87 queries for the https://query-analyzer.wen.cp.ahana.cloud report which ran queries from Wed May 11 03:43:11 2022 until Wed May 11 04:36:45 2022. In total the queries consumed 2969.11 seconds of CPU time and read 0.29 GiB of data.

Questions about your report? Want help optimizing your cluster? Share it with an Ahana engineer and we'll get in touch

Top Query Operators

This chart summarizes the Presto operators which are used in your queries. This can tell you some information about what types of queries you are running.


Top CPU Queries

This chart shows the specific queries which have consumed the most CPU resources on your Presto Cluster


Top Memory Queries

This chart shows the specific queries which have consumed the most memory resources on your Presto Cluster


Top Bandwidth-Consuming Queries

This chart shows the specific queries which have consumed the most network bandwidth on your Presto Cluster


Most Used Columns

This chart shows from the top 5 tables, which columns are the most selected across all queries.


Distinct Users by Catalog

This chart shows across all queries, how many distinct users are executing queries against a particular catalog.


Distinct Users by Schema

This chart shows across all queries, how many distinct users are executing queries against a particular schema.


Distinct Users by Table (Top 10)

This chart shows across the top 10 most queried tables, how many distinct users are querying each table.


Most Frequently Queried Catalog

This chart shows which catalogs are queried most frequently.


Least Frequently Queried Catalog

This chart shows which catalogs are queried least frequently.


Most Frequently Queried Schema

This chart shows which schemas are queried most frequently.


Least Frequently Queried Schema

This chart shows which schemas are queried least frequently.


Most Frequently Queried Tables

This chart shows which tables are queried most frequently.


Tables with 0 Queries in the Last 7 Days

Tables

This table shows the set of queries which have not been used in the last 7 days since the latest query on this cluster was executed.


User Query Resource Consumption

User Average CPU Time (s) Max CPU Time (s) Average Cumulative Memory (GiB) Max Cumulative Memory (GiB)
ash 90.54 966.00 931.03 10229.82
bianca 5.66 17.27 53.91 353.05
joy 55.42 402.60 2102.34 25741.53
kris 36.00 235.80 1726.10 9244.38
root 0.00 0.00 0.00 0.00
sonia 6.92 29.14 153.51 752.08
victor 28.84 99.00 1120.41 7457.01
zac 0.08 0.43 0.03 0.09

This table shows the breakdown of query resource consumption by user.


Query Text Reference Table

id query
20220511_043157_00122_9djq6
20220511_035347_00076_9djq6
20220511_043324_00129_9djq6
20220511_043640_00147_9djq6
20220511_035313_00071_9djq6
20220511_043607_00144_9djq6
20220511_042145_00105_9djq6
20220511_035736_00081_9djq6
20220511_040333_00089_9djq6
20220511_043009_00120_9djq6
20220511_043303_00125_9djq6
20220511_042149_00108_9djq6
20220511_041343_00101_9djq6
20220511_040330_00086_9djq6
20220511_040605_00091_9djq6
20220511_043307_00127_9djq6
20220511_043426_00132_9djq6
20220511_040607_00094_9djq6
20220511_043630_00146_9djq6
20220511_035639_00080_9djq6
20220511_040333_00088_9djq6
20220511_042151_00109_9djq6
20220511_035313_00072_9djq6
20220511_043303_00124_9djq6
20220511_042652_00115_9djq6
20220511_043623_00145_9djq6
20220511_034312_00007_9djq6
20220511_042145_00103_9djq6
20220511_043307_00128_9djq6
20220511_041343_00100_9djq6
20220511_035345_00074_9djq6
20220511_040616_00095_9djq6
20220511_034308_00003_9djq6
20220511_040713_00096_9djq6
20220511_035345_00075_9djq6
20220511_034506_00025_9djq6
20220511_042655_00116_9djq6
20220511_040607_00093_9djq6
20220511_035310_00067_9djq6
20220511_042453_00111_9djq6
20220511_043525_00139_9djq6
20220511_034904_00050_9djq6
20220511_040333_00087_9djq6
20220511_041343_00099_9djq6
20220511_042145_00104_9djq6
20220511_042655_00117_9djq6
20220511_042705_00118_9djq6
20220511_040314_00083_9djq6
20220511_034310_00006_9djq6
20220511_035310_00068_9djq6
20220511_043455_00133_9djq6
20220511_043504_00134_9djq6
20220511_042629_00112_9djq6
20220511_040605_00092_9djq6
20220511_043525_00140_9djq6
20220511_040915_00098_9djq6
20220511_043515_00135_9djq6
20220511_034436_00019_9djq6
20220511_034942_00052_9djq6
20220511_035228_00065_9djq6
20220511_042840_00119_9djq6
20220511_035313_00070_9djq6
20220511_043330_00130_9djq6
20220511_043523_00138_9djq6
20220511_042652_00114_9djq6
20220511_035444_00077_9djq6
20220511_042149_00107_9djq6
20220511_040330_00085_9djq6
20220511_043522_00136_9djq6
20220511_035310_00069_9djq6
20220511_040605_00090_9djq6
20220511_043252_00123_9djq6
20220511_040330_00084_9djq6
20220511_043400_00131_9djq6
20220511_043645_00148_9djq6
20220511_035027_00057_9djq6
20220511_042652_00113_9djq6
20220511_043545_00142_9djq6
20220511_035103_00061_9djq6
20220511_043522_00137_9djq6
20220511_040819_00097_9djq6
20220511_043101_00121_9djq6
20220511_042426_00110_9djq6
20220511_041348_00102_9djq6
20220511_034316_00009_9djq6
20220511_043303_00126_9djq6
20220511_043528_00141_9djq6