Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Show database query execution times during deployment

Components

Labels

Description

In the "\DeploymentHelper::applyRevisions" method:

  1. measure each database query execution time

  2. display time next to shown executed database queries in "*Time*: NNm MMs" format

  3. display time next to shown logged database queries in "Duration: NNm MMs (from YYYY-MM-DD HH:MM:SS to YYYY-MM-DD HH:MM:SS)" format

  4. show executed revision name/number in the log like as on screen

Context Information

None

Additional information (do not use)

None

Activity

[API] Administrator July 8, 2022 at 2:39 PM

User committed a fix to 5.2.x. Commit Message:

Fixes - Show database query execution times during deployment

Differential Revision: http://qa.in-portal.org/D392

Alex April 30, 2021 at 2:42 PM

Totals are now shown after an SQL error.

Erik S. February 19, 2021 at 9:50 AM

erik accepted D392: - Show database query execution times durning deployment.
D392: - Show database query execution times durning deployment is now accepted and ready to land.

Alex December 28, 2020 at 3:03 PM

alex updated the diff for D392: - Show database query execution times durning deployment.
alex added a comment to D392: - Show database query execution times durning deployment.

Show total SQL execution time. Show SQL execution time in different color based on it's speed (<1 min, <5 min, longer).

Alex December 28, 2020 at 3:01 PM

alex updated the test plan for D392: - Show database query execution times durning deployment.

Fixed

Details

Priority

Assignee

Reporter

Developer

Reviewer

Change Log Group

Added

Change Log Message

Patch Instructions

Patches must be submitted through Phabricator.

Time tracking

2h 45m logged

Story Points

Fix versions

Created December 23, 2020 at 3:13 PM
Updated December 29, 2024 at 8:48 PM
Resolved July 8, 2022 at 2:39 PM