Retrieving Statistics with isc database info()

From InterBase

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.

Back To: