Missing generated query from Slamdata 2.x in 4.x

[johan....@gmail.com]

Hi, 

I'm trying to improve query performance in slamdata (which many times can take several minutes in our case) by creating indexes but I find it a bit difficult to know which indexes to create. I recon it would be easier if I could see the generated aggregation query that Slamdata generates. Is it possible to show the generated MongoDB query in Slamdata like you could in version 2?

Regards,

/Johan

[do...@slamdata.com]

Hi Johan, unfortunately there is not a way to see the generated Mongo query in the SlamData interface. You can connect to your MongoDB server and run db.currentOp() while a long running query in SlamData is running and you should see the query that's running at that time. Granted this is not as easy, but might provide you the information you're looking for.

You can also enable profiling on your MongoDB server and see the queries in the log. See the MongoDB documentation at https://docs.mongodb.com/manual/reference/method/db.setProfilingLevel/