Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Replaying WAL slowly - Mailing list pgsql-performance

From Jeff Frost
Subject Re: Postgres Replaying WAL slowly
Date
Msg-id B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com
Whole thread Raw
In response to Re: Postgres Replaying WAL slowly  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Responses Re: Postgres Replaying WAL slowly
List pgsql-performance
Tree view

On Jun 30, 2014, at 12:54 PM, Matheus de Oliveira <matioli.matheus@gmail.com> wrote:


On Mon, Jun 30, 2014 at 4:42 PM, Jeff Frost <jeff@pgexperts.com> wrote:
And if you go fishing in pg_class for any of the oids, you don't find anything:

That is probably because you are connected in the wrong database. Once you connect to the database of interest, you don't even need to query pg_class, just cast relation attribute to regclass:

    SELECT relation::regclass, ...
    FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database());


Yah, i thought about that too, but verified I am in the correct DB.  Just for clarity sake:

SELECT relation::regclass
    FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) and mode = 'AccessExclusiveLock';

  relation
------------


 3245508214
 3245508273
 3245508272
 3245508257
 3245508469
 3245508274
 3245508373
 3245508468
 3245508210
 3245508463
 3245508205
 3245508260
 3245508265
 3245508434
(16 rows)

pgsql-performance by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: Postgres Replaying WAL slowly
Next
From: Andres Freund
Date:
Subject: Re: Postgres Replaying WAL slowly