Vlad, How can those stats be related to the *tables* on which the activity is performed against?
Sean > -----Original Message----- > From: Vlad Khorsun <hv...@optima.com.ua> > Sent: Thursday, August 1, 2019 5:15 AM > To: firebird-devel@lists.sourceforge.net > Subject: Re: [Firebird-devel] Query statistics > > 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 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
