[Patch] Add WHERE clause support to REFRESH MATERIALIZED VIEW

1 patchset tracked - current t52845_9

v9t52845_9posted Apr 09, 17:32successappliesrecent 0dpg 20

base73e69062c about 11 hours ago on master

applyapplied about 7 hours ago

rebaselast tried about 7 hours ago on 73e69062c

pushabout 7 hours ago -> d34319a8f branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1048 / 1048	2m 54s / 5m 35s	`docker run ... :t52845`	about 7 hours ago
run 38695616832 executed 1048 - ccache 78 hit / 6544 miss - head d34319a8f - digest sha256:529a4b59f0d55f... - run 38695616832
success	1	20	1045 / 1045	1m 54s / 4m 16s	`docker run ... @sha256:23a30e6...`	1 day ago
run 38525001686 executed 1045 - ccache 78 hit / 6544 miss - head 1990fd52b - digest sha256:23a30e6efe3b41... - run 38525001686
success	1	20	1045 / 1045	1m 46s / 3m 56s	`docker run ... @sha256:89a4b87...`	2 days ago
run 38358963439 executed 1045 - ccache 78 hit / 6544 miss - head edeffcac1 - digest sha256:89a4b878a7a5c3... - run 38358963439
success	1	20	1045 / 1045	1m 50s / 3m 52s	`docker run ... @sha256:cf7b2f5...`	3 days ago
run 38214365661 executed 1045 - ccache 78 hit / 6544 miss - head c824840fb - digest sha256:cf7b2f50f260b6... - run 38214365661
success	1	20	1045 / 1045	2m 53s / 5m 34s	`docker run ... @sha256:1b88fc8...`	5 days ago
run 38099750534 executed 1045 - ccache 78 hit / 6544 miss - head 505db386f - digest sha256:1b88fc8e133465... - run 38099750534
success	1	20	1044 / 1044	1m 43s / 4m 07s	`docker run ... @sha256:c9faeb6...`	6 days ago
run 38010428389 executed 1044 - ccache 78 hit / 6544 miss - head 12ada7ea5 - digest sha256:c9faeb6a7b3d75... - run 38010428389
success	1	20	1044 / 1044	2m 52s / 5m 26s	`docker run ... @sha256:2d6df46...`	7 days ago
run 37866304603 executed 1044 - ccache 78 hit / 6544 miss - head 6a1ffb511 - digest sha256:2d6df4600a8370... - run 37866304603
success	1	20	1043 / 1043	1m 45s / 4m 08s	`docker run ... @sha256:47090a7...`	Oct 08, 00:43
run 37708548402 executed 1043 - ccache 78 hit / 6544 miss - head a3a436da4 - digest sha256:47090a700ae516... - run 37708548402
success	1	20	1042 / 1042	2m 53s / 5m 20s	`docker run ... @sha256:349f5d5...`	Oct 07, 00:45
run 37552625208 executed 1042 - ccache 78 hit / 6544 miss - head 630227283 - digest sha256:349f5d5b6b17b0... - run 37552625208
success	1	20	1040 / 1040	1m 43s / 4m 08s	`docker run ... @sha256:90d357f...`	Oct 06, 00:40
run 37394527393 executed 1040 - ccache 78 hit / 6544 miss - head 565e94c0c - digest sha256:90d357f8b24aff... - run 37394527393
success	1	20	1040 / 1040	2m 33s / 4m 19s	`docker run ... @sha256:6f0bdb2...`	Oct 05, 00:40
run 37247827846 executed 1040 - ccache 78 hit / 6544 miss - head a91b433c5 - digest sha256:6f0bdb2a5e68a3... - run 37247827846
success	1	20	1040 / 1040	2m 54s / 5m 33s	`docker run ... @sha256:31d9d48...`	Oct 04, 00:40
run 37165090113 executed 1040 - ccache 78 hit / 6544 miss - head 91c294cd5 - digest sha256:31d9d48bbb7d03... - run 37165090113
success	1	20	1040 / 1040	2m 54s / 5m 12s	`docker run ... @sha256:c0ae20c...`	Oct 03, 00:39
run 37082220833 executed 1040 - ccache 78 hit / 6544 miss - head 059eed426 - digest sha256:c0ae20c3973129... - run 37082220833
success	1	20	1040 / 1040	2m 51s / 5m 10s	`docker run ... @sha256:7ecae10...`	Oct 02, 00:38
run 36946089896 executed 1040 - ccache 78 hit / 6544 miss - head 668c82623 - digest sha256:7ecae1014793bf... - run 36946089896
success	1	20	1040 / 1040	2m 54s / 5m 30s	`docker run ... @sha256:513678b...`	Oct 01, 00:33
run 36795857510 executed 1040 - ccache 78 hit / 6544 miss - head f896f36ca - digest sha256:513678b1e34819... - run 36795857510
success	1	20	1040 / 1040	2m 15s / 4m 46s	`docker run ... @sha256:b06da1c...`	Sep 30, 00:28
run 36649719017 executed 1040 - ccache 78 hit / 6544 miss - head aa49fd1cb - digest sha256:b06da1ceb8525b... - run 36649719017
success	1	20	1040 / 1040	2m 15s / 5m 06s	`docker run ... @sha256:699572c...`	Sep 29, 00:26
run 36502225077 executed 1040 - ccache 78 hit / 6544 miss - head 680c6fcd7 - digest sha256:699572cfbc9cb2... - run 36502225077
success	1	20	1040 / 1040	2m 19s / 4m 32s	`docker run ... @sha256:8c97680...`	Sep 28, 00:23
run 36361422217 executed 1040 - ccache 78 hit / 6544 miss - head 83db98dcb - digest sha256:8c976806830372... - run 36361422217
success	1	20	1040 / 1040	2m 51s / 5m 11s	`docker run ... @sha256:4460509...`	Sep 26, 19:41
run 36266297704 executed 1040 - ccache 78 hit / 6544 miss - head c81d7d1d0 - digest sha256:446050964c2484... - run 36266297704
success	1	20	1040 / 1040	2m 48s / 5m 20s	`docker run ... @sha256:21654d7...`	Sep 25, 19:30
run 36178952926 executed 1040 - ccache 78 hit / 6544 miss - head faec3146d - digest sha256:21654d77c4e9bb... - run 36178952926
success	1	20	1039 / 1039	2m 49s / 5m 11s	`docker run ... @sha256:69b8f4f...`	Sep 24, 19:28
run 36047098375 executed 1039 - ccache 78 hit / 6544 miss - head 0c4988ab0 - digest sha256:69b8f4fca279d7... - run 36047098375
success	1	20	1037 / 1037	2m 52s / 5m 12s	`docker run ... @sha256:e75df5c...`	Sep 23, 19:25
run 35908050838 executed 1037 - ccache 98 hit / 6524 miss - head b557a1110 - digest sha256:e75df5cfceb21c... - run 35908050838
success	1	20	1037 / 1037	2m 13s / 4m 39s	`docker run ... @sha256:fc89066...`	Sep 22, 19:21
run 35772261574 executed 1037 - ccache 98 hit / 6524 miss - head 71f7b9fb7 - digest sha256:fc8906688ffb52... - run 35772261574
success	1	20	1037 / 1037	2m 54s / 5m 32s	`docker run ... @sha256:0fe7cfd...`	Sep 21, 19:12
run 35642179791 executed 1037 - ccache 98 hit / 6524 miss - head 34f54c5aa - digest sha256:0fe7cfde333de6... - run 35642179791
success	1	20	1037 / 1037	2m 53s / 5m 27s	`docker run ... @sha256:77a8800...`	Sep 20, 13:40
run 35513639340 executed 1037 - ccache 98 hit / 6524 miss - head b194082a6 - digest sha256:77a8800f39c1b7... - run 35513639340
success	1	20	1037 / 1037	2m 56s / 5m 24s	`docker run ... @sha256:917c871...`	Sep 19, 13:36
run 35445731783 executed 1037 - ccache 98 hit / 6524 miss - head 7bb5efb8a - digest sha256:917c8710ddf916... - run 35445731783
success	1	20	1037 / 1037	2m 52s / 5m 12s	`docker run ... @sha256:74116f0...`	Sep 18, 13:34
run 35349939435 executed 1037 - ccache 98 hit / 6524 miss - head 8ce4a8082 - digest sha256:74116f00d12fba... - run 35349939435
success	1	20	1037 / 1037	2m 54s / 5m 34s	`docker run ... @sha256:471bd0c...`	Sep 17, 13:33
run 35226670193 executed 1037 - ccache 98 hit / 6524 miss - head f6d055edb - digest sha256:471bd0c771bddd... - run 35226670193
success	1	20	1037 / 1037	2m 47s / 5m 25s	`docker run ... @sha256:a2abd64...`	Sep 16, 13:24
run 35100605427 executed 1037 - ccache 98 hit / 6524 miss - head 20866a137 - digest sha256:a2abd6462e7d83... - run 35100605427
success	1	20	1037 / 1037	2m 58s / 5m 39s	`docker run ... @sha256:56d1473...`	Sep 15, 13:21
run 34973289541 executed 1037 - ccache 98 hit / 6523 miss - head 27258bf3b - digest sha256:56d1473a1bccb1... - run 34973289541
success	1	20	1024 / 1024	2m 12s / 4m 38s	`docker run ... @sha256:b4e2e21...`	Sep 14, 13:13
run 34847002312 executed 1024 - ccache 98 hit / 6523 miss - head 0e7d018d9 - digest sha256:b4e2e214c41fb2... - run 34847002312
success	1	20	1024 / 1024	2m 55s / 5m 15s	`docker run ... @sha256:cd61dc7...`	Sep 13, 12:37
run 34757097316 executed 1024 - ccache 98 hit / 6523 miss - head f0324f5a8 - digest sha256:cd61dc7b0789c5... - run 34757097316
success	1	20	1024 / 1024	2m 46s / 5m 09s	`docker run ... @sha256:098e2fe...`	Sep 12, 12:21
run 34692988898 executed 1024 - ccache 98 hit / 6523 miss - head 3e5ae7df3 - digest sha256:098e2fe9e94361... - run 34692988898
success	1	20	1023 / 1023	2m 09s / 4m 36s	`docker run ... @sha256:e7d9cee...`	Sep 11, 12:20
run 34597517754 executed 1023 - ccache 98 hit / 6523 miss - head aaafc24b1 - digest sha256:e7d9cee1619c44... - run 34597517754
success	1	20	1023 / 1023	2m 49s / 5m 20s	`docker run ... @sha256:bceebae...`	Sep 10, 12:18
run 34474955718 executed 1023 - ccache 98 hit / 6523 miss - head d6ad2d862 - digest sha256:bceebae905e317... - run 34474955718
success	1	20	1021 / 1021	2m 47s / 5m 18s	`docker run ... @sha256:1b683fa...`	Sep 09, 12:14
run 34348823825 executed 1021 - ccache 98 hit / 6523 miss - head b7c271d93 - digest sha256:1b683fabe8de96... - run 34348823825
success	1	20	1021 / 1021	2m 44s / 4m 32s	`docker run ... @sha256:9b7ffa2...`	Sep 08, 12:11
run 34223692942 executed 1021 - ccache 98 hit / 6523 miss - head 35e794c99 - digest sha256:9b7ffa26396c91... - run 34223692942
success	1	20	1025 / 1025	2m 54s / 5m 29s	`docker run ... @sha256:9278b94...`	Sep 07, 12:08
run 34119188776 executed 1025 - ccache 98 hit / 6527 miss - head 016e19d66 - digest sha256:9278b94038b66f... - run 34119188776
success	1	20	1025 / 1025	2m 47s / 4m 53s	`docker run ... @sha256:0c725dd...`	Sep 05, 13:56
run 33969840982 executed 1025 - ccache 98 hit / 6527 miss - head 2c6aff958 - digest sha256:0c725dd2b1c813... - run 33969840982
success	1	20	1025 / 1025	2m 55s / 5m 35s	`docker run ... @sha256:b0eede5...`	Sep 04, 13:56
run 33879834828 executed 1025 - ccache 98 hit / 6527 miss - head 416047816 - digest sha256:b0eede575515cb... - run 33879834828
success	1	20	1024 / 1024	2m 46s / 4m 47s	`docker run ... @sha256:214d3f2...`	Sep 03, 13:54
run 33762724037 executed 1024 - ccache 98 hit / 6526 miss - head 34e1daeb6 - digest sha256:214d3f229ff710... - run 33762724037
success	1	20	1023 / 1023	2m 18s / 4m 31s	`docker run ... @sha256:c576457...`	Sep 02, 13:49
run 33637151983 executed 1023 - ccache 98 hit / 6526 miss - head 0ae10df47 - digest sha256:c576457f3ae069... - run 33637151983
success	1	20	1023 / 1023	2m 50s / 5m 30s	`docker run ... @sha256:f8bf267...`	Sep 01, 13:48
run 33514431882 executed 1023 - ccache 98 hit / 6526 miss - head 2bd750543 - digest sha256:f8bf26725b800b... - run 33514431882
success	1	20	1023 / 1023	2m 13s / 4m 13s	`docker run ... @sha256:47e1ba6...`	Aug 31, 13:41
run 33397567056 executed 1023 - ccache 98 hit / 6526 miss - head f832ecf3a - digest sha256:47e1ba697c1a61... - run 33397567056
success	1	20	1022 / 1022	2m 53s / 5m 10s	`docker run ... @sha256:eb6056e...`	Aug 30, 13:42
run 33314425161 executed 1022 - ccache 98 hit / 6525 miss - head 908269046 - digest sha256:eb6056e1e9eaf9... - run 33314425161
success	1	20	1022 / 1022	2m 49s / 5m 08s	`docker run ... @sha256:eb6056e...`	Aug 29, 13:40
run 33255178391 executed 1022 - ccache 98 hit / 6525 miss - head 74a6ac077 - digest sha256:eb6056e1e9eaf9... - run 33255178391
success	1	20	1022 / 1022	2m 11s / 4m 22s	`docker run ... @sha256:44f8650...`	Aug 28, 13:37
run 33175572252 executed 1022 - ccache 98 hit / 6525 miss - head 5205b15c2 - digest sha256:44f86506598472... - run 33175572252
success	1	20	1022 / 1022	2m 49s / 4m 53s	`docker run ... @sha256:ecf8c16...`	Aug 27, 13:37
run 33076905087 executed 1022 - ccache 98 hit / 6525 miss - head e6027d18d - digest sha256:ecf8c16b0881a5... - run 33076905087
success	1	20	1025 / 1025	2m 54s / 5m 26s	`docker run ... @sha256:57a1525...`	Aug 26, 13:26
run 32973049141 executed 1025 - ccache 98 hit / 6525 miss - head 90080a9ec - digest sha256:57a15251e22803... - run 32973049141
success	1	20	1025 / 1025	2m 49s / 5m 33s	`docker run ... @sha256:29f0830...`	Aug 25, 13:15
run 32851009705 executed 1025 - ccache 98 hit / 6525 miss - head 3893e3ebd - digest sha256:29f083097c47e0... - run 32851009705
success	1	20	1024 / 1024	2m 55s / 5m 12s	`docker run ... @sha256:05e5182...`	Aug 24, 13:13
run 32730323882 executed 1024 - ccache 98 hit / 6525 miss - head 352dddcd7 - digest sha256:05e5182aba1026... - run 32730323882
success	1	20	1024 / 1024	1m 56s / 4m 12s	`docker run ... @sha256:6cb05d0...`	Aug 23, 13:09
run 32641018179 executed 1024 - ccache 98 hit / 6525 miss - head 56b27d303 - digest sha256:6cb05d0ea79f55... - run 32641018179
success	1	20	1024 / 1024	2m 09s / 4m 26s	`docker run ... @sha256:6fcb069...`	Aug 22, 13:08
run 32574469544 executed 1024 - ccache 98 hit / 6525 miss - head 834bcd707 - digest sha256:6fcb06943ea2df... - run 32574469544
success	1	20	1024 / 1024	2m 54s / 5m 12s	`docker run ... @sha256:978c324...`	Aug 21, 13:07
run 32484346715 executed 1024 - ccache 98 hit / 6525 miss - head 79cca5d04 - digest sha256:978c324ea5a4b2... - run 32484346715
success	1	20	1024 / 1024	2m 58s / 5m 51s	`docker run ... @sha256:bfa4f3a...`	Aug 20, 13:07
run 32371370883 executed 1024 - ccache 98 hit / 6525 miss - head 1ef6e753a - digest sha256:bfa4f3a011c32e... - run 32371370883
success	1	20	1024 / 1024	2m 54s / 4m 58s	`docker run ... @sha256:8a24230...`	Aug 19, 13:04
run 32255076124 executed 1024 - ccache 98 hit / 6525 miss - head 3f43d6161 - digest sha256:8a2423010f3074... - run 32255076124
success	1	20	1022 / 1022	2m 46s / 4m 35s	`docker run ... @sha256:8df740e...`	Aug 18, 12:50
run 32137790932 executed 1022 - ccache 98 hit / 6525 miss - head 15dea39fa - digest sha256:8df740e09c81a0... - run 32137790932
success	1	20	1020 / 1020	2m 53s / 5m 18s	`docker run ... @sha256:fa63a98...`	Aug 17, 12:51
run 32030711340 executed 1020 - ccache 98 hit / 6524 miss - head d81b89d19 - digest sha256:fa63a9817999d1... - run 32030711340
success	1	20	1020 / 1020	2m 53s / 5m 31s	`docker run ... @sha256:c57c264...`	Aug 16, 12:43
run 31947298557 executed 1020 - ccache 98 hit / 6524 miss - head 83a2b0faf - digest sha256:c57c264542be60... - run 31947298557
success	1	20	1020 / 1020	2m 32s / 4m 42s	`docker run ... @sha256:53051ed...`	Aug 15, 12:42
run 31884774053 executed 1020 - ccache 98 hit / 6524 miss - head ecdbbc8cf - digest sha256:53051ed4ac0e38... - run 31884774053
success	1	20	1020 / 1020	2m 16s / 4m 16s	`docker run ... @sha256:8d79b87...`	Aug 14, 12:40
run 31800581080 executed 1020 - ccache 165 hit / 6457 miss - head f074f0e77 - digest sha256:8d79b87959d5fb... - run 31800581080
success	1	20	1020 / 1020	2m 49s / 5m 06s	`docker run ... @sha256:e593fd5...`	Aug 13, 12:41
run 31700255924 executed 1020 - ccache 165 hit / 6457 miss - head d06e54708 - digest sha256:e593fd522afdc1... - run 31700255924
success	1	20	1020 / 1020	2m 55s / 5m 39s	`docker run ... @sha256:47fb41b...`	Aug 12, 12:39
run 31596455766 executed 1020 - ccache 165 hit / 6457 miss - head 3b7db2a79 - digest sha256:47fb41b4d8a95a... - run 31596455766
success	1	20	1020 / 1020	2m 51s / 5m 21s	`docker run ... @sha256:8679c37...`	Aug 11, 12:38
run 31491139874 executed 1020 - ccache 165 hit / 6453 miss - head 978b7a2e8 - digest sha256:8679c375ad2e89... - run 31491139874
success	1	20	1020 / 1020	2m 54s / 5m 10s	`docker run ... @sha256:8820c82...`	Aug 10, 12:29
run 31387069239 executed 1020 - ccache 166 hit / 6452 miss - head add70f796 - digest sha256:8820c82dc9dc31... - run 31387069239
success	1	20	1020 / 1020	2m 52s / 5m 31s	`docker run ... @sha256:e90e9c9...`	Aug 08, 19:07
run 31273184605 executed 1020 - ccache 166 hit / 6452 miss - head 790b786bf - digest sha256:e90e9c9bf17aba... - run 31273184605
success	1	20	1019 / 1019	2m 55s / 5m 36s	`docker run ... @sha256:e8d548a...`	Aug 05, 16:34
run 31024898150 executed 1019 - ccache 166 hit / 6452 miss - head 9b6e4790a - digest sha256:e8d548a3cd425c... - run 31024898150
success	1	20	1019 / 1019	3m 00s / 5m 16s	`docker run ... @sha256:6ce019c...`	Aug 04, 16:32
run 30928625379 executed 1019 - ccache 166 hit / 6452 miss - head e10d6ddee - digest sha256:6ce019c7c107ef... - run 30928625379
success	1	20	1018 / 1018	2m 56s / 5m 33s	`docker run ... @sha256:62570b2...`	Aug 03, 16:32
run 30831542915 executed 1018 - ccache 166 hit / 6452 miss - head 024d0d3db - digest sha256:62570b2e550992... - run 30831542915
success	1	20	1018 / 1018	2m 46s / 5m 23s	`docker run ... @sha256:7e9b5ee...`	Aug 02, 16:30
run 30756271233 executed 1018 - ccache 166 hit / 6452 miss - head 7e2c38ef7 - digest sha256:7e9b5ee09fa426... - run 30756271233
success	1	20	1018 / 1018	2m 56s / 5m 45s	`docker run ... @sha256:5e58d22...`	Aug 01, 16:28
run 30707718800 executed 1018 - ccache 166 hit / 6452 miss - head 5777e08f8 - digest sha256:5e58d228f26280... - run 30707718800
success	1	20	1018 / 1018	2m 58s / 5m 22s	`docker run ... @sha256:231568f...`	Jul 31, 16:27
run 30646286971 executed 1018 - ccache 166 hit / 6452 miss - head d04229a52 - digest sha256:231568f45c72fb... - run 30646286971
success	1	20	1017 / 1017	2m 53s / 5m 23s	`docker run ... @sha256:b78ae88...`	Jul 30, 16:24
run 30560487692 executed 1017 - ccache 166 hit / 6452 miss - head e27dac77a - digest sha256:b78ae88c596cf5... - run 30560487692
success	1	20	1017 / 1017	1m 42s / 4m 14s	`docker run ... @sha256:81f542a...`	Jul 29, 16:21
run 30469677837 executed 1017 - ccache 166 hit / 6452 miss - head e5d99dec1 - digest sha256:81f542a95b1972... - run 30469677837
success	1	20	1015 / 1015	1m 56s / 3m 57s	`docker run ... @sha256:ed5a8f5...`	Jul 28, 16:29
run 30377051960 executed 1015 - ccache 166 hit / 6452 miss - head 658810551 - digest sha256:ed5a8f5bb58768... - run 30377051960
success	1	20	1014 / 1014	2m 25s / 4m 22s	`docker run ... @sha256:88b1c80...`	Jul 27, 01:55
run 30230568249 executed 1014 - ccache 166 hit / 6452 miss - head 2c4de5e05 - digest sha256:88b1c8019fb6ed... - run 30230568249