Hello,
I am trying to drop deprecated tables, views, procedures from an existing database, I am checking the pg_stat_user_tables view to check if the tables are accessed recently also to check live tuples. For deprecated views and procedures, I am wondering How can I do that, for example suppose the table is used and there is a view defined using this table but no one is using it. Is there is away to check the views statistics.
Regards
I am trying to drop deprecated tables, views, procedures from an existing database, I am checking the pg_stat_user_tables view to check if the tables are accessed recently also to check live tuples. For deprecated views and procedures, I am wondering How can I do that, for example suppose the table is used and there is a view defined using this table but no one is using it. Is there is away to check the views statistics.
Regards
