/[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

Contents of /README.pg_stat

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (show 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 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