We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Memory Usage — Vertica Forum

Memory Usage

soapssoaps Vertica Customer
edited March 2023 in General Discussion

How can I check the memory being used by my tables and overall db. Also want to check if I am reaching memory limit allocated to me and how I am being charged.

Answers

  • VValdarVValdar Vertica Employee Employee

    It depends, are you referring to space consumed on the cluster - meaning after encoding, compressions and buddy projections - or space counted toward the license?
    For the first one you can check in the storage_containers relation, for the second one you can run the AUDIT command.

This discussion has been closed.