pgBadger
  • Overview
    • Global Stats
    • SQL Traffic
    • Select Traffic
    • Write Traffic
    • Queries duration
    • Prepared queries ratio
    • General Activity
  • Connections
    • Established connections
    • Connections per database
    • Connections per user
    • Connections per host
  • Sessions
    • Simultaneous sessions
    • Histogram of sessions times
    • Sessions per database
    • Sessions per user
    • Sessions per host
    • Sessions per application
  • Checkpoints
    • Checkpoints buffers
    • Checkpoints files
    • Checkpoint activity
  • Temp Files
    • Size of temporary files
    • Number of temporary files
    • Temporary files activity
    • Queries generating the most files (N)
    • Queries generating the largest files
  • Vacuums
    • Vacuums distribution
    • Vacuums activity
    • Analyzes per Tables
    • Vacuums per Tables
    • Tuples removed
    • Page removed
  • Locks
    • Locks by type
    • Most frequent waiting queries (N)
    • Queries that waited the most
  • Queries
    • Queries by type
    • Queries by database
    • Queries by user
    • Duration by user
    • Queries by host
    • Queries by application
    • Number of cancelled queries
  • Top
    • Histogram of query times
    • Slowest individual queries
    • Time Consuming queries (N)
    • Most frequent queries (N)
    • Normalized slowest queries
  • Events
    • Log levels
    • Events distribution
    • Most frequent errors/events
  • PgBouncer
    • Request Throughput
    • Bytes I/O Throughput
    • Queries Average duration
    • Simultaneous sessions
    • Histogram of sessions times
    • Sessions per database
    • Sessions per user
    • Sessions per host
    • Established connections
    • Connections per database
    • Connections per user
    • Connections per host
    • Most used reserved pools
    • Most Frequent Errors/Events


  • Overview

    Global Stats

    • Queries
    • Events
    • Vacuums
    • Temporary files
    • Sessions
    • Connections
    • 3,751 Number of unique normalized queries
    • 60,367,937 Number of queries
    • 7d21h24m32s Total query duration
    • 2012-12-06 00:00:00 First query
    • 2012-12-12 00:00:00 Last query
    • 787 queries/s at 2012-12-11 02:02:02 Query peak
    • 3,950 Number of events
    • 6 Number of unique normalized events
    • 3,930 Max number of times the same event was reported
    • 0 Number of cancellation
    • 79 Total number of automatic vacuums
    • 149 Total number of automatic analyzes
    • 235 Number temporary file
    • 24.59 MiB Max size of temporary file
    • 12.06 MiB Average size of temporary file
    • 10,828,337 Total number of sessions
    • 334 sessions at 2012-12-07 00:00:00 Session peak
    • 1494d17h13m24s Total duration of sessions
    • 11s926ms Average duration of sessions
    • 5 Average queries per session
    • 62ms Average queries duration per session
    • 10,828,340 Total number of connections
    • 266 connections/s at 2012-12-07 02:02:02 Connection peak
    • 9 Total number of databases

    SQL Traffic

    Key values

    • 787 queries/s Query Peak
    • 2012-12-11 02:02:02 Date

    SELECT Traffic

    Key values

    • 108 queries/s Query Peak
    • 2012-12-11 10:49:56 Date

    INSERT/UPDATE/DELETE Traffic

    Key values

    • 72 queries/s Query Peak
    • 2012-12-06 09:06:28 Date

    Queries duration

    Key values

    • 7d21h24m32s Total query duration