NewEENode counter in execution_engine_profiles

May_1

Does anyone know what counter NewEENode in execution_engine_profiles means? What type of operation is it? I can't find related information in the documentation.

[Deleted User]

Hi May, NewEENode is a Vertica implementation detail; it has to do with how Vertica happens to stitch together certain pieces of query execution. (You can see it in the graphs generated by EXPLAIN.) It doesn't correspond to any logical operation; as such it shouldn't use significant resources and shouldn't impact query performance. If you look at the graphical query plan, you can sometimes use NewEENode's counters to identify how a particular portion of a running query is progressing. It's probably not the most useful entry in that table. But every now and then it's kinda handy, and it's easy to filter out :-) Adam