Monitoring table refresh

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.

  • Thanks Jim, running version 9 so script is useful.

Leave a Comment

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