Postgres Pro
Downloads
Home   >   mailing lists

Thread: Logging VACUUM activity

Logging VACUUM activity

From
jao@geophile.com
Date:
I'm using postgresql 7.4.6 on RH9. My application includes a
long-running Java process responsible for database access. I'd like to
have this Java process initiate a daily VACUUM and, one way or
another, log VACUUM output.

- Is there some way to get VACUUM output via JDBC?

- If not, how can I get VACUUM output in the postgres logs? Setting
log_min_error_statement to INFO doesn't seem to have any effect.

Jack Orenstein


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Re: Logging VACUUM activity

From
"Joshua D. Drake"
Date:
On Mon, 2005-03-14 at 17:12 -0500, jao@geophile.com wrote:
> I'm using postgresql 7.4.6 on RH9. My application includes a
> long-running Java process responsible for database access. I'd like to
> have this Java process initiate a daily VACUUM and, one way or
> another, log VACUUM output.
>
> - Is there some way to get VACUUM output via JDBC?
>
> - If not, how can I get VACUUM output in the postgres logs? Setting
> log_min_error_statement to INFO doesn't seem to have any effect.

You can run the query vacuum verbose.

Sincerely,

Joshua D. Drake


>
> Jack Orenstein
>
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
--
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/

Re: Logging VACUUM activity

From
Jack Orenstein
Date:
Joshua D. Drake wrote:
> On Mon, 2005-03-14 at 17:12 -0500, jao@geophile.com wrote:
>
>>I'm using postgresql 7.4.6 on RH9. My application includes a
>>long-running Java process responsible for database access. I'd like to
>>have this Java process initiate a daily VACUUM and, one way or
>>another, log VACUUM output.
>>
>>- Is there some way to get VACUUM output via JDBC?
>>
>>- If not, how can I get VACUUM output in the postgres logs? Setting
>>log_min_error_statement to INFO doesn't seem to have any effect.
>
>
> You can run the query vacuum verbose.

I tried that. Whether I issue the VACUUM VERBOSE call through JDBC
or psql, I don't see anything in the postgres log file at all, even
with log_min_error_statement set to info.

In psql, I see the VACUUM VERBOSE output in the psql session itself,
but I need to log the output. I could spawn a psql session if necessary,
but ideally I'd just run VACUUM VERBOSE from JDBC and get the output
in the postgres log file.

Jack Orenstein