# top 10 slow query digest

## Request

curl -s -X POST "http://jumpserver-alb-ec2-1371391278.us-west-2.elb.amazonaws.com:81/slowquery/o11y-query" \
  -H 'Content-Type: application/json' \
  -d @- \
  -w "\nHTTP Status: %{http_code}\n" <<'JSON'
{
  "sql": "SELECT COALESCE(digest, '') AS digest, COALESCE(ROUND(AVG(mem_max), 0), 0) AS avg_mem, COALESCE(ROUND(MAX(mem_max), 0), 0) AS max_mem, COALESCE(ROUND(AVG(query_time), 2), 0) AS avg_query_time, COALESCE(ROUND(MAX(query_time), 2), 0) AS max_query_time, COUNT(*) AS total_count FROM delta_scan(\"s3://o11y-prod-shared-us-east-1/deltalake/1372813089209061633/ed869d81-91c5-4a87-a28d-20795c738d3f/slowlogs\") WHERE \"time\" BETWEEN 1763783383 AND 1764038957 AND lower(query) LIKE 'select%' AND lower(query) NOT LIKE 'analyze%' AND lower(query) NOT LIKE 'create%' AND lower(query) NOT LIKE 'alter%' AND lower(query) NOT LIKE 'drop%' AND lower(query) NOT LIKE 'truncate%' AND lower(query) NOT LIKE 'rename%' AND lower(query) NOT LIKE '%force index%' AND NOT (lower(query) LIKE '%read_from_storage(tiflash%' AND lower(query) NOT LIKE '%/*+ read_from_storage(tiflash%') GROUP BY digest ORDER BY total_count DESC LIMIT 100;",
  "vendor": "aws",
  "region": "us-east-1",
  "sources": [
    {
      "name": "slowlogs",
      "type": "delta",
      "uri": "s3://o11y-prod-shared-us-east-1/deltalake/1372813089209061633/ed869d81-91c5-4a87-a28d-20795c738d3f/slowlogs"
    }
  ]
}
JSON

## Response:

