refactoring

Resolve #7779

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;
-});