Very slow metadata query while querying Vertica 7.1.2

Note: please leave bug reports and feature requests on

Very slow metadata query while querying Vertica 7.1.2

Postby msv615 » Thu Jan 14, 2016 10:15 pm

I'm using DBeaver 3.4.5, Vertica 7.1.2 and the 7.1.2 jdbc driver.

I have a simple SELECT COUNT(*) query that takes much longer in DBeaver than in vsql. When I look at Query Manager and watch it run I notice:

1. The time spent is waiting on "Load Columns" on the Metadata connection.
2. The Duration seems to lie. It claims 2ms, however I watched it run for almost 3 minutes while the original query finished in only 20 seconds.

Are there any ways of digging further into this or disabling the metadata queries?

Thanks!
msv615
 
Posts: 1
Joined: Thu Jan 14, 2016 10:10 pm

Return to Support



Who is online

Users browsing this forum: No registered users and 4 guests