pgbadger issue

S Bob <sbob@xxxxxxxxxxxxxxxxxxxxx> · Thu, 14 Jan 2021 18:42:14 -0700



    All;
    

    Apologies if this is the wrong list. I have a log file from a
      PostgreSQL v10.12 cluster
    

    log_min_duration statement = 0
    log_line_prefix = '%t [%p]: [%l-1] '
    log_destination = stderr
    

    I see queries in the log, such as this one:
    2021-01-14 20:28:20 EST [11486]: [2-1] STATEMENT:  SELECT * FROM
      BigTab WHERE cast(value ->> 'pending' as bool) = 'false'
      order by cast(value ->> '

      closeTimestamp' as bigint) desc, cast(value ->>
      'openTimestamp' as bigint) desc

    
    However when I parse the log I get zero queries:
    $ pgbadger -o uat.html -f stderr -p '%t
        [%p]: [%l-1] '  ./postgresql-Thu.log

        [========================>] Parsed 10007997 bytes of 10007997
        (100.00%), queries: 0, events: 1

        LOG: Ok, generating html report...

      
    Thoughts?
    

    Thanks in advance