In Datagrip (using 2018.2.4), you can right-click on a query and choose 'Explain' which gives nicely formatted output. Is there anyway to get this nicely formatted output using instead 'Explain Analyze'?
DataGrip – Using EXPLAIN ANALYZE GUI
datagrip
Related Solutions
EXPLAIN ANALYZEis showing you the planning and execution time.DataGrip is showing you the completion time. This may include,
- Network transit
- Drawing in the GUI, etc.
Just think, if you have a one-row table with one bytea column that contains 2GB, transferring it across the network or even using TCP/IP will be a substantial transit compared to the planning and execution of the query.
[2017-02-10 21:38:30] 134 rows retrieved starting from 1 in 135ms (execution: 127ms, fetching: 8ms)
That's 134 rows you didn't have to retrieve using EXPLAIN ANALYZE.
This ended up being really simple and a very silly mistake, but hopefully this will help someone else.
I simply needed to select the correct database. The default is postgres. The database I had my tables in was webadmin. You can change the database when you make your connection in datagrip. The screen where I made the change looked like this
Best Answer
Unfortunately, not yet, Bob =( https://youtrack.jetbrains.com/issue/DBE-5373