Clear query result before running new query

Answered

I switched from SQL Workbench/J to DataGrip and so far so good. There are, however, few little things that I miss or hopefully can't just find in settings.

The main one is so that the console query results are cleared when I resubmit the query. Sometimes I don't know if the query ran or not because there isn't a lot of indication that the query has run. Is it possible?

 

4 comments
Comment actions Permalink

@Dawid Nawrot,

You can check execution time in SQL Log which is in Output:

 

Also, if you need to pin results and execute another one - use Pin Tab

 

And result set comparison tool

0
Comment actions Permalink

It's not really what I'm after. While having query Result 1 in the view, when I change the query and execute it again I would like it to be cleared before the new query runs. It's still the same query but perhaps with more refined filters and sometimes, if query takes a long time I won't know if it executed unless I do all these extra steps of checking the log.

 

If I press Execute and see that previous results are cleared then I already know that what I'll see once it's completed are the new results.

0
Comment actions Permalink

@Dawid Nawrot,

> if query takes a long time I won't know if it executed unless I do all these extra steps of checking the log.
There is a notification for long running queries in Event Log.

But the best way to track Output to ensure what was executed or not.

 

0
Comment actions Permalink

It also requires witching windows, unnecessary extra step. When I press CTRL+E  and keep changing the query that log becomes less useful by the minute as you have to keep looking at the time, not to mention I am able to change query few times within one minute.

 

At the moment the only indication of running new query is this:

Also not very prominent, is it?

0

Please sign in to leave a comment.