SELECTThis will list a record for every object in the database including indexes; the ratio of ISAM operations vs. buffer page operations can give you a hint as to the effectiveness of your server's configuration. If the ratio is very low for busy object your buffer pool is possibly too small.
TRIM(dbsname) || ':' || TRIM(tabname) AS relation_name,
isreads AS records_read,
pagreads AS page_reads,
iswrites AS records_inserted
bufwrites AS buffered_writes
ORDER BY isreads DESC;
Text 1: List the basic read and write statistics for objects in the engine's databases.
If you are interested in the counts of various query operations the sysptprof table also provides the following values:
- isrwrite - The number of records updated.
- isrdelete - The number of records deleted.
Many more sysmaster queries can be found in the Informix Wiki.