Is there any system table to check the changes which happened recently in a PostgreSQL DB? I have a PostgreSQL DB with just one table and once a day (time is unknown) updates happens and I want to know when the updates come. How can I check that without check the tables content? (The data is about 10GB+, comparisation is not a good solution, adding an extra column as a flag is not an option in the system, checking the last id of records is not also an option, the id is not increasing). May be it is a good solution if there is any log tracking system which I can see the queries like:
05.11.2021 09:47 - Insert into .....
05.11.2021 09:45 - Update table ...
I also need a tool which I can use via terminal to see differences of tables on Postgresql, have you ever use a tool like this?