31.07.2019 15:06, Jiří Činčura wrote:
Hi *,
is it possible to get statistics about the executed query similar to what
isc_info_req_insert_count etc. allows? I'm mostly interested in
indexed/non-indexed read counts, but whetever is available I'll include in the
implementation.
These stats counters are available at the attachment level. See
isc_database_info() and tags below:
isc_info_read_seq_count,
isc_info_read_idx_count,
isc_info_insert_count,
isc_info_update_count,
isc_info_delete_count,
isc_info_backout_count,
isc_info_purge_count,
isc_info_expunge_count
Note, counters above are accumulated since attachment start, thus one have to
query
stats two times (before and after statement execution) and calculate difference.
More details is available at API Guide, see "Database operation counts" at
chapter 4
"WORKING WITH DATABASES".
Hope it helps,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
