Hacker News Reader

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

> 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?

Good catch, I meant "DDL", corrected my comment.

This extension simplifies things a bit: https://github.com/arkhipov/temporal_tables

Indeed. Better temporal support was added the ANSI SQL 11 standard[0] and it is supported by a number of databases, some (like Postgres) by extensions and others (like SQL Server) natively[1].

[0] https://en.wikipedia.org/wiki/SQL:2011

[1] https://docs.microsoft.com/en-us/sql/relational-databases/ta...

Ah. Sorry to disappoint. The technique was just new to me, so I thought it was worth sharing. :)