Re: How to find the table which is not used in recent 3 month?

Fabio Pardi <f.pardi@xxxxxxxxxxxx> · Mon, 31 Dec 2018 14:22:07 +0100



    Hi Frantz,

      
      If 'used' means 'written', then I think it might be an idea to
      look at the youngest 'xmin' in the table, to know when it was last
      modified together with keeping a log of what xmin is associated to
      each day.

    
      regards,

      
      fabio pardi

      
    On 31/12/2018 07:30, Frantz Song wrote:

    
      Dear all,
        

          I'm use postgresql 9.6, it have 800+tables and some of
            them is not frequently used. 
          How to find the table which is not used in recent 3
            month? 
          

          Thanks!
          

          -- 

          P Help save trees...please don't
                print this e-mail unless you really need to.