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
Question
Monitoring table refresh
+1
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.
+2@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.
+1Thanks Jim, running version 9 so script is useful.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
