Re: Sudden spike in WAL

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(at)gmail(dot)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(dot)g(at)gmail(dot)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: image.png]
>> Regards
>> Siraj
>>
>