--- pgbadger-7.1.orig/debian/changelog +++ pgbadger-7.1/debian/changelog @@ -0,0 +1,35 @@ +pgbadger (7.1-0.1) unstable; urgency=medium + + * Non-maintainer upload (Cyril Bouthors is unfortunately MIA). + * New upstream release (Closes: #785216). + * Suggest libjson-xs-perl for JSON statistics exports. + * Added watch file. + * Increased Standards-Version to 3.9.6 (no changes). + + -- Marc Dequènes (Duck) Sat, 26 Sep 2015 13:09:32 +0200 + +pgbadger (3.3-2) unstable; urgency=low + + * Fixed debian/copyright file + + -- Cyril Bouthors Wed, 01 May 2013 22:23:30 +0200 + +pgbadger (3.3-1) unstable; urgency=low + + * New upstream release + + -- Cyril Bouthors Wed, 01 May 2013 22:11:23 +0200 + +pgbadger (3.2-1) unstable; urgency=low + + * New upstream release + * Fixed dependencies thanks to Marc Fournier + (closes: #704996). + + -- Cyril Bouthors Mon, 08 Apr 2013 18:56:55 +0200 + +pgbadger (1.0-1) unstable; urgency=low + + * Initial release (closes: #679362). + + -- Cyril Bouthors Sun, 27 Jan 2013 02:06:14 +0100 --- pgbadger-7.1.orig/debian/compat +++ pgbadger-7.1/debian/compat @@ -0,0 +1 @@ +5 --- pgbadger-7.1.orig/debian/control +++ pgbadger-7.1/debian/control @@ -0,0 +1,24 @@ +Source: pgbadger +Section: admin +Priority: optional +Maintainer: Cyril Bouthors +Uploaders: Cyril Bouthors , + Cyril Bouthors +Build-Depends: debhelper (>= 5) +Standards-Version: 3.9.6 + +Package: pgbadger +Architecture: all +Depends: ${misc:Depends}, ${perl:Depends} +Suggests: libtext-csv-xs-perl, libjson-xs-perl +Description: Fast PostgreSQL log analysis report + pgBadger is a PostgreSQL log analyzer build for speed with fully detailed + reports from your PostgreSQL log file. It's a single and small script written + in pure Perl language. + . + It uses a javascript library to draw graphs so that you don't need additional + Perl modules or any other package to install. Furthermore, this library gives + us more features such as zooming. + . + pgBadger is able to autodetect your log file format (syslog, stderr or csvlog). + It is designed to parse huge log files as well as gzip compressed file. --- pgbadger-7.1.orig/debian/copyright +++ pgbadger-7.1/debian/copyright @@ -0,0 +1,32 @@ +This package was debianized by Cyril Bouthors on +Sun Jan 27 02:09:25 CET 2013 + +It was downloaded from + +Upstream Author: + + Gilles Darold + +Copyright: + + + +License: + +Copyright (c) 2012-2013, Dalibo + +Permission to use, copy, modify, and distribute this software and its +documentation for any purpose, without fee, and without a written agreement +is hereby granted, provided that the above copyright notice and this +paragraph and the following two paragraphs appear in all copies. + +IN NO EVENT SHALL Dalibo BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, +SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, +ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF +Dalibo HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. + +Dalibo SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED +TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR +PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND Dalibo +HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, +OR MODIFICATIONS. --- pgbadger-7.1.orig/debian/rules +++ pgbadger-7.1/debian/rules @@ -0,0 +1,4 @@ +#!/usr/bin/make -f +# -*- makefile -*- +%: + dh $@ --- pgbadger-7.1.orig/debian/watch +++ pgbadger-7.1/debian/watch @@ -0,0 +1,2 @@ +version=3 +https://github.com/dalibo/pgbadger/releases /dalibo/pgbadger/archive/v([0-9.]+).zip --- pgbadger-7.1.orig/out.html +++ pgbadger-7.1/out.html @@ -0,0 +1,18281 @@ + + + +pgBadger :: PostgreSQL Log Analyzer + + + + + + + + + + + + +


+
+ +
    + +
  • + +

    Overview

    + +
    +

    Global Stats

    +
    + +
    +
    +
      +
    • 29 Number of unique normalized queries
      • +
    • 42 Number of queries
      • +
    • 396ms Total query duration
      • +
    • 2015-09-26 10:54:21 First query
      • +
    • 2015-09-26 10:56:27 Last query
      • +
    • 12 queries/s at 2015-09-26 10:54:50 Query peak
      • +
    +
    +
    +
      +
    • 3 Number of events
      • +
    • 2 Number of unique normalized events
      • +
    • 2 Max number of times the same event was reported
      • +
    • 0 Number of cancellation
      • +
    +
    +
    +
      +
    • 0 Total number of automatic vacuums
      • +
    • 0 Total number of automatic analyzes
      • +
    +
    +
    +
      +
    • 0 Number temporary file
      • +
    • 0 Max size of temporary file
      • +
    • 0.00 Average size of temporary file
      • +
    +
    +
    +
      +
    • 17 Total number of sessions
      • +
    • 3 sessions at 2015-09-26 10:55:20 Session peak
      • +
    • 532ms Total duration of sessions
      • +
    • 31ms Average duration of sessions
      • +
    • 2 Average queries per session
      • +
    • 23ms Average queries duration per session
      • + +
    +
    +
    +
      +
    • 19 Total number of connections
      • + +
    • 2 connections/s at 2015-09-26 10:54:22 Connection peak
      • + +
    • 3 Total number of databases
      • +
    +
    +
    +
    +
    + +
    +

    SQL Traffic

    +
    +

    Key values

    +
    +
      +
    • 12 queries/s Query Peak
      • +
    • 2015-09-26 10:54:50 Date
      • +
    +
    +
    +
    +

    Queries per second (5 minutes average)

    +
    + + +
    +
    + +
    +

    SELECT Traffic

    +
    +

    Key values

    +
    +
      +
    • 12 queries/s Query Peak
      • +
    • 2015-09-26 10:54:50 Date
      • +
    +
    +
    +
    +

    SELECT queries per second (5 minutes average)

    +
    + + +
    +
    + +
    +

    INSERT/UPDATE/DELETE Traffic

    +
    +

    Key values

    +
    +
      +
    • 0 queries/s Query Peak
      • +
    • 2015-09-26 10:55:20 Date
      • +
    +
    +
    +
    +

    Write queries per second (5 minutes average)

    +
    + + +
    +
    + +
    +

    Queries duration

    +
    +

    Key values

    +
    +
      +
    • 396ms Total query duration
      • +
    +
    +
    +
    +

    Average queries duration (5 minutes average)

    +
    + + +
    +
    + +
    +

    Prepared queries ratio

    +
    +

    Key values

    +
    +
      +
    • 1.00 Ratio of bind vs prepare
      • +
    • 12.12 % Ratio between prepared and "usual" statements
      • +
    +
    +
    +
    +

    Ratio of bind vs prepare statements (5 minutes average)

    +
    + + +
    +
    + +
    +

    General Activity

    +
    + +
    +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
    DayHourCountMin durationMax durationAvg durationLatency Percentile(90)Latency Percentile(95)Latency Percentile(99)
    Sep 2610420s80ms9ms204ms204ms204ms
    +
    +
    + + + + + + + + + + + + + + + + + + + + + + + + +
    DayHourCountAverage DurationLatency Percentile(90)Latency Percentile(95)Latency Percentile(99)
    Sep 26103311ms204ms204ms204ms
    +
    +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + +
    DayHourINSERTUPDATEDELETEAverage DurationLatency Percentile(90)Latency Percentile(95)Latency Percentile(99)
    Sep 26100000s0s0s0s
    +
    +
    + + + + + + + + + + + + + + + + + + + + + +
    DayHourPrepareBindBind/PreparePercentage of prepare
    Sep 2610441.0012.12%
    +
    +
    + + + + + + + + + + + + + + + + + +
    DayHourCountAverage / Second
    Sep 2610190.01/s
    +
    +
    + + + + + + + + + + + + + + + + + +
    DayHourCountAverage Duration
    Sep 26101731ms
    +
    +
    + ↑ Back to the top of the General Activity table +
    + +
    + +
    • +
  • +

    Connections

    + + +
    +

    Established Connections

    +
    +

    Key values

    +
    +
      +
    • 2 connections Connection Peak
      • +
    • 2015-09-26 10:54:22 Date
      • +
    +
    +
    +
    +

    Connections per second (5 minutes average)

    +
    + + +
    +
    + +
    +

    Connections per database

    +
    +

    Key values

    +
    +
      +
    • postgres Main Database
      • +
    • 19 connections Total
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + +
    DatabaseUserCount
    dc_prosody 1
     dc_prosody1
    postgres 17
     postgres3
     zabbix14
    ratbox_services 1
     ircserv1
    +
    +
    +
    +
    +
    + +
    +

    Connections per user

    +
    +

    Key values

    +
    +
      +
    • zabbix Main User
      • +
    • 19 connections Total
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + +
    UserCount
    dc_prosody1
    ircserv1
    postgres3
    zabbix14
    +
    +
    +
    +
    +
    + +
    +

    Connections per host

    +
    +

    Key values

    +
    +
      +
    • [local] Main host with 17 connections
      • +
    • 19 Total connections
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + +
    HostCount
    127.0.0.11
    ::11
    [local]17
    +
    +
    +
    +
    +
    + +
    • +
  • +

    Sessions

    + + +
    +

    Simultaneous sessions

    +
    +

    Key values

    +
    +
      +
    • 3 sessions Session Peak
      • +
    • 2015-09-26 10:55:20 Date
      • +
    +
    +
    +
    +

    Number of sessions (5 minutes average)

    +
    + + +
    +
    + +

    Top Queries

    +
    +

    Histogram of session times

    +
    +

    Key values

    +
    +
      +
    • 17 0-500ms duration
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + +
    RangeCountPercentage
    0s-500ms17100.00%
    500ms-1s00.00%
    1s-30s00.00%
    30s-1m00.00%
    1m-10m00.00%
    10m-30m00.00%
    30m-1h00.00%
    1h-8h00.00%
    > 8h00.00%
    +
    +
    +
    +
    +
    + +
    +

    Sessions per database

    +
    +

    Key values

    +
    +
      +
    • postgres Main Database
      • +
    • 17 sessions Total
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + + +
    DatabaseUserCountTotal DurationAverage Duration
    postgres17532ms31ms
    +
    +
    +
    +
    +
    + +
    +

    Sessions per user

    +
    +

    Key values

    +
    +
      +
    • zabbix Main User
      • +
    • 17 sessions Total
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + +
    UserCountTotal DurationAverage Duration
    postgres3177ms
    zabbix14355ms +
    +
    +
    +
    +
    +
    + +
    +

    Sessions per host

    +
    +

    Key values

    +
    +
      +
    • [local] Main Host
      • +
    • 17 sessions Total
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    HostCountTotal DurationAverage Duration
    [local]17532ms31ms
    +
    +
    +
    +
    +
    + +
    +

    Sessions per application

    +
    +

    Key values

    +
    +
      +
    • psql Main Host
      • +
    • 17 sessions Total
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    ApplicationCountTotal DurationAverage Duration
    psql17532ms31ms
    +
    +
    +
    +
    +
    + +
    • +
  • + +

    Checkpoints / Restartpoints

    + +
    +

    Checkpoints Buffers

    +
    +

    Key values

    +
    +
      +
    • 0 buffers Checkpoint Peak
      • +
    • Date
      • +
    • seconds Highest write time
      • +
    • seconds Sync time
      • +
    +
    +
    +
    +

    Checkpoint write buffers (5 minutes average)

    + +
    NO DATASET
    + +
    +
    + +
    +

    Checkpoints Wal files

    +
    +

    Key values

    +
    +
      +
    • 0 files Wal files usage Peak
      • +
    • Date
      • +
    +
    +
    +
    +

    Checkpoint Wal files usage (5 minutes average)

    + +
    NO DATASET
    + +
    +
    + +
    +

    Checkpoints Activity

    +
    + +
    +
    + + + + + + + + + + + + + +
    DayHourWritten buffersWrite timeSync timeTotal time
    Sep 261000s0s0s
    +
    +
    + + + + + + + + + + + + + + + +
    DayHourAddedRemovedRecycledSynced filesLongest syncAverage sync
    Sep 261000000s0s
    +
    +
    + + + + + + + + + + + +
    DayHourCountAvg time (sec)
    Sep 261000s
    +
    +
    + ↑ Back to the top of the Checkpoint Activity table +
    + +
    + +
    • +
  • + +

    Temporary Files

    + +
    +

    Size of temporary files

    +
    +

    Key values

    +
    +
      +
    • 0 Temp Files Peak
      • +
    • 2015-09-26 10:55:20 Date
      • +
    +
    +
    +
    +

    Size of temporary files (5 minutes average)

    + +
    NO DATASET
    + +
    +
    + +
    +

    Number of temporary files

    +
    +

    Key values

    +
    +
      +
    • 0 per second Temp Files Peak
      • +
    • 2015-09-26 10:55:20 Date
      • +
    +
    +
    +
    +

    Number of temporary files (5 minutes average)

    + +
    NO DATASET
    + +
    +
    + +
    +

    Temporary Files Activity

    +
    + +
    +
    + + + + + + + + + + + +
    DayHourCountAverage size
    Sep 261000
    +
    +
    + ↑ Back to the top of the Temporay Files Activity table +
    + +
    + +
    • +
  • + +

    Vacuums

    + +
    +

    Vacuums / Analyzes Distribution

    +
    +

    Key values

    +
    +
      +
    • 0 sec Highest CPU-cost vacuum
      Table
      Database
      • +
    • Date
      • +
    • 0 sec Highest CPU-cost analyze
      Table
      Database
      • +
    • Date
      • +
    +
    +
    +
    +

    Autovacuum actions (5 minutes average)

    +
    + + +
    +
    + +
    +

    Analyses per table

    +
    +

    Key values

    +
    +
      +
    • unknown (0) Main table analyzed (database )
      • +
    • 0 analyzes Total
      • +
    +
    +
    +
    +
    + +
    +
    + +
    NO DATASET
    + +
    +
    + + + + + + + + + + +
    TableNumber of analyzes
    NO DATASET
    +
    +
    +
    +
    +
    + +
    +

    Vacuums per table

    +
    +

    Key values

    +
    +
      +
    • unknown (0) Main table vacuumed on database
      • +
    • 0 vacuums Total
      • +
    +
    +
    +
    +
    + +
    +
    + +
    NO DATASET
    + +
    +
    + + + + + + + + + + + +
    TableNumber of vacuumsIndex scans
    NO DATASET
    +
    +
    +
    +
    +
    + +
    +

    Tuples removed per table

    +
    +

    Key values

    +
    +
      +
    • unknown (0) Main table with removed tuples on database
      • +
    • 0 tuples Total removed
      • +
    +
    +
    +
    +
    + +
    +
    + +
    NO DATASET
    + +
    +
    + + + + + + + + + + + + + +
    TableNumber of vacuumsIndex scansTuples removedPages removed
    NO DATASET
    +
    +
    +
    +
    +
    + +
    +

    Pages removed per table

    +
    +

    Key values

    +
    +
      +
    • unknown (0) Main table with removed pages on database
      • +
    • 0 pages Total removed
      • +
    +
    +
    +
    +
    + +
    +
    + +
    NO DATASET
    + +
    +
    + + + + + + + + + + + + + +
    TableNumber of vacuumsIndex scansTuples removedPages removed
    NO DATASET
    +
    +
    +
    +
    +
    + +
    +

    Autovacuum Activity

    +
    + +
    +
    + + + + + + + + + + + +
    DayHourVACUUMsANALYZEs
    Sep 261000
    +
    +
    + ↑ Back to the top of the Temporay Files Activity table +
    + +
    + +
    • +
  • + +

    Locks

    +
    +

    Locks by types

    +
    +

    Key values

    +
    +
      +
    • unknown Main Lock Type
      • +
    • 0 locks Total
      • +
    +
    +
    +
    +
    + +
    +
    + +
    NO DATASET
    + +
    +
    + + + + + + + + + + + + + +
    TypeObjectCountTotal DurationAverage Duration (s)
    NO DATASET
    +
    +
    +
    +
    +
    + +
    +

    Most frequent waiting queries (N)

    +
    + + + + + + + + + + + + + + + +
    RankCountTotal timeMin timeMax timeAvg durationQuery
    NO DATASET
    +
    +
    + +
    +

    Queries that waited the most

    +
    + + + + + + + + + + + +
    RankWait timeQuery
    NO DATASET
    +
    +
    + +
    • +
  • + +

    Queries

    +
    +

    Queries by type

    +
    +

    Key values

    +
    +
      +
    • 33 Total read queries
      • +
    • 0 Total write queries
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + +
    TypeCountPercentage
    SELECT3378.57%
    INSERT00.00%
    UPDATE00.00%
    DELETE00.00%
    OTHERS921.43%
    +
    +
    +
    +
    +
    + +
    +

    Queries by database

    +
    +

    Key values

    +
    +
      +
    • postgres Main database
      • +
    • 17 Requests
      • +
    • 255ms (postgres)
      • +
    • Main time consuming database
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    DatabaseRequest typeCountDuration
    dc_prosodyTotal130s
    OTHERS90s
    SELECT40s
    postgresTotal17255ms
    SELECT17255ms
    ratbox_servicesTotal12139ms
    SELECT12139ms
    +
    +
    +
    +
    +
    + +
    +

    Queries by user

    +
    +

    Key values

    +
    +
      +
    • zabbix Main user
      • +
    • 14 Requests
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    UserRequest typeCountDuration
    dc_prosodyTotal130s
    OTHERS90s
    SELECT40s
    ircservTotal12139ms
    SELECT12139ms
    postgresTotal364ms
    SELECT364ms
    zabbixTotal14191ms
    SELECT14191ms
    +
    +
    +
    +
    +
    + +
    +

    Duration by user

    +
    +

    Key values

    +
    +
      +
    • 191ms (zabbix) Main time consuming user
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    UserRequest typeCountDuration
    dc_prosodyTotal130s
    OTHERS90s
    SELECT40s
    ircservTotal12139ms
    SELECT12139ms
    postgresTotal364ms
    SELECT364ms
    zabbixTotal14191ms
    SELECT14191ms
    +
    +
    +
    +
    +
    + +
    +

    Queries by host

    +
    +

    Key values

    +
    +
      +
    • unknown Main host
      • +
    • 42 Requests
      • +
    • 396ms (unknown)
      • +
    • Main time consuming host
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    HostRequest typeCountDuration
    unknownTotal42396ms
    OTHERS90s
    SELECT33395ms
    +
    +
    +
    +
    +
    + +
    +

    Queries by application

    +
    +

    Key values

    +
    +
      +
    • [unknown] Main application
      • +
    • 25 Requests
      • +
    • 255ms (psql)
      • +
    • Main time consuming application
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + + +
    ApplicationRequest typeCountDuration
    [unknown]Total25140ms
    OTHERS90s
    SELECT16140ms
    psqlTotal17255ms
    SELECT17255ms
    +
    +
    +
    +
    +
    + +
    +

    Number of cancelled queries

    +
    +

    Key values

    +
    +
      +
    • 0 per second Cancelled query Peak
      • +
    • 2015-09-26 10:55:20 Date
      • +
    +
    +
    +
    +

    Number of cancelled queries (5 minutes average)

    + +
    NO DATASET
    + +
    +
    + +
    • +
  • + +

    Top Queries

    +
    +

    Histogram of query times

    +
    +

    Key values

    +
    +
      +
    • 21 0-1ms duration
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + +
    RangeCountPercentage
    0-1ms2150.00%
    1-5ms614.29%
    5-10ms12.38%
    10-25ms1023.81%
    25-50ms12.38%
    50-100ms37.14%
    100-500ms00.00%
    500-1000ms00.00%
    1000-10000ms00.00%
    > 10000ms00.00%
    +
    +
    +
    +
    +
    + +
    +

    Slowest individual queries

    +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
    RankDurationQuery
    180ms +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:13 - Database: postgres - User: zabbix - Application: psql ]
    + +
    266ms +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    + 
    [ Date: 2015-09-26 10:54:50 - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + +
    361ms +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    + 
    [ Date: 2015-09-26 10:54:21 - Database: postgres - User: postgres - Application: psql ]
    + +
    434ms +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    + 
    [ Date: 2015-09-26 10:54:50 - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + +
    523ms +
    SELECT + chname, + username, + lastmod, + LEVEL, + flags, + suspend +FROM + members; +
    + 
    [ Date: 2015-09-26 10:54:50 - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + +
    612ms +
    SELECT + round ( + blks_hit * 100 / ( + blks_hit + blks_read ), + 2 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards' + AND blks_read > 0 +UNION + ALL +SELECT + 0.00 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 1; +
    + 
    [ Date: 2015-09-26 10:55:13 - Database: postgres - User: zabbix - Application: psql ]
    + +
    712ms +
    SELECT + tup_fetched +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:20 - Database: postgres - User: zabbix - Application: psql ]
    + +
    812ms +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:19 - Database: postgres - User: zabbix - Application: psql ]
    + +
    911ms +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:17 - Database: postgres - User: zabbix - Application: psql ]
    + +
    1011ms +
    SELECT + tup_returned +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:23 - Database: postgres - User: zabbix - Application: psql ]
    + +
    1111ms +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:16 - Database: postgres - User: zabbix - Application: psql ]
    + +
    1211ms +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:14 - Database: postgres - User: zabbix - Application: psql ]
    + +
    1311ms +
    SELECT + temp_bytes +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:19 - Database: postgres - User: zabbix - Application: psql ]
    + +
    1411ms +
    SELECT + tup_inserted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:22 - Database: postgres - User: zabbix - Application: psql ]
    + +
    157ms +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    + 
    [ Date: 2015-09-26 10:54:50 - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + +
    163ms +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    + 
    [ Date: 2015-09-26 10:54:50 - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + +
    172ms +
    SELECT + chname, + tsinfo +FROM + operserv; +
    + 
    [ Date: 2015-09-26 10:54:50 - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + +
    181ms +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    + 
    [ Date: 2015-09-26 10:55:23 - Database: postgres - User: zabbix - Application: psql ]
    + +
    191ms +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    + 
    [ Date: 2015-09-26 10:54:22 - Database: postgres - User: postgres - Application: psql ]
    + +
    201ms +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    + 
    [ Date: 2015-09-26 10:54:22 - Database: postgres - User: postgres - Application: psql ]
    + +
    +
    +
    + +
    +

    Time consuming queries

    +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
    RankTotal durationTimes executedMin durationMax durationAvg durationQuery
    180ms1 +

    Details

    +     		80ms80ms80ms +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #1

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610180ms80ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 80ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 80ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:13 - Duration: 80ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    266ms1 +

    Details

    +     		66ms66ms66ms +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    + +
    +

    Times Reported Time consuming queries #2

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610166ms66ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 66ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 66ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 66ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    364ms3 +

    Details

    +     		1ms61ms21ms +
    SELECT + d.datname AS "name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "encoding", + d.datcollate AS "collate", + d.datctype AS "ctype", + pg_catalog.array_to_string ( + d.datacl, + e '' ) AS "access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 0; +
    + +
    +

    Times Reported Time consuming queries #3

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610364ms21ms
    +

    +
    +

    + + +
    +
    + + 
    [User: postgres - Total duration: 64ms - Times executed: 3 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 64ms - Times executed: 3 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:21 - Duration: 61ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:22 - Duration: 1ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:22 - Duration: 1ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +

    +
    + +
    434ms1 +

    Details

    +     		34ms34ms34ms +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    + +
    +

    Times Reported Time consuming queries #4

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610134ms34ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 34ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 34ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 34ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    523ms1 +

    Details

    +     		23ms23ms23ms +
    SELECT + chname, + username, + lastmod, + LEVEL, + flags, + suspend +FROM + members; +
    + +
    +

    Times Reported Time consuming queries #5

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610123ms23ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 23ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 23ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + chname, + username, + lastmod, + LEVEL, + flags, + suspend +FROM + members; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 23ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    612ms1 +

    Details

    +     		12ms12ms12ms +
    SELECT + round ( + blks_hit * 0 / ( + blks_hit + blks_read ), + 0 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = '' + AND blks_read > 0 +UNION + ALL +SELECT + 0.0 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 0; +
    + +
    +

    Times Reported Time consuming queries #6

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + round ( + blks_hit * 100 / ( + blks_hit + blks_read ), + 2 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards' + AND blks_read > 0 +UNION + ALL +SELECT + 0.00 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 1; +
    +
    + 
    [ Date: 2015-09-26 10:55:13 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    712ms1 +

    Details

    +     		12ms12ms12ms +
    SELECT + tup_fetched +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #7

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + tup_fetched +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:20 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    812ms1 +

    Details

    +     		12ms12ms12ms +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #8

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:19 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    911ms1 +

    Details

    +     		11ms11ms11ms +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #9

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:17 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1011ms1 +

    Details

    +     		11ms11ms11ms +
    SELECT + tup_returned +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #10

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + tup_returned +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:23 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1111ms1 +

    Details

    +     		11ms11ms11ms +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #11

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:16 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1211ms1 +

    Details

    +     		11ms11ms11ms +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #12

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:14 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1311ms1 +

    Details

    +     		11ms11ms11ms +
    SELECT + temp_bytes +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #13

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + temp_bytes +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:19 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1411ms1 +

    Details

    +     		11ms11ms11ms +
    SELECT + tup_inserted +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #14

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + tup_inserted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:22 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    157ms1 +

    Details

    +     		7ms7ms7ms +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    + +
    +

    Times Reported Time consuming queries #15

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261017ms7ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 7ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 7ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 7ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    163ms1 +

    Details

    +     		3ms3ms3ms +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    + +
    +

    Times Reported Time consuming queries #16

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261013ms3ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 3ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 3ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 3ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    172ms1 +

    Details

    +     		2ms2ms2ms +
    SELECT + chname, + tsinfo +FROM + operserv; +
    + +
    +

    Times Reported Time consuming queries #17

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261012ms2ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 2ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 2ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + chname, + tsinfo +FROM + operserv; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 2ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    181ms1 +

    Details

    +     		1ms1ms1ms +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #18

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261011ms1ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:23 - Duration: 1ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    191ms1 +

    Details

    +     		1ms1ms1ms +
    SELECT + pg_database_size ( + '' ); +
    + +
    +

    Times Reported Time consuming queries #19

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261011ms1ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + pg_database_size ( + 'duck_jp-cards' ); +
    +
    + 
    [ Date: 2015-09-26 10:55:16 - Duration: 1ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    200s2 +

    Details

    +     		0s0s0s +
    SELECT 0; +
    + +
    +

    Times Reported Time consuming queries #20

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261020s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 0s - Times executed: 2 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 0s - Times executed: 2 ]
+
    + +
    +

    +
    + + + +
    +
    + +
    +
    SELECT + 1; +
    +
    + 
    [ Date: 2015-09-26 10:55:49 - Duration: 0s - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +
    SELECT + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:48 - Duration: 0s - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    +
    +
    + +
    +

    Most frequent queries (N)

    +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
    RankTimes executedTotal durationMin durationMax durationAvg durationQuery
    15 +

    Details

    +     		0s0s0s0s +
    BEGIN; +
    + +
    +

    Times Reported Time consuming queries #1

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261050s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: dc_prosody - Total duration: 0s - Times executed: 5 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 5 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    BEGIN; +
    +
    + 
    [ Date: 2015-09-26 10:54:27 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] ]
    + + +
    +
    BEGIN; +
    +
    + 
    [ Date: 2015-09-26 10:56:27 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] ]
    + + +
    +
    BEGIN; +
    +
    + 
    [ Date: 2015-09-26 10:55:35 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] ]
    + + +
    +

    +
    + +
    24 +

    Details

    +     		0s0s0s0s +
    COMMIT; +
    + +
    +

    Times Reported Time consuming queries #2

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261040s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: dc_prosody - Total duration: 0s - Times executed: 4 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 4 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    COMMIT; +
    +
    + 
    [ Date: 2015-09-26 10:56:27 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] ]
    + + +
    +
    COMMIT; +
    +
    + 
    [ Date: 2015-09-26 10:55:27 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] ]
    + + +
    +
    COMMIT; +
    +
    + 
    [ Date: 2015-09-26 10:55:35 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] ]
    + + +
    +

    +
    + +
    34 +

    Details

    +     		0s0s0s0s +
    SELECT + * +FROM + "prosody" +WHERE + "host" = '' + AND "user" = '' + AND "store" = ''; +
    + +
    +

    Times Reported Time consuming queries #3

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261040s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: dc_prosody - Total duration: 0s - Times executed: 4 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 4 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + * +FROM + "prosody" +WHERE + "host" = 'milkypond.org' + AND "user" = 'duck' + AND "store" = 'privacy'; +
    +
    + 
    [ Date: 2015-09-26 10:54:27 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] - Bind query: yes ]
    + + +
    +
    SELECT + * +FROM + "prosody" +WHERE + "host" = 'milkypond.org' + AND "user" = 'duck' + AND "store" = 'privacy'; +
    +
    + 
    [ Date: 2015-09-26 10:55:27 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] - Bind query: yes ]
    + + +
    +
    SELECT + * +FROM + "prosody" +WHERE + "host" = 'milkypond.org' + AND "user" = 'duck' + AND "store" = 'privacy'; +
    +
    + 
    [ Date: 2015-09-26 10:55:35 - Duration: 0s - Database: dc_prosody - User: dc_prosody - Application: [unknown] - Bind query: yes ]
    + + +
    +

    +
    + +
    43 +

    Details

    +     		64ms1ms61ms21ms +
    SELECT + d.datname AS "name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "encoding", + d.datcollate AS "collate", + d.datctype AS "ctype", + pg_catalog.array_to_string ( + d.datacl, + e '' ) AS "access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 0; +
    + +
    +

    Times Reported Time consuming queries #4

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610364ms21ms
    +

    +
    +

    + + +
    +
    + + 
    [User: postgres - Total duration: 64ms - Times executed: 3 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 64ms - Times executed: 3 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:21 - Duration: 61ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:22 - Duration: 1ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:22 - Duration: 1ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +

    +
    + +
    52 +

    Details

    +     		0s0s0s0s +
    SELECT 0; +
    + +
    +

    Times Reported Time consuming queries #5

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261020s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 0s - Times executed: 2 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 0s - Times executed: 2 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + 1; +
    +
    + 
    [ Date: 2015-09-26 10:55:49 - Duration: 0s - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +
    SELECT + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:48 - Duration: 0s - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    61 +

    Details

    +     		80ms80ms80ms80ms +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #6

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610180ms80ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 80ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 80ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:13 - Duration: 80ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    71 +

    Details

    +     		12ms12ms12ms12ms +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #7

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:19 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    81 +

    Details

    +     		1ms1ms1ms1ms +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #8

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261011ms1ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:23 - Duration: 1ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    91 +

    Details

    +     		34ms34ms34ms34ms +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    + +
    +

    Times Reported Time consuming queries #9

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610134ms34ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 34ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 34ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 34ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    101 +

    Details

    +     		11ms11ms11ms11ms +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #10

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:14 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    111 +

    Details

    +     		12ms12ms12ms12ms +
    SELECT + round ( + blks_hit * 0 / ( + blks_hit + blks_read ), + 0 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = '' + AND blks_read > 0 +UNION + ALL +SELECT + 0.0 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 0; +
    + +
    +

    Times Reported Time consuming queries #11

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + round ( + blks_hit * 100 / ( + blks_hit + blks_read ), + 2 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards' + AND blks_read > 0 +UNION + ALL +SELECT + 0.00 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 1; +
    +
    + 
    [ Date: 2015-09-26 10:55:13 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    121 +

    Details

    +     		11ms11ms11ms11ms +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #12

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:17 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    131 +

    Details

    +     		66ms66ms66ms66ms +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    + +
    +

    Times Reported Time consuming queries #13

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610166ms66ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 66ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 66ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 66ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    141 +

    Details

    +     		7ms7ms7ms7ms +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    + +
    +

    Times Reported Time consuming queries #14

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261017ms7ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 7ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 7ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 7ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    151 +

    Details

    +     		3ms3ms3ms3ms +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    + +
    +

    Times Reported Time consuming queries #15

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261013ms3ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 3ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 3ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 3ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    161 +

    Details

    +     		0s0s0s0s +
    SELECT + id, + parent_id, + regex, + oper +FROM + operbans_regexp_neg; +
    + +
    +

    Times Reported Time consuming queries #16

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261010s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + id, + parent_id, + regex, + oper +FROM + operbans_regexp_neg; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 0s - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    171 +

    Details

    +     		2ms2ms2ms2ms +
    SELECT + chname, + tsinfo +FROM + operserv; +
    + +
    +

    Times Reported Time consuming queries #17

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261012ms2ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 2ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 2ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + tsinfo +FROM + operserv; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 2ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    181 +

    Details

    +     		0s0s0s0s +
    SELECT + id, + text +FROM + global_welcome; +
    + +
    +

    Times Reported Time consuming queries #18

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261010s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + id, + text +FROM + global_welcome; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 0s - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    191 +

    Details

    +     		0s0s0s0s +
    SELECT + hostname, + oper, + reason +FROM + ignore_hosts; +
    + +
    +

    Times Reported Time consuming queries #19

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261010s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + hostname, + oper, + reason +FROM + ignore_hosts; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 0s - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    201 +

    Details

    +     		11ms11ms11ms11ms +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #20

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:16 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    +
    +
    + +
    +

    Normalized slowest queries (N)

    +
    + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
    RankMin durationMax durationAvg durationTimes executedTotal durationQuery
    180ms80ms80ms1 +

    Details

    +     		80ms +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #1

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610180ms80ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 80ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 80ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + numbackends +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:13 - Duration: 80ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    266ms66ms66ms1 +

    Details

    +     		66ms +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    + +
    +

    Times Reported Time consuming queries #2

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610166ms66ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 66ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 66ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + username, + PASSWORD, + email, + suspender, + suspend_reason, + suspend_time, + reg_time, + last_time, + flags, + LANGUAGE, + id +FROM + users; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 66ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    334ms34ms34ms1 +

    Details

    +     		34ms +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    + +
    +

    Times Reported Time consuming queries #3

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610134ms34ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 34ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 34ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + topic, + url, + createmodes, + enforcemodes, + tsinfo, + reg_time, + last_time, + flags, + suspender, + suspend_reason, + suspend_time +FROM + channels; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 34ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    423ms23ms23ms1 +

    Details

    +     		23ms +
    SELECT + chname, + username, + lastmod, + LEVEL, + flags, + suspend +FROM + members; +
    + +
    +

    Times Reported Time consuming queries #4

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610123ms23ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 23ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 23ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + username, + lastmod, + LEVEL, + flags, + suspend +FROM + members; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 23ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    51ms61ms21ms3 +

    Details

    +     		64ms +
    SELECT + d.datname AS "name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "encoding", + d.datcollate AS "collate", + d.datctype AS "ctype", + pg_catalog.array_to_string ( + d.datacl, + e '' ) AS "access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 0; +
    + +
    +

    Times Reported Time consuming queries #5

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610364ms21ms
    +

    +
    +

    + + +
    +
    + + 
    [User: postgres - Total duration: 64ms - Times executed: 3 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 64ms - Times executed: 3 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:21 - Duration: 61ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:22 - Duration: 1ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +
    SELECT + d.datname AS "Name", + pg_catalog.pg_get_userbyid ( + d.datdba ) AS "Owner", + pg_catalog.pg_encoding_to_char ( + d.encoding ) AS "Encoding", + d.datcollate AS "Collate", + d.datctype AS "Ctype", + pg_catalog.array_to_string ( + d.datacl, + E '\n' ) AS "Access privileges" +FROM + pg_catalog.pg_database d +ORDER BY + 1; +
    +
    + 
    [ Date: 2015-09-26 10:54:22 - Duration: 1ms - Database: postgres - User: postgres - Application: psql ]
    + + +
    +

    +
    + +
    612ms12ms12ms1 +

    Details

    +     		12ms +
    SELECT + round ( + blks_hit * 0 / ( + blks_hit + blks_read ), + 0 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = '' + AND blks_read > 0 +UNION + ALL +SELECT + 0.0 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 0; +
    + +
    +

    Times Reported Time consuming queries #6

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + round ( + blks_hit * 100 / ( + blks_hit + blks_read ), + 2 ) AS cache_hit_ratio +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards' + AND blks_read > 0 +UNION + ALL +SELECT + 0.00 AS cache_hit_ratio +ORDER BY + cache_hit_ratio DESC +LIMIT 1; +
    +
    + 
    [ Date: 2015-09-26 10:55:13 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    712ms12ms12ms1 +

    Details

    +     		12ms +
    SELECT + tup_fetched +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #7

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_fetched +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:20 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    812ms12ms12ms1 +

    Details

    +     		12ms +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #8

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610112ms12ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 12ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_deleted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:19 - Duration: 12ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    911ms11ms11ms1 +

    Details

    +     		11ms +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #9

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + xact_rollback +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:17 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1011ms11ms11ms1 +

    Details

    +     		11ms +
    SELECT + tup_returned +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #10

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_returned +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:23 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1111ms11ms11ms1 +

    Details

    +     		11ms +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #11

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + deadlocks +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:16 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1211ms11ms11ms1 +

    Details

    +     		11ms +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #12

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + xact_commit +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:14 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1311ms11ms11ms1 +

    Details

    +     		11ms +
    SELECT + temp_bytes +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #13

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + temp_bytes +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:19 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    1411ms11ms11ms1 +

    Details

    +     		11ms +
    SELECT + tup_inserted +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #14

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 2610111ms11ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 11ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_inserted +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:22 - Duration: 11ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    157ms7ms7ms1 +

    Details

    +     		7ms +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    + +
    +

    Times Reported Time consuming queries #15

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261017ms7ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 7ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 7ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + nickname, + username, + reg_time, + last_time, + flags +FROM + nicks; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 7ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    163ms3ms3ms1 +

    Details

    +     		3ms +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    + +
    +

    Times Reported Time consuming queries #16

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261013ms3ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 3ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 3ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + mask, + reason, + username, + LEVEL, + HOLD +FROM + bans; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 3ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    172ms2ms2ms1 +

    Details

    +     		2ms +
    SELECT + chname, + tsinfo +FROM + operserv; +
    + +
    +

    Times Reported Time consuming queries #17

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261012ms2ms
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 2ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 2ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + chname, + tsinfo +FROM + operserv; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 2ms - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    181ms1ms1ms1 +

    Details

    +     		1ms +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = ''; +
    + +
    +

    Times Reported Time consuming queries #18

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261011ms1ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + tup_updated +FROM + pg_stat_database +WHERE + datname = 'duck_jp-cards'; +
    +
    + 
    [ Date: 2015-09-26 10:55:23 - Duration: 1ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    191ms1ms1ms1 +

    Details

    +     		1ms +
    SELECT + pg_database_size ( + '' ); +
    + +
    +

    Times Reported Time consuming queries #19

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261011ms1ms
    +

    +
    +

    + + +
    +
    + + 
    [User: zabbix - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: psql - Total duration: 1ms - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + pg_database_size ( + 'duck_jp-cards' ); +
    +
    + 
    [ Date: 2015-09-26 10:55:16 - Duration: 1ms - Database: postgres - User: zabbix - Application: psql ]
    + + +
    +

    +
    + +
    200s0s0s1 +

    Details

    +     		0s +
    SELECT + id, + parent_id, + regex, + oper +FROM + operbans_regexp_neg; +
    + +
    +

    Times Reported Time consuming queries #20

    +
    + + + + + + + + + + + + + + + +
    DayHourCountDurationAvg duration
    Sep 261010s0s
    +

    +
    +

    + + +
    +
    + + 
    [User: ircserv - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + +
    +
    + + 
    [Application: [unknown] - Total duration: 0s - Times executed: 1 ]
+
    + +
    +

    +
    + + + + +
    +
    + +
    +
    SELECT + id, + parent_id, + regex, + oper +FROM + operbans_regexp_neg; +
    +
    + 
    [ Date: 2015-09-26 10:54:50 - Duration: 0s - Database: ratbox_services - User: ircserv - Application: [unknown] ]
    + + +
    +

    +
    + +
    +
    +
    + +
    • +
  • + +

    Events

    + +
    +

    Log levels

    +
    +

    Key values

    +
    +
      +
    • 123 Log entries
      • +
    +
    +
    +
    +
    + +
    +
    +
    + + +
    +
    + + + + + + + + + + + +
    TypeCountPercentage
    DETAIL86.50%
    FATAL21.63%
    LOG11391.87%
    +
    +
    +
    +
    +
    + +
    +

    Events distribution

    +
    +

    Key values

    +
    +
      +
    • 0 PANIC entries
      • +
    • 2 FATAL entries
      • +
    • 1 ERROR entries
      • +
    • 0 WARNING entries
      • +
    +
    +
    +
    +

    Errors per 5 minutes

    +
    + + +
    +
    + + +
    +

    Most Frequent Errors/Events

    +
    +

    Key values

    +
    +
      +
    • 2 Max number of times the same event was reported
      • +
    • 3 Total events found
      • +
    +
    +
    +
    + + + + + + + + + + + + + + + + + + + + + + + +
    RankTimes reportedError
    12 +

    Details

    +     		+ 
    FATAL:  the database system is starting up
    + +
    +

    Times Reported Most Frequent Error / Event #1

    +
    + + + + + + + + + + + + + +
    DayHourCount
    Sep 26102
    +

    +
    + +

    + + +
    +
    + +
    FATAL: the database system is starting up
    + 
    Date: 2015-09-26 10:54:21
+Database: roundcube User: roundcube Remote:
    + +
    +

    +
    + +
    21 +

    Details

    +     		+ 
    LOG:  database system was shut down at ...
    + +
    +

    Times Reported Most Frequent Error / Event #2

    +
    + + + + + + + + + + + + + +
    DayHourCount
    Sep 26101
    +

    +
    + +

    + + +
    +
    + +
    LOG: database system was shut down at 2015-09-26 10:54:19 GMT
    + 
    Date: 2015-09-26 10:54:20
+
    + +
    +

    +
    + +
    +
    +
    + +
    • +
+
+ + + +
+ +
+ + +