Projet

Général

Profil

Révision 93a567af

ID93a567afbc2bd79ce19863344317d91489161bf5
Parent 97ab640b
Enfant fdf6cea2

Ajouté par Lars Kruse il y a plus de 7 ans

postgresql_transactions: use DERIVE instead of COUNTER

Voir les différences:

plugins/postgresql/postgresql_transactions
29 29 
   echo 'graph_category db'
30 30 
   echo 'graph_info Shows summarized commits and rollbacks in transactions on the PostgreSQL Server.'
31 31 
   echo 'graph_title PostgreSQL Transactions'
32 
   echo 'graph_vlabel Number of Commits and Rollbacks'
32 
   echo 'graph_vlabel Commits and Rollbacks per second'
33 33 

  		




  34
  34
  
    
   echo 'commits.label commits'


  		




  35
  35
  
    
   echo 'commits.min 0'


  		




  36
  
  
    
   echo 'commits.type COUNTER'


  		




  37
  
  
    
   echo 'commits.info Number of transaction commits.'


  		




  
  36
  
    
   echo 'commits.type DERIVE'


  		




  
  37
  
    
   echo 'commits.info Number of transaction commits per second.'


  		




  38
  38
  
    

  		




  39
  39
  
    
   echo 'rollbacks.label rollbacks'


  		




  40
  40
  
    
   echo 'rollbacks.min 0'


  		




  41
  
  
    
   echo 'rollbacks.type COUNTER'


  		




  42
  
  
    
   echo 'rollbacks.info Number of transaction rollbacks.'


  		




  
  41
  
    
   echo 'rollbacks.type DERIVE'


  		




  
  42
  
    
   echo 'rollbacks.info Number of transaction rollbacks per second.'


  		




  43
  43
  
    
   exit 0


  		




  44
  44
  
    
fi


  		




  45
  45
  
    
psql -h ${dbserver} -U ${dbuser} -tc "SELECT 'commits.value '||SUM(xact_commit)::TEXT||E'\nrollbacks.value '||SUM(xact_rollback)::TEXT FROM pg_stat_database;" --no-align


  		












Formats disponibles :  Unified diff