Queries run fast on pgadmin but not DBeaver

Note: please leave bug reports and feature requests on

Queries run fast on pgadmin but not DBeaver

Postby alexpetralia » Mon May 16, 2016 4:32 pm

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?
alexpetralia
 
Posts: 2
Joined: Mon May 16, 2016 4:20 pm

Re: Queries run fast on pgadmin but not DBeaver

Postby Serge » Mon May 16, 2016 5:36 pm

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Queries run fast on pgadmin but not DBeaver

Postby alexpetralia » Tue May 17, 2016 1:12 am

alexpetralia
 
Posts: 2
Joined: Mon May 16, 2016 4:20 pm


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 4 guests