Unfortunately there is currently no way in the UI to identify which queries are no longer in use. For constantly enhanced applications this could lead to over 100 queries and or aggregations in single Table. There should be indication which are not is use to easy remove it in a bulk way.
Its not great-- but FYI for fellow strugglers-- if you rename a query and hit save, you will see a warning with a list of all apps which are using it.