Add SQL slow query logging and automatic EXPLAIN ANALYZE for queries exceeding threshold

[RUKAYAT-CODER]

Overview

Slow queries are only visible through external monitoring (APM, database logs). The application does not log slow queries itself, making it difficult to correlate slow query occurrences with specific request traces in structured logs.

Specifications

Features:

• Log queries exceeding DB_SLOW_QUERY_THRESHOLD_MS (default 500ms) with the query text, parameters, and duration.
• For queries exceeding DB_EXPLAIN_THRESHOLD_MS (default 2000ms), automatically run and log EXPLAIN ANALYZE.

Tasks:

• Create a TypeORM custom logger (SlowQueryLogger) implementing Logger.
• Override logSlowQuery(query, params, time) to emit structured log lines.
• For queries over the explain threshold, issue EXPLAIN ANALYZE asynchronously and append to the log.
• Register the logger in database.config.ts.

Impacted Files:

• src/config/database.config.ts
• New src/database/logging/slow-query.logger.ts

Acceptance Criteria

• Queries over 500ms appear in structured logs with query text and duration.
• Queries over 2000ms include EXPLAIN ANALYZE output in the log.
• Logger is disabled in test environments to avoid noise.

[sublime247]

@sublime247 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I would like to resolve this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @sublime247 to this issue.

[Blessed-Femi]

@Blessed-Femi has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I will love to work on this issue. I work effectively and on time.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Blessed-Femi to this issue.

[musa01cyb]

@musa01cyb has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Trust me I can work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @musa01cyb to this issue.

[aliyudotdev]

@aliyudotdev has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi can I please take up on this issue ?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @aliyudotdev to this issue.

[drips-wave]

Congratulations, @aliyudotdev! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @aliyudotdev: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