The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Weird execution time for a query

Hi ,

I have a table with 10 columns 7 numeric and 3 chars , it include 6m records , reading all table data take about 50secounds , i run a profile on top of simple select * from the table and seems like the most query time was spend of the Root stage .

My understanding is that probably most of the time that was spend he is for the uncompressed of the data (See attach execution , i add execution time + clock time on it ) , seeing the high clock time lead to  the understanding that it spend the time on the uncompressed  stage 

Please advise .

image

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.