[SQL_MAGIC] Return transaction_id / statement_id on PROFILE

[yakirgb]

Hi Vertica team,
Small question/idea
When running PROFILE on vsql , i'm getting in result:
HINT: Select * from v_monitor.execution_engine_profiles where transaction_id=63050394809876088 and statement_id=3;
But when running:

%load_ext verticapy.sql
%%sql
PROFILE SELECT..

I see the result of query but without the part of transaction_id and statement_id.

Is it possible to add for %%sql new flag of --profile? like %%sql --file query.sql --profile
Or just return trx_id too if the command starting with PROFILE.

After this command i'm using QPROF with:

from verticapy.performance.vertica import QueryProfilerInterface
from verticapy.performance.vertica import QueryProfiler

qprof_interface = QueryProfilerInterface((63050394809876088,3),
    key_id='yakir_1',
    target_schema='tests',
    overwrite=True
    )

Thank you,
Yakir Gibraltar.

[yakirgb]

Upgraded vertica-python to 1.3.8
Looks better, but something still not good:
VerticaPy output:

/usr/local/lib/python3.11/site-packages/vertica_python/vertica/connection.py:653: UserWarning:

[NOTICE] Statement is being profiled

/usr/local/lib/python3.11/site-packages/vertica_python/vertica/connection.py:653: UserWarning:

[NOTICE] Initiator memory for query: [on pool dba_pool: 19922944 KB, minimum: 327377 KB]

/usr/local/lib/python3.11/site-packages/vertica_python/vertica/connection.py:653: UserWarning:

[NOTICE] Total memory required by query: [19922944 KB]

And this is what i see on vsql:

NOTICE 4788:  Statement is being profiled
HINT:  Select * from v_monitor.execution_engine_profiles where transaction_id=121597190033954370 and statement_id=3;
NOTICE 3557:  Initiator memory for query: [on pool sysquery: 8314 KB, minimum: 8314 KB]
NOTICE 5077:  Total memory required by query: [8314 KB]

This part is missing:
HINT: Select * from v_monitor.execution_engine_profiles where transaction_id=121597190033954370 and statement_id=3

[yakirgb]

Issue resolved on vertica-python 1.3.8 ,
I reinstalled the env and all good.