28.09.2020 13:27, Adriano dos Santos Fernandes wrote:

I would like something about cursors too and I think in the future it
can be added.

I believe this should be a top-priority thing. I doubt many users implement heavy logic in PSQL without queries, so per-statement stats is mostly usable to quickly identify the slow query, for example. But the most interesting part comes after that - understand why query is slow. And here we need stats collected/shown per every plan node (at the RecordSource level). Obviously, RSB tree has no relation to source lines anymore, so it should be reported differently, RDB$PROFILE_STATS is not enough. I'd suggest to seriously think about that, as it may affect the design of the feature.


Dmitry


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

Reply via email to