Can I visualize a queryplan if I have the raw JSON?

I’m tracing down slow queries and have some raw execution plans, generated from .aggregate(pipeline, {explain: true}).

Is there a tool somewhere - so I can import the raw JSON and get the information visualized - or do I need to read the JSON raw?

Hi @Alex_Bjorlig,

I was working on a similar plugin to compass to visualise explain from raw but it was never published.

Can I ask you to open a https://feedback.mongodb.com so I can try and push this option forward?

CC: @Massimiliano_Marcon :blush:

Thanks
Pavel

1 Like

Hi @Pavel_Duchovny .

Do you envision this is a feature of Compass?

Do you know if it’s possible to explain an aggregation query in Compass today?

Hi @Alex_Bjorlig,

As far as I recall its only available in query document tab and not in aggregation builder.

But my feature idea was to parse both aggregation and query.

Thanks
Pavel

Ok, nice! And would that be inside compass? (I just wan’t to make sure to put the feature request in the right place)

Well you don’t have to explicitly say it , jist mention you would love to see an explain plan visualise tool like the one in compass query today :wink:

It’s here :rocket: