20.10. Reporting

20.10.1.1. Table IO Detail Report

This particular report lists the following information for all the tables under a monitored database:

• Table Name - The name of the table

• Seqntl Scans - Number of sequential scans on that table

• Seqntl Rows - Number of sequential rows read in that tab

• Data Disk Reads - Number of data disk reads on that table

• Data Mem Reads - Number of data memory reads on that table

• Data Hit Ratio - The hit ratio

• Rows Ins - Number of rows inserted into the table

• Rows Upd - Number of rows updated in the table

• Rows Del - Number of rows deleted from the table

Simply click on the button to generate the latest Table IO Details report against a particular database.

Remember that in order to collect these statistics, the stats_start_collector and stats_row_level parameters should be turned ON. The stats_row_level can be turned on and off from the Configuration page, however stats_start_collector must be enabled in the postgresql.conf file.

The Table IO Detail report can be very useful for database administrators for determining high activity tables, and then accordingly tuning them by adding indexes, or isolating them on a seperate disk.

20.10.1.2. Index IO Detail Report

This particular report lists the following information for each index under a monitored datasource:

• Idx Name - The name of the index

• Idx Scans - The number of index scans done against the index

• Idx Rows Read - Number of index entries returned by that index

• Idx Rows Fetched - Number of table rows fetched by simple index scans using the index

• Idx Mem Reads - Number of data memory reads on that index

• Idx Disk Reads - Number of data disk reads on the index

• Data Hit Ratio - The data hit ratio

Simply click on the button to generate the latest Index IO Details report for a particular database.

Remember that in order to collect these statistics, the stats_start_collector and stats_row_level parameters should be turned ON. The stats_row_level can be turned on and off from the Configuration page, however stats_start_collector must be enabled in postgresql.conf file.

This report can be very useful for the DBA's to determine high or low activity indexes, and remove those indexes which are not being utilized and creating overhead.

20.10.1.3. Column Statistics Report

This report shows the statistics for the columns within a database table. The column names are grouped according to the table they belong to. The following information is displayed for every table column:

• Column - The column's name

• Data Type - The column's data type

• Null Frac - Fraction of column entries that are null

• Avg Width - Average width(in bytes) of the column's entries

• Distinct Values - If greater than zero, the estimated number of distinct values in the column. If less than zero, the negative of the number of distinct values divided by the number of rows

• Most Common Values - A list of the most common values in the column

20.10.2.1. Tables Report

This report contains information about all the tables in a configured database. It provides us with the following information about every table column:

• Column - The column's name

• Data Type - The column's data type

• Size/Precision - If the column's data type is a numeric type, this column contains the (declared or implicit) precision of the type for this column

• Scale - If the column's data type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this column

• Nullable - YES if the column is possibly nullable, NO if it is known not nullable

Additional table level information available with this report includes Row Count and Table Size.

20.10.2.2. Indexes Report

This report contains the following information about indexes on your database tables:

• Table - The table this index belongs to

• Row - The number of rows in the table the index is on

• Index Size - Size of the index using KB, MB, GB or TB as appropriate

• Index - The name of the index

• Definition - The SQL for the index's definition

20.10.2.3. Views Report

The Views report contains information about all the views present in a database. The page displays views in a list format along with their definitions.

20.10.2.4. Sequences Report

This report contains information about all the sequences within your monitored data source. Each row in this report contains the following information:

• Sequence - The sequence's name

• Last Val - Last Value for the sequence

• Min Val - Minimum Value the new sequence will generate. The default minimum is 1 for an ascending sequence and -2147483647 for a descending sequence

• Max Val - Maximum Value the new sequence will generate. The default is 2147483647 for an ascending sequence, and -1 for a descending sequence

• Increment - The value to be applied on each sequence increment

• Cache - The quantity of sequence numbers that can be stored in cache memory

• Cycled - Indicates whether this sequences is allowed to wrap or not

20.10.3.1. Packages Report

EnterpriseDB 8.1 and above has support for packages. The Packages report makes use of this new functionality to represent the complete package body and specification, along with the name and owner for all the packages in your database.

20.10.3.2. Procedures Report

EnterpriseDB also includes support for stored procedures. The purpose of this report is to list the complete procedure source code along with owner name and language for all the stored procedures in your database.

20.10.3.3. Functions Report

This report provides the end user with information about all the database functions present in their database.

20.10.3.4. Triggers Report

This report is similar to other reports in this category. All trigger relevent information including the trigger's name, the table name the trigger is on, the owner of the trigger as well as the source code of the trigger is shown in this report.