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 (367 forks)batch import
Nice to havefeaturehelp wanted

Repository metrics

Stars
 (2,296 stars)
PR merge metrics
 (No merged PRs in 30d)

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

Research direction
Look at how the database driver executes queries in the node db migrate codebase. Identify if there's a callback or promise that receives the result and could capture timing. Propose adding an option to log execution time using console.time or a callback.
Tech stack
javascriptnodejs
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
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.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
Node.jsdatabase migration basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65