pgstat: Flush some statistics within running transactions, take 2

7 patchsets tracked - current t139667_18

v18t139667_18posted 2 days agosuccessappliesrecent 0dpg 20

basef20c42783 1 day ago on master

applyapplied about 9 hours ago

rebaselast tried about 9 hours ago on f20c42783

pushabout 9 hours ago -> 926372183 branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1023 / 1023	2m 55s / 5m 29s	`docker run ... :t139667`	about 9 hours ago
run 32650414838 executed 1023 - ccache 98 hit / 6525 miss - head 926372183 - digest sha256:e5a3d7892c9cd4... - run 32650414838
success	1	20	1023 / 1023	2m 47s / 5m 17s	`docker run ... @sha256:7dc5a68...`	1 day ago
run 32583427308 executed 1023 - ccache 98 hit / 6525 miss - head b8f9d4f0e - digest sha256:7dc5a68c4a12a2... - run 32583427308
success	1	20	1023 / 1023	2m 30s / 4m 34s	`docker run ... @sha256:07ffdaf...`	2 days ago
run 32500567175 executed 1023 - ccache 98 hit / 6525 miss - head 311fed345 - digest sha256:07ffdaff66d71c... - run 32500567175

v12t139667_12posted Aug 14, 19:08successsupersededrecent 5dpg 20

base4921447be 6 days ago on master

applyapplied 6 days ago

rebaselast tried 3 days ago on 0ebeec35f

Applying: pgstat: Allow pg_stat_force_next_flush() to work in-transaction
Using index info to reconstruct a base tree...
M	src/include/catalog/catversion.h
M	src/include/catalog/pg_proc.dat
M	src/tools/pgindent/typedefs.list
Falling back to patching base and 3-way merge...
Auto-merging src/tools/pgindent/typedefs.list
Auto-merging src/include/catalog/pg_proc.dat
Auto-merging src/include/catalog/catversion.h
CONFLICT (content): Merge conflict in src/include/catalog/catversion.h
Patch failed at 0001 pgstat: Allow pg_stat_force_next_flush() to work in-transaction

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: src/include/catalog/catversion.h

push6 days ago -> a97cef849 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1019 / 1019	2m 51s / 5m 15s	`docker run ... @sha256:1299b26...`	6 days ago
run 32082708265 executed 1019 - ccache 98 hit / 6524 miss - head a97cef849 - digest sha256:1299b266a9cc73... - run 32082708265
success	1	20	1019 / 1019	2m 56s / 5m 37s	`docker run ... @sha256:295ba90...`	Aug 17, 00:09
run 31980548773 executed 1019 - ccache 98 hit / 6524 miss - head 0e34690c5 - digest sha256:295ba9033f2d6c... - run 31980548773
success	1	20	1019 / 1019	2m 50s / 5m 32s	`docker run ... @sha256:20ddf8e...`	Aug 15, 19:21
run 31903186991 executed 1019 - ccache 98 hit / 6524 miss - head fbf176a2a - digest sha256:20ddf8ebc4698b... - run 31903186991
success	1	20	1019 / 1019	2m 54s / 5m 35s	`docker run ... @sha256:e886421...`	Aug 14, 19:21
run 31832061521 executed 1019 - ccache 98 hit / 6524 miss - head 96929c6d2 - digest sha256:e886421e39453b... - run 31832061521

v10t139667_10posted Aug 06, 23:23successsupersededrecent 11dpg 20

basefeb15361b Aug 12, 00:45 on master

applyapplied Aug 12, 01:47

rebaselast tried Aug 14, 01:50 on 1f97b252d

