Time in milliseconds

lscapim · December 3, 2021, 3:26pm

Hi,
When we run a query in Redash, it brings the result in seconds, we need it in milliseconds, how can we do that?

Thanks

jesse · December 6, 2021, 4:02pm

There is no setting that controls this. You will need to modify the source code.

Example

getredash/redash/blob/df472eb1d444e4e8389d2bf1d7251a5f1db6d3ae/client/app/pages/queries/components/QueryExecutionMetadata.jsx#L64


      
                  }>
                  <WarningTwoTone twoToneColor="#FF9800" />
                </Tooltip>
              </span>
            )}
            <strong>{queryResultData.rows.length}</strong> {pluralize("row", queryResultData.rows.length)}
          </span>
          <span className="m-l-5">
            {!isQueryExecuting && (
              <React.Fragment>
                <strong>{durationHumanize(queryResultData.runtime)}</strong>
                <span className="hidden-xs"> runtime</span>
              </React.Fragment>
            )}
            {isQueryExecuting && <span>Running&hellip;</span>}
          </span>
          {queryResultData.metadata.data_scanned && (
            <span className="m-l-5">
              Data Scanned
              <strong>{prettySize(queryResultData.metadata.data_scanned)}</strong>
            </span>

Change this line like so:

              <strong>{queryResultData.runtime * 1000} milliseconds</strong>

And the result will appear like this in the browser:

lscapim · December 17, 2021, 3:13pm

Thank you for the request,
We are using Redash in docker, how can i do in this case?
I never did this modifications. If you could explaim how i do.