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

Knowledge Drop

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.                

Comments
FabGuada
Observer

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!

Version history
Last update:
‎07-07-2021 12:45 PM
Updated by: