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


COST_STATUS in EXPLAIN — Vertica Forum

COST_STATUS in EXPLAIN

ligialigia
in General Discussion

When I run "EXPLAIN JSON", one of the things I get back is "COST_STATUS". I have looked in the documentation but can't find what it means, does anyone know anything about this?

Comments

  • Ben_VandiverBen_Vandiver Employee

    COST_STATUS explains whether the cost is based on good statistics or not. Other than "GOOD", it can be NO_STATISTICS (self evident) or PREDICATE VALUE OUT-OF-RANGE (estimated predicate selectivity due to stale statistics). The value not being GOOD doesn't necessarily mean the plan is bad, merely that it was based on (more) guesswork by the optimizer.

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 ...