Re: Sudden spike in WAL
От | Siraj G |
---|---|
Тема | Re: Sudden spike in WAL |
Дата | |
Msg-id | CAC5iy62bVkFBEmxFXF6vr0-jLKFq+fLHcxoXvf5YziVMWQCSaw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Sudden spike in WAL (Mahesh mana <maheshbabumms12@gmail.com>) |
Ответы |
Re: Sudden spike in WAL
|
Список | pgsql-admin |
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)
---------------------------------------------+------------------+-----------+--------+----------------+-----------+--------+------------+------+--------------+--------------+---------------------+------------+---------------
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:RegardsSiraj
Вложения
В списке pgsql-admin по дате отправления: