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


activity_id and operator_id in profile table — Vertica Forum

activity_id and operator_id in profile table

qihua_wuqihua_wu ✭
edited September 2023 in General Discussion

After ran a complex query profile, we save it to adhoc.profile_backup. Using the following query, we found one operation_id can be used by multiple activiity_id. operation_id is the number of a thread, then what's activity id?

And why a single sort has 4 activity id?

select distinct activity_id, operator_id from adhoc.profile_backup where path_id=62 and operator_name ilike 'sort' and node_name='v_node0032' and counter_value>0 order by operator_id

Tagged:

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