db-migrate/node-db-migrate

Get query execution time

Open

#562 opened on Apr 9, 2018

View on GitHub
 (1 comment) (0 reactions) (0 assignees)JavaScript (2,296 stars) (367 forks)batch import
Nice to havefeaturehelp wanted

Description

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.

Contributor guide

Tech stack
javascriptnodejsmysql
Domain
backenddatabasedeveloper experience
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic Node.js knowledgeFamiliarity with MySQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60
Research direction
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.