Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to see Query Execution Time in DataGrip?

I am not able to see any query execution time option ORACLE DB's PL/SQL in JetBrain's DataGrip. There are no any help about this in JetBrain's help pages.

Any help will be greatly appreciated.

like image 937
Prometheus Avatar asked Mar 22 '17 07:03

Prometheus


People also ask

How do you check query execution time?

Using Client StatisticsGo to Menu >> Query >> Select Include client Statistics. Execute your query. In the results panel, you can see a new tab Client Statistics. Go to the Client Statistics tab to see the execution time.

How do I view query history in DataGrip?

Right-click anywhere in the editor and choose Local History | Show History from the context menu. In the dialog that opens, the left-hand pane shows a list of all saved revisions of the current file with timestamps.

How do I find the execution plan in DataGrip?

Execution Plan in DataGripRight-click in your query, select Explain Plan > Explain Plan. You'll see the execution plan in a tab at the bottom of the screen. It looks similar to the SQL Developer execution plan, as you can see the operation, object name, rows, total cost, and a description.


1 Answers

This problem is going to be solved with the 2017.1 version of DataGrip. For Details : https://youtrack.jetbrains.com/issue/DBE-3063

like image 125
Prometheus Avatar answered Oct 24 '22 10:10

Prometheus