summaryrefslogtreecommitdiff
path: root/src/server/api/endpoints/admin/get-table-stats.ts
diff options
context:
space:
mode:
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;
-});