summaryrefslogtreecommitdiff
path: root/src/server/api/endpoints/admin/get-table-stats.ts
diff options
context:
space:
mode:
authorsyuilo <Syuilotan@yahoo.co.jp>2021-11-13 12:23:49 +0900
committersyuilo <Syuilotan@yahoo.co.jp>2021-11-13 12:23:49 +0900
commit2795fe457909c687f668d020ef65d52abc3182fb (patch)
tree0a52e4e4d854333496fcc487560c93c3de5d5eb5 /src/server/api/endpoints/admin/get-table-stats.ts
parentMerge branch 'develop' (diff)
parent12.96.0 (diff)
downloadmisskey-2795fe457909c687f668d020ef65d52abc3182fb.tar.gz
misskey-2795fe457909c687f668d020ef65d52abc3182fb.tar.bz2
misskey-2795fe457909c687f668d020ef65d52abc3182fb.zip
Merge branch 'develop'
Diffstat (limited to 'src/server/api/endpoints/admin/get-table-stats.ts')
-rw-r--r--src/server/api/endpoints/admin/get-table-stats.ts45
1 files changed, 0 insertions, 45 deletions
diff --git a/src/server/api/endpoints/admin/get-table-stats.ts b/src/server/api/endpoints/admin/get-table-stats.ts
deleted file mode 100644
index bce813232b..0000000000
--- a/src/server/api/endpoints/admin/get-table-stats.ts
+++ /dev/null
@@ -1,45 +0,0 @@
-import define from '../../define';
-import { getConnection } from 'typeorm';
-
-export const meta = {
- requireCredential: true as const,
- requireModerator: true,
-
- tags: ['admin'],
-
- params: {
- },
-
- res: {
- type: 'object' as const,
- optional: false as const, nullable: false as const,
- example: {
- migrations: {
- count: 66,
- size: 32768
- },
- }
- }
-};
-
-export default define(meta, async () => {
- const sizes = await
- getConnection().query(`
- SELECT relname AS "table", reltuples as "count", pg_total_relation_size(C.oid) AS "size"
- FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
- WHERE nspname NOT IN ('pg_catalog', 'information_schema')
- AND C.relkind <> 'i'
- AND nspname !~ '^pg_toast';`)
- .then(recs => {
- const res = {} as Record<string, { count: number; size: number; }>;
- for (const rec of recs) {
- res[rec.table] = {
- count: parseInt(rec.count, 10),
- size: parseInt(rec.size, 10),
- };
- }
- return res;
- });
-
- return sizes;
-});