Answers

• SruthiA Administrator

  March 2023

  @Sergey_Cherepan_1 ; It is getting logged in dc_requests_issued but as a part of different txn id

  I have run below to call the stored procedure. as you can see it logged the query, but as a part of other txn id.

  eonv1203=> call result1();

  result1

     0
  

  (1 row)

  select node_name, transaction_id, statement_id,request from dc_requests_issued order by time desc;

  v_eonv1203_node0001 | 45035996273735120 | 1 | select ($1)::int
  v_eonv1203_node0001 | 45035996273735118 | 1 | SELECT * FROM t1 ORDER BY b DESC
  v_eonv1203_node0001 | 45035996273735117 | 1 | call result1();
  v_eonv1203_node0001 | 45035996273735116 | 1 | CREATE PROCEDURE result1() LANGUAGE PLvSQL AS $$
  DECLARE
  x int;
  BEGIN
  x <- SELECT * FROM t1 ORDER BY b DESC; -- x is now assigned the first row returned by the SELECT query
  RETURN;
  END;
  $$;

  0
• Sergey_Cherepan_1 ✭✭✭

  March 2023

  Thanks for looking!
  Yes I found that SQL is logged in dc requests issued under different transaction Id.
  Question here - how I can monitor SQL executed in stored procedure.
  I want to see what SQL is being executed right now, and how long it is running.

  0
• Bryan_H Vertica Employee Administrator

  March 2023

  Stored procedures run in an internal session that you can view with "select * from vs_sessions;"

  2
• Sergey_Cherepan_1 ✭✭✭

  March 2023

  Interesting... thanks for hint, will investigate how it works.

  0