aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/random_queries.md5
1 files changed, 5 insertions, 0 deletions
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;