Example 43.6. A PL/pgSQL Trigger Function for Maintaining a Summary Table
1 patchset tracked - current t77509_4
v4t77509_4posted Oct 26, 2023successappliesrecent 0dpg 20
base9e17d25e7 about 17 hours ago on master
applyapplied about 12 hours ago
rebaselast tried about 12 hours ago on 9e17d25e7
pushabout 12 hours ago -> 7275414d2branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1036 / 1036 | 2m 44s / 5m 06s | docker run ... :t77509 | about 12 hours ago |
run 35505217687executed 1036 - ccache 98 hit / 6524 miss - head 7275414d2 - digest sha256:09f91d73ed3ad4... - run 35505217687 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 11s / 4m 40s | docker run ... @sha256:333116d... | 1 day ago |
run 35437482884executed 1036 - ccache 98 hit / 6524 miss - head 0c76d5efd - digest sha256:333116d49de139... - run 35437482884 | ||||||
| success | 1 | 20 | 1036 / 1036 | 1m 47s / 3m 58s | docker run ... @sha256:464e962... | 2 days ago |
run 35334745357executed 1036 - ccache 98 hit / 6524 miss - head f9d088563 - digest sha256:464e9626849865... - run 35334745357 | ||||||
| success | 1 | 20 | 1036 / 1036 | 1m 42s / 4m 11s | docker run ... @sha256:ca18e11... | 3 days ago |
run 35210478643executed 1036 - ccache 98 hit / 6524 miss - head dda9720c9 - digest sha256:ca18e1167a31f6... - run 35210478643 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 09s / 4m 54s | docker run ... @sha256:146ec7f... | 4 days ago |
run 35084539703executed 1036 - ccache 98 hit / 6524 miss - head 09d9277db - digest sha256:146ec7f784d7b6... - run 35084539703 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 54s / 5m 30s | docker run ... @sha256:4f131cd... | 6 days ago |
run 34957055337executed 1036 - ccache 98 hit / 6523 miss - head 8f9694869 - digest sha256:4f131cd1f7ec78... - run 34957055337 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 51s / 5m 08s | docker run ... @sha256:dbeb02a... | 7 days ago |
run 34831961337executed 1023 - ccache 98 hit / 6523 miss - head c506da610 - digest sha256:dbeb02a72640d9... - run 34831961337 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 17s / 4m 18s | docker run ... @sha256:980a685... | Sep 13, 09:42 |
run 34749656930executed 1023 - ccache 98 hit / 6523 miss - head 35c79c23a - digest sha256:980a6858022e3a... - run 34749656930 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 45s / 5m 14s | docker run ... @sha256:48806b5... | Sep 12, 09:40 |
run 34685953033executed 1023 - ccache 98 hit / 6523 miss - head e25d779c7 - digest sha256:48806b5d18a629... - run 34685953033 | ||||||
| success | 1 | 20 | 1022 / 1022 | 1m 55s / 4m 18s | docker run ... @sha256:53f1900... | Sep 11, 09:39 |
run 34584332248executed 1022 - ccache 98 hit / 6523 miss - head 97e562861 - digest sha256:53f1900fdff518... - run 34584332248 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 57s / 5m 19s | docker run ... @sha256:64e3f20... | Sep 10, 09:38 |
run 34460652959executed 1022 - ccache 98 hit / 6523 miss - head b6c8df61f - digest sha256:64e3f20c9cf0cd... - run 34460652959 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 53s / 5m 27s | docker run ... @sha256:222c399... | Sep 09, 09:35 |
run 34334388934executed 1020 - ccache 98 hit / 6523 miss - head 21b449c7b - digest sha256:222c399fd25843... - run 34334388934 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 58s / 5m 26s | docker run ... @sha256:5da87ba... | Sep 08, 09:35 |
run 34209545699executed 1020 - ccache 98 hit / 6523 miss - head 2f72dc4d6 - digest sha256:5da87ba5ff3a9e... - run 34209545699 | ||||||
| success | 1 | 20 | 1024 / 1024 | 1m 55s / 4m 06s | docker run ... @sha256:a3612f0... | Sep 07, 09:33 |
run 34105435318executed 1024 - ccache 98 hit / 6527 miss - head 80a94cb34 - digest sha256:a3612f0600d7c2... - run 34105435318 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 54s / 5m 33s | docker run ... @sha256:5773cbe... | Sep 05, 11:25 |
run 33962666179executed 1024 - ccache 98 hit / 6527 miss - head 9f48f857c - digest sha256:5773cbe763f192... - run 33962666179 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 49s / 4m 50s | docker run ... @sha256:de40b91... | Sep 04, 11:23 |
run 33866651750executed 1024 - ccache 98 hit / 6527 miss - head 0f5b8908f - digest sha256:de40b9165c3b4e... - run 33866651750 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 52s / 5m 39s | docker run ... @sha256:f1eb9f7... | Sep 03, 11:21 |
run 33748028598executed 1023 - ccache 98 hit / 6526 miss - head 4c7bcb9a4 - digest sha256:f1eb9f7c29936e... - run 33748028598 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 49s / 5m 28s | docker run ... @sha256:9402cc5... | Sep 02, 11:18 |
run 33622885620executed 1022 - ccache 98 hit / 6526 miss - head 40014dea8 - digest sha256:9402cc5e4aa742... - run 33622885620 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 51s / 5m 24s | docker run ... @sha256:f3e12d0... | Sep 01, 11:17 |
run 33500621790executed 1022 - ccache 98 hit / 6526 miss - head b6a01a813 - digest sha256:f3e12d08f2e6da... - run 33500621790 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 54s / 5m 22s | docker run ... @sha256:e958bc0... | Aug 31, 11:01 |
run 33384116248executed 1022 - ccache 98 hit / 6526 miss - head 6694ee9d4 - digest sha256:e958bc02e5070a... - run 33384116248 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 46s / 5m 06s | docker run ... @sha256:9c14b03... | Aug 30, 10:59 |
run 33307345339executed 1021 - ccache 98 hit / 6525 miss - head d931785b6 - digest sha256:9c14b03b459463... - run 33307345339 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 53s / 5m 17s | docker run ... @sha256:3e7345e... | Aug 29, 10:58 |
run 33248604315executed 1021 - ccache 98 hit / 6525 miss - head 14ddfe953 - digest sha256:3e7345eba0bdb6... - run 33248604315 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 57s / 5m 45s | docker run ... @sha256:2ca881b... | Aug 28, 10:55 |
run 33164530360executed 1021 - ccache 98 hit / 6525 miss - head 3ec4785c8 - digest sha256:2ca881bd24c20b... - run 33164530360 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 28s / 4m 44s | docker run ... @sha256:a90a9fd... | Aug 27, 10:52 |
run 33064232464executed 1021 - ccache 98 hit / 6525 miss - head 8b7d55107 - digest sha256:a90a9fda3e8f85... - run 33064232464 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 51s / 4m 45s | docker run ... @sha256:1735e59... | Aug 26, 10:52 |
run 32959123148executed 1024 - ccache 98 hit / 6525 miss - head 036827e7a - digest sha256:1735e59318ad85... - run 32959123148 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 53s / 5m 08s | docker run ... @sha256:fc1b985... | Aug 24, 10:27 |
run 32715946595executed 1023 - ccache 98 hit / 6525 miss - head 82c1027cc - digest sha256:fc1b9853d4f63d... - run 32715946595 | ||||||
| success | 1 | 20 | 1023 / 1023 | 3m 01s / 5m 26s | docker run ... @sha256:d2f920b... | Aug 23, 10:26 |
run 32633215370executed 1023 - ccache 98 hit / 6525 miss - head f502a4cb5 - digest sha256:d2f920bc812db5... - run 32633215370 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 46s / 5m 03s | docker run ... @sha256:bbd0bc3... | Aug 22, 10:24 |
run 32567049528executed 1023 - ccache 98 hit / 6525 miss - head 9d068568e - digest sha256:bbd0bc3de45482... - run 32567049528 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 53s / 5m 35s | docker run ... @sha256:c8cdef2... | Aug 21, 10:23 |
run 32471573675executed 1023 - ccache 98 hit / 6525 miss - head e55fc9820 - digest sha256:c8cdef29f6fda0... - run 32471573675 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 54s / 5m 27s | docker run ... @sha256:63ce992... | Aug 20, 10:22 |
run 32357630587executed 1023 - ccache 98 hit / 6525 miss - head f6b9f1995 - digest sha256:63ce992f98b047... - run 32357630587 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 50s / 4m 51s | docker run ... @sha256:40eb8af... | Aug 19, 10:19 |
run 32241206157executed 1023 - ccache 98 hit / 6525 miss - head eec10db65 - digest sha256:40eb8af7b9f9fe... - run 32241206157 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 51s / 5m 33s | docker run ... @sha256:65575c6... | Aug 18, 10:17 |
run 32125033725executed 1021 - ccache 98 hit / 6524 miss - head 1eea19ad9 - digest sha256:65575c65a7af96... - run 32125033725 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 46s / 4m 52s | docker run ... @sha256:d3fe7ff... | Aug 17, 10:14 |
run 32018356341executed 1019 - ccache 98 hit / 6524 miss - head e54b029dc - digest sha256:d3fe7ff1ce2475... - run 32018356341 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 12s / 4m 14s | docker run ... @sha256:fd917d4... | Aug 16, 10:11 |
run 31940642051executed 1019 - ccache 98 hit / 6524 miss - head fae33f7e7 - digest sha256:fd917d4f469a34... - run 31940642051 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 48s / 4m 49s | docker run ... @sha256:3ad46ad... | Aug 15, 10:11 |
run 31878465783executed 1019 - ccache 98 hit / 6524 miss - head a748bfc8a - digest sha256:3ad46ad50a40f1... - run 31878465783 | ||||||
| success | 1 | 20 | 1019 / 1019 | 3m 00s / 5m 42s | docker run ... @sha256:a7f0273... | Aug 14, 10:11 |
run 31790404605executed 1019 - ccache 165 hit / 6457 miss - head 9a0f5607e - digest sha256:a7f0273c6b2772... - run 31790404605 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 54s / 5m 16s | docker run ... @sha256:ec2046c... | Aug 13, 10:10 |
run 31689040098executed 1019 - ccache 165 hit / 6457 miss - head 425eff66f - digest sha256:ec2046cb3bc854... - run 31689040098 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 47s / 5m 19s | docker run ... @sha256:11c48d6... | Aug 12, 10:07 |
run 31585136372executed 1019 - ccache 165 hit / 6457 miss - head 741b9d8dc - digest sha256:11c48d694bbf89... - run 31585136372 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 49s / 5m 31s | docker run ... @sha256:c7ef5e4... | Aug 11, 10:06 |
run 31479810878executed 1019 - ccache 165 hit / 6453 miss - head 2e53c05fd - digest sha256:c7ef5e41df49e7... - run 31479810878 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 14s / 4m 44s | docker run ... @sha256:bc3fb92... | Aug 10, 09:55 |
run 31376031976executed 1019 - ccache 166 hit / 6452 miss - head ac8db47aa - digest sha256:bc3fb9249635a7... - run 31376031976 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 55s / 5m 29s | docker run ... @sha256:b8ac915... | Aug 08, 12:14 |
run 31256314063executed 1019 - ccache 166 hit / 6452 miss - head 66a2508f7 - digest sha256:b8ac915ec9682e... - run 31256314063 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 49s / 5m 18s | docker run ... @sha256:bc09c15... | Aug 07, 12:09 |
run 31176224407executed 1019 - ccache 166 hit / 6452 miss - head 80417bda1 - digest sha256:bc09c1558dad9e... - run 31176224407 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 48s / 5m 26s | docker run ... @sha256:1cb6ffb... | Aug 06, 12:08 |
run 31099358285executed 1018 - ccache 166 hit / 6452 miss - head d77e03427 - digest sha256:1cb6ffbe607f7a... - run 31099358285 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 53s / 5m 33s | docker run ... @sha256:0010641... | Aug 05, 12:12 |
run 31003488781executed 1018 - ccache 166 hit / 6452 miss - head 48e943b40 - digest sha256:001064134cf448... - run 31003488781 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 56s / 5m 14s | docker run ... @sha256:b63b2f5... | Aug 04, 12:08 |
run 30906673819executed 1018 - ccache 166 hit / 6452 miss - head 70b2d4b02 - digest sha256:b63b2f51de31ba... - run 30906673819 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 56s / 5m 29s | docker run ... @sha256:ee2b574... | Aug 03, 12:07 |
run 30811220432executed 1017 - ccache 166 hit / 6452 miss - head 786278b54 - digest sha256:ee2b574e695f5c... - run 30811220432 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 14s / 4m 19s | docker run ... @sha256:5dcaa4a... | Aug 02, 12:02 |
run 30746580743executed 1017 - ccache 166 hit / 6452 miss - head b91c482ad - digest sha256:5dcaa4a87ec69c... - run 30746580743 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 57s / 5m 32s | docker run ... @sha256:cd5b090... | Aug 01, 12:00 |
run 30698437654executed 1017 - ccache 166 hit / 6452 miss - head 7d2fb1cab - digest sha256:cd5b090c54ba44... - run 30698437654 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 50s / 5m 26s | docker run ... @sha256:3fb7de1... | Jul 31, 11:59 |
run 30628300289executed 1016 - ccache 166 hit / 6452 miss - head 1575c4f1c - digest sha256:3fb7de17cb3a1a... - run 30628300289 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 46s / 5m 12s | docker run ... @sha256:5467da6... | Jul 30, 12:05 |
run 30539834593executed 1016 - ccache 166 hit / 6452 miss - head 17d32877d - digest sha256:5467da6965d462... - run 30539834593 | ||||||
| success | 1 | 20 | 1015 / 1015 | 2m 53s / 5m 22s | docker run ... @sha256:9defb61... | Jul 29, 12:00 |
run 30448686614executed 1015 - ccache 166 hit / 6452 miss - head 127e0e476 - digest sha256:9defb61995d1b4... - run 30448686614 | ||||||
| success | 1 | 20 | 1014 / 1014 | 2m 54s / 5m 11s | docker run ... @sha256:8ed1d54... | Jul 28, 12:03 |
run 30355870779executed 1014 - ccache 166 hit / 6452 miss - head 702d83f8a - digest sha256:8ed1d549d9b299... - run 30355870779 | ||||||
| success | 1 | 20 | 1013 / 1013 | 2m 49s / 5m 45s | docker run ... @sha256:c67a650... | Jul 27, 13:01 |
run 30267530316executed 1013 - ccache 166 hit / 6452 miss - head 11a366738 - digest sha256:c67a6507c3af86... - run 30267530316 | ||||||