See values behind parameterized INSERTs

+2

Is there any way to see what values were actually passed with a parameterized INSERT? For example;

INSERT INTO t1 (id, col1) VALUES (?, ?)

... is how the transaction appears in the dc_ tables and vertica.log.

Can't you use something like

select request from v_monitor.query_requests where request like '%insert%'

to see your insert statement and its values

+2

I think you might be onto something; it looks like dc_requests_* has the values.

Sign up