From fdff17d2cdf4ac92a0458403bb4ca0b073a7752b Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@archive.org>
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(+)

(limited to 'sql')

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