28.09.2020 20:44, Adriano dos Santos Fernandes wrote:

I have thought on that possibility since the start and the conflict
points I see are:
- Name of RDB$PROFILE_STATS - perhaps RDB$PROFILE_PSQL?

Maybe we may leave it as is. And add RDB$PROFILE_CURSOR_STATS.

The question is how they should be linked. Some artificial unique cursor ID added to RDB$PROFILE_STATS for lines containing queries? Or should RDB$PROFILE_CURSOR_STATS duplicate LINE/COLUMN as a reference? What if the statement has multiple sub-queries?

BTW, execution time is good but I believe all other statistics (page-level, record-level, memory) should also be collected/reported while profiling. Mostly this is about cursors, but not only (singleton INSERTs for example).


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to