db-migrate/node-db-migrate

Get query execution time

Open

#562 建立於 2018年4月9日

在 GitHub 查看
 (1 留言) (0 反應) (0 負責人)JavaScript (2,296 star) (367 fork)batch import
Nice to havefeaturehelp wanted

描述

I'm submitting a...

  • Bug report
  • Feature request
  • Question

Question

Hey, i would like to know if there is a way to get each running query execution time? i tried using verbose, but it didnt return it.

I am using mysql 5.6.latest Note, when running each query manually inside the database command line, we get the running time and how many rows were affected: 1 row in set (0.00 sec)

Thanks.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

貢獻者指南

技術棧
javascriptnodejsmysql
領域
backenddatabasedeveloper experience
議題類型
feature
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
1-3 hours
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
stale
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
Basic Node.js knowledgeFamiliarity with MySQL
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
60
研究方向
Investigate how queries are executed in the migration framework, likely in the migration runner or database driver. Look for existing timing or logging mechanisms. Implement a way to capture and display query execution time, possibly by wrapping the query execution in a timing function and logging the result. Consider adding a verbose mode or a new option to enable timing.