4 ms·
You can use pgaudit, it's an extension that let's you audit DDL/DML statements. It's a great auditing mechanism. I use it on all our prod postgres instances, bu
by sharadov 5y ago
You can use pgaudit, it's an extension that let's you audit DDL/DML statements. It's a great auditing mechanism. I use it on all our prod postgres instances, but have only "DDL" enabled, because of the potential performance overhead
https://github.com/pgaudit/pgaudit https://github.com/pgaudit/pgaudit
- AmericanChopper 5y ago> but have only "DML" enabled, because of the potential performance overhead Surely the amount of DDL statements would be trivial compared to the DML ones?
- sharadov 5y agoGood catch, I meant "DDL", corrected my comment.