Options

when will v_monitor.execution_engine_profiles be populated?

qihua_wuqihua_wu ✭
in General Discussion

Per the document, it said when we profile a sql, it will populate this table. But from our system, we have many sql which are not profiled, this table is also populated for them. I am wondering whether this kind of populated data when no profile is partial in comparison when doing profile. Or the only difference between profile and non-profile is to print out the mem usage message?

Answers

  • Options
    SruthiASruthiA Vertica Employee Administrator

    it will populate even when the query is not profiled as long as the execution time of query crosses value set for SaveDCEEProfileThresholdUS

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