Add CI runner counts to usage ping (!58197) · Merge requests · GitLab.org / GitLab

Stan Hu requested to merge sh-usage-data-ci-runners into master Apr 01, 2021

This commit adds a number of new metrics:

ci_runners: The number of runners in the database
ci_runners_active: The number of active runners
ci_runners_instance_type_active: The number of active instance runners
ci_runners_group_type_active: The number of active group runners
ci_runners_project_type_active: The number of active project runners
ci_runners_instance_type_active_online: The number of active and online instance runners
ci_runners_group_type_active_online: The number of active and online group runners
ci_runners_project_type_active_online: The number of active and online project runners

`count(::Ci::Runner)` queries

irb(main):003:0> count(::Ci::Runner)
D, [2021-04-29T04:28:59.716995 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners"
D, [2021-04-29T04:28:59.718277 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners"
D, [2021-04-29T04:28:59.728275 #20296] DEBUG -- :   Feature::FlipperGate Load (0.7ms)  /*application:console*/ SELECT "feature_gates".* FROM "feature_gates" WHERE "feature_gates"."feature_key" = 'loose_index_scan_for_distinct_values'
D, [2021-04-29T04:28:59.744223 #20296] DEBUG -- :    (12.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 9 AND "ci_runners"."id" < 100009
D, [2021-04-29T04:28:59.762657 #20296] DEBUG -- :    (6.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 100009 AND "ci_runners"."id" < 200009
D, [2021-04-29T04:28:59.778104 #20296] DEBUG -- :    (4.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 200009 AND "ci_runners"."id" < 300009
D, [2021-04-29T04:28:59.796879 #20296] DEBUG -- :    (6.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 300009 AND "ci_runners"."id" < 400009
D, [2021-04-29T04:28:59.827439 #20296] DEBUG -- :    (18.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 400009 AND "ci_runners"."id" < 500009
D, [2021-04-29T04:28:59.852865 #20296] DEBUG -- :    (14.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 500009 AND "ci_runners"."id" < 600009
D, [2021-04-29T04:28:59.880299 #20296] DEBUG -- :    (15.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 600009 AND "ci_runners"."id" < 700009
D, [2021-04-29T04:28:59.910188 #20296] DEBUG -- :    (19.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 700009 AND "ci_runners"."id" < 800009
D, [2021-04-29T04:28:59.937342 #20296] DEBUG -- :    (15.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 800009 AND "ci_runners"."id" < 900009
D, [2021-04-29T04:28:59.977537 #20296] DEBUG -- :    (29.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 900009 AND "ci_runners"."id" < 1000009
D, [2021-04-29T04:28:59.998036 #20296] DEBUG -- :    (9.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1000009 AND "ci_runners"."id" < 1100009
D, [2021-04-29T04:29:00.017353 #20296] DEBUG -- :    (7.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1100009 AND "ci_runners"."id" < 1200009
D, [2021-04-29T04:29:00.042699 #20296] DEBUG -- :    (13.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1200009 AND "ci_runners"."id" < 1300009
D, [2021-04-29T04:29:00.061962 #20296] DEBUG -- :    (8.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1300009 AND "ci_runners"."id" < 1400009
D, [2021-04-29T04:29:00.085455 #20296] DEBUG -- :    (11.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1400009 AND "ci_runners"."id" < 1500009
D, [2021-04-29T04:29:00.107030 #20296] DEBUG -- :    (10.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1500009 AND "ci_runners"."id" < 1600009
D, [2021-04-29T04:29:00.134913 #20296] DEBUG -- :    (16.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1600009 AND "ci_runners"."id" < 1700009
D, [2021-04-29T04:29:00.151701 #20296] DEBUG -- :    (4.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1700009 AND "ci_runners"."id" < 1800009
D, [2021-04-29T04:29:00.185267 #20296] DEBUG -- :    (22.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1800009 AND "ci_runners"."id" < 1900009
D, [2021-04-29T04:29:00.202423 #20296] DEBUG -- :    (5.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 1900009 AND "ci_runners"."id" < 2000009
D, [2021-04-29T04:29:00.222033 #20296] DEBUG -- :    (8.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2000009 AND "ci_runners"."id" < 2100009
D, [2021-04-29T04:29:00.245506 #20296] DEBUG -- :    (11.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2100009 AND "ci_runners"."id" < 2200009
D, [2021-04-29T04:29:00.265220 #20296] DEBUG -- :    (7.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2200009 AND "ci_runners"."id" < 2300009
D, [2021-04-29T04:29:00.281405 #20296] DEBUG -- :    (5.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2300009 AND "ci_runners"."id" < 2400009
D, [2021-04-29T04:29:00.298904 #20296] DEBUG -- :    (5.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2400009 AND "ci_runners"."id" < 2500009
D, [2021-04-29T04:29:00.318074 #20296] DEBUG -- :    (8.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2500009 AND "ci_runners"."id" < 2600009
D, [2021-04-29T04:29:00.344217 #20296] DEBUG -- :    (14.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2600009 AND "ci_runners"."id" < 2700009
D, [2021-04-29T04:29:00.365450 #20296] DEBUG -- :    (10.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2700009 AND "ci_runners"."id" < 2800009
D, [2021-04-29T04:29:00.389702 #20296] DEBUG -- :    (12.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2800009 AND "ci_runners"."id" < 2900009
D, [2021-04-29T04:29:00.411476 #20296] DEBUG -- :    (10.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 2900009 AND "ci_runners"."id" < 3000009
D, [2021-04-29T04:29:00.440277 #20296] DEBUG -- :    (17.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3000009 AND "ci_runners"."id" < 3100009
D, [2021-04-29T04:29:00.482350 #20296] DEBUG -- :    (31.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3100009 AND "ci_runners"."id" < 3200009
D, [2021-04-29T04:29:00.524299 #20296] DEBUG -- :    (30.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3200009 AND "ci_runners"."id" < 3300009
D, [2021-04-29T04:29:00.559648 #20296] DEBUG -- :    (24.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3300009 AND "ci_runners"."id" < 3400009
D, [2021-04-29T04:29:00.606173 #20296] DEBUG -- :    (34.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3400009 AND "ci_runners"."id" < 3500009
D, [2021-04-29T04:29:00.640610 #20296] DEBUG -- :    (22.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3500009 AND "ci_runners"."id" < 3600009
D, [2021-04-29T04:29:00.678665 #20296] DEBUG -- :    (27.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3600009 AND "ci_runners"."id" < 3700009
D, [2021-04-29T04:29:00.713056 #20296] DEBUG -- :    (22.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3700009 AND "ci_runners"."id" < 3800009
D, [2021-04-29T04:29:00.741048 #20296] DEBUG -- :    (16.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3800009 AND "ci_runners"."id" < 3900009
D, [2021-04-29T04:29:00.770605 #20296] DEBUG -- :    (18.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 3900009 AND "ci_runners"."id" < 4000009
D, [2021-04-29T04:29:00.798357 #20296] DEBUG -- :    (16.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4000009 AND "ci_runners"."id" < 4100009
D, [2021-04-29T04:29:00.825767 #20296] DEBUG -- :    (16.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4100009 AND "ci_runners"."id" < 4200009
D, [2021-04-29T04:29:00.868862 #20296] DEBUG -- :    (31.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4200009 AND "ci_runners"."id" < 4300009
D, [2021-04-29T04:29:00.905524 #20296] DEBUG -- :    (25.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4300009 AND "ci_runners"."id" < 4400009
D, [2021-04-29T04:29:00.938580 #20296] DEBUG -- :    (22.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4400009 AND "ci_runners"."id" < 4500009
D, [2021-04-29T04:29:00.974692 #20296] DEBUG -- :    (24.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4500009 AND "ci_runners"."id" < 4600009
D, [2021-04-29T04:29:01.018031 #20296] DEBUG -- :    (31.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4600009 AND "ci_runners"."id" < 4700009
D, [2021-04-29T04:29:01.050967 #20296] DEBUG -- :    (22.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4700009 AND "ci_runners"."id" < 4800009
D, [2021-04-29T04:29:01.084026 #20296] DEBUG -- :    (21.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4800009 AND "ci_runners"."id" < 4900009
D, [2021-04-29T04:29:01.112151 #20296] DEBUG -- :    (17.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 4900009 AND "ci_runners"."id" < 5000009
D, [2021-04-29T04:29:01.145206 #20296] DEBUG -- :    (21.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 5000009 AND "ci_runners"."id" < 5100009
D, [2021-04-29T04:29:01.170859 #20296] DEBUG -- :    (14.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 5100009 AND "ci_runners"."id" < 5200009
D, [2021-04-29T04:29:01.193305 #20296] DEBUG -- :    (11.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 5200009 AND "ci_runners"."id" < 5300009
D, [2021-04-29T04:29:01.230047 #20296] DEBUG -- :    (25.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 5300009 AND "ci_runners"."id" < 5400009
D, [2021-04-29T04:29:01.254646 #20296] DEBUG -- :    (14.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."id" >= 5400009 AND "ci_runners"."id" < 5436739
=> 1526396

`count(::Ci::Runner.active)` queries

irb(main):004:0> count(::Ci::Runner.active)
D, [2021-04-29T04:29:25.521366 #20296] DEBUG -- :    (1.4ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE
D, [2021-04-29T04:29:25.524068 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE
D, [2021-04-29T04:29:25.689672 #20296] DEBUG -- :    (164.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 9 AND "ci_runners"."id" < 100009
D, [2021-04-29T04:29:25.978055 #20296] DEBUG -- :    (275.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 100009 AND "ci_runners"."id" < 200009
D, [2021-04-29T04:29:26.270624 #20296] DEBUG -- :    (281.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 200009 AND "ci_runners"."id" < 300009
D, [2021-04-29T04:29:26.678802 #20296] DEBUG -- :    (395.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 300009 AND "ci_runners"."id" < 400009
D, [2021-04-29T04:29:27.115186 #20296] DEBUG -- :    (423.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 400009 AND "ci_runners"."id" < 500009
D, [2021-04-29T04:29:27.563359 #20296] DEBUG -- :    (437.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 500009 AND "ci_runners"."id" < 600009
D, [2021-04-29T04:29:27.874588 #20296] DEBUG -- :    (299.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 600009 AND "ci_runners"."id" < 700009
D, [2021-04-29T04:29:28.320562 #20296] DEBUG -- :    (434.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 700009 AND "ci_runners"."id" < 800009
D, [2021-04-29T04:29:28.952094 #20296] DEBUG -- :    (619.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 800009 AND "ci_runners"."id" < 900009
D, [2021-04-29T04:29:29.422100 #20296] DEBUG -- :    (458.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 900009 AND "ci_runners"."id" < 1000009
D, [2021-04-29T04:29:29.890602 #20296] DEBUG -- :    (456.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1000009 AND "ci_runners"."id" < 1100009
D, [2021-04-29T04:29:30.263553 #20296] DEBUG -- :    (361.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1100009 AND "ci_runners"."id" < 1200009
D, [2021-04-29T04:29:30.723099 #20296] DEBUG -- :    (447.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1200009 AND "ci_runners"."id" < 1300009
D, [2021-04-29T04:29:31.209174 #20296] DEBUG -- :    (473.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1300009 AND "ci_runners"."id" < 1400009
D, [2021-04-29T04:29:31.661731 #20296] DEBUG -- :    (441.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1400009 AND "ci_runners"."id" < 1500009
D, [2021-04-29T04:29:32.212604 #20296] DEBUG -- :    (538.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1500009 AND "ci_runners"."id" < 1600009
D, [2021-04-29T04:29:32.764890 #20296] DEBUG -- :    (540.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1600009 AND "ci_runners"."id" < 1700009
D, [2021-04-29T04:29:33.120827 #20296] DEBUG -- :    (344.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1700009 AND "ci_runners"."id" < 1800009
D, [2021-04-29T04:29:33.406789 #20296] DEBUG -- :    (273.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1800009 AND "ci_runners"."id" < 1900009
D, [2021-04-29T04:29:33.610867 #20296] DEBUG -- :    (193.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1900009 AND "ci_runners"."id" < 2000009
D, [2021-04-29T04:29:34.050844 #20296] DEBUG -- :    (428.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2000009 AND "ci_runners"."id" < 2100009
D, [2021-04-29T04:29:34.427620 #20296] DEBUG -- :    (364.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2100009 AND "ci_runners"."id" < 2200009
D, [2021-04-29T04:29:34.661994 #20296] DEBUG -- :    (223.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2200009 AND "ci_runners"."id" < 2300009
D, [2021-04-29T04:29:34.806089 #20296] DEBUG -- :    (131.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2300009 AND "ci_runners"."id" < 2400009
D, [2021-04-29T04:29:35.015826 #20296] DEBUG -- :    (198.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2400009 AND "ci_runners"."id" < 2500009
D, [2021-04-29T04:29:35.363690 #20296] DEBUG -- :    (335.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2500009 AND "ci_runners"."id" < 2600009
D, [2021-04-29T04:29:35.772631 #20296] DEBUG -- :    (397.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2600009 AND "ci_runners"."id" < 2700009
D, [2021-04-29T04:29:36.022732 #20296] DEBUG -- :    (237.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2700009 AND "ci_runners"."id" < 2800009
D, [2021-04-29T04:29:36.412621 #20296] DEBUG -- :    (378.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2800009 AND "ci_runners"."id" < 2900009
D, [2021-04-29T04:29:36.761819 #20296] DEBUG -- :    (336.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2900009 AND "ci_runners"."id" < 3000009
D, [2021-04-29T04:29:37.109092 #20296] DEBUG -- :    (335.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3000009 AND "ci_runners"."id" < 3100009
D, [2021-04-29T04:29:37.468903 #20296] DEBUG -- :    (348.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3100009 AND "ci_runners"."id" < 3200009
D, [2021-04-29T04:29:37.850408 #20296] DEBUG -- :    (369.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3200009 AND "ci_runners"."id" < 3300009
D, [2021-04-29T04:29:38.010965 #20296] DEBUG -- :    (149.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3300009 AND "ci_runners"."id" < 3400009
D, [2021-04-29T04:29:38.282773 #20296] DEBUG -- :    (260.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3400009 AND "ci_runners"."id" < 3500009
D, [2021-04-29T04:29:38.718419 #20296] DEBUG -- :    (423.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3500009 AND "ci_runners"."id" < 3600009
D, [2021-04-29T04:29:39.003997 #20296] DEBUG -- :    (274.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3600009 AND "ci_runners"."id" < 3700009
D, [2021-04-29T04:29:39.354329 #20296] DEBUG -- :    (338.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3700009 AND "ci_runners"."id" < 3800009
D, [2021-04-29T04:29:39.702281 #20296] DEBUG -- :    (336.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3800009 AND "ci_runners"."id" < 3900009
D, [2021-04-29T04:29:39.965978 #20296] DEBUG -- :    (252.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3900009 AND "ci_runners"."id" < 4000009
D, [2021-04-29T04:29:40.276824 #20296] DEBUG -- :    (298.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4000009 AND "ci_runners"."id" < 4100009
D, [2021-04-29T04:29:40.585985 #20296] DEBUG -- :    (298.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4100009 AND "ci_runners"."id" < 4200009
D, [2021-04-29T04:29:40.813424 #20296] DEBUG -- :    (215.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4200009 AND "ci_runners"."id" < 4300009
D, [2021-04-29T04:29:41.048030 #20296] DEBUG -- :    (222.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4300009 AND "ci_runners"."id" < 4400009
D, [2021-04-29T04:29:41.360258 #20296] DEBUG -- :    (301.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4400009 AND "ci_runners"."id" < 4500009
D, [2021-04-29T04:29:41.583062 #20296] DEBUG -- :    (210.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4500009 AND "ci_runners"."id" < 4600009
D, [2021-04-29T04:29:41.939541 #20296] DEBUG -- :    (344.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4600009 AND "ci_runners"."id" < 4700009
D, [2021-04-29T04:29:42.542587 #20296] DEBUG -- :    (592.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4700009 AND "ci_runners"."id" < 4800009
D, [2021-04-29T04:29:42.812603 #20296] DEBUG -- :    (258.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4800009 AND "ci_runners"."id" < 4900009
D, [2021-04-29T04:29:42.907977 #20296] DEBUG -- :    (84.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4900009 AND "ci_runners"."id" < 5000009
D, [2021-04-29T04:29:42.982173 #20296] DEBUG -- :    (62.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5000009 AND "ci_runners"."id" < 5100009
D, [2021-04-29T04:29:43.054140 #20296] DEBUG -- :    (61.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5100009 AND "ci_runners"."id" < 5200009
D, [2021-04-29T04:29:43.116821 #20296] DEBUG -- :    (50.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5200009 AND "ci_runners"."id" < 5300009
D, [2021-04-29T04:29:43.312291 #20296] DEBUG -- :    (184.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5300009 AND "ci_runners"."id" < 5400009
D, [2021-04-29T04:29:43.540190 #20296] DEBUG -- :    (214.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5400009 AND "ci_runners"."id" < 5436761
=> 1498425

`count(::Ci::Runner.instance_type.active)` queries

irb(main):005:0> count(::Ci::Runner.instance_type.active)
D, [2021-04-29T04:30:04.102767 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE
D, [2021-04-29T04:30:04.104038 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE
D, [2021-04-29T04:30:04.106213 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 44028 AND "ci_runners"."id" < 144028
D, [2021-04-29T04:30:04.117449 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 144028 AND "ci_runners"."id" < 244028
D, [2021-04-29T04:30:04.129106 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 244028 AND "ci_runners"."id" < 344028
D, [2021-04-29T04:30:04.140290 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 344028 AND "ci_runners"."id" < 444028
D, [2021-04-29T04:30:04.151851 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 444028 AND "ci_runners"."id" < 544028
D, [2021-04-29T04:30:04.162979 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 544028 AND "ci_runners"."id" < 644028
D, [2021-04-29T04:30:04.175078 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 644028 AND "ci_runners"."id" < 744028
D, [2021-04-29T04:30:04.186687 #20296] DEBUG -- :    (1.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 744028 AND "ci_runners"."id" < 844028
D, [2021-04-29T04:30:04.197884 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 844028 AND "ci_runners"."id" < 944028
D, [2021-04-29T04:30:04.209381 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 944028 AND "ci_runners"."id" < 1044028
D, [2021-04-29T04:30:04.220563 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1044028 AND "ci_runners"."id" < 1144028
D, [2021-04-29T04:30:04.232943 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1144028 AND "ci_runners"."id" < 1244028
D, [2021-04-29T04:30:04.244171 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1244028 AND "ci_runners"."id" < 1344028
D, [2021-04-29T04:30:04.256877 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1344028 AND "ci_runners"."id" < 1444028
D, [2021-04-29T04:30:04.269459 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1444028 AND "ci_runners"."id" < 1544028
D, [2021-04-29T04:30:04.281007 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1544028 AND "ci_runners"."id" < 1644028
D, [2021-04-29T04:30:04.293934 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1644028 AND "ci_runners"."id" < 1744028
D, [2021-04-29T04:30:04.305298 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1744028 AND "ci_runners"."id" < 1844028
D, [2021-04-29T04:30:04.318468 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1844028 AND "ci_runners"."id" < 1944028
D, [2021-04-29T04:30:04.330296 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1944028 AND "ci_runners"."id" < 2044028
D, [2021-04-29T04:30:04.343402 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2044028 AND "ci_runners"."id" < 2144028
D, [2021-04-29T04:30:04.356006 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2144028 AND "ci_runners"."id" < 2244028
D, [2021-04-29T04:30:04.367437 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2244028 AND "ci_runners"."id" < 2344028
D, [2021-04-29T04:30:04.379968 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2344028 AND "ci_runners"."id" < 2444028
D, [2021-04-29T04:30:04.391892 #20296] DEBUG -- :    (1.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2444028 AND "ci_runners"."id" < 2544028
D, [2021-04-29T04:30:04.404815 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2544028 AND "ci_runners"."id" < 2568001
=> 15

`count(::Ci::Runner.group_type.active)` queries

irb(main):006:0> count(::Ci::Runner.group_type.active)
D, [2021-04-29T04:30:18.464486 #20296] DEBUG -- :    (54.2ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE
D, [2021-04-29T04:30:18.466043 #20296] DEBUG -- :    (0.9ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE
D, [2021-04-29T04:30:18.499255 #20296] DEBUG -- :    (32.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 366443 AND "ci_runners"."id" < 466443
D, [2021-04-29T04:30:18.545027 #20296] DEBUG -- :    (34.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 466443 AND "ci_runners"."id" < 566443
D, [2021-04-29T04:30:18.582290 #20296] DEBUG -- :    (26.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 566443 AND "ci_runners"."id" < 666443
D, [2021-04-29T04:30:18.637588 #20296] DEBUG -- :    (44.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 666443 AND "ci_runners"."id" < 766443
D, [2021-04-29T04:30:18.681072 #20296] DEBUG -- :    (32.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 766443 AND "ci_runners"."id" < 866443
D, [2021-04-29T04:30:18.754108 #20296] DEBUG -- :    (62.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 866443 AND "ci_runners"."id" < 966443
D, [2021-04-29T04:30:18.792386 #20296] DEBUG -- :    (27.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 966443 AND "ci_runners"."id" < 1066443
D, [2021-04-29T04:30:18.822624 #20296] DEBUG -- :    (19.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1066443 AND "ci_runners"."id" < 1166443
D, [2021-04-29T04:30:18.870527 #20296] DEBUG -- :    (37.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1166443 AND "ci_runners"."id" < 1266443
D, [2021-04-29T04:30:18.928670 #20296] DEBUG -- :    (47.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1266443 AND "ci_runners"."id" < 1366443
D, [2021-04-29T04:30:18.983928 #20296] DEBUG -- :    (44.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1366443 AND "ci_runners"."id" < 1466443
D, [2021-04-29T04:30:19.046233 #20296] DEBUG -- :    (51.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1466443 AND "ci_runners"."id" < 1566443
D, [2021-04-29T04:30:19.106046 #20296] DEBUG -- :    (48.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1566443 AND "ci_runners"."id" < 1666443
D, [2021-04-29T04:30:19.135220 #20296] DEBUG -- :    (18.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1666443 AND "ci_runners"."id" < 1766443
D, [2021-04-29T04:30:19.188422 #20296] DEBUG -- :    (42.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1766443 AND "ci_runners"."id" < 1866443
D, [2021-04-29T04:30:19.237462 #20296] DEBUG -- :    (38.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1866443 AND "ci_runners"."id" < 1966443
D, [2021-04-29T04:30:19.290811 #20296] DEBUG -- :    (42.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1966443 AND "ci_runners"."id" < 2066443
D, [2021-04-29T04:30:19.410839 #20296] DEBUG -- :    (109.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2066443 AND "ci_runners"."id" < 2166443
D, [2021-04-29T04:30:19.479466 #20296] DEBUG -- :    (57.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2166443 AND "ci_runners"."id" < 2266443
D, [2021-04-29T04:30:19.516406 #20296] DEBUG -- :    (25.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2266443 AND "ci_runners"."id" < 2366443
D, [2021-04-29T04:30:19.566616 #20296] DEBUG -- :    (39.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2366443 AND "ci_runners"."id" < 2466443
D, [2021-04-29T04:30:19.621714 #20296] DEBUG -- :    (44.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2466443 AND "ci_runners"."id" < 2566443
D, [2021-04-29T04:30:19.718127 #20296] DEBUG -- :    (85.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2566443 AND "ci_runners"."id" < 2666443
D, [2021-04-29T04:30:19.806957 #20296] DEBUG -- :    (77.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2666443 AND "ci_runners"."id" < 2766443
D, [2021-04-29T04:30:19.890107 #20296] DEBUG -- :    (72.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2766443 AND "ci_runners"."id" < 2866443
D, [2021-04-29T04:30:19.966014 #20296] DEBUG -- :    (64.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2866443 AND "ci_runners"."id" < 2966443
D, [2021-04-29T04:30:20.034151 #20296] DEBUG -- :    (57.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2966443 AND "ci_runners"."id" < 3066443
D, [2021-04-29T04:30:20.104149 #20296] DEBUG -- :    (58.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3066443 AND "ci_runners"."id" < 3166443
D, [2021-04-29T04:30:20.257963 #20296] DEBUG -- :    (142.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3166443 AND "ci_runners"."id" < 3266443
D, [2021-04-29T04:30:20.312530 #20296] DEBUG -- :    (43.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3266443 AND "ci_runners"."id" < 3366443
D, [2021-04-29T04:30:20.495913 #20296] DEBUG -- :    (172.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3366443 AND "ci_runners"."id" < 3466443
D, [2021-04-29T04:30:20.629587 #20296] DEBUG -- :    (122.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3466443 AND "ci_runners"."id" < 3566443
D, [2021-04-29T04:30:20.749730 #20296] DEBUG -- :    (109.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3566443 AND "ci_runners"."id" < 3666443
D, [2021-04-29T04:30:20.917980 #20296] DEBUG -- :    (157.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3666443 AND "ci_runners"."id" < 3766443
D, [2021-04-29T04:30:21.065664 #20296] DEBUG -- :    (136.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3766443 AND "ci_runners"."id" < 3866443
D, [2021-04-29T04:30:21.189056 #20296] DEBUG -- :    (112.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3866443 AND "ci_runners"."id" < 3966443
D, [2021-04-29T04:30:21.316444 #20296] DEBUG -- :    (116.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3966443 AND "ci_runners"."id" < 4066443
D, [2021-04-29T04:30:21.441077 #20296] DEBUG -- :    (113.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4066443 AND "ci_runners"."id" < 4166443
D, [2021-04-29T04:30:21.556690 #20296] DEBUG -- :    (104.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4166443 AND "ci_runners"."id" < 4266443
D, [2021-04-29T04:30:21.643118 #20296] DEBUG -- :    (75.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4266443 AND "ci_runners"."id" < 4366443
D, [2021-04-29T04:30:21.756407 #20296] DEBUG -- :    (102.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4366443 AND "ci_runners"."id" < 4466443
D, [2021-04-29T04:30:21.882418 #20296] DEBUG -- :    (115.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4466443 AND "ci_runners"."id" < 4566443
D, [2021-04-29T04:30:22.022628 #20296] DEBUG -- :    (129.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4566443 AND "ci_runners"."id" < 4666443
D, [2021-04-29T04:30:22.173205 #20296] DEBUG -- :    (139.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4666443 AND "ci_runners"."id" < 4766443
D, [2021-04-29T04:30:22.273166 #20296] DEBUG -- :    (88.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4766443 AND "ci_runners"."id" < 4866443
D, [2021-04-29T04:30:22.396033 #20296] DEBUG -- :    (111.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4866443 AND "ci_runners"."id" < 4966443
D, [2021-04-29T04:30:22.468235 #20296] DEBUG -- :    (61.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4966443 AND "ci_runners"."id" < 5066443
D, [2021-04-29T04:30:22.531782 #20296] DEBUG -- :    (52.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5066443 AND "ci_runners"."id" < 5166443
D, [2021-04-29T04:30:22.578185 #20296] DEBUG -- :    (35.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5166443 AND "ci_runners"."id" < 5266443
D, [2021-04-29T04:30:22.634710 #20296] DEBUG -- :    (45.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5266443 AND "ci_runners"."id" < 5366443
D, [2021-04-29T04:30:22.688539 #20296] DEBUG -- :    (42.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5366443 AND "ci_runners"."id" < 5436790
=> 505903

`count(::Ci::Runner.project_type.active)` queries

irb(main):007:0> count(::Ci::Runner.project_type.active)
D, [2021-04-29T04:30:39.577582 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE
D, [2021-04-29T04:30:39.578736 #20296] DEBUG -- :    (0.5ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE
D, [2021-04-29T04:30:39.590361 #20296] DEBUG -- :    (11.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 9 AND "ci_runners"."id" < 100009
D, [2021-04-29T04:30:39.617414 #20296] DEBUG -- :    (16.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 100009 AND "ci_runners"."id" < 200009
D, [2021-04-29T04:30:39.643892 #20296] DEBUG -- :    (15.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 200009 AND "ci_runners"."id" < 300009
D, [2021-04-29T04:30:39.678217 #20296] DEBUG -- :    (23.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 300009 AND "ci_runners"."id" < 400009
D, [2021-04-29T04:30:39.727429 #20296] DEBUG -- :    (38.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 400009 AND "ci_runners"."id" < 500009
D, [2021-04-29T04:30:39.762051 #20296] DEBUG -- :    (23.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 500009 AND "ci_runners"."id" < 600009
D, [2021-04-29T04:30:39.813590 #20296] DEBUG -- :    (40.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 600009 AND "ci_runners"."id" < 700009
D, [2021-04-29T04:30:39.882046 #20296] DEBUG -- :    (57.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 700009 AND "ci_runners"."id" < 800009
D, [2021-04-29T04:30:39.919651 #20296] DEBUG -- :    (26.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 800009 AND "ci_runners"."id" < 900009
D, [2021-04-29T04:30:39.960760 #20296] DEBUG -- :    (29.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 900009 AND "ci_runners"."id" < 1000009
D, [2021-04-29T04:30:39.999748 #20296] DEBUG -- :    (27.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1000009 AND "ci_runners"."id" < 1100009
D, [2021-04-29T04:30:40.035085 #20296] DEBUG -- :    (24.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1100009 AND "ci_runners"."id" < 1200009
D, [2021-04-29T04:30:40.070098 #20296] DEBUG -- :    (24.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1200009 AND "ci_runners"."id" < 1300009
D, [2021-04-29T04:30:40.105008 #20296] DEBUG -- :    (24.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1300009 AND "ci_runners"."id" < 1400009
D, [2021-04-29T04:30:40.149284 #20296] DEBUG -- :    (33.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1400009 AND "ci_runners"."id" < 1500009
D, [2021-04-29T04:30:40.186516 #20296] DEBUG -- :    (26.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1500009 AND "ci_runners"."id" < 1600009
D, [2021-04-29T04:30:40.224059 #20296] DEBUG -- :    (26.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1600009 AND "ci_runners"."id" < 1700009
D, [2021-04-29T04:30:40.251571 #20296] DEBUG -- :    (16.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1700009 AND "ci_runners"."id" < 1800009
D, [2021-04-29T04:30:40.292145 #20296] DEBUG -- :    (29.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1800009 AND "ci_runners"."id" < 1900009
D, [2021-04-29T04:30:40.333916 #20296] DEBUG -- :    (30.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 1900009 AND "ci_runners"."id" < 2000009
D, [2021-04-29T04:30:40.390327 #20296] DEBUG -- :    (45.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2000009 AND "ci_runners"."id" < 2100009
D, [2021-04-29T04:30:40.455100 #20296] DEBUG -- :    (53.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2100009 AND "ci_runners"."id" < 2200009
D, [2021-04-29T04:30:40.498508 #20296] DEBUG -- :    (32.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2200009 AND "ci_runners"."id" < 2300009
D, [2021-04-29T04:30:40.530473 #20296] DEBUG -- :    (20.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2300009 AND "ci_runners"."id" < 2400009
D, [2021-04-29T04:30:40.566409 #20296] DEBUG -- :    (24.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2400009 AND "ci_runners"."id" < 2500009
D, [2021-04-29T04:30:40.627159 #20296] DEBUG -- :    (49.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2500009 AND "ci_runners"."id" < 2600009
D, [2021-04-29T04:30:40.722194 #20296] DEBUG -- :    (83.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2600009 AND "ci_runners"."id" < 2700009
D, [2021-04-29T04:30:40.771615 #20296] DEBUG -- :    (38.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2700009 AND "ci_runners"."id" < 2800009
D, [2021-04-29T04:30:40.845735 #20296] DEBUG -- :    (63.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2800009 AND "ci_runners"."id" < 2900009
D, [2021-04-29T04:30:40.937421 #20296] DEBUG -- :    (80.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 2900009 AND "ci_runners"."id" < 3000009
D, [2021-04-29T04:30:41.017920 #20296] DEBUG -- :    (69.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3000009 AND "ci_runners"."id" < 3100009
D, [2021-04-29T04:30:41.096681 #20296] DEBUG -- :    (67.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3100009 AND "ci_runners"."id" < 3200009
D, [2021-04-29T04:30:41.171701 #20296] DEBUG -- :    (63.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3200009 AND "ci_runners"."id" < 3300009
D, [2021-04-29T04:30:41.227736 #20296] DEBUG -- :    (45.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3300009 AND "ci_runners"."id" < 3400009
D, [2021-04-29T04:30:41.362743 #20296] DEBUG -- :    (123.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3400009 AND "ci_runners"."id" < 3500009
D, [2021-04-29T04:30:41.484829 #20296] DEBUG -- :    (111.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3500009 AND "ci_runners"."id" < 3600009
D, [2021-04-29T04:30:41.599471 #20296] DEBUG -- :    (103.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3600009 AND "ci_runners"."id" < 3700009
D, [2021-04-29T04:30:41.705712 #20296] DEBUG -- :    (94.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3700009 AND "ci_runners"."id" < 3800009
D, [2021-04-29T04:30:41.826152 #20296] DEBUG -- :    (109.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3800009 AND "ci_runners"."id" < 3900009
D, [2021-04-29T04:30:41.924919 #20296] DEBUG -- :    (87.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 3900009 AND "ci_runners"."id" < 4000009
D, [2021-04-29T04:30:42.066749 #20296] DEBUG -- :    (130.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4000009 AND "ci_runners"."id" < 4100009
D, [2021-04-29T04:30:42.195241 #20296] DEBUG -- :    (117.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4100009 AND "ci_runners"."id" < 4200009
D, [2021-04-29T04:30:42.280607 #20296] DEBUG -- :    (74.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4200009 AND "ci_runners"."id" < 4300009
D, [2021-04-29T04:30:42.376319 #20296] DEBUG -- :    (84.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4300009 AND "ci_runners"."id" < 4400009
D, [2021-04-29T04:30:42.465764 #20296] DEBUG -- :    (78.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4400009 AND "ci_runners"."id" < 4500009
D, [2021-04-29T04:30:42.571402 #20296] DEBUG -- :    (94.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4500009 AND "ci_runners"."id" < 4600009
D, [2021-04-29T04:30:42.677844 #20296] DEBUG -- :    (95.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4600009 AND "ci_runners"."id" < 4700009
D, [2021-04-29T04:30:42.791602 #20296] DEBUG -- :    (102.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4700009 AND "ci_runners"."id" < 4800009
D, [2021-04-29T04:30:42.884931 #20296] DEBUG -- :    (82.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4800009 AND "ci_runners"."id" < 4900009
D, [2021-04-29T04:30:42.942684 #20296] DEBUG -- :    (46.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 4900009 AND "ci_runners"."id" < 5000009
D, [2021-04-29T04:30:42.990657 #20296] DEBUG -- :    (37.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5000009 AND "ci_runners"."id" < 5100009
D, [2021-04-29T04:30:43.069774 #20296] DEBUG -- :    (68.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5100009 AND "ci_runners"."id" < 5200009
D, [2021-04-29T04:30:43.104294 #20296] DEBUG -- :    (23.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5200009 AND "ci_runners"."id" < 5300009
D, [2021-04-29T04:30:43.171339 #20296] DEBUG -- :    (56.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5300009 AND "ci_runners"."id" < 5400009
D, [2021-04-29T04:30:43.210829 #20296] DEBUG -- :    (28.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND "ci_runners"."active" = TRUE AND "ci_runners"."id" >= 5400009 AND "ci_runners"."id" < 5436820
=> 992524

`count(::Ci::Runner.online)` queries

irb(main):008:0> count(::Ci::Runner.online)
D, [2021-04-29T04:30:58.458834 #20296] DEBUG -- :    (1.7ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395')
D, [2021-04-29T04:30:58.460338 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395')
D, [2021-04-29T04:30:58.469976 #20296] DEBUG -- :    (9.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4448 AND "ci_runners"."id" < 104448
D, [2021-04-29T04:30:58.490631 #20296] DEBUG -- :    (10.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 104448 AND "ci_runners"."id" < 204448
D, [2021-04-29T04:30:58.514987 #20296] DEBUG -- :    (13.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 204448 AND "ci_runners"."id" < 304448
D, [2021-04-29T04:30:58.544784 #20296] DEBUG -- :    (19.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 304448 AND "ci_runners"."id" < 404448
D, [2021-04-29T04:30:58.817544 #20296] DEBUG -- :    (262.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 404448 AND "ci_runners"."id" < 504448
D, [2021-04-29T04:30:58.847511 #20296] DEBUG -- :    (18.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 504448 AND "ci_runners"."id" < 604448
D, [2021-04-29T04:30:58.883641 #20296] DEBUG -- :    (24.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 604448 AND "ci_runners"."id" < 704448
D, [2021-04-29T04:30:58.917239 #20296] DEBUG -- :    (22.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 704448 AND "ci_runners"."id" < 804448
D, [2021-04-29T04:30:58.949626 #20296] DEBUG -- :    (21.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 804448 AND "ci_runners"."id" < 904448
D, [2021-04-29T04:30:58.985916 #20296] DEBUG -- :    (25.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 904448 AND "ci_runners"."id" < 1004448
D, [2021-04-29T04:30:59.020875 #20296] DEBUG -- :    (23.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1004448 AND "ci_runners"."id" < 1104448
D, [2021-04-29T04:30:59.049404 #20296] DEBUG -- :    (17.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1104448 AND "ci_runners"."id" < 1204448
D, [2021-04-29T04:30:59.094913 #20296] DEBUG -- :    (34.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1204448 AND "ci_runners"."id" < 1304448
D, [2021-04-29T04:30:59.122657 #20296] DEBUG -- :    (16.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1304448 AND "ci_runners"."id" < 1404448
D, [2021-04-29T04:30:59.151308 #20296] DEBUG -- :    (17.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1404448 AND "ci_runners"."id" < 1504448
D, [2021-04-29T04:30:59.186617 #20296] DEBUG -- :    (24.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1504448 AND "ci_runners"."id" < 1604448
D, [2021-04-29T04:30:59.224728 #20296] DEBUG -- :    (26.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1604448 AND "ci_runners"."id" < 1704448
D, [2021-04-29T04:30:59.253666 #20296] DEBUG -- :    (17.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1704448 AND "ci_runners"."id" < 1804448
D, [2021-04-29T04:30:59.292644 #20296] DEBUG -- :    (27.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1804448 AND "ci_runners"."id" < 1904448
D, [2021-04-29T04:30:59.327515 #20296] DEBUG -- :    (23.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 1904448 AND "ci_runners"."id" < 2004448
D, [2021-04-29T04:30:59.376221 #20296] DEBUG -- :    (37.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2004448 AND "ci_runners"."id" < 2104448
D, [2021-04-29T04:30:59.427036 #20296] DEBUG -- :    (39.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2104448 AND "ci_runners"."id" < 2204448
D, [2021-04-29T04:30:59.466652 #20296] DEBUG -- :    (28.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2204448 AND "ci_runners"."id" < 2304448
D, [2021-04-29T04:30:59.497462 #20296] DEBUG -- :    (19.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2304448 AND "ci_runners"."id" < 2404448
D, [2021-04-29T04:30:59.535313 #20296] DEBUG -- :    (26.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2404448 AND "ci_runners"."id" < 2504448
D, [2021-04-29T04:30:59.594410 #20296] DEBUG -- :    (47.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2504448 AND "ci_runners"."id" < 2604448
D, [2021-04-29T04:30:59.656139 #20296] DEBUG -- :    (50.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2604448 AND "ci_runners"."id" < 2704448
D, [2021-04-29T04:30:59.707056 #20296] DEBUG -- :    (39.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2704448 AND "ci_runners"."id" < 2804448
D, [2021-04-29T04:30:59.790112 #20296] DEBUG -- :    (71.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2804448 AND "ci_runners"."id" < 2904448
D, [2021-04-29T04:30:59.871120 #20296] DEBUG -- :    (69.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 2904448 AND "ci_runners"."id" < 3004448
D, [2021-04-29T04:30:59.928792 #20296] DEBUG -- :    (46.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3004448 AND "ci_runners"."id" < 3104448
D, [2021-04-29T04:30:59.984714 #20296] DEBUG -- :    (44.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3104448 AND "ci_runners"."id" < 3204448
D, [2021-04-29T04:31:00.064951 #20296] DEBUG -- :    (69.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3204448 AND "ci_runners"."id" < 3304448
D, [2021-04-29T04:31:00.144042 #20296] DEBUG -- :    (68.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3304448 AND "ci_runners"."id" < 3404448
D, [2021-04-29T04:31:00.177760 #20296] DEBUG -- :    (22.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3404448 AND "ci_runners"."id" < 3504448
D, [2021-04-29T04:31:00.207744 #20296] DEBUG -- :    (18.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3504448 AND "ci_runners"."id" < 3604448
D, [2021-04-29T04:31:00.238568 #20296] DEBUG -- :    (19.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3604448 AND "ci_runners"."id" < 3704448
D, [2021-04-29T04:31:00.269476 #20296] DEBUG -- :    (19.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3704448 AND "ci_runners"."id" < 3804448
D, [2021-04-29T04:31:00.301790 #20296] DEBUG -- :    (21.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3804448 AND "ci_runners"."id" < 3904448
D, [2021-04-29T04:31:00.333373 #20296] DEBUG -- :    (20.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 3904448 AND "ci_runners"."id" < 4004448
D, [2021-04-29T04:31:00.381460 #20296] DEBUG -- :    (37.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4004448 AND "ci_runners"."id" < 4104448
D, [2021-04-29T04:31:00.422324 #20296] DEBUG -- :    (29.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4104448 AND "ci_runners"."id" < 4204448
D, [2021-04-29T04:31:00.493658 #20296] DEBUG -- :    (60.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4204448 AND "ci_runners"."id" < 4304448
D, [2021-04-29T04:31:00.609544 #20296] DEBUG -- :    (104.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4304448 AND "ci_runners"."id" < 4404448
D, [2021-04-29T04:31:00.708045 #20296] DEBUG -- :    (87.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4404448 AND "ci_runners"."id" < 4504448
D, [2021-04-29T04:31:00.773908 #20296] DEBUG -- :    (54.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4504448 AND "ci_runners"."id" < 4604448
D, [2021-04-29T04:31:00.808552 #20296] DEBUG -- :    (23.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4604448 AND "ci_runners"."id" < 4704448
D, [2021-04-29T04:31:00.892596 #20296] DEBUG -- :    (73.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4704448 AND "ci_runners"."id" < 4804448
D, [2021-04-29T04:31:00.980994 #20296] DEBUG -- :    (77.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4804448 AND "ci_runners"."id" < 4904448
D, [2021-04-29T04:31:01.031230 #20296] DEBUG -- :    (39.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 4904448 AND "ci_runners"."id" < 5004448
D, [2021-04-29T04:31:01.087619 #20296] DEBUG -- :    (45.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 5004448 AND "ci_runners"."id" < 5104448
D, [2021-04-29T04:31:01.137048 #20296] DEBUG -- :    (38.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 5104448 AND "ci_runners"."id" < 5204448
D, [2021-04-29T04:31:01.170118 #20296] DEBUG -- :    (21.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 5204448 AND "ci_runners"."id" < 5304448
D, [2021-04-29T04:31:01.220709 #20296] DEBUG -- :    (39.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 5304448 AND "ci_runners"."id" < 5404448
D, [2021-04-29T04:31:01.259233 #20296] DEBUG -- :    (27.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE (contacted_at > '2021-04-29 02:30:58.456395') AND "ci_runners"."id" >= 5404448 AND "ci_runners"."id" < 5436790
=> 107649

`count(::Ci::Runner.instance_type.online)` queries

irb(main):009:0> count(::Ci::Runner.instance_type.online)
D, [2021-04-29T04:31:16.457346 #20296] DEBUG -- :    (0.9ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649')
D, [2021-04-29T04:31:16.458647 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649')
D, [2021-04-29T04:31:16.459869 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 44028 AND "ci_runners"."id" < 144028
D, [2021-04-29T04:31:16.471454 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 144028 AND "ci_runners"."id" < 244028
D, [2021-04-29T04:31:16.483018 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 244028 AND "ci_runners"."id" < 344028
D, [2021-04-29T04:31:16.494482 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 344028 AND "ci_runners"."id" < 444028
D, [2021-04-29T04:31:16.505952 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 444028 AND "ci_runners"."id" < 544028
D, [2021-04-29T04:31:16.517381 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 544028 AND "ci_runners"."id" < 644028
D, [2021-04-29T04:31:16.528967 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 644028 AND "ci_runners"."id" < 744028
D, [2021-04-29T04:31:16.540356 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 744028 AND "ci_runners"."id" < 844028
D, [2021-04-29T04:31:16.551843 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 844028 AND "ci_runners"."id" < 944028
D, [2021-04-29T04:31:16.571009 #20296] DEBUG -- :    (8.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 944028 AND "ci_runners"."id" < 1044028
D, [2021-04-29T04:31:16.582540 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1044028 AND "ci_runners"."id" < 1144028
D, [2021-04-29T04:31:16.593990 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1144028 AND "ci_runners"."id" < 1244028
D, [2021-04-29T04:31:16.605253 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1244028 AND "ci_runners"."id" < 1344028
D, [2021-04-29T04:31:16.616620 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1344028 AND "ci_runners"."id" < 1444028
D, [2021-04-29T04:31:16.628121 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1444028 AND "ci_runners"."id" < 1544028
D, [2021-04-29T04:31:16.639396 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1544028 AND "ci_runners"."id" < 1644028
D, [2021-04-29T04:31:16.650615 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1644028 AND "ci_runners"."id" < 1744028
D, [2021-04-29T04:31:16.661949 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1744028 AND "ci_runners"."id" < 1844028
D, [2021-04-29T04:31:16.673163 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1844028 AND "ci_runners"."id" < 1944028
D, [2021-04-29T04:31:16.684478 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 1944028 AND "ci_runners"."id" < 2044028
D, [2021-04-29T04:31:16.695840 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 2044028 AND "ci_runners"."id" < 2144028
D, [2021-04-29T04:31:16.707209 #20296] DEBUG -- :    (0.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 2144028 AND "ci_runners"."id" < 2244028
D, [2021-04-29T04:31:16.718567 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 2244028 AND "ci_runners"."id" < 2344028
D, [2021-04-29T04:31:16.729929 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 2344028 AND "ci_runners"."id" < 2444028
D, [2021-04-29T04:31:16.741356 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 2444028 AND "ci_runners"."id" < 2544028
D, [2021-04-29T04:31:16.752731 #20296] DEBUG -- :    (0.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 1 AND (contacted_at > '2021-04-29 02:31:16.455649') AND "ci_runners"."id" >= 2544028 AND "ci_runners"."id" < 2568001
=> 15

`count(::Ci::Runner.group_type.online)` queries

irb(main):010:0> count(::Ci::Runner.group_type.online)
D, [2021-04-29T04:31:30.642835 #20296] DEBUG -- :    (44.1ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047')
D, [2021-04-29T04:31:30.644450 #20296] DEBUG -- :    (0.9ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047')
D, [2021-04-29T04:31:30.668459 #20296] DEBUG -- :    (23.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 366443 AND "ci_runners"."id" < 466443
D, [2021-04-29T04:31:30.711330 #20296] DEBUG -- :    (32.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 466443 AND "ci_runners"."id" < 566443
D, [2021-04-29T04:31:30.747985 #20296] DEBUG -- :    (25.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 566443 AND "ci_runners"."id" < 666443
D, [2021-04-29T04:31:30.783196 #20296] DEBUG -- :    (24.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 666443 AND "ci_runners"."id" < 766443
D, [2021-04-29T04:31:30.827530 #20296] DEBUG -- :    (33.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 766443 AND "ci_runners"."id" < 866443
D, [2021-04-29T04:31:30.863055 #20296] DEBUG -- :    (24.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 866443 AND "ci_runners"."id" < 966443
D, [2021-04-29T04:31:30.897035 #20296] DEBUG -- :    (23.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 966443 AND "ci_runners"."id" < 1066443
D, [2021-04-29T04:31:30.924287 #20296] DEBUG -- :    (16.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1066443 AND "ci_runners"."id" < 1166443
D, [2021-04-29T04:31:30.965021 #20296] DEBUG -- :    (29.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1166443 AND "ci_runners"."id" < 1266443
D, [2021-04-29T04:31:31.000551 #20296] DEBUG -- :    (24.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1266443 AND "ci_runners"."id" < 1366443
D, [2021-04-29T04:31:31.030885 #20296] DEBUG -- :    (19.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1366443 AND "ci_runners"."id" < 1466443
D, [2021-04-29T04:31:31.072342 #20296] DEBUG -- :    (30.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1466443 AND "ci_runners"."id" < 1566443
D, [2021-04-29T04:31:31.108874 #20296] DEBUG -- :    (25.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1566443 AND "ci_runners"."id" < 1666443
D, [2021-04-29T04:31:31.143371 #20296] DEBUG -- :    (23.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1666443 AND "ci_runners"."id" < 1766443
D, [2021-04-29T04:31:31.180614 #20296] DEBUG -- :    (26.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1766443 AND "ci_runners"."id" < 1866443
D, [2021-04-29T04:31:31.210995 #20296] DEBUG -- :    (19.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1866443 AND "ci_runners"."id" < 1966443
D, [2021-04-29T04:31:31.253478 #20296] DEBUG -- :    (31.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 1966443 AND "ci_runners"."id" < 2066443
D, [2021-04-29T04:31:31.305082 #20296] DEBUG -- :    (40.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2066443 AND "ci_runners"."id" < 2166443
D, [2021-04-29T04:31:31.359892 #20296] DEBUG -- :    (43.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2166443 AND "ci_runners"."id" < 2266443
D, [2021-04-29T04:31:31.391459 #20296] DEBUG -- :    (20.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2266443 AND "ci_runners"."id" < 2366443
D, [2021-04-29T04:31:31.424594 #20296] DEBUG -- :    (22.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2366443 AND "ci_runners"."id" < 2466443
D, [2021-04-29T04:31:31.475803 #20296] DEBUG -- :    (40.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2466443 AND "ci_runners"."id" < 2566443
D, [2021-04-29T04:31:31.556543 #20296] DEBUG -- :    (69.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2566443 AND "ci_runners"."id" < 2666443
D, [2021-04-29T04:31:31.609319 #20296] DEBUG -- :    (41.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2666443 AND "ci_runners"."id" < 2766443
D, [2021-04-29T04:31:31.675079 #20296] DEBUG -- :    (54.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2766443 AND "ci_runners"."id" < 2866443
D, [2021-04-29T04:31:31.737464 #20296] DEBUG -- :    (51.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2866443 AND "ci_runners"."id" < 2966443
D, [2021-04-29T04:31:31.812265 #20296] DEBUG -- :    (63.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 2966443 AND "ci_runners"."id" < 3066443
D, [2021-04-29T04:31:31.879472 #20296] DEBUG -- :    (56.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3066443 AND "ci_runners"."id" < 3166443
D, [2021-04-29T04:31:31.943430 #20296] DEBUG -- :    (52.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3166443 AND "ci_runners"."id" < 3266443
D, [2021-04-29T04:31:31.990551 #20296] DEBUG -- :    (36.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3266443 AND "ci_runners"."id" < 3366443
D, [2021-04-29T04:31:32.021813 #20296] DEBUG -- :    (20.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3366443 AND "ci_runners"."id" < 3466443
D, [2021-04-29T04:31:32.052939 #20296] DEBUG -- :    (20.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3466443 AND "ci_runners"."id" < 3566443
D, [2021-04-29T04:31:32.084259 #20296] DEBUG -- :    (20.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3566443 AND "ci_runners"."id" < 3666443
D, [2021-04-29T04:31:32.115242 #20296] DEBUG -- :    (20.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3666443 AND "ci_runners"."id" < 3766443
D, [2021-04-29T04:31:32.146853 #20296] DEBUG -- :    (20.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3766443 AND "ci_runners"."id" < 3866443
D, [2021-04-29T04:31:32.178885 #20296] DEBUG -- :    (21.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3866443 AND "ci_runners"."id" < 3966443
D, [2021-04-29T04:31:32.211168 #20296] DEBUG -- :    (21.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 3966443 AND "ci_runners"."id" < 4066443
D, [2021-04-29T04:31:32.243584 #20296] DEBUG -- :    (21.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4066443 AND "ci_runners"."id" < 4166443
D, [2021-04-29T04:31:32.281059 #20296] DEBUG -- :    (26.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4166443 AND "ci_runners"."id" < 4266443
D, [2021-04-29T04:31:32.356815 #20296] DEBUG -- :    (65.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4266443 AND "ci_runners"."id" < 4366443
D, [2021-04-29T04:31:32.451232 #20296] DEBUG -- :    (83.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4366443 AND "ci_runners"."id" < 4466443
D, [2021-04-29T04:31:32.517410 #20296] DEBUG -- :    (55.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4466443 AND "ci_runners"."id" < 4566443
D, [2021-04-29T04:31:32.643469 #20296] DEBUG -- :    (114.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4566443 AND "ci_runners"."id" < 4666443
D, [2021-04-29T04:31:32.681476 #20296] DEBUG -- :    (27.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4666443 AND "ci_runners"."id" < 4766443
D, [2021-04-29T04:31:32.767990 #20296] DEBUG -- :    (75.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4766443 AND "ci_runners"."id" < 4866443
D, [2021-04-29T04:31:32.828723 #20296] DEBUG -- :    (49.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4866443 AND "ci_runners"."id" < 4966443
D, [2021-04-29T04:31:32.872930 #20296] DEBUG -- :    (33.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 4966443 AND "ci_runners"."id" < 5066443
D, [2021-04-29T04:31:32.960255 #20296] DEBUG -- :    (76.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 5066443 AND "ci_runners"."id" < 5166443
D, [2021-04-29T04:31:32.994916 #20296] DEBUG -- :    (23.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 5166443 AND "ci_runners"."id" < 5266443
D, [2021-04-29T04:31:33.038189 #20296] DEBUG -- :    (32.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 5266443 AND "ci_runners"."id" < 5366443
D, [2021-04-29T04:31:33.079275 #20296] DEBUG -- :    (30.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 2 AND (contacted_at > '2021-04-29 02:31:30.598047') AND "ci_runners"."id" >= 5366443 AND "ci_runners"."id" < 5436840
=> 38393

`count(::Ci::Runner.project_type.online)` queries

irb(main):011:0> count(::Ci::Runner.project_type.online)
D, [2021-04-29T04:31:52.327537 #20296] DEBUG -- :    (1.8ms)  /*application:console*/ SELECT MIN("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144')
D, [2021-04-29T04:31:52.328876 #20296] DEBUG -- :    (0.8ms)  /*application:console*/ SELECT MAX("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144')
D, [2021-04-29T04:31:52.357263 #20296] DEBUG -- :    (27.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4448 AND "ci_runners"."id" < 104448
D, [2021-04-29T04:31:52.380905 #20296] DEBUG -- :    (12.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 104448 AND "ci_runners"."id" < 204448
D, [2021-04-29T04:31:52.403433 #20296] DEBUG -- :    (11.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 204448 AND "ci_runners"."id" < 304448
D, [2021-04-29T04:31:52.432964 #20296] DEBUG -- :    (18.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 304448 AND "ci_runners"."id" < 404448
D, [2021-04-29T04:31:52.464403 #20296] DEBUG -- :    (20.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 404448 AND "ci_runners"."id" < 504448
D, [2021-04-29T04:31:52.495977 #20296] DEBUG -- :    (20.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 504448 AND "ci_runners"."id" < 604448
D, [2021-04-29T04:31:52.524719 #20296] DEBUG -- :    (17.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 604448 AND "ci_runners"."id" < 704448
D, [2021-04-29T04:31:52.557131 #20296] DEBUG -- :    (21.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 704448 AND "ci_runners"."id" < 804448
D, [2021-04-29T04:31:52.592090 #20296] DEBUG -- :    (24.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 804448 AND "ci_runners"."id" < 904448
D, [2021-04-29T04:31:52.627882 #20296] DEBUG -- :    (24.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 904448 AND "ci_runners"."id" < 1004448
D, [2021-04-29T04:31:52.659521 #20296] DEBUG -- :    (20.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1004448 AND "ci_runners"."id" < 1104448
D, [2021-04-29T04:31:52.690149 #20296] DEBUG -- :    (19.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1104448 AND "ci_runners"."id" < 1204448
D, [2021-04-29T04:31:52.727607 #20296] DEBUG -- :    (26.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1204448 AND "ci_runners"."id" < 1304448
D, [2021-04-29T04:31:52.761186 #20296] DEBUG -- :    (22.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1304448 AND "ci_runners"."id" < 1404448
D, [2021-04-29T04:31:52.792924 #20296] DEBUG -- :    (20.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1404448 AND "ci_runners"."id" < 1504448
D, [2021-04-29T04:31:52.833382 #20296] DEBUG -- :    (29.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1504448 AND "ci_runners"."id" < 1604448
D, [2021-04-29T04:31:52.869473 #20296] DEBUG -- :    (25.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1604448 AND "ci_runners"."id" < 1704448
D, [2021-04-29T04:31:52.898047 #20296] DEBUG -- :    (17.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1704448 AND "ci_runners"."id" < 1804448
D, [2021-04-29T04:31:52.933816 #20296] DEBUG -- :    (24.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1804448 AND "ci_runners"."id" < 1904448
D, [2021-04-29T04:31:52.976878 #20296] DEBUG -- :    (32.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 1904448 AND "ci_runners"."id" < 2004448
D, [2021-04-29T04:31:53.030223 #20296] DEBUG -- :    (42.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2004448 AND "ci_runners"."id" < 2104448
D, [2021-04-29T04:31:53.086479 #20296] DEBUG -- :    (45.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2104448 AND "ci_runners"."id" < 2204448
D, [2021-04-29T04:31:53.129008 #20296] DEBUG -- :    (31.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2204448 AND "ci_runners"."id" < 2304448
D, [2021-04-29T04:31:53.163105 #20296] DEBUG -- :    (23.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2304448 AND "ci_runners"."id" < 2404448
D, [2021-04-29T04:31:53.199478 #20296] DEBUG -- :    (25.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2404448 AND "ci_runners"."id" < 2504448
D, [2021-04-29T04:31:53.262476 #20296] DEBUG -- :    (51.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2504448 AND "ci_runners"."id" < 2604448
D, [2021-04-29T04:31:53.329003 #20296] DEBUG -- :    (55.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2604448 AND "ci_runners"."id" < 2704448
D, [2021-04-29T04:31:53.379204 #20296] DEBUG -- :    (39.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2704448 AND "ci_runners"."id" < 2804448
D, [2021-04-29T04:31:53.448035 #20296] DEBUG -- :    (57.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2804448 AND "ci_runners"."id" < 2904448
D, [2021-04-29T04:31:53.515632 #20296] DEBUG -- :    (56.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 2904448 AND "ci_runners"."id" < 3004448
D, [2021-04-29T04:31:53.583064 #20296] DEBUG -- :    (56.4ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3004448 AND "ci_runners"."id" < 3104448
D, [2021-04-29T04:31:53.646813 #20296] DEBUG -- :    (52.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3104448 AND "ci_runners"."id" < 3204448
D, [2021-04-29T04:31:53.726083 #20296] DEBUG -- :    (68.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3204448 AND "ci_runners"."id" < 3304448
D, [2021-04-29T04:31:53.790886 #20296] DEBUG -- :    (53.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3304448 AND "ci_runners"."id" < 3404448
D, [2021-04-29T04:31:53.825676 #20296] DEBUG -- :    (23.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3404448 AND "ci_runners"."id" < 3504448
D, [2021-04-29T04:31:53.855590 #20296] DEBUG -- :    (19.1ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3504448 AND "ci_runners"."id" < 3604448
D, [2021-04-29T04:31:53.889261 #20296] DEBUG -- :    (22.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3604448 AND "ci_runners"."id" < 3704448
D, [2021-04-29T04:31:53.920649 #20296] DEBUG -- :    (20.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3704448 AND "ci_runners"."id" < 3804448
D, [2021-04-29T04:31:53.960706 #20296] DEBUG -- :    (29.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3804448 AND "ci_runners"."id" < 3904448
D, [2021-04-29T04:31:53.995697 #20296] DEBUG -- :    (24.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 3904448 AND "ci_runners"."id" < 4004448
D, [2021-04-29T04:31:54.029353 #20296] DEBUG -- :    (22.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4004448 AND "ci_runners"."id" < 4104448
D, [2021-04-29T04:31:54.085749 #20296] DEBUG -- :    (45.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4104448 AND "ci_runners"."id" < 4204448
D, [2021-04-29T04:31:54.252273 #20296] DEBUG -- :    (155.7ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4204448 AND "ci_runners"."id" < 4304448
D, [2021-04-29T04:31:54.333544 #20296] DEBUG -- :    (70.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4304448 AND "ci_runners"."id" < 4404448
D, [2021-04-29T04:31:54.415511 #20296] DEBUG -- :    (70.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4404448 AND "ci_runners"."id" < 4504448
D, [2021-04-29T04:31:54.491978 #20296] DEBUG -- :    (65.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4504448 AND "ci_runners"."id" < 4604448
D, [2021-04-29T04:31:54.527636 #20296] DEBUG -- :    (24.5ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4604448 AND "ci_runners"."id" < 4704448
D, [2021-04-29T04:31:54.618948 #20296] DEBUG -- :    (80.2ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4704448 AND "ci_runners"."id" < 4804448
D, [2021-04-29T04:31:54.697302 #20296] DEBUG -- :    (67.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4804448 AND "ci_runners"."id" < 4904448
D, [2021-04-29T04:31:54.745164 #20296] DEBUG -- :    (36.8ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 4904448 AND "ci_runners"."id" < 5004448
D, [2021-04-29T04:31:54.796830 #20296] DEBUG -- :    (40.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 5004448 AND "ci_runners"."id" < 5104448
D, [2021-04-29T04:31:54.851895 #20296] DEBUG -- :    (43.6ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 5104448 AND "ci_runners"."id" < 5204448
D, [2021-04-29T04:31:54.885411 #20296] DEBUG -- :    (22.3ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 5204448 AND "ci_runners"."id" < 5304448
D, [2021-04-29T04:31:54.938306 #20296] DEBUG -- :    (41.9ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 5304448 AND "ci_runners"."id" < 5404448
D, [2021-04-29T04:31:54.974472 #20296] DEBUG -- :    (25.0ms)  /*application:console*/ SELECT COUNT("ci_runners"."id") FROM "ci_runners" WHERE "ci_runners"."runner_type" = 3 AND (contacted_at > '2021-04-29 02:31:52.325144') AND "ci_runners"."id" >= 5404448 AND "ci_runners"."id" < 5436710
=> 69258

Relates to #27141 (closed)

Edited May 05, 2021 by Stan Hu

Add CI runner counts to usage ping

count(::Ci::Runner) queries

count(::Ci::Runner.active) queries

count(::Ci::Runner.instance_type.active) queries

count(::Ci::Runner.group_type.active) queries

count(::Ci::Runner.project_type.active) queries

count(::Ci::Runner.online) queries

count(::Ci::Runner.instance_type.online) queries

count(::Ci::Runner.group_type.online) queries

count(::Ci::Runner.project_type.online) queries

Merge request reports

`count(::Ci::Runner)` queries

`count(::Ci::Runner.active)` queries

`count(::Ci::Runner.instance_type.active)` queries

`count(::Ci::Runner.group_type.active)` queries

`count(::Ci::Runner.project_type.active)` queries

`count(::Ci::Runner.online)` queries

`count(::Ci::Runner.instance_type.online)` queries

`count(::Ci::Runner.group_type.online)` queries

`count(::Ci::Runner.project_type.online)` queries