Skip site navigation (1) Skip section navigation (2)

Re: How can I tell if I'm autovacuuming?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Mitch Collinsworth <mitch(at)ccmr(dot)cornell(dot)edu>
Cc: Joshua D(dot) Drake <jd(at)commandprompt(dot)com>, Doug Gorley <doug(dot)gorley(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How can I tell if I'm autovacuuming?
Date: 2010-05-25 18:59:37
Message-ID: 1274813948-sup-8946@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Excerpts from Mitch Collinsworth's message of mar may 25 14:40:04 -0400 2010:

> I'm wondering about the same question.  I did the above and restarted,
> and now my pg_stat_user_tables looks like this:
> 
> postgres=# \d pg_stat_user_tables
> View "pg_catalog.pg_stat_user_tables"
>      Column     |  Type  | Modifiers
> ---------------+--------+-----------
>   relid         | oid    |
>   schemaname    | name   |
>   relname       | name   |
>   seq_scan      | bigint |
>   seq_tup_read  | bigint |
>   idx_scan      | bigint |
>   idx_tup_fetch | bigint |
>   n_tup_ins     | bigint |
>   n_tup_upd     | bigint |
>   n_tup_del     | bigint |

I'd say you're running 8.1, not 8.2 as initially stated.

-- 
Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>

In response to

Responses

pgsql-admin by date

Next:From: Mitch CollinsworthDate: 2010-05-25 19:38:38
Subject: Re: How can I tell if I'm autovacuuming?
Previous:From: Josi Perez (3T Systems)Date: 2010-05-25 18:54:04
Subject: Re: Trigger with dynamic SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group