Easier administration of Hue with the new Threads and Metrics pages

02 February 2018 in Administration / Version 4 - 2 minutes read

If you are an Administrator this post is for you! (in the contrary, the SQL Editor would be a great starting point).

In our last post we talked about how to optimally configure Hue with the Analytic Database engines Impala and Hive. This post describes how troubleshooting is getting easier for administrators, with the new Threads and Metrics pages. Those are in the Administration section, which can be accessed from the user menu:

The Administration page link when logged-in as an admin



Threads page can be very helpful in debugging purposes. It includes a daemonic thread and the thread objects serving concurrent requests. The host name, thread name identifier and current stack frame of each are displayed. Those are useful when Hue “hangs”, sometimes in case of a request too CPU intensive.


There is also a REST API to get the dump of Threads using ‘desktop/debug/threads’



Hue uses the PyFormance Python library to collect the metrics. These metrics are represented as gauge, counters, meter, rate of events over time, histogram, statistical distribution of values. A REST API endpoint ‘/desktop/metrics/’ to get all the metrics dump as json is also exposed.

The below metrics of most concern to us are displayed on the page

  • requests.active
  • requests.exceptions
  • requests.response-time
  • threads.daemon
  • threads.total
  • users
  • users.active
  • One of the most useful ones are the percentiles of response time of requests and the count of active users.

    Admins can either filter a particular property in all the metrics:

    Or select a particular metric for all properties:


    comments powered by Disqus

    More recent stories

    13 November 2019
    Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
    Read More
    31 October 2019
    Missing some color? How to improve or add your own SQL syntax Highlighter
    Read More
    24 October 2019
    How to create a HBase table on Kerberized Hadoop clusters
    Read More