Retrieving Statistics with isc database info()

Go Up to Database Statistics and Connection Monitoring

InterBase includes programming facilities to gather performance timings and database operation statistics.

You can use the API function isc_database_info( ) to retrieve statistics, by specifying one or more of the following request buffer items:

Database I/O Statistics Information Items

Request Buffer Item	Result Buffer Contents
isc_info_fetches	Number of reads from the memory buffer cache; calculated since the InterBase server started.
isc_info_marks	Number of writes to the memory buffer cache; calculated since the InterBase server started.
isc_info_reads	Number of page reads; calculated since the InterBase server started.
isc_info_writes	Number of page writes; calculated since the InterBase server started.
isc_info_backout_count	Number of removals of record versions per table since the current database attachment started.
isc_info_delete_count	Number of row deletions Reported per table. Calculated since the current database attachment started.
isc_info_expunge_count	Number of removals of a record and all of its ancestors, for records whose deletions have been committed Reported per table. Calculated since the current database attachment started.
isc_info_insert_count	Number of inserts into the database Reported per table. Calculated since the current database attachment started.
isc_info_purge_count	Number of removals of old versions of fully mature records (records committed, resulting in older-ancestor-versions no longer being needed) Reported per table. Calculated since the current database attachment started.
isc_info_read_idx_count	Number of reads done via an index Reported per table. Calculated since the current database attachment started.
isc_info_read_seq_count	Number of sequential database reads, that is, the number of sequential table scans (row reads) Reported per table. Calculated since the current database attachment started.
isc_info_read_update_count	Number of row updates Reported per table. Calculated since the current database attachment started.

See the API Guide for information on request buffers, and details of using this API call.