Replace indexes for counting active users

This adjusts the partial condition for an index. The index is intended
to be used when counting active users with `ghost IS NOT TRUE AND
bot_type IS NULL`.

With the current index, this wasn't working as the partial condition
didn't match the query: `ghost <> TRUE` is not semantically equivalent
to `ghost IS NOT TRUE` (null semantics).

The reason we add an index particularly intended for EE is that the EE
query is going to have the additional part `AND bot_type IS NULL`
whereas the CE query doesn't. Logically, it'd be enough to have an index
for `ghost IS NOT TRUE`. However, on GitLab.com, the query planner makes
poor choices when the additional `AND bot_type IS NULL` part is present:
It goes for the index on `bot_type` and doesn't use the partial index.

Note the existing index isn't being used at all according to GitLab.com
index statistics. Hence we can first remove it and don't have to worry
about the window of time without an index.

Relates to https://gitlab.com/gitlab-org/gitlab-ce/issues/66770
100 jobs for ab-admin-page-user-active-count in 75 minutes and 23 seconds (queued for 7 seconds)
Status Job ID Name Coverage
  Prepare
passed #285585592
gitlab-org
compile-assets pull-cache

00:07:34

passed #285585596
retrieve-tests-metadata

00:00:48

passed #285585594
gitlab-org
setup-test-env

00:07:25

 
  Test
passed #285585705
docker gitlab-org
build-qa-image

00:06:07

passed #285585609
allowed to fail
code_quality

00:09:41

passed #285672495
gitlab-org
danger-review

00:02:07

passed #285585696
gitlab-org
db:check-schema

00:03:20

passed #285585699
gitlab-org
db:migrate-from-v11.11.0

00:09:13

passed #285585694
gitlab-org
db:migrate:reset

00:03:27

passed #285585701
gitlab-org
db:rollback

00:04:30

passed #285585612
allowed to fail
dependency_scanning

00:05:19

passed #285585598
gitlab-org
docs lint

00:03:06

passed #285585688
gitlab-org
downtime_check

00:02:08

passed #285585690
gitlab-org
ee_compat_check

00:03:11

passed #285585599
docker gitlab-org
gitlab:assets:compile pull-cache

00:15:32

passed #285585703
gitlab-org
gitlab:setup

00:05:57

passed #285585711
gitlab-org
gitlab_git_test

00:01:39

passed #285585601
gitlab-org
jest

00:18:42

passed #285585600
gitlab-org
karma

00:13:17

54.11%
passed #285585716
gitlab-org
lint-ci-gitlab

00:00:59

passed #285585608
gitlab-org
memory-on-boot

00:07:03

passed #285585607
gitlab-org
memory-static

00:03:39

passed #285585714
gitlab-org
no_ee_check

00:01:35

passed #285585605
gitlab-org
qa-frontend-node:10

00:14:18

passed #285585604
gitlab-org
qa-frontend-node:8

00:15:07

passed #285585606
gitlab-org allowed to fail
qa-frontend-node:latest

00:13:55

passed #285585602
gitlab-org
qa:internal

00:03:19

passed #285585603
gitlab-org
qa:selectors

00:03:15

passed #285585708
allowed to fail manual
review-build-cng

00:28:32

passed #285585633
gitlab-org
rspec integration pg 1/6

00:18:20

passed #285585634
gitlab-org
rspec integration pg 2/6

00:18:12

passed #285585635
gitlab-org
rspec integration pg 3/6

00:16:28

passed #285585636
gitlab-org
rspec integration pg 4/6

00:16:01

passed #285585637
gitlab-org
rspec integration pg 5/6

00:20:43

passed #285585638
gitlab-org
rspec integration pg 6/6

00:20:34

passed #285585639
gitlab-org
rspec system pg 1/24

00:15:28

passed #285585652
gitlab-org
rspec system pg 10/24

00:14:48

passed #285585653
gitlab-org
rspec system pg 11/24

00:14:45

passed #285585654
gitlab-org
rspec system pg 12/24

00:13:55

passed #285585655
gitlab-org
rspec system pg 13/24

00:12:33

passed #285585657
gitlab-org
rspec system pg 14/24

00:15:54

passed #285585658
gitlab-org
rspec system pg 15/24

00:15:30

passed #285585659
gitlab-org
rspec system pg 16/24

00:12:57

passed #285585660
gitlab-org
rspec system pg 17/24

00:13:34

passed #285585661
gitlab-org
rspec system pg 18/24

