| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitch Collinsworth | 2010-05-25 19:38:38 | Re: How can I tell if I'm autovacuuming? |
| Previous Message | Josi Perez (3T Systems) | 2010-05-25 18:54:04 | Re: Trigger with dynamic SQL |