Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitda42b9f

Browse files
committed
Reimplement nullification of walsender timestamp
Make the value null only at pg_stat_activity-output time, as suggestedby Tom Lane, instead of messing with the internal state. This shouldappease buildfarm members with force_parallel_mode=regress, which arerunning parallel queries on logical replication walsenders.The fact that walsenders can run parallel queries should perhaps bestudied more carefully, but for the moment let's get rid of the redblots in buildfarm.Backpatch to pg10, like the previous commit.Discussion:https://postgr.es/m/30804.1578438763@sss.pgh.pa.us
1 parent0c046f8 commitda42b9f

File tree

2 files changed

+7
-8
lines changed

2 files changed

+7
-8
lines changed

‎src/backend/access/transam/xact.c

Lines changed: 0 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -758,13 +758,6 @@ GetCurrentTransactionStopTimestamp(void)
758758
void
759759
SetCurrentStatementStartTimestamp(void)
760760
{
761-
/*
762-
* Skip if on a walsender; this is not needed, and it confuses monitoring
763-
* if we publish non-NULL values.
764-
*/
765-
if (am_walsender)
766-
return;
767-
768761
if (!IsParallelWorker())
769762
stmtStartTimestamp=GetCurrentTimestamp();
770763
else

‎src/backend/utils/adt/pgstatfuncs.c

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -732,7 +732,13 @@ pg_stat_get_activity(PG_FUNCTION_ARGS)
732732
else
733733
nulls[7]= true;
734734

735-
if (beentry->st_xact_start_timestamp!=0)
735+
/*
736+
* Don't expose transaction time for walsenders; it confuses
737+
* monitoring, particularly because we don't keep the time up-to-
738+
* date.
739+
*/
740+
if (beentry->st_xact_start_timestamp!=0&&
741+
beentry->st_backendType!=B_WAL_SENDER)
736742
values[8]=TimestampTzGetDatum(beentry->st_xact_start_timestamp);
737743
else
738744
nulls[8]= true;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp