To debug an action, you can increase the log level and run the job manually in the foreground.

Use the run_job procedure, which takes a job_id argument. Because run_job is a stored procedure and not a function, it needs to be executed with CALL instead of SELECT.

  1. Change the minimum log level shown to the client. Set it to DEBUG1.

    SET client_min_messages TO DEBUG1;
  2. Run the job. Replace 1000 with your actual job_id.

    CALL run_job(1000);
Note

To find the job_id for your job, query the timescaledb_information.jobs table.

SELECT * FROM timescaledb_information.jobs;

Keywords

Found an issue on this page?Report an issue or Edit this page in GitHub.