Re: Cleaning job statistics

From: Dave Page <dpage(at)postgresql(dot)org>
To: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Cleaning job statistics
Date: 2007-03-14 08:40:33
Message-ID: 45F7B501.10105@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Sabin Coanda 2007-03-14 09:25:22 Re: Cleaning job statistics
Previous Message Dave Page 2007-03-14 08:30:21 Re: Where is located pgAgent log on Linux ?