Subject | Bug in monitoring tables with stored procs? |
---|---|
Author | Douglas Tosi |
Post date | 2008-07-28T13:23:08Z |
Hello!
Using FB 2.1.1 64bit Windows, create a dummy stored procedure:
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.
Why the io_stats and record_stats for stored procedures are not being
accounted at the statement level?
Is this a bug or a design decision?
thanks,
--
Douglas Tosi
www.sinatica.com
Using FB 2.1.1 64bit Windows, create a dummy stored procedure:
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.
Why the io_stats and record_stats for stored procedures are not being
accounted at the statement level?
Is this a bug or a design decision?
thanks,
--
Douglas Tosi
www.sinatica.com