What are the units in Halins Query Performance tab

[SimonThordal]

Under Members -> Query Performance there are two columns called Compile (avg) and Execute (avg). What are the units for these two? I am assuming ms, but without a specified unit it is hard to tell.

[david_allen · Accepted solution]

It's milliseconds.

The actual query Halin is using to get that data is this:

        CALL db.stats.retrieve("QUERIES") 
        YIELD data 
        WITH 
            data.queryExecutionPlan as qep,                
            data.estimatedRows as estimatedRows,
            data.invocationSummary.invocationCount as invocationCount,
            data.invocationSummary.compileTimeInUs as compileTime,
            data.invocationSummary.executionTimeInUs as executionTime,
            data.query as query,
            data.invocations as invocations

        RETURN 
            query,
            qep, 
            invocationCount,
            compileTime.min as compileMin,
            compileTime.max as compileMax,
            compileTime.avg as compileAvg,
            executionTime.min as executeMin,
            executionTime.max as executeMax,
            executionTime.avg as executeAvg,
            estimatedRows,
            invocations
        ORDER BY query ASC

The db.stats procedures have a little bit of documentation in the built in procedure reference.

[SimonThordal]

Thanks David. I now see that the tool tip actually states microseconds. Is that a typo?

Let me know if you'd rather have this as an issue in the repo and I'll move it there - and thanks for creating Halin, it is very useful!

[david_allen]

Oops. You're completely right. It's microseconds, I responded too quickly. You can actually see it in the query that I pasted, which is the right query. The results that come back from CALL db.stats.retrieve('QUERIES") even says so:

    "compileTimeInUs": {
      "max": 1388839,
      "min": 1388839,
      "avg": 1388839
    },

(Compile time in Us) -- which is sort of an ASCII-fied way of saying microsecond (µs)