PSQL Should \sv & \ev work with materialized views?

1 patchset tracked - current t47853_3

v3t47853_3posted Mar 29, 2024successappliesrecent 0dpg 20

based4c15309e about 3 hours ago on master

applyapplied about 1 hour ago

rebaselast tried about 1 hour ago on d4c15309e

pushabout 1 hour ago -> f01f33c5e branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1040 / 1040	2m 58s / 5m 22s	`docker run ... :t47853`	about 1 hour ago
run 37431228517 executed 1040 - ccache 78 hit / 6544 miss - head f01f33c5e - digest sha256:6761c197f9261f... - run 37431228517
success	1	20	1039 / 1039	2m 15s / 4m 30s	`docker run ... @sha256:b30d216...`	1 day ago
run 37278961424 executed 1039 - ccache 78 hit / 6544 miss - head adcb1d500 - digest sha256:b30d2163776362... - run 37278961424
success	1	20	1039 / 1039	2m 44s / 5m 03s	`docker run ... @sha256:f94e5aa...`	2 days ago
run 37186414183 executed 1039 - ccache 78 hit / 6544 miss - head 18037d581 - digest sha256:f94e5aa97d0d54... - run 37186414183
success	1	20	1039 / 1039	2m 51s / 5m 10s	`docker run ... @sha256:bdbc352...`	3 days ago
run 37106965940 executed 1039 - ccache 78 hit / 6544 miss - head 4b56fc826 - digest sha256:bdbc3520327e64... - run 37106965940
success	1	20	1039 / 1039	1m 45s / 4m 04s	`docker run ... @sha256:ff74c22...`	4 days ago
run 36979457621 executed 1039 - ccache 78 hit / 6544 miss - head 103b2b4a1 - digest sha256:ff74c225543bb6... - run 36979457621
success	1	20	1039 / 1039	2m 54s / 5m 47s	`docker run ... @sha256:3f24584...`	5 days ago
run 36831071262 executed 1039 - ccache 78 hit / 6544 miss - head c5649c3f9 - digest sha256:3f24584ac5b5ac... - run 36831071262
success	1	20	1039 / 1039	2m 53s / 5m 13s	`docker run ... @sha256:966eebe...`	6 days ago
run 36682996470 executed 1039 - ccache 78 hit / 6544 miss - head e281b4397 - digest sha256:966eebe7c8a72f... - run 36682996470
success	1	20	1039 / 1039	2m 56s / 5m 16s	`docker run ... @sha256:f3ea82f...`	Sep 29, 07:26
run 36535614128 executed 1039 - ccache 78 hit / 6544 miss - head 8f4cbf81d - digest sha256:f3ea82fca728d6... - run 36535614128
success	1	20	1039 / 1039	2m 58s / 5m 36s	`docker run ... @sha256:6e10c4f...`	Sep 28, 07:20
run 36390109059 executed 1039 - ccache 78 hit / 6544 miss - head 9df0e4b82 - digest sha256:6e10c4f51b90b6... - run 36390109059
success	1	20	1039 / 1039	1m 55s / 3m 55s	`docker run ... @sha256:d906f57...`	Sep 27, 04:51
run 36295119087 executed 1039 - ccache 78 hit / 6544 miss - head 02b1ced58 - digest sha256:d906f574e8b637... - run 36295119087
success	1	20	1039 / 1039	2m 53s / 5m 16s	`docker run ... @sha256:00f20c3...`	Sep 26, 04:51
run 36218534441 executed 1039 - ccache 78 hit / 6544 miss - head fe520cff3 - digest sha256:00f20c39a9a6a9... - run 36218534441
success	1	20	1038 / 1038	2m 42s / 4m 37s	`docker run ... @sha256:4e34284...`	Sep 25, 04:49
run 36095317701 executed 1038 - ccache 78 hit / 6544 miss - head 1a5a88acd - digest sha256:4e34284e561fc9... - run 36095317701
success	1	20	1036 / 1036	2m 55s / 5m 31s	`docker run ... @sha256:e677b9b...`	Sep 24, 04:46
run 35956297184 executed 1036 - ccache 98 hit / 6524 miss - head b733753ff - digest sha256:e677b9b929e6e5... - run 35956297184
success	1	20	1036 / 1036	2m 54s / 5m 28s	`docker run ... @sha256:ab8b907...`	Sep 23, 04:45
run 35818895297 executed 1036 - ccache 98 hit / 6524 miss - head ed03f3d69 - digest sha256:ab8b907a79f2e6... - run 35818895297
success	1	20	1036 / 1036	2m 53s / 5m 12s	`docker run ... @sha256:14f0253...`	Sep 22, 04:42
run 35687240788 executed 1036 - ccache 98 hit / 6524 miss - head b517892da - digest sha256:14f0253ebd4272... - run 35687240788
success	1	20	1036 / 1036	2m 53s / 5m 25s	`docker run ... @sha256:ddc7eb1...`	Sep 21, 04:41
run 35561234716 executed 1036 - ccache 98 hit / 6524 miss - head 322137a14 - digest sha256:ddc7eb11a045c6... - run 35561234716
success	1	20	1036 / 1036	2m 52s / 5m 15s	`docker run ... @sha256:3469188...`	Sep 20, 04:38
run 35489219228 executed 1036 - ccache 98 hit / 6524 miss - head 8ff7324f7 - digest sha256:3469188e98273a... - run 35489219228
success	1	20	1036 / 1036	2m 19s / 4m 20s	`docker run ... @sha256:2c225e7...`	Sep 19, 04:36
run 35421339613 executed 1036 - ccache 98 hit / 6524 miss - head 3fa33d3f7 - digest sha256:2c225e7672308a... - run 35421339613
success	1	20	1036 / 1036	2m 54s / 5m 30s	`docker run ... @sha256:4dfae58...`	Sep 18, 04:35
run 35306870332 executed 1036 - ccache 98 hit / 6524 miss - head 01b92f925 - digest sha256:4dfae5899516f6... - run 35306870332
success	1	20	1036 / 1036	2m 08s / 4m 20s	`docker run ... @sha256:37751d7...`	Sep 17, 04:31
run 35181731094 executed 1036 - ccache 98 hit / 6524 miss - head f2ecbdcc8 - digest sha256:37751d7b6a8357... - run 35181731094
success	1	20	1036 / 1036	2m 48s / 5m 41s	`docker run ... @sha256:57d1678...`	Sep 16, 04:32
run 35055281879 executed 1036 - ccache 98 hit / 6524 miss - head 5bc335d6b - digest sha256:57d1678b6f9b8b... - run 35055281879
success	1	20	1036 / 1036	2m 54s / 5m 16s	`docker run ... @sha256:cb569a7...`	Sep 15, 04:27
run 34928240573 executed 1036 - ccache 98 hit / 6523 miss - head cdfc9b90c - digest sha256:cb569a765059e0... - run 34928240573
success	1	20	1023 / 1023	2m 59s / 5m 17s	`docker run ... @sha256:6cfdf25...`	Sep 14, 04:26
run 34805376610 executed 1023 - ccache 98 hit / 6523 miss - head 6721e00a5 - digest sha256:6cfdf25803d246... - run 34805376610
success	1	20	1023 / 1023	2m 13s / 4m 36s	`docker run ... @sha256:170a4ed...`	Sep 13, 04:18
run 34736623452 executed 1023 - ccache 98 hit / 6523 miss - head ac0ec3c64 - digest sha256:170a4ed13a9ff4... - run 34736623452
success	1	20	1023 / 1023	2m 46s / 4m 37s	`docker run ... @sha256:0dff47c...`	Sep 12, 04:00
run 34671399648 executed 1023 - ccache 98 hit / 6523 miss - head 6b2d5a96c - digest sha256:0dff47ca1d23f4... - run 34671399648
success	1	20	1022 / 1022	2m 44s / 4m 34s	`docker run ... @sha256:a2d8eb8...`	Sep 11, 03:55
run 34559645407 executed 1022 - ccache 98 hit / 6523 miss - head b91a14faa - digest sha256:a2d8eb89fb0f9a... - run 34559645407
success	1	20	1021 / 1021	2m 47s / 5m 13s	`docker run ... @sha256:ea8d2fd...`	Sep 10, 03:53
run 34434381360 executed 1021 - ccache 98 hit / 6523 miss - head adf5af41d - digest sha256:ea8d2fde883032... - run 34434381360
success	1	20	1020 / 1020	2m 45s / 5m 14s	`docker run ... @sha256:162c8af...`	Sep 09, 03:50
run 34307942051 executed 1020 - ccache 98 hit / 6523 miss - head c5d3e3a84 - digest sha256:162c8af380b5f4... - run 34307942051
success	1	20	1020 / 1020	1m 39s / 3m 57s	`docker run ... @sha256:4f87f4d...`	Sep 08, 03:44
run 34184057269 executed 1020 - ccache 98 hit / 6523 miss - head 6fe31369d - digest sha256:4f87f4deb191e7... - run 34184057269
success	1	20	1024 / 1024	2m 54s / 5m 28s	`docker run ... @sha256:b8a729e...`	Sep 07, 03:44
run 34080065602 executed 1024 - ccache 98 hit / 6527 miss - head c13c9139f - digest sha256:b8a729eb808604... - run 34080065602
success	1	20	1024 / 1024	2m 57s / 5m 18s	`docker run ... @sha256:82e8b49...`	Sep 05, 05:38
run 33947118568 executed 1024 - ccache 98 hit / 6527 miss - head c7abe5d12 - digest sha256:82e8b49c582b8c... - run 33947118568
success	1	20	1024 / 1024	2m 50s / 5m 36s	`docker run ... @sha256:2a3ddf5...`	Sep 04, 05:37
run 33840197714 executed 1024 - ccache 98 hit / 6527 miss - head e4eef310e - digest sha256:2a3ddf5e560b54... - run 33840197714
success	1	20	1023 / 1023	2m 03s / 4m 25s	`docker run ... @sha256:d214493...`	Sep 03, 05:31
run 33718406740 executed 1023 - ccache 98 hit / 6526 miss - head f583afa86 - digest sha256:d214493ddf81a5... - run 33718406740
success	1	20	1022 / 1022	2m 53s / 5m 14s	`docker run ... @sha256:96bcdb3...`	Sep 02, 05:28
run 33594087133 executed 1022 - ccache 98 hit / 6526 miss - head ec2a8c496 - digest sha256:96bcdb3963e9fd... - run 33594087133
success	1	20	1022 / 1022	2m 12s / 4m 27s	`docker run ... @sha256:3e19e78...`	Sep 01, 05:26
run 33472898656 executed 1022 - ccache 98 hit / 6526 miss - head d144e455a - digest sha256:3e19e78a75e687... - run 33472898656
success	1	20	1022 / 1022	2m 12s / 4m 14s	`docker run ... @sha256:d615af0...`	Aug 31, 05:05
run 33358566306 executed 1022 - ccache 98 hit / 6526 miss - head f09ab6c2a - digest sha256:d615af0103cbea... - run 33358566306
success	1	20	1021 / 1021	1m 54s / 4m 00s	`docker run ... @sha256:bce2630...`	Aug 30, 04:56
run 33293211720 executed 1021 - ccache 98 hit / 6525 miss - head 3345c8d4e - digest sha256:bce26302853937... - run 33293211720
success	1	20	1021 / 1021	2m 44s / 4m 44s	`docker run ... @sha256:d3a6a0a...`	Aug 29, 04:54
run 33234534457 executed 1021 - ccache 98 hit / 6525 miss - head 6e280bd26 - digest sha256:d3a6a0a402697b... - run 33234534457
success	1	20	1021 / 1021	2m 39s / 4m 54s	`docker run ... @sha256:d70b718...`	Aug 28, 04:46
run 33142275221 executed 1021 - ccache 98 hit / 6525 miss - head d2a291027 - digest sha256:d70b7181c5d41d... - run 33142275221
success	1	20	1021 / 1021	2m 48s / 5m 22s	`docker run ... @sha256:89e3507...`	Aug 27, 04:42
run 33039689243 executed 1021 - ccache 98 hit / 6525 miss - head 69e14df0e - digest sha256:89e3507528246c... - run 33039689243
success	1	20	1024 / 1024	2m 50s / 5m 15s	`docker run ... @sha256:d1f3ca9...`	Aug 26, 04:19
run 32929088601 executed 1024 - ccache 98 hit / 6525 miss - head 51da5f6ff - digest sha256:d1f3ca91a57ed6... - run 32929088601
success	1	20	1024 / 1024	2m 51s / 5m 36s	`docker run ... @sha256:a06dd0f...`	Aug 25, 04:15
run 32807467355 executed 1024 - ccache 98 hit / 6525 miss - head d477ffc29 - digest sha256:a06dd0f98af96e... - run 32807467355
success	1	20	1023 / 1023	2m 48s / 5m 08s	`docker run ... @sha256:257d98a...`	Aug 24, 04:14
run 32688460272 executed 1023 - ccache 98 hit / 6525 miss - head 389bd9dd8 - digest sha256:257d98a0fbe26b... - run 32688460272
success	1	20	1023 / 1023	2m 55s / 5m 19s	`docker run ... @sha256:4ac9c42...`	Aug 23, 04:12
run 32616747220 executed 1023 - ccache 98 hit / 6525 miss - head 55625b359 - digest sha256:4ac9c428a966af... - run 32616747220
success	1	20	1023 / 1023	2m 55s / 5m 29s	`docker run ... @sha256:6244f23...`	Aug 22, 04:11
run 32550427993 executed 1023 - ccache 98 hit / 6525 miss - head 126cde431 - digest sha256:6244f2381c317e... - run 32550427993
success	1	20	1023 / 1023	2m 39s / 4m 50s	`docker run ... @sha256:f37a4af...`	Aug 21, 04:09
run 32445190247 executed 1023 - ccache 98 hit / 6525 miss - head e9d7f61e5 - digest sha256:f37a4aff354af7... - run 32445190247
success	1	20	1023 / 1023	2m 49s / 5m 11s	`docker run ... @sha256:d21787a...`	Aug 20, 04:06
run 32330021444 executed 1023 - ccache 98 hit / 6525 miss - head 54ba4d72f - digest sha256:d21787a5d40d20... - run 32330021444
success	1	20	1023 / 1023	2m 47s / 5m 02s	`docker run ... @sha256:634fb2a...`	Aug 19, 04:08
run 32213840334 executed 1023 - ccache 98 hit / 6525 miss - head 71cc0ec28 - digest sha256:634fb2a26201c9... - run 32213840334
success	1	20	1020 / 1020	2m 56s / 5m 35s	`docker run ... @sha256:639bed0...`	Aug 18, 04:06
run 32096961105 executed 1020 - ccache 98 hit / 6524 miss - head 19d3db189 - digest sha256:639bed03952d03... - run 32096961105
success	1	20	1019 / 1019	2m 45s / 4m 47s	`docker run ... @sha256:b46dcb0...`	Aug 17, 04:00
run 31992425117 executed 1019 - ccache 98 hit / 6524 miss - head 5af6664a1 - digest sha256:b46dcb034560a6... - run 31992425117
success	1	20	1019 / 1019	2m 56s / 5m 34s	`docker run ... @sha256:6ff82d5...`	Aug 16, 03:55
run 31924897313 executed 1019 - ccache 98 hit / 6524 miss - head d4c49a452 - digest sha256:6ff82d5a603bcc... - run 31924897313
success	1	20	1019 / 1019	2m 55s / 5m 26s	`docker run ... @sha256:1fd0c37...`	Aug 15, 03:53
run 31862500662 executed 1019 - ccache 98 hit / 6524 miss - head 1680d8caf - digest sha256:1fd0c37fa84d1d... - run 31862500662
success	1	20	1019 / 1019	2m 53s / 5m 30s	`docker run ... @sha256:616f131...`	Aug 14, 03:50
run 31767426511 executed 1019 - ccache 165 hit / 6457 miss - head fe620643d - digest sha256:616f1314cb6cf3... - run 31767426511
success	1	20	1019 / 1019	2m 47s / 5m 24s	`docker run ... @sha256:3146eeb...`	Aug 13, 03:49
run 31664496873 executed 1019 - ccache 165 hit / 6457 miss - head 59237b225 - digest sha256:3146eeb6bcc219... - run 31664496873
success	1	20	1019 / 1019	3m 00s / 5m 50s	`docker run ... @sha256:24bf0fd...`	Aug 12, 03:48
run 31560607863 executed 1019 - ccache 165 hit / 6454 miss - head 32fc752e7 - digest sha256:24bf0fdee667c6... - run 31560607863
success	1	20	1019 / 1019	2m 55s / 5m 09s	`docker run ... @sha256:ffcef59...`	Aug 11, 03:46
run 31455857167 executed 1019 - ccache 165 hit / 6453 miss - head 71dd63630 - digest sha256:ffcef5990479de... - run 31455857167
success	1	20	1019 / 1019	2m 46s / 5m 20s	`docker run ... @sha256:33985a7...`	Aug 10, 03:44
run 31352915414 executed 1019 - ccache 166 hit / 6452 miss - head 793cdf9b0 - digest sha256:33985a7af07826... - run 31352915414
success	1	20	1019 / 1019	2m 57s / 5m 22s	`docker run ... @sha256:35a9f2a...`	Aug 08, 02:25
run 31234408195 executed 1019 - ccache 166 hit / 6452 miss - head 386b69764 - digest sha256:35a9f2ac50c942... - run 31234408195
success	1	20	1018 / 1018	2m 39s / 4m 44s	`docker run ... @sha256:7a785e1...`	Aug 07, 02:24
run 31140389212 executed 1018 - ccache 166 hit / 6452 miss - head e3984d2ae - digest sha256:7a785e101a17de... - run 31140389212
success	1	20	1018 / 1018	2m 07s / 4m 24s	`docker run ... @sha256:4246045...`	Aug 05, 20:29
run 31043244364 executed 1018 - ccache 166 hit / 6452 miss - head 7535d3f26 - digest sha256:42460456bafd50... - run 31043244364
success	1	20	1018 / 1018	2m 11s / 4m 41s	`docker run ... @sha256:dea706e...`	Aug 04, 20:25
run 30946907184 executed 1018 - ccache 166 hit / 6452 miss - head d8bd10cc1 - digest sha256:dea706e400136c... - run 30946907184
success	1	20	1018 / 1018	2m 54s / 5m 26s	`docker run ... @sha256:65f8ce1...`	Aug 03, 20:24
run 30849115184 executed 1018 - ccache 166 hit / 6452 miss - head b7a9fb2fc - digest sha256:65f8ce1314dc1b... - run 30849115184
success	1	20	1017 / 1017	2m 59s / 5m 43s	`docker run ... @sha256:be8a4cc...`	Aug 02, 20:24
run 30765037494 executed 1017 - ccache 166 hit / 6452 miss - head 0ab4acd9c - digest sha256:be8a4cc4025bf9... - run 30765037494
success	1	20	1017 / 1017	2m 52s / 5m 32s	`docker run ... @sha256:aa22349...`	Aug 01, 20:25
run 30716329144 executed 1017 - ccache 166 hit / 6452 miss - head 604f90afb - digest sha256:aa22349bc7f041... - run 30716329144
success	1	20	1017 / 1017	2m 47s / 4m 59s	`docker run ... @sha256:2fffc9f...`	Jul 31, 20:24
run 30661664841 executed 1017 - ccache 166 hit / 6452 miss - head 568ee7ae8 - digest sha256:2fffc9fde869d1... - run 30661664841
tests failed	1	20	1015 / 1016	2m 48s / 4m 57s	`docker run ... @sha256:1090a55...`	Jul 30, 20:22
run 30577625818 failed: recovery/051_effective_wal_level executed 1016 - ccache 166 hit / 6452 miss - head c6e4ac6e2 - digest sha256:1090a55bf03147... - run 30577625818
success	1	20	1016 / 1016	2m 47s / 5m 22s	`docker run ... @sha256:b4c0ca8...`	Jul 29, 20:20
run 30487071587 executed 1016 - ccache 166 hit / 6452 miss - head 65a1d93be - digest sha256:b4c0ca8871b13d... - run 30487071587
success	1	20	1015 / 1015	2m 48s / 4m 59s	`docker run ... @sha256:bf20be0...`	Jul 28, 20:20
run 30394681344 executed 1015 - ccache 166 hit / 6452 miss - head 6e0978c54 - digest sha256:bf20be095c2d49... - run 30394681344
success	1	20	1013 / 1013	2m 47s / 5m 18s	`docker run ... @sha256:740fc7d...`	Jul 27, 12:28
run 30265044605 executed 1013 - ccache 166 hit / 6452 miss - head c70ce60a9 - digest sha256:740fc7d9fd067e... - run 30265044605