We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


large spike of IO write ( io_written_kbytes_per_second) — Vertica Forum

large spike of IO write ( io_written_kbytes_per_second)

Balu_VenkataBalu_Venkata
in General Discussion
We happen to draw system resources usage graph for 24 window, where in we noticed spike of IO write and specific point in time.  to reason out we dig out more  we moved to  Tuple_mover_operations to see if any mergout happened for the particular timeframe, but no success .

My questions ?

1) Is there a way to know what cause this IO spike ?
2) Can we  know, how much of IO do a perticular query take ? no system table gives this info @ query level.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...