From fdff17d2cdf4ac92a0458403bb4ca0b073a7752b Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 2 Jan 2020 18:11:24 -0800 Subject: sql: more cool random queries --- sql/random_queries.md | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/sql/random_queries.md b/sql/random_queries.md index 6ae651a..604088a 100644 --- a/sql/random_queries.md +++ b/sql/random_queries.md @@ -53,3 +53,8 @@ Time: 189067.335 ms (03:09.067) ) r LIMIT 5; +More stats (2019-12-27): + + SELECT mimetype, COUNT(*) FROM file_meta GROUP BY mimetype ORDER BY COUNT(*) DESC LIMIT 20; + + SELECT SUM(size_bytes) FROM file_meta; -- cgit v1.2.3