Diff Report
Run #51c6814c41b47: XHProf Run (Namespace=drupal-perf-joelpittet)
vs.
Run #51c6824f48b42: XHProf Run (Namespace=drupal-perf-joelpittet)
Tip
Click a function name below to drill down.

Regression/Improvement summary for Drupal\Core\Database\Connection::query

Drupal\Core\Database\Connection::queryRun #51c6814c41b47Run #51c6824f48b42DiffDiff%
Number of Function Calls 157 157 N/A%
Incl. Wall Time (microsec) 70,541 70,541 N/A%
Incl. Wall Time (microsec) per call N/A 449 449 N/A%
Excl. Wall Time (microsec) 3,237 3,237 N/A%
Incl. CPU (microsecs) 28,712 28,712 N/A%
Incl. CPU (microsecs) per call N/A 183 183 N/A%
Excl. CPU (microsec) 2,890 2,890 N/A%
Incl. MemUse (bytes) 980,584 980,584 N/A%
Incl. MemUse (bytes) per call N/A 6,246 6,246 N/A%
Excl. MemUse (bytes) -145,992 -145,992 N/A%
Incl. PeakMemUse (bytes) 596,288 596,288 N/A%
Incl. PeakMemUse (bytes) per call N/A 3,798 3,798 N/A%
Excl. PeakMemUse (bytes) 43,968 43,968 N/A%

Parent/Child Regression/Improvement report for Drupal\Core\Database\Connection::query [View Callgraph Diff]


Function NameCalls DiffCalls
Diff%
Incl. Wall
Diff
(microsec)
IWall
Diff%
Incl. CPU Diff
(microsec)
ICpu
Diff%
Incl.
MemUse
Diff
(bytes)
IMemUse
Diff%
Incl.
PeakMemUse
Diff
(bytes)
IPeakMemUse
Diff%
Current Function
Drupal\Core\Database\Connection::query157 19.7% 70,541 6.4% 28,712 2.7% 980,584 5.1% 596,288 3.1%
Exclusive Metrics Diff for Current Function3,237 4.6% 2,890 10.1% -145,992 -14.9% 43,968 7.4%
Parent functions
Drupal\Core\Cache\DatabaseBackend::getMultiple107 68.2% 45,451 64.4% 19,457 67.8% 720,032 73.4% 339,736 57.0%
Drupal\Core\KeyValueStore\DatabaseStorage::getMultiple15 9.6% 6,585 9.3% 2,754 9.6% 58,128 5.9% 33,456 5.6%
Drupal\Core\Routing\RouteProvider::getRoutesByPath8 5.1% 5,499 7.8% 1,728 6.0% 68,016 6.9% 72,528 12.2%
Drupal\Core\Cache\DatabaseBackend::checksumTags11 7.0% 4,364 6.2% 1,843 6.4% 44,744 4.6% 31,312 5.3%
Drupal\Core\Database\Query\Update::execute2 1.3% 1,964 2.8% 481 1.7% 2,152 0.2% 67,184 11.3%
Drupal\Core\Database\Query\Select::execute4 2.5% 1,864 2.6% 703 2.4% 28,040 2.9% 7,904 1.3%
Drupal\Core\KeyValueStore\DatabaseStorageExpirable::getMultiple3 1.9% 1,377 2.0% 583 2.0% 13,448 1.4% 7,872 1.3%
Drupal\Core\Database\Driver\mysql\Insert::execute1 0.6% 943 1.3% 193 0.7% 2,000 0.2% 2,408 0.4%
Drupal\Core\Cache\DatabaseBackend::getMultiple@11 0.6% 552 0.8% 212 0.7% 6,984 0.7% 5,656 0.9%
Drupal\Core\Path\AliasManager::lookupPathSource1 0.6% 481 0.7% 165 0.6% 4,696 0.5% 0 0.0%
Drupal\Core\Database\Query\Delete::execute1 0.6% 472 0.7% 125 0.4% 800 0.1% 1,768 0.3%
Drupal\Core\Database\Driver\mysql\Connection::queryRange1 0.6% 438 0.6% 184 0.6% 18,144 1.9% 12,560 2.1%
db_query1 0.6% 341 0.5% 150 0.5% 9,072 0.9% 9,736 1.6%
Drupal\Core\Routing\RouteProvider::getRoutesByNames1 0.6% 210 0.3% 134 0.5% 4,328 0.4% 4,168 0.7%
Child functions
Drupal\Core\Database\Statement::execute157 24.8% 57,596 81.6% 15,700 54.7% 824,936 84.1% 370,960 62.2%
Drupal\Core\Database\Connection::prepareQuery157 24.8% 4,597 6.5% 4,742 16.5% 155,864 15.9% 35,832 6.0%
Drupal\Core\Database\Connection::expandArguments157 24.8% 4,581 6.5% 4,720 16.4% 23,784 2.4% 111,448 18.7%
Drupal\Core\Database\Connection::defaultOptions157 24.8% 506 0.7% 627 2.2% 120,360 12.3% 34,080 5.7%
PDO::lastInsertId1 0.2% 13 0.0% 18 0.1% 832 0.1% 0 0.0%
PDOStatement::rowCount3 0.5% 11 0.0% 15 0.1% 800 0.1% 0 0.0%