How many users are affected by enforcing auth membership limits?

Current stable steemd version is enforcing auth membership limits.
How many users are affected?

The following link shows that the STEEMIT_MAX_AUTHORITY_MEMBERSHIP is set to 10.

Each Steem account has list of account_auths and keys_auths. The first one is related to the applications you are using. Lists for each account can be seen on steemd. For example looking only at posting authorities:

Data for analysis was downloaded from SteemSQL using the following query:

SELECT name, posting FROM Accounts (NOLOCK)

---

Column posting is a json containing arrays: account_auths and key_auths.

Let's look at the histogram for account_auths and key_auths, taking into account all the Steem users.

To be honest, the above histogram is not very readable, most of the values ​​are on the left, so let's use the logarithmic scale. Now the chart looks much better.

We are most interested in the higher values, so let's zoom it.

From 5:

From 10:

From 15:

We can also check which exact users have the most account_auths and key_auths used.

Top50 by account_auths

.	Account	account_auths
1	aneilpatel	33
2	hsynterkr	30
3	amico	25
4	anupbose	25
5	suheri	25
6	gilabola.mania	25
7	siol	24
8	cgbartow	24
9	bustillo	23
10	chronocrypto	23
11	nitro.speeder	23
12	dwiitavita	22
13	mkt	22
14	nulled67	22
15	rye05	22
16	birdinc	21
17	hungryhustle	21
18	jasmadiyunus	21
19	murizalpangeran	21
20	simplymike	21
21	pichat	21
22	buzzer11	20
23	frankremmy	20
24	gamsam	20
25	nameless-berk	20
26	nikema	20
27	puregrace	20
28	teamhumble	20
29	amulla505	20
30	jonnyla08	20
31	sebescen81	20
32	anzirpasai	19
33	ederaleng	19
34	jpederson96	19
35	rishi556	19
36	travelnepal	19
37	davidisfedup	19
38	viktorcapulet	19
39	samest	19
40	zainenn	19
41	szokerobert	19
42	tibfox	18
43	akintunde	18
44	barber78	18
45	braaiboy	18
46	didic	18
47	evildido	18
48	inlakech	18
49	mermaidvampire	18
50	sinzzer	18

Top50 by key_auths

.	Account	key_auths
1	laodr	23
2	cn-reader	16
3	spaminator	14
4	steemcleaners	11
5	abit	7
6	lafona-miner	7
7	adm	6
8	delegate.lafona	6
9	juurop	6
10	spi-postit	6
11	ffbank	5
12	lafona	5
13	lafona-miner3	5
14	steemiex	5
15	steempostitalia	5
16	robotq	4
17	guard	4
18	steemitblog	4
19	steemcleaner	4
20	bitshares.fdn	3
21	ceviche	3
22	cheetah	3
23	ginovotino	3
24	greymass	3
25	lafona-miner2	3
26	sariel	3
27	steem	3
28	witness.svk	3
29	xeroc	3
30	ptgram-power	3
31	princess	3
32	quarry	3
33	alittle	2
34	aluma	2
35	amalia	2
36	anonymous	2
37	b0y2k	2
38	b0y2k13	2
39	b0y2k14	2
40	b0y2k15	2
41	b0y2k16	2
42	b0y2k17	2
43	b0y2k18	2
44	b0y2k19	2
45	b0y2k2	2
46	b0y2k20	2
47	b0y2k21	2
48	b0y2k22	2
49	b0y2k23	2
50	b0y2k24	2

Top50 by account_auths + key_auths

.	Account	account_auths + key_auths
1	aneilpatel	34
2	hsynterkr	31
3	amico	26
4	anupbose	26
5	suheri	26
6	gilabola.mania	26
7	siol	25
8	cgbartow	25
9	bustillo	24
10	chronocrypto	24
11	nitro.speeder	24
12	dwiitavita	23
13	laodr	23
14	mkt	23
15	nulled67	23
16	rye05	23
17	birdinc	22
18	hungryhustle	22
19	jasmadiyunus	22
20	murizalpangeran	22
21	simplymike	22
22	pichat	22
23	buzzer11	21
24	frankremmy	21
25	gamsam	21
26	nameless-berk	21
27	nikema	21
28	puregrace	21
29	teamhumble	21
30	amulla505	21
31	jonnyla08	21
32	sebescen81	21
33	anzirpasai	20
34	ederaleng	20
35	jpederson96	20
36	rishi556	20
37	travelnepal	20
38	davidisfedup	20
39	viktorcapulet	20
40	samest	20
41	zainenn	20
42	szokerobert	20
43	tibfox	19
44	akintunde	19
45	barber78	19
46	braaiboy	19
47	didic	19
48	evildido	19
49	inlakech	19
50	mermaidvampire	19

If we sum account_auths and key_auths for each user then it turns out that 1161 accounts exceed the limit, which is equal to 10.