The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

explain local version: How to understand section "Estimated resources for plan:"

I have the following info in "Estimated resources for plan:".
Scratch Memory MB: 897
File Handles: 1005
Worker Threads: 24
Blocking Threads: 75
Externalizing Ops: 0
Unbounded Mem Ops: 0
Max Threads: 16

what's the meaning of Unbounded Mem Ops and Externalizing Ops? And there are 3 kinds of threads, what's the relationship among them? Worker Threads,Blocking Threads and Max Threads


  • Great questions!
    Not sure why you want to go that deep. Well, except if you want to rewrite Vertica by yourself :-)

Leave a Comment

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