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:03:30 2026
    • Log file: ./2026-03-10_PT1D.log
    • Parsed 3,006 log entries in 1m57s
    • Log start from 2026-03-10 03:13:15 to 2026-03-10 15:13:16
  • Overview

    Global Stats

    • Queries
    • Durations
    • Events
    • Vacuums
    • Temporary files
    • Sessions
    • Connections
    • 57 Number of unique normalized queries
    • 165 Number of queries
    • 17m57s Total query duration
    • 2026-03-10 03:13:15 First query
    • 2026-03-10 15:13:16 Last query
    • 2 queries/s at 2026-03-10 09:24:00 Query peak
    • 17m57s Total query duration
    • 0ms Prepare/parse total duration
    • 0ms Bind total duration
    • 17m57s Execute total duration
    • 0 Number of events
    • 0 Number of unique normalized events
    • 0 Max number of times the same event was reported
    • 0 Number of cancellation
    • 0 Total number of automatic vacuums
    • 788 Total number of automatic analyzes
    • 0 Number temporary file
    • 0 Max size of temporary file
    • 0.00 B Average size of temporary file
    • 704 Total number of sessions
    • 20 sessions at 2026-03-10 11:34:32 Session peak
    • 1d2h4m41s Total duration of sessions
    • 2m13s Average duration of sessions
    • 0 Average queries per session
    • 1s530ms Average queries duration per session
    • 2m11s Average idle time per session
    • 704 Total number of connections
    • 10 connections/s at 2026-03-10 10:54:05 Connection peak
    • 1 Total number of databases

    SQL Traffic

    Key values

    • 2 queries/s Query Peak
    • 2026-03-10 09:24:00 Date

    SELECT Traffic

    Key values

    • 2 queries/s Query Peak
    • 2026-03-10 09:24:00 Date

    INSERT/UPDATE/DELETE Traffic

    Key values

    • 2 queries/s Query Peak
    • 2026-03-10 15:13:16 Date

    Queries duration

    Key values

    • 17m57s Total query duration

    Prepared queries ratio

    Key values

    • 0.00 Ratio of bind vs prepare
    • 0.00 % Ratio between prepared and "usual" statements

    General Activity

    • Queries
    • Read Queries
    • Write Queries
    • Prepared Queries
    • Connections
    • Sessions
    Day Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99)
    Mar 10 00 0 0ms 0ms 0ms 0ms 0ms 0ms
      01 0 0ms 0ms 0ms 0ms 0ms 0ms
      02 0 0ms 0ms 0ms 0ms 0ms 0ms
      03 2 0ms 8s990ms 8s990ms 0ms 0ms 17s981ms
      04 0 0ms 0ms 0ms 0ms 0ms 0ms
      05 0 0ms 0ms 0ms 0ms 0ms 0ms
      06 0 0ms 0ms 0ms 0ms 0ms 0ms
      07 0 0ms 0ms 0ms 0ms 0ms 0ms
      08 2 0ms 4s127ms 4s127ms 0ms 0ms 8s254ms
      09 71 0ms 1m3s 7s59ms 36s808ms 1m6s 1m42s
      10 0 0ms 0ms 0ms 0ms 0ms 0ms
      11 88 0ms 31s241ms 6s16ms 45s878ms 51s312ms 1m23s
      12 0 0ms 0ms 0ms 0ms 0ms 0ms
      13 0 0ms 0ms 0ms 0ms 0ms 0ms
      14 0 0ms 0ms 0ms 0ms 0ms 0ms
      15 2 0ms 10s126ms 10s122ms 0ms 0ms 20s245ms
      16 0 0ms 0ms 0ms 0ms 0ms 0ms
      17 0 0ms 0ms 0ms 0ms 0ms 0ms
      18 0 0ms 0ms 0ms 0ms 0ms 0ms
      19 0 0ms 0ms 0ms 0ms 0ms 0ms
      20 0 0ms 0ms 0ms 0ms 0ms 0ms
      21 0 0ms 0ms 0ms 0ms 0ms 0ms
      22 0 0ms 0ms 0ms 0ms 0ms 0ms
      23 0 0ms 0ms 0ms 0ms 0ms 0ms
    Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99)
    Mar 10 00 0 0 0ms 0ms 0ms 0ms
      01 0 0 0ms 0ms 0ms 0ms
      02 0 0 0ms 0ms 0ms 0ms
      03 0 0 0ms 0ms 0ms 0ms
      04 0 0 0ms 0ms 0ms 0ms
      05 0 0 0ms 0ms 0ms 0ms
      06 0 0 0ms 0ms 0ms 0ms
      07 0 0 0ms 0ms 0ms 0ms
      08 2 0 4s127ms 0ms 0ms 8s254ms
      09 71 0 7s59ms 11s494ms 36s808ms 1m27s
      10 0 0 0ms 0ms 0ms 0ms
      11 86 0 5s955ms 25s929ms 45s878ms 51s798ms
      12 0 0 0ms 0ms 0ms 0ms
      13 0 0 0ms 0ms 0ms 0ms
      14 0 0 0ms 0ms