Re: Sudden spike in WAL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxx> 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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux