Re: Database stats

Ron <ronljohnsonjr@xxxxxxxxx> · Fri, 7 Dec 2018 10:46:15 -0600



    On 12/07/2018 10:38 AM, Campbell, Lance wrote:

    
        PostgreSQL
            10.X
        Is there a
            query we can run to answer the following questions:
        
          How many SQL commands have been
              executed in the last 24 hours?
          How many insert SQL commands have
              been executed in the last 24 hours?
          How many update SQL commands have
              been executed in the last 24 hours?
        
         
        OR
        Instead of 2
            or 3 maybe how many row updates have occurred in the last 24
            hours?
         
        OR
        Something
            that gives me an idea of rows reads and written.  Or rows
            read, written and created in 24 hours.
      
    
    Look in pg_stat_all_tables.  It keeps a running count since the
    cluster was started, but if you capture a snapshot every X hours
    then you should be able to approximate what you want.

    
https://www.postgresql.org/docs/9.6/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW

    
        There might
            be other ways to get to general levels of usage base on a
            date or date range.
         
        Thanks,
         
        Lance
      
    
    -- 

      Angular momentum makes the world go 'round.