pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-admin@postgresql.org
Subject: Re: determining which table is being vacuumed by autovacuum (SOLVED)
Date: Thu, 23 Aug 2007 11:23:40 -0600
Message-ID: <200708231123.40357.kevin@kevinkempterllc.com> (raw)
In-Reply-To: <16624.1187842205@sss.pgh.pa.us>
References: <200708221525.45292.kevin@kevinkempterllc.com>
<16624.1187842205@sss.pgh.pa.us>
On Wednesday 22 August 2007 22:10:05 Tom Lane wrote:
> Kevin Kempter <kevin@kevinkempterllc.com> writes:
> > Then I ran this:
> >
> > postgres=# select relation from pg_locks where pid = 9902;
> > relation
> > -----------
> > 82097999
> > 143763216
> > 143763215
> > 143763193
> > 143763193
> > 143763217
> > (7 rows)
> >
> > However none of these seem to have a corresponding pg_class oid, see
> > the below queries:
>
> This most likely means that the vacuum is happening in a different
> database than you are looking in. Did you check
> pg_stat_activity.datname?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
I sent this once but it never showed up on the list, so just to make sure it
gets into the archives here it is again:
All;
I had a brain-dead moment (user-error). It turns out that the above queries do
work fine when they're both run against the same database.
view thread (3+ messages)
Message-ID: <200708231123.40357.kevin@kevinkempterllc.com> Permalink: ../200708231123.40357.kevin@kevinkempterllc.com/ Also on: postgresql.org/message-id/200708231123.40357.kevin@kevinkempterllc.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-admin@postgresql.org Cc: kevin@kevinkempterllc.com Subject: Re: determining which table is being vacuumed by autovacuum (SOLVED) In-Reply-To: <200708231123.40357.kevin@kevinkempterllc.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox