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
    • Checkpoints distance
    • Checkpoint activity
    • Checkpoint causes
  • 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
    • Time consuming prepare
    • Time consuming bind
  • 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
  • Global information

    • Generated on Mon May 16 22:45:25 2022
    • Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
    • Parsed 247,924,278 log entries in 13m8s
    • Log start from 2012-12-06 00:00:00 to 2012-12-12 00:00:00
  • Overview

    Global Stats

    • Queries
    • Durations
    • Events
    • Vacuums
    • Temporary files
    • Sessions
    • Connections
    • 3,606 Number of unique normalized queries
    • 60,366,965 Number of queries
    • 7d20h40m16s 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
    • 7d20h40m16s Total query duration
    • 1s974ms Prepare/parse total duration
    • 1m38s Bind total duration
    • 7d20h38m35s Execute total duration
    • 3,965 Number of events
    • 7 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
    • 0 Number temporary file
    • 0 Max size of temporary file
    • 0.00 B Average size of temporary file
    • 10,828,336 Total number of sessions
    • 80 sessions at 2012-12-06 05:18:33 Session peak
    • 1494d17h12m28s Total duration of sessions
    • 11s926ms Average duration of sessions
    • 5 Average queries per session
    • 62ms Average queries duration per session
    • 11s863ms Average idle time per session
    • 10,828,340 Total number of connections
    • 266 connections/s at 2012-12-07 02:02:02 Connection peak
    • 6 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

    • 7d20h40m16s Total query duration