dbeaver / dbeaver/dbeaver

Add "Table Last Modified" to table view, esp. on PostgreSQL

Open
#20,701 5 comments 0 reactions 0 assignees View on GitHub
enhancement x:postgresql xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

**Is your feature request related to a problem? Please describe.**
I always wish I could see when the last commit was to a specific table in a PostgreSQL database.

**Describe the solution you'd like**
I'd like to see an always-read-only field that shows the last time the table was edited.
![image](https://github.com/dbeaver/dbeaver/assets/11021263/cef4faf3-a433-46fd-9665-fc30f1c11542)

Could also add a first-edit and a pct null edit date value.

**Describe alternatives you've considered**
Currently, the only option is to run a query like this:

```sql
SELECT max(pg_xact_commit_timestamp(xmin)) FROM schema_name.table_name;

-- or --

SELECT pg_xact_commit_timestamp(xmin), * FROM schema_name.table_name;
```

**Additional context**
It might be good to add a hovertip or link to docs on how to enable this feature in the PostgreSQL database. On AWS PostgreSQL, it's disabled by default.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.