thank you for the info
regards,Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: Dmitry Yemanov <firebi...@yandex.ru> 
Data: 17.09.2015  14:23  (GMT+01:00) 
Do: For discussion among Firebird Developers 
<firebird-devel@lists.sourceforge.net> 
Temat: Re: [Firebird-devel] Explained plan - sub plan 

17.09.2015 14:42, liviuslivius wrote:
>
> is this possible to have information about sub plans in plan itself

This is theoretically possible for subqueries inside FROM and WHERE 
clauses, but not for subqueries inside the select list (except derived 
tables and CTEs). But it's not just about the plan output, it requires 
engine code changes. Definitely not for v3.

> PS. i saw somewhere info about including more stats in Explained Plan -
> when can we expect this? :)

The intention was for v3 but that's unlikely. We still don't have the 
core statistics propagated at the every level of the plan.


Dmitry


------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to