Page 1 of 1

Queries run fast on pgadmin but not DBeaver

PostPosted: Mon May 16, 2016 4:32 pm
by alexpetralia
I have queries that hang on DBeaver yet run very fast on pgadmin. I have restarted DBeaver and the problem remains. I've turned off all metadata queries in the Preferences. I also am on Ubuntu. It almost feels like there's a DBeaver "wrapper" for the query that pgadmin doesn't have, and it's making the query slow. In this particular case, a "WHERE <col> NOT IN ( subquery )" made the query infinitely slow on DBeaver but ran fine on pgadmin. On the other hand, using a LEFT JOIN instead made the query run equally fast on both platforms. Does anyone know why this may be?

Re: Queries run fast on pgadmin but not DBeaver

PostPosted: Mon May 16, 2016 5:36 pm
by Serge
There are no special "wrappers" in DBeaver which can slow the query.
Main difference with pgAdmin is that DBeaver additionally reads database metadata (like table columns and foreign keys). But it makes metadata read only when if you accessing some table for the first time. And in most cases metadata reading works very fast.
You can check Query Manager view to see what actual query is executing at the moment and how much time it takes.

Re: Queries run fast on pgadmin but not DBeaver

PostPosted: Tue May 17, 2016 1:12 am
by alexpetralia