New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I/O statistics for stored procedures are not accounted in monitoring tables [CORE2017] #2454
Comments
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Open [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] Fix Version: 2.1.2 [ 10270 ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Commented by: @pcisar Qa test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] Test Details: Note about SuperServer, 2.5.6 and 3.0, for 'writes' counter. Statistics for procedural code can differ from DSQL in HUGE degree, especially for 'writes' counter - up to THOUSANDS percents! |
Modified by: @pavel-zotovAttachment: differences-between-Psql-and-Dsql-in-2_5-and-3_0.zip [ 12885 ] |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] Test Details: Note about SuperServer, 2.5.6 and 3.0, for 'writes' counter. Statistics for procedural code can differ from DSQL in HUGE degree, especially for 'writes' counter - up to THOUSANDS percents! => |
Submitted by: Douglas Tosi (douglasht)
Is related to QA239
Attachments:
differences-between-Psql-and-Dsql-in-2_5-and-3_0.zip
create procedure dummy
returns (i bigint)
as
begin
select count(*)
from big_table /* my test is 3.5 million records */
into :i;
suspend;
end
Now select i from dummy;
The statistics for this statement should show a lot of page_reads.
But mon$io_stats always show zero.
Curiously, the io_stats for the transaction and for the attachment did
show a correct increase in page_reads.
Commits: ea6fbf9 c4c496b FirebirdSQL/fbt-repository@71c23f9
The text was updated successfully, but these errors were encountered: