/** * Performance testing script to demonstrate the impact of database indexes * * This script can be used to measure query performance before and after * index creation to validate the performance improvements. */ interface PerformanceTestConfig { connectionString: string; testDataSize: number; iterations: number; } interface PerformanceResult { operation: string; avgTimeMs: number; minTimeMs: number; maxTimeMs: number; iterations: number; scenario: 'without_indexes' | 'with_indexes'; } interface PerformanceComparison { operation: string; withoutIndexes: PerformanceResult; withIndexes: PerformanceResult; improvementFactor: number; improvementPercentage: number; } export declare class PostgresPerformanceTest { private store; private memory; private dbOps; private config; constructor(config: PerformanceTestConfig); init(): Promise; cleanup(): Promise; resetDatabase(): Promise; dropPerformanceIndexes(): Promise; createDefaultIndexes(): Promise; seedTestData(): Promise; measureOperation(name: string, operation: () => Promise, scenario: 'without_indexes' | 'with_indexes'): Promise; runPerformanceTests(scenario: 'without_indexes' | 'with_indexes'): Promise; runComparisonTest(): Promise; analyzeCurrentQueries(): Promise; printComparison(comparisons: PerformanceComparison[]): void; printResults(results: PerformanceResult[]): void; checkIndexes(): Promise; } export {}; //# sourceMappingURL=performance-test.d.ts.map