/[cricket]/README.pg_stat
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /README.pg_stat

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (hide annotations)
Fri Sep 13 16:26:53 2002 UTC (21 years, 6 months ago) by dpavlin
Branch: MAIN
CVS Tags: HEAD
first version of module for PostgreSQL performance monitoring

1 dpavlin 1.1 How to turn on statistics for your PostgreSQL database?
2    
3     Please read instructions at:
4     http://www.postgresql.org/idocs/index.php?monitoring-stats.html
5    
6     If nothing else, you will have to issue following SQL statement in
7     database that you wish to monitor. Otherwise, you will not get ANY
8     results!
9    
10     set STATS_COMMAND_STRING = true ;
11     set STATS_BLOCK_LEVEL = true ;
12     set STATS_ROW_LEVEL = true ;
13    
14     You could also add following lines in your postgresql.conf:
15    
16     STATS_COMMAND_STRING = true
17     STATS_BLOCK_LEVEL = true
18     STATS_ROW_LEVEL = true
19    
20    
21     This module should be considered "beta". I have no idea what performance
22     penalty for database is to collect statistics and/or pull data to cricket
23     every 5 minutes. You have been warned.

  ViewVC Help
Powered by ViewVC 1.1.26