Table of Contents Previous Next


10 Postgres Log Analysis Expert

Before using the PEM Log Analysis Expert, you must specify the Service ID on the Advanced tab of the Server Properties dialog, and use the Log Manager wizard to enable log collection by the PEM server. For more information about using the Log Manager wizard, see Section 9.
To open the Log Analysis Expert wizard select the Postgres Log Analysis Expert option from the Management menu in the PEM client. When the wizard's Welcome dialog (see Figure 10.1) opens, click Next to continue.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\04a5471e\laone.png
The wizard displays a list of Analyzers from which you can select (see Figure 10.2). Each Analyzer generates a corresponding table, chart, or graph that contains information gleaned from the log reports.

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\ca595fff\latwo.png
Click the Unselect all button to un-check all of the boxes before navigating through the list and selecting only the tables, charts or graphs that you wish Log Analysis Expert to generate.
Click the Select all button to instruct Log Analysis Expert to review the server logs and generate a report for each analyzer selected.
After making your selections, click Next to continue to the Servers tree control (see Figure 10.3).

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\dad26e82\lathree.png

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\8525c53c\lafour.png
Use the fields in the Time Intervals section of the dialog (see Figure 10.4) to specify the time range that the Log Analysis Expert is supposed to analyze:
Check the box next to Relative Days to enable the (+/-)From date field and specify the number of days before or after the date and time selected in the From Date field.
Use the From Date field to specify the starting date and time for the analysis.
Use the Time Span selector to specify the number of minutes that the analyzer will incorporate into each calculation for a point on a graph. For example, if the Time Span is 5 minutes, and the Aggregate method is AVG, each point on the given graph will contain the average value of the activity that occurred within a five minute time span.
Use the (+/-) From Date selector to indicate the number of days before or after the From Date that should be included in the analysis.
Use the options in the Report Options section of the dialog to specify the analysis method and the maximum length of any resulting tables:
Use the Aggregate Method drop-down to select the method used by the Log Analysis Expert to consolidate data for the selected time span - select from:
SUM instructs the analyzer to calculate a value that is the sum of the collected values for the specified time span.
AVG instructs the analyzer to calculate a value that is the average of the collected values for the specified time span.
MAX instructs the analyzer to use the maximum value that occurs within a specified time span.
MIN instructs the analyzer to use the minimum value that occurs within a specified time span.
Use the Rows Limit selector to indicate the maximum number of rows to include in a table.
Click Next to continue.

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\872cc30e\lafive.png
You can select the default option and click Finish to view the Log Analysis Expert report, or check the box next to Save the report to a file to save a copy of the report to an HTML file for later use (see Figure 10.5). If you wish to save the report to a file, specify a filename in the field provided; alternatively, use the button to the right of the field to open a browser dialog and use a browser to specify a log file location.

10 Postgres Log Analysis Expert

Table of Contents Previous Next