开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