It will have one line per component. And overlapping operations will be regrouped into one.
This should give a nice overview of the operations while remaining mininal.
I will create another issue for this.

We can easily aggregate the time spent by retrievals and group them as post-processors, agg providers and jit
This will allow to easily see where most of the time is spent

When using the tool with the following query plan, nothing happens :

queryplan.txt

AP version : 5.8.9

Details about external retrievals are not display in the tool, as it is looking for locations or measures, which are absent from external retrievals.

ExternalRetrieval #0: ExternalDatabaseRetrieval
	store= Rates
	fields= [`Currency`]
	JoinedMeasures= [Conversion Rate]
	Condition= `Currency` = Ccy1

plan.txt

With a simple query plan with one Measure, the tool doesn't show any Measure in the Summary tab.

query.txt

Trying to use https://activeviam.github.io/atoti-query-analyser/ with the latest directquery on the "Import from Server" I get the following error:

Uncaught (in promise) TypeError: e.retrievals is undefined
    n selection.js:37
    n selection.js:36
    Z selection.js:48
    e App.js:41
    l runtime.js:45
    _invoke runtime.js:274
    t runtime.js:97
    Babel 6
     App.js:15
    submitQuery Input.js:52
    importFromServer Input.js:40
    React 12
    unstable_runWithPriority scheduler.production.min.js:19
    React 18
    113 index.js:7
    i (index):1
    97 main.242db114.chunk.js:1
    i (index):1
    t (index):1
    r (index):1
     main.242db114.chunk.js:1
selection.js:37:47
    Babel 6
     App.js:15
    submitQuery Input.js:52
    importFromServer Input.js:40
    React 12
    bind_applyFunctionN self-hosted:1376
    Gt self-hosted:1339
    unstable_runWithPriority scheduler.production.min.js:19
    React 3
    bind_applyFunctionN self-hosted:1376
    Qt self-hosted:1339
    React 15
    113 index.js:7
    i (index):1
    97 main.242db114.chunk.js:1
    i (index):1
    t (index):1
    r (index):1
     main.242db114.chunk.js:1

This is with the latest ActivePivot 5.11 and latest atoti.

I do see the query to the server and the server answer so I think the parsing fails.

Here is the JSON answer:

queryPlan.zip

We should be able to compare two retrieval operations, to see differences in:

• the location
• the measures
• the cube filter
• the partitioning

Query plans start with the header like:

GetAggregatesQuery explanation
==============================

Earlier if one have chosen "text area", "v1" in the input menu, one may have put the query plan without the header. It does not work anymore and the error message is not clear:

TypeError: Cannot read properties of undefined (reading 'parentId')
at findRootInfo (src/components/Summary/Summary.tsx:392:16)
at Summary (src/components/Summary/Summary.tsx:416:20)
at renderWithHooks (node_modules/react-dom/cjs/react-dom.development.js:16305:22)
at mountIndeterminateComponent (node_modules/react-dom/cjs/react-dom.development.js:20074:17)
at beginWork (node_modules/react-dom/cjs/react-dom.development.js:21587:20)
at beginWork$1 (node_modules/react-dom/cjs/react-dom.development.js:27426:18)
at performUnitOfWork (node_modules/react-dom/cjs/react-dom.development.js:26557:16)
at workLoopSync (node_modules/react-dom/cjs/react-dom.development.js:26466:9)
at renderRootSync (node_modules/react-dom/cjs/react-dom.development.js:26434:11)
at recoverFromConcurrentError (node_modules/react-dom/cjs/react-dom.development.js:25850:24)

README.md instruction yarn --cwd atoti-query-analyzer start does not work. The folder is called atoti-query-analyser with 's' instead of 'z' in 'analyser'. Also, when I tried to run:

$ yarn
$ yarn --cwd atoti-query-analyser start

The first yarn command returned immediately and on start I got the error:

yarn run v1.22.19
$ react-scripts start
/bin/sh: 1: react-scripts: not found
error Command failed with exit code 127.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

The issue seems to be related to node_modules that cannot be correctly created by yarn in the folder atoti-query-analyser. I also tried

$ yarn --cwd atoti-query-analyser
$ yarn --cwd atoti-query-analyser start

But yarn --cwd atoti-query-analyser falls with an error:

yarn install v1.22.19
[1/4] Resolving packages...
[2/4] Fetching packages...
error [email protected]: The engine "node" is incompatible with this module. Expected version "^14 || ^16 || ^17 || ^18 || ^19". Got "20.5.1"
error Found incompatible module.
info Visit https://yarnpkg.com/en/docs/cli/install for documentation about this command

The only way to build the project that worked for me was to go to atoti-query-analyser folder and run npm install. Then yarn --cwd atoti-query-analyser start works.

External retrievals and standard retrievals seem to have their distinct id sequence. This results in plans containing multiple conflicting ids.
In the attached example, there is Retrieval #0 and ExternalRetrieval #0.

in the screenshot above, this is only one node "0"

plan.txt

Retrieval #0: PostProcessedAggregatesRetrieval
	....
 which depends on {
	Retrieval #1: PrimitiveResultsMerger
		....
	 which depends on {
		Retrieval #2: PrimitiveAnalysisAggregationRetrieval
			....
		 which depends on {
			...
			ExternalRetrieval #0: ExternalDatabaseRetrieval
				store= Rates
				fields= [`Currency`]
				JoinedMeasures= [Conversion Rate]
				Condition= `Currency` = Ccy1
		}
	}
...
}

Because the tool relies on these ids #<id>, this generates missing nodes.
It may be an issue with ActivePivot query plan printer.

It is not possible to analyse the attached query plan when loading it from V1.
query-plan.txt