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

Reply via email to