/usr/share/pgfouine/include/NormalizedQuery.class.php is in pgfouine 1.2-3ubuntu1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | <?php
/*
* This file is part of pgFouine.
*
* pgFouine - a PostgreSQL log analyzer
* Copyright (c) 2005-2008 Guillaume Smet
*
* pgFouine is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or (at
* your option) any later version.
*
* pgFouine is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with pgFouine; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA 02110-1301, USA.
*/
class NormalizedQuery {
var $normalizedText;
var $duration = 0;
var $count = 0;
var $examples = false;
var $hourlyStatistics = array();
function NormalizedQuery(& $query) {
$this->normalizedText = $query->getNormalizedText();
$maxExamples = CONFIG_MAX_NUMBER_OF_EXAMPLES;
if($maxExamples) {
$this->examples = new SlowestQueryList($maxExamples);
}
$this->addQuery($query);
}
function addQuery(& $query) {
$this->count ++;
$this->duration += $query->getDuration();
$formattedTimestamp = date('Y-m-d H:00:00', $query->getTimestamp());
if(!isset($this->hourlyStatistics[$formattedTimestamp])) {
$this->hourlyStatistics[$formattedTimestamp]['count'] = 0;
$this->hourlyStatistics[$formattedTimestamp]['duration'] = 0;
}
$this->hourlyStatistics[$formattedTimestamp]['count']++;
$this->hourlyStatistics[$formattedTimestamp]['duration']+= $query->getDuration();
if($this->examples) {
$this->examples->addQuery($query);
}
}
function & getQuery() {
return $this->examples->getLastQuery();
}
function getNormalizedText() {
return $this->normalizedText;
}
function getTotalDuration() {
return $this->duration;
}
function getTimesExecuted() {
return $this->count;
}
function getAverageDuration() {
$average = 0;
if($this->count > 0) {
$average = ($this->duration/$this->count);
}
return $average;
}
function & getFilteredExamplesArray() {
$returnExamples = false;
$examples =& $this->examples->getSortedQueries();
$exampleCount = count($examples);
for($i = 0; $i < $exampleCount; $i++) {
$example =& $examples[$i];
if($example->getText() != $this->getNormalizedText()) {
return $examples;
}
unset($example);
}
$examples = array();
return $examples;
}
function & getHourlyStatistics() {
ksort($this->hourlyStatistics);
return $this->hourlyStatistics;
}
}
?>
|