00:13:15

passed #285585662
gitlab-org
rspec system pg 19/24

00:13:03

passed #285585640
gitlab-org
rspec system pg 2/24

00:13:12

passed #285585663
gitlab-org
rspec system pg 20/24

00:14:23

passed #285585666
gitlab-org
rspec system pg 21/24

00:14:08

passed #285585672
gitlab-org
rspec system pg 22/24

00:17:12

passed #285585675
gitlab-org
rspec system pg 23/24

00:16:03

passed #285585679
gitlab-org
rspec system pg 24/24

00:13:03

passed #285585642
gitlab-org
rspec system pg 3/24

00:13:27

passed #285585644
gitlab-org
rspec system pg 4/24

00:10:52

passed #285585645
gitlab-org
rspec system pg 5/24

00:16:22

passed #285585647
gitlab-org
rspec system pg 6/24

00:11:41

passed #285585648
gitlab-org
rspec system pg 7/24

00:14:24

passed #285585649
gitlab-org
rspec system pg 8/24

00:13:01

passed #285585651
gitlab-org
rspec system pg 9/24

00:12:48

passed #285585613
gitlab-org
rspec unit pg 1/20

00:16:15

passed #285585622
gitlab-org
rspec unit pg 10/20

00:14:49

passed #285585623
gitlab-org
rspec unit pg 11/20

00:16:57

passed #285585624
gitlab-org
rspec unit pg 12/20

00:18:35

passed #285585625
gitlab-org
rspec unit pg 13/20

00:20:42

passed #285585626
gitlab-org
rspec unit pg 14/20

00:17:59

passed #285585627
gitlab-org
rspec unit pg 15/20

00:17:50

passed #285585628
gitlab-org
rspec unit pg 16/20

00:15:54

passed #285585629
gitlab-org
rspec unit pg 17/20

00:17:17

passed #285585630
gitlab-org
rspec unit pg 18/20

00:18:52

passed #285585631
gitlab-org
rspec unit pg 19/20

00:15:54

passed #285585614
gitlab-org
rspec unit pg 2/20

00:16:22

passed #285585632
gitlab-org
rspec unit pg 20/20

00:17:02

passed #285585615
gitlab-org
rspec unit pg 3/20

00:19:22

passed #285585616
gitlab-org
rspec unit pg 4/20

00:15:06

passed #285585617
gitlab-org
rspec unit pg 5/20

00:16:48

passed #285585618
gitlab-org
rspec unit pg 6/20

00:15:38

passed #285585619
gitlab-org
rspec unit pg 7/20

00:15:30

passed #285585620
gitlab-org
rspec unit pg 8/20

00:16:29

passed #285585621
gitlab-org
rspec unit pg 9/20

00:16:13

passed #285585681
gitlab-org
rspec-fast-spec-helper

00:03:32

passed #285585610
allowed to fail
sast

00:07:51

passed #285585685
gitlab-org
static-analysis

00:13:11

passed #285585709
gitlab-org
danger-review

00:02:21

 
  Review
passed #285585723
gitlab-org allowed to fail
review-deploy

00:06:35

manual #285585722
gitlab-org allowed to fail manual
review-docs-cleanup
manual #285585718
gitlab-org allowed to fail manual
review-docs-deploy-manual
passed #285585724
gitlab-org allowed to fail manual
review-stop

00:00:40

 
  Qa
passed #285585726
allowed to fail
dast

00:10:39

manual #285585725
allowed to fail manual
package-and-qa-manual
passed #285585734
docker gitlab-org allowed to fail
review-performance

00:03:24

manual #285585728
docker gitlab-org allowed to fail manual
review-qa-all 1/5
manual #285585729
docker gitlab-org allowed to fail manual
review-qa-all 2/5
manual #285585730
docker gitlab-org allowed to fail manual
review-qa-all 3/5
manual #285585731
docker gitlab-org allowed to fail manual
review-qa-all 4/5
manual #285585733
docker gitlab-org allowed to fail manual
review-qa-all 5/5
passed #285585727
docker gitlab-org allowed to fail
review-qa-smoke

00:05:27

 
  Post Test
passed #285585738
gitlab-org
coverage

00:03:58

96.6%
passed #285585743
gitlab-org allowed to fail
flaky-examples-check

00:02:21

passed #285585736
gitlab-org
jsdoc

00:04:30

manual #285585740
gitlab-org allowed to fail manual
parallel-spec-reports