function devel_queries

File

./devel.module, line 2059

Code

function devel_queries() {
    $header = array(
        array(
            'data' => t('Total (ms)'),
            'field' => 'total_time',
            'sort' => 'desc',
        ),
        array(
            'data' => t('Average (ms)'),
            'field' => 'average',
            'sort' => 'desc',
        ),
        array(
            'data' => t('Std deviation (ms)'),
        ),
        array(
            'data' => t('Count'),
            'field' => 'count',
        ),
        array(
            'data' => t('Function'),
            'field' => 'q.function',
        ),
        array(
            'data' => t('Query'),
            'field' => 'q.query',
        ),
    );
    global $db_type;
    if ($db_type == 'pgsql') {
        $result = pager_query('SELECT q.qid, q.query, q.function , t.* FROM {devel_queries} q INNER JOIN (SELECT t.qid, COUNT(t.qid) AS count,SUM(t.time) AS total_time, AVG(t.time) AS average, STDDEV(t.time) AS stddev FROM {devel_times} t GROUP BY t.qid) AS t ON t.qid=q.qid ' . tablesort_sql($header), 30, 0, 'SELECT COUNT(qid) FROM {devel_queries}');
    }
    else {
        $result = pager_query('SELECT q.qid, q.query, q.function, t.*, COUNT(t.qid) AS count, SUM(t.time) AS total_time, AVG(t.time) AS average, STDDEV(t.time) AS stddev FROM {devel_queries} q INNER JOIN {devel_times} t ON q.qid = t.qid GROUP BY t.qid ' . tablesort_sql($header), 30, 0, 'SELECT COUNT(qid) FROM {devel_queries}');
    }
    while ($log = db_fetch_object($result)) {
        $rows[] = array(
            round($log->total_time * 1000, 3),
            round($log->average * 1000, 3),
            round($log->stddev * 1000, 3),
            $log->count,
            $log->function,
            check_plain($log->query),
        );
    }
    $output = theme('table', $header, $rows);
    $output .= theme('pager', NULL, 30, 0);
    $output .= l(t('Delete collected query statistics'), 'devel/queries/empty');
    print theme('page', $output, FALSE);
}