Postgres Pro
Downloads
Home   >   mailing lists

Re: Sudden spike in WAL - Mailing list pgsql-admin

From Siraj G
Subject Re: Sudden spike in WAL
Date
Msg-id CAC5iy62bVkFBEmxFXF6vr0-jLKFq+fLHcxoXvf5YziVMWQCSaw@mail.gmail.com
Whole thread Raw
In response to Re: Sudden spike in WAL  (Mahesh mana <maheshbabumms12@gmail.com>)
Responses Re: Sudden spike in WAL
List pgsql-admin
Tree view
Hi Mahesh

Yes, I noticed an inactive replication slot.

select * From pg_replication_slots where not active;
                 slot_name                  |      plugin      | slot_type | datoid |    database    | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn  | confirmed_flush_lsn | wal_status | safe_wal_size
---------------------------------------------+------------------+-----------+--------+----------------+-----------+--------+------------+------+--------------+--------------+---------------------+------------+---------------
 pgl_marketing_prod_provider_marketin3444436 | pglogical_output | logical   |  16648 | marketing_prod | f         | f      |            |      |    244033832 | E0C/DABEE880 | E0C/DABF1870        | extended   |              
(1 row)

How do I see the timestamp it became inactive? 

On Sun, Jun 30, 2024 at 12:24 AM Mahesh mana <maheshbabumms12@gmail.com> wrote:

Hi,

Please check if you have any inactive replication slot.

Thanks,Mahesh.

On Sun, Jun 30, 2024, 12:22 AM Siraj G <tosiraj.g@gmail.com> wrote:
Hello!

I am trying to figure out why we had a sudden spike in WAL (on 12th Jun at around 6:30pm IST). The storage has not got back to its original state since then.

Please assist if there is a way we can find it out. The instance is a GCP cloud managed and PgSQL version is 13.

Please see the spike below:

image.png
Regards
Siraj
Attachment

pgsql-admin by date:

Previous
From: Mahesh mana
Date:
Subject: Re: Sudden spike in WAL
Next
From: Mahesh mana
Date:
Subject: Re: Sudden spike in WAL