I've been working on a new explain mode for multi-stage queries that is able to include physical information (aka whether indexes are being used or not). It is still a draft, but you can start to look at it if interested: https://github.com/apache/pinot/pull/13733