we have a Postgres database which receives data by an extern web client. We would like to measure the duration of the UPDATE, INSERT and DELETE processes on our tables.
Until now, we used the following triggers: https://wiki.postgresql.org/wiki/Audit_trigger
However, our database has grown to a size where these triggers slow down our processes too extremely. Now I would like to know what kind of recommendations you have for me in order to measure the durations. I have heard of using internal log files or doing other stuff but I am really now that deep into database management as I perhaps should be. Thank you!