Patch graphile-worker to log out the getJob query

ericallam · ericallam · commit ebe079d83c11 · 2024-06-05T17:45:24.000+01:00
diff --git a/apps/webapp/app/platform/zodWorker.server.ts b/apps/webapp/app/platform/zodWorker.server.ts
@@ -170,6 +170,8 @@ export class ZodWorker<TMessageCatalog extends MessageCatalogSchema> {
 
     const graphileLogger = new GraphileLogger((scope) => {
       return (level, message, meta) => {
+        if (env.VERBOSE_GRAPHILE_LOGGING !== "true") return;
+
         logger.debug(`[graphile-worker][${this.#name}][${level}] ${message}`, {
           scope,
           meta,
diff --git a/package.json b/package.json
@@ -70,7 +70,8 @@
     "patchedDependencies": {
       "@changesets/assemble-release-plan@5.2.4": "patches/@changesets__assemble-release-plan@5.2.4.patch",
       "tsup@8.0.1": "patches/tsup@8.0.1.patch",
-      "engine.io-parser@5.2.2": "patches/engine.io-parser@5.2.2.patch"
+      "engine.io-parser@5.2.2": "patches/engine.io-parser@5.2.2.patch",
+      "graphile-worker@0.16.6": "patches/graphile-worker@0.16.6.patch"
     }
   }
 }
diff --git a/patches/graphile-worker@0.16.6.patch b/patches/graphile-worker@0.16.6.patch
@@ -0,0 +1,18 @@
+diff --git a/dist/sql/getJob.js b/dist/sql/getJob.js
+index 70cc9b49d7d08c8dd32214f15c463b2a568abd15..bb3fe15317f139edd2b24c5046512813ae88f36e 100644
+--- a/dist/sql/getJob.js
++++ b/dist/sql/getJob.js
+@@ -153,6 +153,13 @@ with j as (
+     const name = !preparedStatements
+         ? undefined
+         : `get_job${hasFlags ? "F" : ""}${useNodeTime ? "N" : ""}/${workerSchema}`;
++    
++    logger.debug("Running getJob query...", {
++      text,
++      values,
++      name
++    });
++
+     const { rows: [jobRow], } = await withPgClient.withRetries((client) => client.query({
+         text,
+         values,
diff --git a/pnpm-lock.yaml b/pnpm-lock.yaml

Original file line number	Diff line number	Diff line change
`@@ -70,7 +70,8 @@`
`70`	`70`	`"patchedDependencies": {`
`71`	`71`	`"@changesets/assemble-release-plan@5.2.4": "patches/@changesets__assemble-release-plan@5.2.4.patch",`
`72`	`72`	`"tsup@8.0.1": "patches/tsup@8.0.1.patch",`
`73`		`- "engine.io-parser@5.2.2": "patches/engine.io-parser@5.2.2.patch"`
	`73`	`+ "engine.io-parser@5.2.2": "patches/engine.io-parser@5.2.2.patch",`
	`74`	`+ "graphile-worker@0.16.6": "patches/graphile-worker@0.16.6.patch"`
`74`	`75`	`}`
`75`	`76`	`}`
`76`	`77`	`}`