aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2020-01-02 18:11:24 -0800
committerBryan Newbold <bnewbold@archive.org>2020-01-02 18:13:03 -0800
commitfdff17d2cdf4ac92a0458403bb4ca0b073a7752b (patch)
treedfacd521b1e8b43ab3a4f54cce7d9bc3320b1255
parent34f8d3d32845774d7fc8690350084eabff54e44f (diff)
downloadsandcrawler-fdff17d2cdf4ac92a0458403bb4ca0b073a7752b.tar.gz
sandcrawler-fdff17d2cdf4ac92a0458403bb4ca0b073a7752b.zip
sql: more cool random queries
-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;