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

Every hour how much data loaded into each tables



I want to generate a report every hour how many rows inserter into a table. i am trying to aggregare it using LOAD_STREAMS tables. But that table gets cleared every hour. 


either I want to extend the retention period of Load_Streams table or any other way to get Loaded row count details in table wise.






    Quote from the doc on LOAD_STREAMS tables:


    "HP Vertica maintains system table metrics until they reach a designated size quota (in kilobytes). The quota is set through internal processes and cannot be set or viewed directly."


    I think this is not easy to change. You may want to work with HP Vertica support on this one.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.