Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Answers

  • 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

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