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. |