How can I see executed the raw query?

[resulyrt93]

Hey team ✋ thanks for this great library, we love it.

We want to know is there any way to see the executed (or will be executed) raw mongo queries?

query = my_model.find(search_criteria)
query = query.limit(10).skip(0)
query = query.sort("create_at")
items = await query.to_list()

Let's say I have the above code block, is there sth like query.get_raw_query()?

Expected output:

{
  "filter": {"search_key": "search_value"}, 
  "sort": [{"create_at", 1}],
  "skip": 0,
  "limit": 10
}

or

db.my_model.find(
  { search_key: "search_value" }
).sort({ create_at: 1 }).skip(0).limit(10)

I need that to debug executed queries, aggregations when I face query related performance issues. That would great if I hands-on try on the executed query on db.

Thanks in advance

[resulyrt93]

Hey, I just wanted to ping again for this question, thanks in advance :)

[ComeTurrataOptimizConstruction]

I think you can do .get_filter_query() on a query, would that work for you ?

[FranciscoZanonDP]

While the library you are using (likely Motor/Pymongo based) often doesn't expose a direct .get_raw_query() method like an ORM might, you can achieve your goal by leveraging MongoDB's native logging/profiling tools or by utilizing the explain() method during development. The explain() method allows you to see the execution plan, which effectively contains the raw query structure (filter, sort, skip, limit) and execution statistics for debugging performance issues, as demonstrated by running await query.explain(). If you need constant logging of all executed queries, you must enable Database Profiling directly on your MongoDB server instance.