{"rows":[{"digest":"18576e217f5f93fa2a934f84290447caa4b783cab493503c4ad71c912ea16930","avg_mem":19175.0,"max_mem":1517096,"avg_query_time":1.79,"max_query_time":17.03,"total_count":72108},{"digest":"1ed23fa94b568a653ef9fed21861be9ca9d143d160281b74f59919517f95bd47","avg_mem":216882.0,"max_mem":566980,"avg_query_time":1.58,"max_query_time":23.57,"total_count":26945},{"digest":"b7100868a0a898084deb610f5fc58c60803849885eee119db315eb3da9291661","avg_mem":27315497.0,"max_mem":79465643,"avg_query_time":1.5,"max_query_time":22.76,"total_count":22983},{"digest":"51750251f7a597915ca6bb7ca50d18f8e101c8fe95f57ae3884e2bd43f075270","avg_mem":37765.0,"max_mem":340432,"avg_query_time":1.53,"max_query_time":34.61,"total_count":22507},{"digest":"d52086c8917ad69336603fa8a0458f78096d0f45f2601c2efeb1f807333edf92","avg_mem":15312738.0,"max_mem":421785554,"avg_query_time":1.44,"max_query_time":14.63,"total_count":21338},{"digest":"095f2241e75ee77e1f91adb7e55bfc05ae1dbc7227bb5f400108ca60649e8f24","avg_mem":5283.0,"max_mem":258048,"avg_query_time":1.69,"max_query_time":25.59,"total_count":18403},{"digest":"964b5c2d1bd95b8baae21e3cb062d9ed867bdcc3a4077879a75cdd0a414e2e73","avg_mem":358531.0,"max_mem":3617773,"avg_query_time":1.18,"max_query_time":15.13,"total_count":16426},{"digest":"b540b397584b7f99ed11b9b4604ccc412514da94736549d9abd86b94516bd626","avg_mem":633544.0,"max_mem":27117675,"avg_query_time":2.13,"max_query_time":17.31,"total_count":16251},{"digest":"ad338193b43dbc4974803b296ce63c7097e3fe8bc12fa4c525c9c9a16a8f8aa4","avg_mem":79476.0,"max_mem":25430724,"avg_query_time":1.51,"max_query_time":32.01,"total_count":16190},{"digest":"43d2b9451d03b438a92c09d022aefdff30dbff9623c49d3bab032943b597fff9","avg_mem":36888790.0,"max_mem":470555700,"avg_query_time":1.77,"max_query_time":12.97,"total_count":14541},{"digest":"cc2c4a2aad4218e9e62c2614331b77fc9fe1f725d97e4aafd46070a6ab8d341b","avg_mem":259654.0,"max_mem":4815292,"avg_query_time":1.84,"max_query_time":32.27,"total_count":14437},{"digest":"eb2d7096fbf3a00ace5183b9d10e3d7983257778e7d56d597f264d0c34f7a6a3","avg_mem":84181.0,"max_mem":116656,"avg_query_time":1.71,"max_query_time":27.75,"total_count":14189},{"digest":"c211c18e8f8f07e610df43a0561e64bfd5826b7748e7860e6542b2e6c6086142","avg_mem":79855269.0,"max_mem":1353235382,"avg_query_time":3.07,"max_query_time":45.48,"total_count":14142},{"digest":"f46d84d97870e12755f906587e981261f5e2e86eda88ad0bb3fe742eb452c231","avg_mem":41961883.0,"max_mem":650622138,"avg_query_time":1.43,"max_query_time":17.21,"total_count":12933},{"digest":"6cfe2342f13988fec332eb0c73390684258bc02e2937e5b98d3a813ec833d5f2","avg_mem":9616.0,"max_mem":12288,"avg_query_time":1.77,"max_query_time":22.73,"total_count":10271},{"digest":"18743e098be32e9f7637a56cdec62286bcddb8935fe64be0f6663fcd5d62a96f","avg_mem":4840417.0,"max_mem":13593072,"avg_query_time":1.31,"max_query_time":26.2,"total_count":9986},{"digest":"7924fca72e8a0e88a3b11e2bc8ee97fcf878709dc77b3f0501fd8c480b559cda","avg_mem":32027.0,"max_mem":60040,"avg_query_time":2.59,"max_query_time":29.37,"total_count":9540},{"digest":"b66acc30e9dbf4f1d1a398be05196ea51843cbfcafbee1ba4af93c94c783eb28","avg_mem":41640890.0,"max_mem":136248229,"avg_query_time":2.13,"max_query_time":15.03,"total_count":9488},{"digest":"f9d18239fd67983e1bf6172bdb19c446c2a0ef45c44bf3e5a179273cde2f7d56","avg_mem":72608.0,"max_mem":911164,"avg_query_time":1.71,"max_query_time":18.83,"total_count":9392},{"digest":"d2b8943637d6ddfa68c48b8a31617924618b05da93a63f03cd7e6768ee58dec7","avg_mem":81404.0,"max_mem":240832,"avg_query_time":1.71,"max_query_time":20.11,"total_count":8966},{"digest":"8a7f9aa17e64079c3002dc7c0513e29a32f1fd2afa7da0852b226c3720b5d55e","avg_mem":53179055.0,"max_mem":318881469,"avg_query_time":2.88,"max_query_time":20.52,"total_count":8444},{"digest":"d6d701a9f4338181b18a06a6cd4d3900ef3e06379302405a2db11714ceb8868d","avg_mem":91567.0,"max_mem":140849,"avg_query_time":1.47,"max_query_time":16.81,"total_count":8366},{"digest":"3f60b094be5c03ad48ab6e8e5c2dd615be377fba8d3b4e9e40b8ed3faee84822","avg_mem":12211672.0,"max_mem":25955484,"avg_query_time":1.48,"max_query_time":8.01,"total_count":8243},{"digest":"ac6c806b85b747ebc4d17ba23499c9c470420aafa08e00d2c8634091a772f4fe","avg_mem":2381328.0,"max_mem":122384712,"avg_query_time":1.3,"max_query_time":8.88,"total_count":8175},{"digest":"5b8bf226daed8407c2ef8e1f031eb7a77e8b971c76f7d55748918c7e671220a6","avg_mem":212758.0,"max_mem":510416,"avg_query_time":1.6,"max_query_time":12.84,"total_count":8070},{"digest":"1b9337f806f28ef79cb91d16369c279f3d9a78aa5ca1b8333f67df32c58b3d7e","avg_mem":99701.0,"max_mem":240112,"avg_query_time":1.66,"max_query_time":13.84,"total_count":7802},{"digest":"10f37b2108969c5e295ddfc3d78a0e736e7b16af5e7005e8e3c37ceef77c2807","avg_mem":787036.0,"max_mem":60836560,"avg_query_time":1.16,"max_query_time":3.81,"total_count":7701},{"digest":"892a189a8e91dfb2e4c2ff0196addeee96a93cebff3570ef0fda645ecd3dee5c","avg_mem":206844908.0,"max_mem":1350975690,"avg_query_time":1.96,"max_query_time":7.29,"total_count":7656},{"digest":"5ed3c66a6505fd76ff485d8829bf90185120209653739e7ed473e676d622ce5b","avg_mem":88050958.0,"max_mem":595204237,"avg_query_time":1.86,"max_query_time":12.3,"total_count":7486},{"digest":"b9a982447eafb04ff86f50e6cd38ac1ae7cbeef7c3130fdf8502a0dc736fb390","avg_mem":137140557.0,"max_mem":790153059,"avg_query_time":3.35,"max_query_time":20.97,"total_count":6784},{"digest":"31534c016e5d32aa632d06df4c6b3eed2a30a2889cecb3c736dd24e5d5ce4bf3","avg_mem":2878677.0,"max_mem":5070346,"avg_query_time":1.7,"max_query_time":5.33,"total_count":6695},{"digest":"8be0d83a9f1a9ac1c25eb5d69b924dfb9b732b475846fa5b7369ecd9767eb4a2","avg_mem":33593707.0,"max_mem":224767437,"avg_query_time":1.56,"max_query_time":9.49,"total_count":6694},{"digest":"9061404e19cf394b9f66da12a0dea52f824f739bba0175f3de8fa9d23c1937f5","avg_mem":724629.0,"max_mem":2605264,"avg_query_time":1.69,"max_query_time":28.48,"total_count":6368},{"digest":"0996d656ed77b9c9688cabdea440439923c6ebc8a728c9efbc95b9659121de73","avg_mem":5056.0,"max_mem":1044480,"avg_query_time":1.69,"max_query_time":17.36,"total_count":6147},{"digest":"ba0dada88f798386ffc6d67a831743bf6f02c45375ba707ce034419e2ae5b792","avg_mem":14367.0,"max_mem":19528,"avg_query_time":1.5,"max_query_time":35.68,"total_count":6125},{"digest":"39884be2ec34aec2ecb3e48edd6bc15f39cc224eb53b1f9d3d813139a6a1393f","avg_mem":11631.0,"max_mem":12288,"avg_query_time":1.75,"max_query_time":25.55,"total_count":5929},{"digest":"e72e17bf6066a0b12861d0784e72893172c98fb7aa63cc8c37b0be028242468f","avg_mem":208851.0,"max_mem":516280,"avg_query_time":1.51,"max_query_time":32.39,"total_count":5545},{"digest":"7e1e4896745be640240102363b0c38fa3622c809457cb8cb1891ddd662a109ae","avg_mem":5376453.0,"max_mem":71203838,"avg_query_time":1.72,"max_query_time":4.98,"total_count":5525},{"digest":"b53cb201ac54839bfe04d779e0a33d0a70beb4965436ea42edac3d2f96688e07","avg_mem":4144.0,"max_mem":12288,"avg_query_time":1.71,"max_query_time":9.72,"total_count":5461},{"digest":"eeb8a43e7abaeebc29dc28cc2081dcadce7f78fa8343cefefbe7ce8910ac4204","avg_mem":49348.0,"max_mem":16773120,"avg_query_time":1.7,"max_query_time":6.87,"total_count":5302},{"digest":"9e00c94b3884ef3c4c94f0b4d56477522b595e958d2b46cf764286293e3e7842","avg_mem":2898020.0,"max_mem":161487734,"avg_query_time":1.73,"max_query_time":4.93,"total_count":5093},{"digest":"ba085a5d461661d0bae8d5be13263b337c94d294b7982fe21926da5260d0e2c1","avg_mem":333261007.0,"max_mem":2704745157,"avg_query_time":3.36,"max_query_time":39.86,"total_count":4995},{"digest":"15aa7f11760bf3f48b0f9ae7798f2b2b2834326440e1fa72679578c709cedded","avg_mem":4109961.0,"max_mem":17580306,"avg_query_time":1.38,"max_query_time":17.67,"total_count":4995},{"digest":"3a5c4ba3129feae42418b36877ab456b7ab123c188b31cd162eea8f29787e8cb","avg_mem":63297418.0,"max_mem":275500460,"avg_query_time":1.43,"max_query_time":8.45,"total_count":4948},{"digest":"d5af2008a5e0afe65bbb9e4777a3e3c98f7878aa86e875109deb33bec9ff93e2","avg_mem":104046.0,"max_mem":2587096,"avg_query_time":1.59,"max_query_time":15.52,"total_count":4794},{"digest":"a01afca48fdfadcb4d9806885932276b12366750d7251e0047e656ba9928ced0","avg_mem":6779.0,"max_mem":47080,"avg_query_time":1.74,"max_query_time":2.78,"total_count":4764},{"digest":"def9b50107e40c4ce129ab80b3de68e6066057216ae2a88f7b8849c62b020b42","avg_mem":10017.0,"max_mem":12288,"avg_query_time":1.69,"max_query_time":17.14,"total_count":4682},{"digest":"520a3be8e18ad8dad1bf20b3f90db052dda3faddcf97481e2fac51abc15040f6","avg_mem":2229.0,"max_mem":12288,"avg_query_time":1.69,"max_query_time":14.22,"total_count":4537},{"digest":"7bbc3d7cc387595724c0954fa66c31c3e01b548660ee221f66dc1ddb204bb7b2","avg_mem":83633.0,"max_mem":328344,"avg_query_time":1.71,"max_query_time":15.82,"total_count":4376},{"digest":"8272d402603a68291d4b9138c706a6d4609959e8ed17140662ad13ec955c3687","avg_mem":166775.0,"max_mem":532033,"avg_query_time":1.31,"max_query_time":7.68,"total_count":4319},{"digest":"f591cb1e17ba1a72ac34b2b2254a27a60f2199b7d70a3f15bdfe6b2c9d0a1a8d","avg_mem":49548.0,"max_mem":196044,"avg_query_time":1.73,"max_query_time":2.76,"total_count":4165},{"digest":"b87c378dad64f0457a4fc3beaae3c8109a1181788e0b13d5cf6abed4578afaa5","avg_mem":22174.0,"max_mem":141424,"avg_query_time":1.47,"max_query_time":26.87,"total_count":4126},{"digest":"3220dd8c3d5dbdcca3f5cd6f0ac7b8b69e1d465fdbea572c1636b417e26bc008","avg_mem":416557.0,"max_mem":1487908,"avg_query_time":1.84,"max_query_time":12.86,"total_count":4065},{"digest":"d11003c929411644f7be373d58226cbb25a8efd59d645618fa035a3fae07cefe","avg_mem":27871940.0,"max_mem":74579408,"avg_query_time":1.67,"max_query_time":4.84,"total_count":3971},{"digest":"20ae484a3ebac7eebf690a05add3d484d048e338700cd34857ccc6a246a352c1","avg_mem":106027181.0,"max_mem":391294982,"avg_query_time":3.2,"max_query_time":18.56,"total_count":3928},{"digest":"840e8311a58da8697028d69e039f3cc65fc280b32d50239fbd29d414d3e0af4e","avg_mem":56119097.0,"max_mem":182300836,"avg_query_time":3.25,"max_query_time":18.04,"total_count":3896},{"digest":"90aae334885d8533d028e801a850901b2b34411b4e39efd59afff19a539e7f6a","avg_mem":4367.0,"max_mem":12288,"avg_query_time":1.67,"max_query_time":14.56,"total_count":3872},{"digest":"ef289ad9caf7fe5e01859e112cbaadd66e1e4eb541c3d41854711f1d1b511dfb","avg_mem":73500813.0,"max_mem":224518754,"avg_query_time":3.22,"max_query_time":19.5,"total_count":3784},{"digest":"45d9c6ebfe12d55c56926713d855917cbb00572e88417fb82b8a7f86d928b06d","avg_mem":50084028.0,"max_mem":160039994,"avg_query_time":2.07,"max_query_time":12.99,"total_count":3766},{"digest":"e257cebbaa30f156832f6fe6f3cd0077afd45ab70e67f59a815ee9bb307104bb","avg_mem":4471.0,"max_mem":28672,"avg_query_time":1.67,"max_query_time":13.97,"total_count":3596},{"digest":"475423b74d077e818396c9ba209113811e3dddc232a6658b2bfcb5dcd95f5e5f","avg_mem":94674.0,"max_mem":924524,"avg_query_time":1.56,"max_query_time":36.33,"total_count":3587},{"digest":"ff7de06d56d2411864436d3086e67e2ab70ab54fe1f46fe2276d10ea05d69224","avg_mem":0.0,"max_mem":0,"avg_query_time":1.72,"max_query_time":13.44,"total_count":3545},{"digest":"8e964cf252c8b1021c979dc930801e88263d7ab9581827ae3bf7cf2109d2d3fb","avg_mem":6839.0,"max_mem":12288,"avg_query_time":1.71,"max_query_time":16.16,"total_count":3450},{"digest":"f947cb31b498552f046609c5ba1d190cad9b7347df7b42ff5d68415ba826b84e","avg_mem":153696025.0,"max_mem":838746265,"avg_query_time":1.97,"max_query_time":6.54,"total_count":3434},{"digest":"8f95b574dbfcbcecd9ede61ba2e83fcff7814428bc62a9cf36a92c629a148dda","avg_mem":3327.0,"max_mem":12288,"avg_query_time":1.69,"max_query_time":2.74,"total_count":3434},{"digest":"7eae3b2fd106a47f2442377a4d7d5f0ebdbc0a0acb03a06605b95f10315b4333","avg_mem":77828.0,"max_mem":276704,"avg_query_time":1.75,"max_query_time":23.15,"total_count":3379},{"digest":"dc51cc4b3098b47fe02dd1d94abc8be84c50ce9878f614ccb2148fdfecdb4914","avg_mem":89574628.0,"max_mem":205397886,"avg_query_time":1.69,"max_query_time":9.05,"total_count":3372},{"digest":"56eaa5136b34f5a075fe80155adadc95d9eedaacb18f3b0de909f269ba572330","avg_mem":54571658.0,"max_mem":129433321,"avg_query_time":1.67,"max_query_time":10.37,"total_count":3337},{"digest":"10a778ec39258794db5c1726baee2614954eb5c9d0f5da8fcad35a24ed921952","avg_mem":1379183.0,"max_mem":56133615,"avg_query_time":1.78,"max_query_time":34.53,"total_count":3309},{"digest":"2af7f47444ed6872f33aa5bb5066da63314dff20daeb97ed7c78ebcff197d9d4","avg_mem":57701150.0,"max_mem":273564882,"avg_query_time":1.53,"max_query_time":8.91,"total_count":3215},{"digest":"01c56234ab4f30ce9880183502ebd990871cfb63e936cb3cc07edf76515d60d1","avg_mem":71036097.0,"max_mem":201098436,"avg_query_time":1.64,"max_query_time":10.42,"total_count":3177},{"digest":"e2814265b31cce00f4c4ec262b65bda7e9be73be087d0fedac7ef74e25169b18","avg_mem":17126.0,"max_mem":105704,"avg_query_time":1.77,"max_query_time":12.59,"total_count":3164},{"digest":"a2d68fbc9f975194a7838a4398aa496c58950f35769d2130c763b7b3dcc42ffd","avg_mem":195281579.0,"max_mem":836517880,"avg_query_time":2.4,"max_query_time":10.85,"total_count":3158},{"digest":"ca0cefda68fcc3cbcc671ca7d82df5ac34645cc5721e349fe54dede15d07af13","avg_mem":15519119.0,"max_mem":247964529,"avg_query_time":1.54,"max_query_time":6.29,"total_count":3060},{"digest":"6984b53faa50d8a62ad3c4c3ed163e7e2ad4d96224864cc210eff97da3589cfe","avg_mem":65557709.0,"max_mem":231860983,"avg_query_time":1.66,"max_query_time":7.74,"total_count":2919},{"digest":"cddc469a709ad2be9b854388455a98fb89329d70fc44862393f3ec794d97c245","avg_mem":14443.0,"max_mem":258048,"avg_query_time":1.8,"max_query_time":13.27,"total_count":2902},{"digest":"0c233f56781b779a25cf1732e0e6e058942f9fc56557c6d1af42ec18fef399d1","avg_mem":389844634.0,"max_mem":2084029189,"avg_query_time":1.95,"max_query_time":9.16,"total_count":2804},{"digest":"b694598d50f365e504edc2a08fa7b84b318080030f0f06998d76594e9c4802b3","avg_mem":24959058.0,"max_mem":106777482,"avg_query_time":1.81,"max_query_time":12.47,"total_count":2783},{"digest":"afb5c747b59805cd86ae311618abff51f9f621b9586fad10d1168727a9391a82","avg_mem":9885.0,"max_mem":12288,"avg_query_time":1.82,"max_query_time":24.71,"total_count":2772},{"digest":"f7b8ab37a2a1830ebab54f9ea40c6ecb82bc99352550c6dda8ff8dfe8b29ff2d","avg_mem":50889.0,"max_mem":359397,"avg_query_time":1.51,"max_query_time":16.23,"total_count":2729},{"digest":"5c15436d862885de69b67f0f4d6f26e66824fdf362f69d0c052c062672cc22c3","avg_mem":153342.0,"max_mem":1462412,"avg_query_time":1.49,"max_query_time":14.82,"total_count":2720},{"digest":"606af23d9761c5a243b90ff4b14e83aef0048e33b999ae34be11b7c2b483b5cd","avg_mem":1676224.0,"max_mem":5355048,"avg_query_time":1.7,"max_query_time":8.68,"total_count":2712},{"digest":"77671a31bb6f04e5799a6dad9aeaf1bfed097a5c7fe4f125a62a91ffdd8de7ab","avg_mem":41874.0,"max_mem":204736,"avg_query_time":1.29,"max_query_time":8.29,"total_count":2705},{"digest":"20bf657c894740b6ba118c377a13c165d4e851fe65d33819c9aeb8bbc7325829","avg_mem":1261410.0,"max_mem":82635183,"avg_query_time":1.51,"max_query_time":27.48,"total_count":2702},{"digest":"90330288f8df910dd0823837c90a5f86689fa0254ce209b140551c459c71708b","avg_mem":60898.0,"max_mem":61072,"avg_query_time":1.67,"max_query_time":7.33,"total_count":2695},{"digest":"7dd99b0dc388a9d8a88240b01ebd674bf429c06ae007bbef1d551dc19d806454","avg_mem":605858.0,"max_mem":5835028,"avg_query_time":1.73,"max_query_time":24.44,"total_count":2681},{"digest":"62aa4a72e20253909f07d3608bda1a973de32fdaf2a28dfcf9208a365a851f87","avg_mem":11757.0,"max_mem":12288,"avg_query_time":1.7,"max_query_time":2.78,"total_count":2559},{"digest":"c312671322fab8c827f1578e39d8fa43662a424e55f3255890ae43249b26e892","avg_mem":51834076.0,"max_mem":245027841,"avg_query_time":3.5,"max_query_time":31.29,"total_count":2545},{"digest":"967d079f1741dae32d709c75637a5fcac61391f7af4872d27497c50092c75271","avg_mem":4313131.0,"max_mem":169291926,"avg_query_time":1.73,"max_query_time":4.25,"total_count":2412},{"digest":"c13a84af9e0162969f43147c99b2ddf4363bbcdcefa0e6f67be129776259b505","avg_mem":11629067.0,"max_mem":38911144,"avg_query_time":1.71,"max_query_time":6.11,"total_count":2381},{"digest":"a2d5b5adc51ff2d41d54ecce59ef780a3d3f792ee2809c85578d7a7a0170caa9","avg_mem":4475489.0,"max_mem":14246661,"avg_query_time":1.68,"max_query_time":13.54,"total_count":2380},{"digest":"fc43c2b8ae188dffb8cd593ef91309f1595fb28be59827699b1bc06be490e01f","avg_mem":165241859.0,"max_mem":258950787,"avg_query_time":2.72,"max_query_time":10.74,"total_count":2375},{"digest":"adf0384ee3b7b8ce35f0e5c8124b07d2d9864bcee03b0f6c04f1e0ac8e89e711","avg_mem":594582.0,"max_mem":5116904,"avg_query_time":1.79,"max_query_time":27.99,"total_count":2312},{"digest":"9f4121d09187e931a67c8682890b7e22b4f89d9a6b71dfc929e33015ddcb26f1","avg_mem":25954.0,"max_mem":122000,"avg_query_time":1.66,"max_query_time":11.05,"total_count":2277},{"digest":"965be57aab4eb36c583fe70a66d8f80bb3dbc344ebde10e561b769847470f303","avg_mem":66093052.0,"max_mem":238069124,"avg_query_time":1.64,"max_query_time":10.29,"total_count":2248},{"digest":"60069d872eaa06b708e486c82733e9980023f85e5f1cd5b054473c7664af485e","avg_mem":159357.0,"max_mem":296428,"avg_query_time":1.46,"max_query_time":11.62,"total_count":2219},{"digest":"022829de31e6331a3f0cf7344799c0530683d859ac32754752594964f9c703c6","avg_mem":4096.0,"max_mem":4096,"avg_query_time":1.71,"max_query_time":14.47,"total_count":2211},{"digest":"9669d32630d5ab42b5fd855329208fce963ce1a59477e0f1843de4dca44446a2","avg_mem":44902.0,"max_mem":79312,"avg_query_time":1.7,"max_query_time":2.77,"total_count":2134},{"digest":"5a39bb0fe8c2529a1e40d46fe99991293e069f9e2151d710b764f95c17d0cd3c","avg_mem":84000.0,"max_mem":92036,"avg_query_time":1.58,"max_query_time":22.3,"total_count":2126},{"digest":"7f78523a8e835641cbb384a2053a933653b0787b8b25ceb8120c63e6b6a70a22","avg_mem":66931041.0,"max_mem":269533348,"avg_query_time":1.69,"max_query_time":4.38,"total_count":2084}],"meta":{"columns":["digest","avg_mem","max_mem","avg_query_time","max_query_time","total_count"],"row_count":100,"elapsed_ms":8512}}
HTTP Status: 200


