如何发现Postgresql表的用法是什么? [英] How to discover what a Postgresql table's usage is?

问题描述

我们的团队正在开发一个具有大量表和视图且没有任何引用约束的Postgresql数据库.该项目没有文档记录，并且似乎有大量未使用/临时/重复的表/视图弄脏了该模式.

Our team is working on a Postgresql database with lots of tables and views, without any referential constraints. The project is undocumented and there appears to be a great number of unused/temporary/duplicate tables/views dirtying the schema.

我们需要发现哪些数据库对象具有实际价值，并且可以实际使用和访问. 我最初的想法是查询目录/数据字典".

We need to discover what database objects have real value and are actually used and accessed. My inital thoughts were to query the Catalog/'data-dictionary'.

是否可以查询Postgresql目录以找到对象的最后查询时间.

Is it possible to query the Postgresql Catalog to find an object's last query time.

有什么想法，替代方法和/或工具构想吗?

Any thoughts, alternative approaches and or tools ideas?

推荐答案

检查 查看全文