summaryrefslogtreecommitdiff
path: root/packages/backend/src/server/api/endpoints/admin/get-index-stats.ts
blob: dd16473f302ade2c76cae72cddccda6159fb7f83 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
import define from '../../define.js';
import { db } from '@/db/postgre.js';

export const meta = {
	requireCredential: true,
	requireModerator: true,

	tags: ['admin'],
} as const;

export const paramDef = {
	type: 'object',
	properties: {},
	required: [],
} as const;

// eslint-disable-next-line import/no-default-export
export default define(meta, paramDef, async () => {
	const stats = await db.query(`SELECT * FROM pg_indexes;`).then(recs => {
		const res = [] as { tablename: string; indexname: string; }[];
		for (const rec of recs) {
			res.push(rec);
		}
		return res;
	});

	return stats;
});