28.09.2020 09:41, Simonov Denis via Firebird-devel wrote:
1. Why is statistics limited to procedure / function / trigger and block only? But what about queries and cursors inside blocks. Their execution times are much more interesting.
RDB$PROFILE_STATS contains statement ID and RDB$LINE/RDB$COLUMN as a position inside the PSQL block. So every inner statement is profiled.
3. If tables RDB$PROFILE_SESSIONS, RDB$PROFILE_REQUESTS, RDB$PROFILE_STATS read data only from memory, then why are they prefixed with RDB$, and not MON$ for example?
MON$ tables create a snapshot. This is not what every other in-memory table needs.
Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel