diff options
| -rw-r--r-- | sql/random_queries.md | 5 |
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; |