From 0e4a111f81cceed275d9bec2695f6e401fb654d8 Mon Sep 17 00:00:00 2001 From: syuilo Date: Fri, 12 Nov 2021 02:02:25 +0900 Subject: refactoring Resolve #7779 --- src/server/api/endpoints/admin/get-table-stats.ts | 45 ----------------------- 1 file changed, 45 deletions(-) delete mode 100644 src/server/api/endpoints/admin/get-table-stats.ts (limited to 'src/server/api/endpoints/admin/get-table-stats.ts') 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; - for (const rec of recs) { - res[rec.table] = { - count: parseInt(rec.count, 10), - size: parseInt(rec.size, 10), - }; - } - return res; - }); - - return sizes; -}); -- cgit v1.2.3-freya