Applying: pgstat: Allow pg_stat_force_next_flush() to work in-transaction
Using index info to reconstruct a base tree...
M	doc/src/sgml/monitoring.sgml
M	src/backend/utils/activity/pgstat.c
M	src/backend/utils/activity/pgstat_relation.c
M	src/include/catalog/catversion.h
M	src/include/catalog/pg_proc.dat
M	src/include/pgstat.h
M	src/include/utils/pgstat_internal.h
M	src/test/regress/expected/stats.out
M	src/test/regress/sql/stats.sql
M	src/tools/pgindent/typedefs.list
Falling back to patching base and 3-way merge...
Auto-merging src/tools/pgindent/typedefs.list
Auto-merging src/test/regress/sql/stats.sql
Auto-merging src/test/regress/expected/stats.out
Auto-merging src/include/utils/pgstat_internal.h
Auto-merging src/include/pgstat.h
CONFLICT (content): Merge conflict in src/include/pgstat.h
Auto-merging src/include/catalog/pg_proc.dat
Auto-merging src/include/catalog/catversion.h
CONFLICT (content): Merge conflict in src/include/catalog/catversion.h
Auto-merging src/backend/utils/activity/pgstat_relation.c
CONFLICT (content): Merge conflict in src/backend/utils/activity/pgstat_relation.c
Auto-merging src/backend/utils/activity/pgstat.c
Auto-merging doc/src/sgml/monitoring.sgml
Patch failed at 0001 pgstat: Allow pg_stat_force_next_flush() to work in-transaction

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: src/include/pgstat.h, src/include/catalog/catversion.h, src/backend/utils/activity/pgstat_relation.c

pushAug 12, 01:47 -> 91ecd1176 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1019 / 1019	2m 58s / 5m 43s	`docker run ... @sha256:793eecc...`	Aug 12, 02:01
run 31554785283 executed 1019 - ccache 165 hit / 6453 miss - head 91ecd1176 - digest sha256:793eeccc151e33... - run 31554785283
success	1	20	1019 / 1019	3m 00s / 5m 21s	`docker run ... @sha256:f743f43...`	Aug 11, 01:59
run 31450262212 executed 1019 - ccache 165 hit / 6453 miss - head ba35ed7cb - digest sha256:f743f430d26a5e... - run 31450262212
success	1	20	1019 / 1019	3m 01s / 5m 32s	`docker run ... @sha256:e0107d0...`	Aug 10, 01:57
run 31347869441 executed 1019 - ccache 166 hit / 6452 miss - head f9a71f9b6 - digest sha256:e0107d0ea8999d... - run 31347869441
success	1	20	1019 / 1019	2m 57s / 5m 32s	`docker run ... @sha256:6d1d5c9...`	Aug 08, 00:38
run 31229985577 executed 1019 - ccache 166 hit / 6452 miss - head a74572974 - digest sha256:6d1d5c9a72d583... - run 31229985577
success	1	20	1018 / 1018	2m 50s / 5m 26s	`docker run ... @sha256:8793ecb...`	Aug 07, 00:37
run 31134510661 executed 1018 - ccache 166 hit / 6452 miss - head 0435b8b35 - digest sha256:8793ecb240aea3... - run 31134510661

v8t139667_8posted Aug 06, 01:22successsupersededrecent 17dpg 20

base1200dfd60 Aug 05, 23:19 on master

applyapplied Aug 06, 01:25

rebaselast tried Aug 06, 01:25 on 1200dfd60

pushAug 06, 01:25 -> 090d6b15c branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1018 / 1018	2m 53s / 5m 15s	`docker run ... @sha256:8d16ddb...`	Aug 06, 01:37
run 31062687838 executed 1018 - ccache 166 hit / 6452 miss - head 090d6b15c - digest sha256:8d16ddbe9df30e... - run 31062687838

v4t139667_4posted Jul 31, 20:08successsupersededrecent 17dpg 20

basee90e198e3 Aug 05, 20:11 on master

applyapplied Aug 05, 20:17

rebaselast tried Aug 05, 20:17 on e90e198e3

