Options

EON and disk_storage view

bmurrellbmurrell Community Edition User ✭
in General Discussion

I'm running v24.1 on EON. We have a number of other Enterprise databases running v12, and I extract from disk_storage daily ("DATA,TEMP") to show growth over time.
For EON this view isn't populated with the S3 side of things.
How can I extract node usage for communal storage? I can of course look in the S3 vendor's tool, but this is a collection process.
Thanks

Tagged:

Answers

  • Options
    SruthiASruthiA Vertica Employee Administrator

    we dont have anything to view communal usage.. communal is at global level not at node level. you need to you s3 vendor's tool to find the usage growth

  • Options
    Bryan_HBryan_H Vertica Employee Administrator

    V_MONITOR.STORAGE_CONTAINERS has the sizes of ROS containers in Eon communal storage (divided by 2^30 for gigabytes in this example):
    select sum(used_bytes)/(2^30) from v_monitor.storage_containers;

    ?column?

    2793.33258333523

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...