Disabling enable_sproc_hist_logging

Learn how to disable enable_sproc_hist_logging.

Note: After you disable this parameter, queries from stored procedure that is run from current session are not recorded in the query history database.

Disabling enable_sproc_hist_logging globally

  1. Set the following line in postgresql.conf.
    enable_sproc_hist_logging = false
  2. Restart Netezza Performance Server

Disabling enable_sproc_hist_logging at a session level

  1. Set enable_sproc_hist_logging to false:
    1. SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
    2. 
SHOW VARIABLE
SYSTEM.ADMIN(ADMIN)=> set enable_sproc_hist_logging=false;
SET VARIABLE
SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
      Example: 
      SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
NOTICE: ENABLE_SPROC_HIST_LOGGING is on
SHOW VARIABLE
SYSTEM.ADMIN(ADMIN)=> set enable_sproc_hist_logging=false;
SET VARIABLE
SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
NOTICE: ENABLE_SPROC_HIST_LOGGING is off
SHOW VARIABLE