4.1 Configuring and Using DRITA

Table of Contents Previous Next



Advanced Server's postgresql.conf file includes a configuration parameter named timed_statistics that controls the collection of timing data. The valid parameter values are TRUE or FALSE; the default value is FALSE.
This is a dynamic parameter which can be modified in the postgresql.conf file, or while a session is in progress. To enable DRITA, you must either:
Modify the postgresql.conf file, setting the timed_statistics parameter to TRUE.
After modifying the timed_statistics parameter, take a starting snapshot. A snapshot captures the current state of each timer and event counter. The server will compare the starting snapshot to a later snapshot to gauge system performance.
Use the edbsnap() function to take the beginning snapshot:


Table of Contents Previous Next