1

Issue Summary

I have a query issue on redash. Some of the query tasks I have scheduled are everyday, then the Runtime and Last Executed At fields still return results and show but for some other query tasks, the two fields above do not appear to be empty and empty. But when I entered the query manually press it still shows the runtime and retrieves the data successfully updated. I hope everyone will help me in this case. Thank you all so much.

Technical details:

  • Redash Version:
  • Browser/OS: MacOS
  • How did you install Redash: pull to github, after that checkout, install and run docker .
2

Do all your queries use the same data source?

Do you see execution time and duration on the query_results table of the metadata database?

3

i have see it !

image
image1400×554 45.7 KB

4

but when I go out this page after that it still blank.

5

image
image823×283 33.4 KB

6

meanwhile some other tags are still working!

image
image819×200 20.4 KB

7

Seems like the sync_user_details job might be failing on your instance. Do you see any record of it in your logs?

If your queries use parameter then you won’t see the runtime or last executed information. The sync_user_details job doesn’t apply here. I mistook the query list screen for the user list screen.

8

can i know the unit of runtime in query_result table in postgres database , is it sec on milli sec.

9

@Quanglam form where are we getting this view?