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
  • 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
  • Global information

    • Generated on Wed Mar 11 09:04:15 2026
    • Log file: ./2026-03-10_PT1D.log
    • Parsed 355,550 log entries in 2m42s
    • Log start from 2026-03-10 00:00:00 to 2026-03-10 23:59:59
  • Overview

    Global Stats

    • Queries
    • Durations
    • Events
    • Vacuums
    • Temporary files
    • Sessions
    • Connections
    • 31 Number of unique normalized queries
    • 1,141 Number of queries
    • 1h39m34s Total query duration
    • 2026-03-10 00:00:01 First query
    • 2026-03-10 23:57:02 Last query
    • 3 queries/s at 2026-03-10 11:26:34 Query peak
    • 1h39m34s Total query duration
    • 0ms Prepare/parse total duration
    • 0ms Bind total duration
    • 1h39m34s Execute total duration
    • 171,634 Number of events
    • 1 Number of unique normalized events
    • 171,634 Max number of times the same event was reported
    • 0 Number of cancellation
    • 0 Total number of automatic vacuums
    • 1,549 Total number of automatic analyzes
    • 0 Number temporary file
    • 0 Max size of temporary file
    • 0.00 B Average size of temporary file
    • 2,561 Total number of sessions
    • 25 sessions at 2026-03-10 09:40:06 Session peak
    • 4d15h17m48s Total duration of sessions
    • 2m36s Average duration of sessions
    • 0 Average queries per session
    • 2s332ms Average queries duration per session
    • 2m34s Average idle time per session
    • 2,559 Total number of connections
    • 10 connections/s at 2026-03-10 03:34:26 Connection peak
    • 1 Total number of databases

    SQL Traffic

    Key values

    • 3 queries/s Query Peak
    • 2026-03-10 11:26:34 Date

    SELECT Traffic

    Key values

    • 3 queries/s Query Peak
    • 2026-03-10 11:26:34 Date

    INSERT/UPDATE/DELETE Traffic

    Key values

    • 2 queries/s Query Peak
    • 2026-03-10 05:06:01 Date

    Queries duration

    Key values

    • 1h39m34s Total query duration