audit_license_size -- running many times?



I am wondering if it is normal to see many running select audit_license_size(); queries like the attached image shows.




  • SruthiASruthiA Vertica Employee Employee

    Yes. it is normal. Increase in data/ creating new projections will trigger audit_license_size query

  • Thanks for the quick reply.


    I just did a copycluster and am seeing many of these:


    Completed Queries: 202  as of 6 hrs ago. --- only 6 queries out of the 202 are something other than audit_license_size()


    Thanks again,



  • Would you really expect Completed Queries: 916 of these in < 12 hours?


    Something seems wrong.


    Thanks again,


  • If anyone else runs into this, it was fixed in a hotfix:


    VER-39069UI - Management ConsoleManagement Console previously performed continuous license audits, which could negatively affect performance of other queries. This issue has been resolved.


Leave a Comment

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