useSlowQueriesCount.test.ts21 lines · main

1	import { describe, expect, it } from 'vitest'
2
3	import { buildSlowQueriesCountSql } from './useSlowQueriesCount'
4
5	describe('buildSlowQueriesCountSql', () => {
6	it('checks pg_extension before querying pg_stat_statements', () => {
7	const sql = buildSlowQueriesCountSql()
8	expect(sql).toContain('pg_extension')
9	expect(sql).toContain("extname = 'pg_stat_statements'")
10	})
11
12	it('returns 0 when extension is not installed', () => {
13	expect(buildSlowQueriesCountSql()).toContain('ELSE 0')
14	})
15
16	it('still queries pg_stat_statements when extension exists', () => {
17	const sql = buildSlowQueriesCountSql()
18	expect(sql).toContain('pg_stat_statements')
19	expect(sql).toContain('total_exec_time + total_plan_time > 1000')
20	})
21	})