Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: Postgress log analyzer

    Hello,
    given a Postgres log, I need to extract for every type of db operation (query, insert, delete, update) the total time that each type of db operation take up.For example:

    • QUERY: 30m 10s
    • INSERT: 5m 3s
    • DELETE: 7m 3s
    • UPDATE: 9m 2s


    Do you know some tool that does this work?

    Thanks

    narste

  2. #2
    Join Date
    Aug 2011
    Posts
    42
    Try

    pgFouine - a PostgreSQL log analyzer

    a good and respected analyzer

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •