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!
Effective way to track INSERT process

Hello,
I try to find the effective way to track INSERT process. Sometimes INSERT statements can take too long to execute. It'd be great to have a possibility to track them.
I understand that the EE operators counters are what I need, but there is no detailed information about the underlying EE processes. Therefore, it's difficult to understand which counters should be used.
0
Answers
The following script example shows the step differences between two INSERT statements.
Thanks for the answer, but that's not exactly what I'm trying to find. I want to get an output like this:
+++++
Rows to proceed:
Rows proceeded:
select output_rows
from query_consumption
where LABEL='The_INSERT_Label';
-- OR --
with my_insert as (
select transaction_id,statement_id
from query_requests
where REQUEST_LABEL = 'The_Insert_Label'
-- OR add: and is_executing
)
select
eep.node_name, eep.operator_name, eep.counter_value
from execution_engine_profiles eep, my_insert mi
where
eep.transaction_id = mi.transaction_id
and eep.statement_id = mi.statement_id
and counter_name='rows produced'
and operator_name='NewEENode'
order by 1;