pushAug 05, 20:17 -> f80e29cd4 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1018 / 1018	2m 54s / 5m 21s	`docker run ... @sha256:05129a4...`	Aug 05, 20:35
run 31043383978 executed 1018 - ccache 166 hit / 6452 miss - head f80e29cd4 - digest sha256:05129a45ec6f19... - run 31043383978
success	1	20	1018 / 1018	1m 46s / 4m 11s	`docker run ... @sha256:107bab3...`	Aug 04, 20:25
run 30947052872 executed 1018 - ccache 166 hit / 6452 miss - head 908143450 - digest sha256:107bab3b49305c... - run 30947052872
success	1	20	1018 / 1018	2m 52s / 5m 18s	`docker run ... @sha256:db0a0f5...`	Aug 03, 20:28
run 30849265101 executed 1018 - ccache 166 hit / 6452 miss - head 382c2c62b - digest sha256:db0a0f57b1eaa0... - run 30849265101
success	1	20	1017 / 1017	2m 57s / 5m 33s	`docker run ... @sha256:95d53f4...`	Aug 02, 20:28
run 30765102952 executed 1017 - ccache 166 hit / 6452 miss - head d5018f566 - digest sha256:95d53f43b01ec7... - run 30765102952
success	1	20	1017 / 1017	2m 54s / 5m 06s	`docker run ... @sha256:4d10f8c...`	Aug 01, 20:26
run 30716439147 executed 1017 - ccache 166 hit / 6452 miss - head b51cc665d - digest sha256:4d10f8c18608b9... - run 30716439147
success	1	20	1017 / 1017	2m 57s / 5m 17s	`docker run ... @sha256:4ae7fe5...`	Jul 31, 20:26
run 30661860137 executed 1017 - ccache 166 hit / 6452 miss - head 71dcb8db5 - digest sha256:4ae7fe5eea5370... - run 30661860137

v2t139667_2posted Jul 30, 19:41successsupersededrecent 22dpg 20

base481052c77 Jul 31, 18:39 on master

applyapplied Jul 31, 19:45

rebaselast tried Jul 31, 19:45 on 481052c77

pushJul 31, 19:45 -> 9f8b09375 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1017 / 1017	2m 50s / 5m 32s	`docker run ... @sha256:d50a03d...`	Jul 31, 20:02
run 30660297120 executed 1017 - ccache 166 hit / 6452 miss - head 9f8b09375 - digest sha256:d50a03d0a43260... - run 30660297120
success	1	20	1016 / 1016	2m 53s / 5m 17s	`docker run ... @sha256:58e01e2...`	Jul 30, 19:58
run 30576114470 executed 1016 - ccache 166 hit / 6452 miss - head 87434b72d - digest sha256:58e01e2c5aa80d... - run 30576114470

v1t139667_1posted May 17, 14:34successsupersededrecent 24dpg 20

base7cb9060dc Jul 30, 14:33 on master

applyapplied Jul 30, 15:22

rebaselast tried Jul 30, 15:22 on 7cb9060dc

pushJul 30, 15:22 -> ebefbf381 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1016 / 1016	2m 15s / 4m 46s	`docker run ... @sha256:07515b6...`	Jul 30, 15:31
run 30556347193 executed 1016 - ccache 166 hit / 6452 miss - head ebefbf381 - digest sha256:07515b6756308f... - run 30556347193
success	1	20	1016 / 1016	2m 46s / 5m 23s	`docker run ... @sha256:9691b17...`	Jul 29, 15:31
run 30465366848 executed 1016 - ccache 166 hit / 6452 miss - head 6b376139f - digest sha256:9691b1776318a8... - run 30465366848
success	1	20	1014 / 1014	2m 47s / 5m 17s	`docker run ... @sha256:2282bba...`	Jul 28, 15:29
run 30372721559 executed 1014 - ccache 166 hit / 6452 miss - head 4a8578775 - digest sha256:2282bba01a67ef... - run 30372721559
success	1	20	1013 / 1013	2m 13s / 4m 34s	`docker run ... @sha256:fd69459...`	Jul 27, 00:16
run 30226691542 executed 1013 - ccache 166 hit / 6452 miss - head d0576aa81 - digest sha256:fd69459ab7dd86... - run 30226691542