[PATCH] Remove redundant ORDER BY from COUNT aggregates

1 patchset tracked - current t253385_1

v1t253385_1posted Aug 12, 04:00successappliesrecent 0dpg 20

base5ffb8c740 about 12 hours ago on master

applyapplied about 5 hours ago

rebaselast tried about 5 hours ago on 5ffb8c740

pushabout 5 hours ago -> 5fdbd0dab branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1050 / 1050	3m 08s / 5m 32s	`docker run ... :t253385`	about 5 hours ago
run 39802973101 executed 1050 - ccache 78 hit / 6544 miss - head 5fdbd0dab - digest sha256:d9ea3a8d53c7ec... - run 39802973101
success	1	20	1049 / 1049	2m 15s / 4m 19s	`docker run ... @sha256:e9a15b0...`	1 day ago
run 39622916086 executed 1049 - ccache 78 hit / 6544 miss - head 60ad1ad4d - digest sha256:e9a15b08fd3ed4... - run 39622916086
success	1	20	1049 / 1049	3m 04s / 5m 42s	`docker run ... @sha256:73829a3...`	2 days ago
run 39442632135 executed 1049 - ccache 78 hit / 6544 miss - head 70f9fef38 - digest sha256:73829a3bde77ee... - run 39442632135
success	1	20	1049 / 1049	1m 54s / 4m 18s	`docker run ... @sha256:b05af66...`	3 days ago
run 39271343945 executed 1049 - ccache 78 hit / 6544 miss - head 51a7ec48a - digest sha256:b05af66fd7fde2... - run 39271343945
success	1	20	1049 / 1049	2m 54s / 5m 22s	`docker run ... @sha256:5b110fb...`	4 days ago
run 39136601630 executed 1049 - ccache 78 hit / 6544 miss - head 2c18e769e - digest sha256:5b110fb0f15d66... - run 39136601630
success	1	20	1049 / 1049	2m 46s / 4m 56s	`docker run ... @sha256:a9f8bfe...`	5 days ago
run 39041156012 executed 1049 - ccache 78 hit / 6544 miss - head 012cbd4be - digest sha256:a9f8bfe30325fb... - run 39041156012
success	1	20	1049 / 1049	2m 57s / 5m 30s	`docker run ... @sha256:0f18dd7...`	6 days ago
run 38916035174 executed 1049 - ccache 78 hit / 6544 miss - head 3f621f331 - digest sha256:0f18dd747c85d1... - run 38916035174
success	1	20	1049 / 1049	2m 11s / 4m 36s	`docker run ... @sha256:c52dde4...`	Oct 15, 14:35
run 38751358285 executed 1049 - ccache 78 hit / 6544 miss - head 71ec7668e - digest sha256:c52dde4ca5a364... - run 38751358285
success	1	20	1045 / 1045	2m 53s / 5m 12s	`docker run ... @sha256:7d27c74...`	Oct 14, 14:32
run 38579856759 executed 1045 - ccache 78 hit / 6544 miss - head 18933e156 - digest sha256:7d27c7408ecc23... - run 38579856759
success	1	20	1044 / 1044	2m 53s / 5m 15s	`docker run ... @sha256:80a2d21...`	Oct 13, 14:21
run 38411095342 executed 1044 - ccache 78 hit / 6544 miss - head 374c8c04e - digest sha256:80a2d218f97487... - run 38411095342
success	1	20	1044 / 1044	2m 12s / 4m 42s	`docker run ... @sha256:ddf9722...`	Oct 12, 14:12
run 38260021719 executed 1044 - ccache 78 hit / 6544 miss - head 3c59f4706 - digest sha256:ddf9722d61ede7... - run 38260021719
success	1	20	1044 / 1044	2m 53s / 5m 09s	`docker run ... @sha256:ddb44f9...`	Oct 11, 08:34
run 38124670724 executed 1044 - ccache 78 hit / 6544 miss - head 8d51ca643 - digest sha256:ddb44f9fca7afa... - run 38124670724
success	1	20	1042 / 1042	2m 36s / 4m 43s	`docker run ... @sha256:59e0b28...`	Oct 08, 08:31
run 37749334096 executed 1042 - ccache 78 hit / 6544 miss - head 31811fc20 - digest sha256:59e0b285c83c0f... - run 37749334096
success	1	20	1041 / 1041	2m 50s / 5m 05s	`docker run ... @sha256:e12b6c3...`	Oct 07, 08:28
run 37592837836 executed 1041 - ccache 78 hit / 6544 miss - head ebfc18aff - digest sha256:e12b6c3ed149f1... - run 37592837836
success	1	20	1040 / 1040	1m 52s / 4m 25s	`docker run ... @sha256:8a75924...`	Oct 06, 08:25
run 37435056064 executed 1040 - ccache 78 hit / 6544 miss - head b7df3b0dc - digest sha256:8a75924bbfd7ba... - run 37435056064
success	1	20	1039 / 1039	2m 53s / 5m 34s	`docker run ... @sha256:7beb49f...`	Oct 05, 08:27
run 37282581963 executed 1039 - ccache 78 hit / 6544 miss - head 4d71349d1 - digest sha256:7beb49f4917453... - run 37282581963
success	1	20	1039 / 1039	2m 45s / 4m 40s	`docker run ... @sha256:e22f72c...`	Oct 04, 08:24
run 37188280493 executed 1039 - ccache 78 hit / 6544 miss - head 64b6bc6ba - digest sha256:e22f72c8b871ab... - run 37188280493
success	1	20	1039 / 1039	2m 53s / 5m 23s	`docker run ... @sha256:1966e6a...`	Oct 03, 08:23
run 37108929776 executed 1039 - ccache 78 hit / 6544 miss - head 4a1bfb12f - digest sha256:1966e6a6a06e0b... - run 37108929776
success	1	20	1039 / 1039	3m 02s / 5m 26s	`docker run ... @sha256:a449a27...`	Oct 02, 08:22
run 36982590139 executed 1039 - ccache 78 hit / 6544 miss - head e4f37c136 - digest sha256:a449a270edbf10... - run 36982590139
success	1	20	1039 / 1039	2m 54s / 5m 23s	`docker run ... @sha256:f7bcda3...`	Oct 01, 08:33
run 36835798391 executed 1039 - ccache 78 hit / 6544 miss - head 8a542f8e4 - digest sha256:f7bcda355175da... - run 36835798391
success	1	20	1039 / 1039	2m 41s / 4m 49s	`docker run ... @sha256:f790b6a...`	Sep 30, 08:01
run 36686087215 executed 1039 - ccache 78 hit / 6544 miss - head 7815d1ea2 - digest sha256:f790b6a77ecdb1... - run 36686087215
success	1	20	1039 / 1039	2m 59s / 5m 06s	`docker run ... @sha256:3ab5151...`	Sep 29, 08:01
run 36539025995 executed 1039 - ccache 78 hit / 6544 miss - head 5de11ddd0 - digest sha256:3ab51513f0bd4a... - run 36539025995
success	1	20	1039 / 1039	2m 57s / 5m 34s	`docker run ... @sha256:5b91bad...`	Sep 28, 07:54
run 36393229783 executed 1039 - ccache 78 hit / 6544 miss - head e369b2c7b - digest sha256:5b91bad534263c... - run 36393229783
success	1	20	1039 / 1039	2m 53s / 5m 28s	`docker run ... @sha256:f65bb56...`	Sep 27, 05:27
run 36296713766 executed 1039 - ccache 78 hit / 6544 miss - head a4f58b493 - digest sha256:f65bb566a12557... - run 36296713766
success	1	20	1039 / 1039	1m 42s / 3m 44s	`docker run ... @sha256:24fc5de...`	Sep 26, 05:21
run 36220205398 executed 1039 - ccache 78 hit / 6544 miss - head 105a05820 - digest sha256:24fc5de1e831b5... - run 36220205398
success	1	20	1038 / 1038	2m 11s / 4m 43s	`docker run ... @sha256:11601dd...`	Sep 25, 05:23
run 36097693825 executed 1038 - ccache 78 hit / 6544 miss - head 7123aecf1 - digest sha256:11601dd02656d8... - run 36097693825
success	1	20	1036 / 1036	2m 54s / 5m 11s	`docker run ... @sha256:88db409...`	Sep 24, 05:18
run 35958620304 executed 1036 - ccache 98 hit / 6524 miss - head 07f7f2894 - digest sha256:88db4095f7cda7... - run 35958620304
success	1	20	1036 / 1036	2m 56s / 5m 16s	`docker run ... @sha256:846af7c...`	Sep 23, 05:17
run 35821000484 executed 1036 - ccache 98 hit / 6524 miss - head 3d00016b7 - digest sha256:846af7c08d56e3... - run 35821000484
success	1	20	1036 / 1036	2m 52s / 5m 19s	`docker run ... @sha256:e8737ee...`	Sep 22, 05:15
run 35689297695 executed 1036 - ccache 98 hit / 6524 miss - head f58017233 - digest sha256:e8737ee64f65ff... - run 35689297695
success	1	20	1036 / 1036	2m 56s / 5m 48s	`docker run ... @sha256:f49b83a...`	Sep 21, 05:14
run 35563124215 executed 1036 - ccache 98 hit / 6524 miss - head 5cc4b7f03 - digest sha256:f49b83a1389f82... - run 35563124215
success	1	20	1036 / 1036	2m 53s / 5m 15s	`docker run ... @sha256:ded8e08...`	Sep 20, 05:11
run 35490573115 executed 1036 - ccache 98 hit / 6524 miss - head cd7db23cb - digest sha256:ded8e08516ffd8... - run 35490573115
success	1	20	1036 / 1036	2m 52s / 5m 27s	`docker run ... @sha256:bc1c256...`	Sep 19, 05:10
run 35422764293 executed 1036 - ccache 98 hit / 6524 miss - head dad469652 - digest sha256:bc1c256e17f1dd... - run 35422764293
success	1	20	1036 / 1036	2m 56s / 5m 47s	`docker run ... @sha256:343457f...`	Sep 18, 05:09
run 35308971744 executed 1036 - ccache 98 hit / 6524 miss - head 3c898a7d5 - digest sha256:343457f70cf167... - run 35308971744
success	1	20	1036 / 1036	2m 53s / 5m 32s	`docker run ... @sha256:c22cb86...`	Sep 17, 05:05
run 35183703057 executed 1036 - ccache 98 hit / 6524 miss - head b1d6c0a2c - digest sha256:c22cb8624d1a1f... - run 35183703057
success	1	20	1036 / 1036	1m 54s / 4m 06s	`docker run ... @sha256:2bca297...`	Sep 16, 05:02
run 35057330905 executed 1036 - ccache 98 hit / 6524 miss - head 92d3365d5 - digest sha256:2bca297883f75c... - run 35057330905
success	1	20	1036 / 1036	2m 55s / 5m 40s	`docker run ... @sha256:2efbcc0...`	Sep 15, 05:03
run 34930482805 executed 1036 - ccache 98 hit / 6523 miss - head 28c30869f - digest sha256:2efbcc0573f16b... - run 34930482805
success	1	20	1023 / 1023	2m 58s / 5m 17s	`docker run ... @sha256:2637251...`	Sep 14, 05:01
run 34807524365 executed 1023 - ccache 98 hit / 6523 miss - head f1a958b7e - digest sha256:26372513b5965c... - run 34807524365
success	1	20	1023 / 1023	2m 53s / 5m 20s	`docker run ... @sha256:de3d54c...`	Sep 13, 04:45
run 34738191785 executed 1023 - ccache 98 hit / 6523 miss - head 9df7650cb - digest sha256:de3d54c703a0df... - run 34738191785
success	1	20	1023 / 1023	2m 53s / 5m 18s	`docker run ... @sha256:baabfb1...`	Sep 12, 04:31
run 34672756556 executed 1023 - ccache 98 hit / 6523 miss - head 2501f7b50 - digest sha256:baabfb131e18a5... - run 34672756556
success	1	20	1022 / 1022	2m 54s / 5m 28s	`docker run ... @sha256:0db9a5f...`	Sep 11, 04:30
run 34561714322 executed 1022 - ccache 98 hit / 6523 miss - head ead2553d3 - digest sha256:0db9a5f7f98487... - run 34561714322
success	1	20	1021 / 1021	2m 53s / 5m 28s	`docker run ... @sha256:8bd92c4...`	Sep 10, 04:29
run 34436287106 executed 1021 - ccache 98 hit / 6523 miss - head 55c4d7f95 - digest sha256:8bd92c4a49ba9f... - run 34436287106
success	1	20	1020 / 1020	2m 58s / 5m 09s	`docker run ... @sha256:782a6dc...`	Sep 09, 04:26
run 34309822046 executed 1020 - ccache 98 hit / 6523 miss - head ca50b3a6d - digest sha256:782a6dc94287aa... - run 34309822046
success	1	20	1020 / 1020	2m 56s / 5m 29s	`docker run ... @sha256:2889932...`	Sep 08, 04:21
run 34185746124 executed 1020 - ccache 98 hit / 6523 miss - head c6a45b222 - digest sha256:288993238b16e6... - run 34185746124
success	1	20	1024 / 1024	1m 54s / 4m 05s	`docker run ... @sha256:a62ac4c...`	Sep 07, 04:17
run 34081551124 executed 1024 - ccache 98 hit / 6527 miss - head b545edc42 - digest sha256:a62ac4cf98c6dd... - run 34081551124
success	1	20	1024 / 1024	2m 38s / 4m 28s	`docker run ... @sha256:a6db75d...`	Sep 05, 06:06
run 33948411646 executed 1024 - ccache 98 hit / 6527 miss - head 64d17a196 - digest sha256:a6db75d27ab7aa... - run 33948411646
success	1	20	1024 / 1024	2m 53s / 5m 23s	`docker run ... @sha256:9b904e9...`	Sep 04, 06:06
run 33842185457 executed 1024 - ccache 98 hit / 6527 miss - head bed44ae39 - digest sha256:9b904e91f1bc42... - run 33842185457
success	1	20	1023 / 1023	2m 48s / 5m 21s	`docker run ... @sha256:0a1fd72...`	Sep 03, 06:04
run 33720685394 executed 1023 - ccache 98 hit / 6526 miss - head d74026669 - digest sha256:0a1fd72bd36a94... - run 33720685394
success	1	20	1022 / 1022	2m 56s / 5m 08s	`docker run ... @sha256:a281775...`	Sep 02, 06:01
run 33596132016 executed 1022 - ccache 98 hit / 6526 miss - head 9fbb0b496 - digest sha256:a281775cf6dbcc... - run 33596132016
success	1	20	1022 / 1022	2m 54s / 5m 21s	`docker run ... @sha256:a3bd8e2...`	Sep 01, 06:01
run 33474957429 executed 1022 - ccache 98 hit / 6526 miss - head 82cc807b1 - digest sha256:a3bd8e2dee7d21... - run 33474957429
success	1	20	1022 / 1022	2m 54s / 5m 22s	`docker run ... @sha256:e679423...`	Aug 31, 05:43
run 33360353936 executed 1022 - ccache 98 hit / 6526 miss - head 9e85e013c - digest sha256:e67942352e0af8... - run 33360353936
success	1	20	1021 / 1021	2m 14s / 4m 27s	`docker run ... @sha256:052c46b...`	Aug 30, 05:21
run 33294185864 executed 1021 - ccache 98 hit / 6525 miss - head 292dd692b - digest sha256:052c46b927e892... - run 33294185864
success	1	20	1021 / 1021	3m 01s / 5m 08s	`docker run ... @sha256:1046da5...`	Aug 29, 05:21
run 33235536775 executed 1021 - ccache 98 hit / 6525 miss - head 3f9ab76fd - digest sha256:1046da5145d0dc... - run 33235536775
success	1	20	1021 / 1021	2m 53s / 5m 21s	`docker run ... @sha256:4179256...`	Aug 28, 05:14
run 33143568397 executed 1021 - ccache 98 hit / 6525 miss - head 23817535f - digest sha256:41792563550bfe... - run 33143568397
success	1	20	1021 / 1021	2m 15s / 4m 08s	`docker run ... @sha256:df9f143...`	Aug 27, 05:09
run 33041123948 executed 1021 - ccache 98 hit / 6525 miss - head 89e64ade3 - digest sha256:df9f1430c41e10... - run 33041123948
success	1	20	1024 / 1024	2m 56s / 5m 38s	`docker run ... @sha256:dad2d33...`	Aug 26, 04:46
run 32930777616 executed 1024 - ccache 98 hit / 6525 miss - head 377148cdc - digest sha256:dad2d3354b88eb... - run 32930777616
success	1	20	1024 / 1024	2m 48s / 5m 12s	`docker run ... @sha256:c0cfdb2...`	Aug 25, 04:44
run 32809313524 executed 1024 - ccache 98 hit / 6525 miss - head 5150c2f6b - digest sha256:c0cfdb240d2ec8... - run 32809313524
success	1	20	1023 / 1023	2m 48s / 5m 23s	`docker run ... @sha256:b607fff...`	Aug 24, 04:42
run 32690227016 executed 1023 - ccache 98 hit / 6525 miss - head b74ec6c14 - digest sha256:b607fff762fc5a... - run 32690227016
success	1	20	1023 / 1023	2m 54s / 5m 20s	`docker run ... @sha256:b70b880...`	Aug 23, 04:41
run 32617970361 executed 1023 - ccache 98 hit / 6525 miss - head 84be45ccc - digest sha256:b70b880e8511dd... - run 32617970361
success	1	20	1023 / 1023	2m 56s / 5m 14s	`docker run ... @sha256:770ae59...`	Aug 22, 04:38
run 32551755362 executed 1023 - ccache 98 hit / 6525 miss - head 4a1c319a9 - digest sha256:770ae598501a68... - run 32551755362
success	1	20	1023 / 1023	2m 48s / 5m 11s	`docker run ... @sha256:6f62ab5...`	Aug 21, 04:37
run 32446964513 executed 1023 - ccache 98 hit / 6525 miss - head 6c7fc48e9 - digest sha256:6f62ab54a83697... - run 32446964513
success	1	20	1023 / 1023	2m 38s / 4m 23s	`docker run ... @sha256:8e6c883...`	Aug 20, 04:36
run 32331786598 executed 1023 - ccache 98 hit / 6525 miss - head 72e2efe20 - digest sha256:8e6c8830ae2184... - run 32331786598
success	1	20	1023 / 1023	2m 48s / 5m 04s	`docker run ... @sha256:bc6af78...`	Aug 19, 04:37
run 32215565782 executed 1023 - ccache 98 hit / 6525 miss - head ec1c84f40 - digest sha256:bc6af787fb4b76... - run 32215565782
success	1	20	1020 / 1020	2m 44s / 4m 13s	`docker run ... @sha256:d6a17ad...`	Aug 18, 04:31
run 32098727255 executed 1020 - ccache 98 hit / 6524 miss - head 28a36cf55 - digest sha256:d6a17ad5421b1e... - run 32098727255
success	1	20	1019 / 1019	2m 39s / 4m 35s	`docker run ... @sha256:3b77013...`	Aug 17, 04:34
run 31993991920 executed 1019 - ccache 98 hit / 6524 miss - head d15a89eda - digest sha256:3b770133747002... - run 31993991920
success	1	20	1019 / 1019	2m 16s / 4m 59s	`docker run ... @sha256:0d81e68...`	Aug 16, 04:20
run 31925949804 executed 1019 - ccache 98 hit / 6524 miss - head 803be86ad - digest sha256:0d81e680414784... - run 31925949804
success	1	20	1019 / 1019	2m 55s / 5m 14s	`docker run ... @sha256:59bbe47...`	Aug 15, 04:19
run 31863641462 executed 1019 - ccache 98 hit / 6524 miss - head 9776fd3af - digest sha256:59bbe477ac7bab... - run 31863641462
success	1	20	1019 / 1019	2m 13s / 4m 47s	`docker run ... @sha256:7ab4842...`	Aug 14, 04:17
run 31768841083 executed 1019 - ccache 165 hit / 6457 miss - head 668835b36 - digest sha256:7ab4842da303fd... - run 31768841083
success	1	20	1019 / 1019	2m 55s / 5m 30s	`docker run ... @sha256:f017fa4...`	Aug 13, 04:16
run 31665903791 executed 1019 - ccache 165 hit / 6457 miss - head d238afd6b - digest sha256:f017fa4533885b... - run 31665903791
success	1	20	1019 / 1019	2m 48s / 5m 06s	`docker run ... @sha256:163ca7b...`	Aug 12, 04:17
run 31562074591 executed 1019 - ccache 165 hit / 6454 miss - head 38384f001 - digest sha256:163ca7b314d227... - run 31562074591