开发者

How to see "Actual execution plan" of our query in python?

开发者 https://www.devze.com 2023-01-24 19:27 出处:网络
I have a sql query in python which is pretty slow, it contain some inner join, And some one suggest that in this case we can:turn on the \"Show Actual Execution Plan\" option and then take a close lo

I have a sql query in python which is pretty slow, it contain some inner join,

And some one suggest that in this case we can: turn on the "Show Actual Execution Plan" option and then take a close look at what is causing the slowdown.

Here some one has similar prolem as me : Slow SQL Query due to inner and left join?

Does anyone know how can I see the "Actual Execution Plan" and "estimated Execution Plan" in sqlite inside a python script?

I found some defenitions here开发者_如何学编程 : http://www.simple-talk.com/sql/performance/execution-plan-basics/ But still don't know how to do it in python, Any recommendation?

cheers

Atieh


You issue the EXPLAIN query the same as you would any other query.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号