12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788 |
- <?php
- if (!defined('STATUSNET')) {
- exit(1);
- }
- class SQLStatsPlugin extends Plugin
- {
- protected $queryCount = 0;
- protected $queryStart = 0;
- protected $queryTimes = array();
- protected $queries = array();
- function onPluginVersion(&$versions)
- {
- $versions[] = array('name' => 'SQLStats',
- 'version' => GNUSOCIAL_VERSION,
- 'author' => 'Evan Prodromou',
- 'homepage' => 'http://status.net/wiki/Plugin:SQLStats',
- 'rawdescription' =>
-
- _m('Debug tool to watch for poorly indexed DB queries.'));
- return true;
- }
- function onStartDBQuery($obj, $query, &$result)
- {
- $this->queryStart = microtime(true);
- return true;
- }
- function onEndDBQuery($obj, $query, &$result)
- {
- $endTime = microtime(true);
- $this->queryTimes[] = round(($endTime - $this->queryStart) * 1000);
- $this->queries[] = trim(preg_replace('/\s/', ' ', $query));
- $this->queryStart = 0;
- return true;
- }
- function cleanup()
- {
- if (count($this->queryTimes) == 0) {
- $this->log(LOG_INFO, sprintf('0 queries this hit.'));
- } else {
- $this->log(LOG_INFO, sprintf('%d queries this hit (total = %d, avg = %d, max = %d, min = %d)',
- count($this->queryTimes),
- array_sum($this->queryTimes),
- array_sum($this->queryTimes)/count($this->queryTimes),
- max($this->queryTimes),
- min($this->queryTimes)));
- }
- $verbose = common_config('sqlstats', 'verbose');
- if ($verbose) {
- foreach ($this->queries as $query) {
- $this->log(LOG_INFO, $query);
- }
- }
- }
- }
|