Page 1 of 1

Very slow metadata query while querying Vertica 7.1.2

PostPosted: Thu Jan 14, 2016 10:15 pm
by msv615
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!