Knowledge Drop

What System Activity explore query will give me the same info as the Admin --> Queries panel?

  • 7 July 2021
  • 1 reply
  • 55 views

Userlevel 5

Last tested: Aug 25, 2020
 

Yes! We can use the following System Activity query appended to our hostname to get (almost) all of the same information:

/explore/system__activity/history?fields=history.created_time,history.status,history.connection_name,user.name,history.source,query.id,query.model,query.view,history.id,history.runtime,query.link,query.formatted_fields&f[query.created_time]=NOT+NULL&sorts=history.created_time+desc&limit=500&column_limit=50&vis=%7B%22x_axis_gridlines%22%3Afalse%2C%22y_axis_gridlines%22%3Atrue%2C%22show_view_names%22%3Afalse%2C%22show_y_axis_labels%22%3Atrue%2C%22show_y_axis_ticks%22%3Atrue%2C%22y_axis_tick_density%22%3A%22default%22%2C%22y_axis_tick_density_custom%22%3A5%2C%22show_x_axis_label%22%3Atrue%2C%22show_x_axis_ticks%22%3Atrue%2C%22y_axis_scale_mode%22%3A%22linear%22%2C%22x_axis_reversed%22%3Afalse%2C%22y_axis_reversed%22%3Afalse%2C%22plot_size_by_field%22%3Afalse%2C%22trellis%22%3A%22%22%2C%22stacking%22%3A%22%22%2C%22limit_displayed_rows%22%3Afalse%2C%22legend_position%22%3A%22center%22%2C%22point_style%22%3A%22none%22%2C%22show_value_labels%22%3Afalse%2C%22label_density%22%3A25%2C%22x_axis_scale%22%3A%22auto%22%2C%22y_axis_combined%22%3Atrue%2C%22ordering%22%3A%22none%22%2C%22show_null_labels%22%3Afalse%2C%22show_totals_labels%22%3Afalse%2C%22show_silhouette%22%3Afalse%2C%22totals_color%22%3A%22%23808080%22%2C%22type%22%3A%22looker_column%22%2C%22defaults_version%22%3A1%7D&filter_config=%7B%22query.created_time%22%3A%5B%7B%22type%22%3A%22%21null%22%2C%22values%22%3A%5B%7B%22constant%22%3A%2260%22%2C%22unit%22%3A%22sec%22%7D%2C%7B%7D%5D%2C%22id%22%3A10%2C%22error%22%3Afalse%7D%5D%7D&dynamic_fields=%5B%5D&origin=share-expanded

 

 

 

This content is subject to limited support.                

 

 


1 reply

Hey! Nice tip, however I was looking at the generated content and it's not matching the realtime running queries. It looks like each query is "shown" in the system activity model after 5 mins or so. 

Is there another way to see the exact running queries we currently have? Keep in mind most of our queries will run in less than 10 seconds, so it might be real time.

We want to have an admin dashboard to identify (and alert) when we have an excessive number of concurrent running queries. Is that possible?

Thanks in advance!

Reply