diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-06-04 12:40:13 +0000 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-06-04 12:40:13 +0000 |
| commit | dae544b353ebbc6edd85c032786b9901807460e8 (patch) | |
| tree | f8495c993b0c29f911220ade7df8a5f3f076e811 /packages/backend/src/postgres.ts | |
| parent | merge: Fix error caused by activity type confusion (!1090) (diff) | |
| parent | restore join to note.channel in channel/timeline.ts (diff) | |
| download | sharkey-dae544b353ebbc6edd85c032786b9901807460e8.tar.gz sharkey-dae544b353ebbc6edd85c032786b9901807460e8.tar.bz2 sharkey-dae544b353ebbc6edd85c032786b9901807460e8.zip | |
merge: Rework queries and add indexes to improve timeline performance (!1091)
View MR for information: https://activitypub.software/TransFem-org/Sharkey/-/merge_requests/1091
Approved-by: dakkar <dakkar@thenautilus.net>
Approved-by: Marie <github@yuugi.dev>
Diffstat (limited to 'packages/backend/src/postgres.ts')
| -rw-r--r-- | packages/backend/src/postgres.ts | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/packages/backend/src/postgres.ts b/packages/backend/src/postgres.ts index b4bd934972..45caec54ce 100644 --- a/packages/backend/src/postgres.ts +++ b/packages/backend/src/postgres.ts @@ -145,7 +145,10 @@ class MyCustomLogger implements Logger { @bindThis private transformParameters(parameters?: any[]) { if (this.props.enableQueryParamLogging && parameters && parameters.length > 0) { - return parameters.map(stringifyParameter); + return parameters.reduce((params, p, i) => { + params[`$${i + 1}`] = stringifyParameter(p); + return params; + }, {} as Record<string, string>); } return undefined; @@ -158,7 +161,8 @@ class MyCustomLogger implements Logger { const prefix = (this.props.printReplicationMode && queryRunner) ? `[${queryRunner.getReplicationMode()}] ` : undefined; - sqlLogger.info(this.transformQueryLog(query, { prefix }), this.transformParameters(parameters)); + const transformed = this.transformQueryLog(query, { prefix }); + sqlLogger.debug(`Query run: ${transformed}`, this.transformParameters(parameters)); } @bindThis |