Re: Add ps display while waiting for wal in read_local_xlog_page_guts

2023-04-13 Thread Drouvot, Bertrand
Hi, On 4/13/23 4:29 AM, Tom Lane wrote: sirisha chamarthi writes: pg_create_logical_replication_slot can take longer than usual on a standby when there is no activity on the primary. We don't have enough information in the pg_stat_activity or process title to debug why this is taking so long.

Re: Add ps display while waiting for wal in read_local_xlog_page_guts

2023-04-13 Thread Drouvot, Bertrand
Hi, On 4/13/23 12:43 AM, sirisha chamarthi wrote: Hi, pg_create_logical_replication_slot can take longer than usual on a standby when there is no activity on the primary. We don't have enough information in the pg_stat_activity or process title to debug why this is taking so long. Attached

Re: Add ps display while waiting for wal in read_local_xlog_page_guts

2023-04-12 Thread Tom Lane
sirisha chamarthi writes: > pg_create_logical_replication_slot can take longer than usual on a standby > when there is no activity on the primary. We don't have enough information > in the pg_stat_activity or process title to debug why this is taking so > long. Attached a small patch to update

Add ps display while waiting for wal in read_local_xlog_page_guts

2023-04-12 Thread sirisha chamarthi
Hi, pg_create_logical_replication_slot can take longer than usual on a standby when there is no activity on the primary. We don't have enough information in the pg_stat_activity or process title to debug why this is taking so long. Attached a small patch to update the process title while waiting