Trace and read data in packets

[Karol Bieniaszewski]

Hi

 

Is there a way to see info about packet read in trace?

I mean e.g.:

 

Table have 10000 records.

I do SELECT * FROM MY_TABLE

But i do not read all records at start (do not feth all) but i read data in packets e.g. 300 records at one time.

 

Such statement is shown in MON$STATEMENTS as „Stalled”.

But i do not see any info in trace about this fetches.

I see only PREPARE_STATEMENT, EXECUTE_STATEMENT_START, EXECUTE_STATEMENT_FINISH, FREE_STATEMENT

 

But i need to calculate how long query was executed.

And between next 300 record fetches can be e.g. 5 minute break.

 

Is there a way to handle this information somehow?

 

Regards,

Karol Bieniaszewski

 

[Karol Bieniaszewski]

Anyone?

Is this possible or should i create ticket in the tracker?

 

Regards,

Karol Bieniaszewski

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4CrccN6Qmvz2YWn%40smtp.poczta.onet.pl.

 

[Mark Rotteveel]

On 11-12-2020 19:25, Karol Bieniaszewski wrote:
> Anyone?
>
> Is this possible or should i create ticket in the tracker?

I'm not that familiar with trace, but as far as I can tell, fetches
aren't traced like that.

Mark
--
Mark Rotteveel