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

Try

pgFouine - a PostgreSQL log analyzer

a good and respected analyzer