This one takes 55 seconds on apache superset

hypertable.sql

SELECT DATE_TRUNC('day', time) AS __timestamp,
       fill_level AS fill_level,
       AVG(sensor_id) AS "AVG(sensor_id)"
FROM demo.fill_measurements
JOIN
  (SELECT fill_level AS fill_level__,
          AVG(sensor_id) AS mme_inner__
   FROM demo.fill_measurements
   GROUP BY fill_level
   ORDER BY mme_inner__ DESC
   LIMIT 100) AS anon_1 ON fill_level = fill_level__
GROUP BY fill_level,
         DATE_TRUNC('day', time)
ORDER BY "AVG(sensor_id)" DESC
LIMIT 10000;