root/trunk/quickstats/README.txt

Revision 29, 478 bytes (checked in by denish, 5 years ago)

README

Line 
1 INFO:
2
3 Quickstats schema is used to gather DML (insert/update/delete) statistics to find the number of transactions in the database.
4
5 INSTALL:
6
7 You should install quickstats_schema.sql into database for which you want to gather the statistics and schedule a postgres cron job to gather the statistics.
8
9 Schedule postgres cron job:
10
11 #5,10,15,20,25,30,35,40,45,50,55 * * * * [pgsql dir]/bin/psql -U postgres -c "select quickstats.gather()" -d DB_NAME > /dev/null 2>&1
Note: See TracBrowser for help on using the browser.