Hi,
I’m trying to retrieve the explain plan of the last prepared query, using the
mon$explained_plan field, introduced in FB3 beta.
I used:
SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id =
CURRENT_TRANSACTION
This seems to give me however the plan of the first prepared statement of the
transaction. I want the plan of the last prepared query (of course also
excluding the statement that is querying for the plan)
BTW:
- the mon$explained_plan field is not yet added to README.monitoring_tables.txt.
- the mon$explained_plan field seems to start with a carriage return, what is
the purpose of that?
Kind regards,
Robert
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
