02.08.2019 17:16, Leyne, Sean wrote:
Sean,How can those stats be related to the *tables* on which the activity isperformed against? Below is excerpt from APU Guide, if your question was about something else - please, clarify: --- Database operation counts Several information items are provided for determining the number of various database operations performed by the currently attached calling program. These values are calculated on a per-table basis.Only available via API ;-[ I was hoping to gather those details via MON$ tables.
It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
I have a DB SP which itself calls several SPs, and I was hoping to collect details on the operations that each child SP performs (in a production database environment -- not a static database snapshot) by simply wrapping the SPs with an analysis of the MON$ details (without needing application code changes).
Try Trace - it could show stats for every call Hope it helps, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
