Time statistics for explian analzy

CrazyDrumming

unread,

Jul 12, 2023, 1:27:29 AM7/12/23

to H2 Database

Sorry, I didn't find anything more in the docs about time counting and explain analyze.
One question I have is, does the time counted by explain analyze include the time it takes to convert the queried data into strings? (Strings are used to display results on the console)

ps: Use `java -cp h2-*.jar org.h2.tools.Shell` start up

Noel Grandin

unread,

Jul 12, 2023, 4:29:59 AM7/12/23

to h2-da...@googlegroups.com

On 7/11/2023 5:51 PM, CrazyDrumming wrote:
> One question I have is, does the time counted by explain analyze include the time it takes to convert the queried data
> into strings? (Strings are used to display results on the console)

It does not. But that it normally a very small amount of the overall time spent performing a query.

CrazyDrumming

unread,

Jul 12, 2023, 11:06:18 AM7/12/23

to H2 Database

Meaning that this time does not include the time to convert the result to String?

Because in some special scenarios this time may be very long, such as the output of many rows of data, data conversion is complex, and so on.

Reply all

Reply to author

Forward