Postgres Pro
Downloads
Home   >   mailing lists

Re: Cleaning job statistics - Mailing list pgadmin-support

From Dave Page
Subject Re: Cleaning job statistics
Date
Msg-id 45F7B501.10105@postgresql.org
Whole thread Raw
In response to Cleaning job statistics  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgadmin-support
Tree view 
Sabin Coanda wrote:
> Hi,
>  
> I'd like to clean my statistics list of a job step.
> Do you know how, please ?
>

If I remember correctly, something like:

DELETE FROM pgagent.pga_jobsteplog WHERE jsljstid = <job step ID>;

Regards, Dave

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Where is located pgAgent log on Linux ?
Next
From: "Sabin Coanda"
Date:
Subject: Re: Cleaning job statistics