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


Monitoring table refresh — Vertica Forum

Monitoring table refresh

Tim_1Tim_1 ✭✭
in General Discussion

Hi,
Sorry, I'm sure the answer is already in the forum, but I can't find it.
After adding a new projection to a table I'm running a "select refresh" of the table. Is there any way of monitoring the progression to see how much it still has to do?
Regards
Tim

Best Answer

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    Answer ✓

    @Tim_1 - Following up on @s_crossman's recommendation, note that Vertica 11 added a new super informative column named PERCENT_COMPLETE to the PROJECTION_REFRESHES system table!

    If you are running a version of Vertica < 11, you can create a database view manually that mimic's Vertica 11's PROJECTION_REFRESHES system table using the attached script.

Answers

  • s_crossmans_crossman Vertica Employee Employee

    Tim,

    There is a Vertica system table PROJECITON_REFRESHES that I think will give you the details you are looking for. Info on it can be found in the SQL Reference Manual under the V_Monitor systems tables section.

    I hope it helps.

  • Tim_1Tim_1 ✭✭

    Thanks Jim, running version 9 so script is useful.

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 ...