# Digest 统计
## Request
curl -s -X POST "http://jumpserver-alb-ec2-1371391278.us-west-2.elb.amazonaws.com:81/slowquery/o11y-query" \
  -H 'Content-Type: application/json' \
  -d @- \
  -w "\nHTTP Status: %{http_code}\n" <<'JSON'
{
  "sql": "WITH filtered AS ( SELECT digest, query, lower(query) AS q FROM delta_scan(\"s3://o11y-prod-shared-us-east-1/deltalake/1372813089209061633/ed869d81-91c5-4a87-a28d-20795c738d3f/slowlogs\") WHERE \"time\" BETWEEN 1763783383 AND 1764038957 ), final_filtered AS ( SELECT digest FROM filtered WHERE NOT ( q LIKE 'analyze%' OR q LIKE 'create%' OR q LIKE 'alter%' OR q LIKE 'drop%' OR q LIKE 'truncate%' OR q LIKE 'rename%' OR q LIKE '%force index%' OR (q LIKE '%read_from_storage(tiflash%' AND q NOT LIKE '%/*+ read_from_storage(tiflash%') OR q NOT LIKE 'select%' ) ) SELECT COUNT(*) AS total_records, COUNT(DISTINCT digest) AS distinct_digests FROM final_filtered",
  "vendor": "aws",
  "region": "us-east-1",
  "sources": [
    {
      "name": "slowlogs",
      "type": "delta",
      "uri": "s3://o11y-prod-shared-us-east-1/deltalake/1372813089209061633/ed869d81-91c5-4a87-a28d-20795c738d3f/slowlogs"
    }
  ]
}
JSON

##  Response:
{"rows":[{"total_records":923384,"distinct_digests":3829}],"meta":{"columns":["total_records","distinct_digests"],"row_count":1,"elapsed_ms":7915}}
HTTP Status: 200