how to measure query execution time in seqilize?

Question

How can I calculate the execution time of a query Seqilize ORM?

• There is a build in function that measures it?
• How can I manage the running queries(PROCESS LIST)?
• How do I know how many connections running?

Answer 1

To print execution time of the query insert logging and benchmark options to it like that:

const game = await Game.findAll({
    benchmark: true,
    logging: console.log,
    <...>
}