Page MenuHomePhabricator
Paste P17089

Quarry query runs per day (2021-01-01 through 2021-08-26)
ActivePublic
Actions

Authored by bd808 on Aug 26 2021, 9:17 PM.
MariaDB [quarry]> select date_format(timestamp, '%Y-%m-%d'), count(*) from query_run where timestamp >= '2021-01-01' group by YEAR(timestamp), month(timestamp), dayofmonth(timestamp) order by timestamp desc;
+------------------------------------+----------+
| date_format(timestamp, '%Y-%m-%d') | count(*) |
+------------------------------------+----------+
| 2021-08-26 | 224 |
| 2021-08-25 | 121 |
| 2021-08-24 | 235 |
| 2021-08-23 | 248 |
| 2021-08-22 | 196 |
| 2021-08-21 | 136 |
| 2021-08-20 | 212 |
| 2021-08-19 | 223 |
| 2021-08-18 | 210 |
| 2021-08-17 | 260 |
| 2021-08-16 | 281 |
| 2021-08-15 | 196 |
| 2021-08-14 | 181 |
| 2021-08-13 | 180 |
| 2021-08-12 | 362 |
| 2021-08-11 | 214 |
| 2021-08-10 | 135 |
| 2021-08-09 | 226 |
| 2021-08-08 | 163 |
| 2021-08-07 | 156 |
| 2021-08-06 | 126 |
| 2021-08-05 | 274 |
| 2021-08-04 | 301 |
| 2021-08-03 | 290 |
| 2021-08-02 | 153 |
| 2021-08-01 | 283 |
| 2021-07-31 | 162 |
| 2021-07-30 | 220 |
| 2021-07-29 | 356 |
| 2021-07-28 | 205 |
| 2021-07-27 | 355 |
| 2021-07-26 | 304 |
| 2021-07-25 | 266 |
| 2021-07-24 | 224 |
| 2021-07-23 | 285 |
| 2021-07-22 | 167 |
| 2021-07-21 | 188 |
| 2021-07-20 | 219 |
| 2021-07-19 | 290 |
| 2021-07-18 | 240 |
| 2021-07-17 | 225 |
| 2021-07-16 | 269 |
| 2021-07-15 | 222 |
| 2021-07-14 | 155 |
| 2021-07-13 | 286 |
| 2021-07-12 | 214 |
| 2021-07-11 | 285 |
| 2021-07-10 | 469 |
| 2021-07-09 | 173 |
| 2021-07-08 | 394 |
| 2021-07-07 | 335 |
| 2021-07-06 | 278 |
| 2021-07-05 | 381 |
| 2021-07-04 | 263 |
| 2021-07-03 | 210 |
| 2021-07-02 | 113 |
| 2021-07-01 | 144 |
| 2021-06-30 | 252 |
| 2021-06-29 | 246 |
| 2021-06-28 | 175 |
| 2021-06-27 | 233 |
| 2021-06-26 | 206 |
| 2021-06-25 | 205 |
| 2021-06-24 | 291 |
| 2021-06-23 | 244 |
| 2021-06-22 | 216 |
| 2021-06-21 | 153 |
| 2021-06-20 | 208 |
| 2021-06-19 | 302 |
| 2021-06-18 | 220 |
| 2021-06-17 | 203 |
| 2021-06-16 | 243 |
| 2021-06-15 | 361 |
| 2021-06-14 | 227 |
| 2021-06-13 | 146 |
| 2021-06-12 | 315 |
| 2021-06-11 | 329 |
| 2021-06-10 | 256 |
| 2021-06-09 | 252 |
| 2021-06-08 | 276 |
| 2021-06-07 | 285 |
| 2021-06-06 | 336 |
| 2021-06-05 | 354 |
| 2021-06-04 | 285 |
| 2021-06-03 | 417 |
| 2021-06-02 | 273 |
| 2021-06-01 | 435 |
| 2021-05-31 | 260 |
| 2021-05-30 | 215 |
| 2021-05-29 | 214 |
| 2021-05-28 | 202 |
| 2021-05-27 | 181 |
| 2021-05-26 | 202 |
| 2021-05-25 | 174 |
| 2021-05-24 | 227 |
| 2021-05-23 | 198 |
| 2021-05-22 | 175 |
| 2021-05-21 | 160 |
| 2021-05-20 | 164 |
| 2021-05-19 | 259 |
| 2021-05-18 | 227 |
| 2021-05-17 | 221 |
| 2021-05-16 | 198 |
| 2021-05-15 | 221 |
| 2021-05-14 | 183 |
| 2021-05-13 | 243 |
| 2021-05-12 | 306 |
| 2021-05-11 | 237 |
| 2021-05-10 | 351 |
| 2021-05-09 | 321 |
| 2021-05-08 | 363 |
| 2021-05-07 | 365 |
| 2021-05-06 | 330 |
| 2021-05-05 | 296 |
| 2021-05-04 | 650 |
| 2021-05-03 | 201 |
| 2021-05-02 | 200 |
| 2021-05-01 | 205 |
| 2021-04-30 | 361 |
| 2021-04-29 | 328 |
| 2021-04-28 | 399 |
| 2021-04-27 | 216 |
| 2021-04-26 | 216 |
| 2021-04-25 | 253 |
| 2021-04-24 | 111 |
| 2021-04-23 | 137 |
| 2021-04-22 | 138 |
| 2021-04-21 | 189 |
| 2021-04-20 | 171 |
| 2021-04-19 | 244 |
| 2021-04-18 | 185 |
| 2021-04-17 | 128 |
| 2021-04-16 | 228 |
| 2021-04-15 | 185 |
| 2021-04-14 | 161 |
| 2021-04-13 | 105 |
| 2021-04-12 | 240 |
| 2021-04-11 | 188 |
| 2021-04-10 | 212 |
| 2021-04-09 | 162 |
| 2021-04-08 | 230 |
| 2021-04-07 | 304 |
| 2021-04-06 | 252 |
| 2021-04-05 | 188 |
| 2021-04-04 | 259 |
| 2021-04-03 | 286 |
| 2021-04-02 | 275 |
| 2021-04-01 | 340 |
| 2021-03-31 | 262 |
| 2021-03-30 | 290 |
| 2021-03-29 | 184 |
| 2021-03-28 | 178 |
| 2021-03-27 | 157 |
| 2021-03-26 | 151 |
| 2021-03-25 | 359 |
| 2021-03-24 | 320 |
| 2021-03-23 | 221 |
| 2021-03-22 | 427 |
| 2021-03-21 | 123 |
| 2021-03-20 | 416 |
| 2021-03-19 | 227 |
| 2021-03-18 | 105 |
| 2021-03-17 | 181 |
| 2021-03-16 | 204 |
| 2021-03-15 | 397 |
| 2021-03-14 | 297 |
| 2021-03-13 | 180 |
| 2021-03-12 | 253 |
| 2021-03-11 | 200 |
| 2021-03-10 | 243 |
| 2021-03-09 | 262 |
| 2021-03-08 | 400 |
| 2021-03-07 | 482 |
| 2021-03-06 | 337 |
| 2021-03-05 | 180 |
| 2021-03-04 | 111 |
| 2021-03-03 | 170 |
| 2021-03-02 | 153 |
| 2021-03-01 | 168 |
| 2021-02-28 | 245 |
| 2021-02-27 | 289 |
| 2021-02-26 | 467 |
| 2021-02-25 | 312 |
| 2021-02-24 | 193 |
| 2021-02-23 | 401 |
| 2021-02-22 | 464 |
| 2021-02-21 | 566 |
| 2021-02-20 | 339 |
| 2021-02-19 | 297 |
| 2021-02-18 | 475 |
| 2021-02-17 | 244 |
| 2021-02-16 | 156 |
| 2021-02-15 | 93 |
| 2021-02-14 | 293 |
| 2021-02-13 | 208 |
| 2021-02-12 | 217 |
| 2021-02-11 | 187 |
| 2021-02-10 | 277 |
| 2021-02-09 | 120 |
| 2021-02-08 | 211 |
| 2021-02-07 | 130 |
| 2021-02-06 | 118 |
| 2021-02-05 | 162 |
| 2021-02-04 | 91 |
| 2021-02-03 | 217 |
| 2021-02-02 | 420 |
| 2021-02-01 | 234 |
| 2021-01-31 | 140 |
| 2021-01-30 | 193 |
| 2021-01-29 | 253 |
| 2021-01-28 | 203 |
| 2021-01-27 | 264 |
| 2021-01-26 | 235 |
| 2021-01-25 | 299 |
| 2021-01-24 | 425 |
| 2021-01-23 | 453 |
| 2021-01-22 | 455 |
| 2021-01-21 | 226 |
| 2021-01-20 | 193 |
| 2021-01-19 | 414 |
| 2021-01-18 | 372 |
| 2021-01-17 | 270 |
| 2021-01-16 | 467 |
| 2021-01-15 | 385 |
| 2021-01-14 | 420 |
| 2021-01-13 | 221 |
| 2021-01-12 | 250 |
| 2021-01-11 | 146 |
| 2021-01-10 | 155 |
| 2021-01-09 | 183 |
| 2021-01-08 | 218 |
| 2021-01-07 | 188 |
| 2021-01-06 | 244 |
| 2021-01-05 | 198 |
| 2021-01-04 | 166 |
| 2021-01-03 | 319 |
| 2021-01-02 | 255 |
| 2021-01-01 | 253 |
+------------------------------------+----------+
238 rows in set (0.40 sec)

Event Timeline

bd808 created this paste.Aug 26 2021, 9:17 PM
bd808 added a project: Quarry.
bd808 added a comment.Aug 26 2021, 9:21 PM
MariaDB [quarry]> select date_format(timestamp, '%Y-%m'), count(*) from query_run group by YEAR(timestamp), month(timestamp) order by timestamp desc;
+---------------------------------+----------+
| date_format(timestamp, '%Y-%m') | count(*) |
+---------------------------------+----------+
| 2021-08                         |     5586 |
| 2021-07                         |     7897 |
| 2021-06                         |     7944 |
| 2021-05                         |     7749 |
| 2021-04                         |     6691 |
| 2021-03                         |     7638 |
| 2021-02                         |     7426 |
| 2021-01                         |     8463 |
| 2020-12                         |     5385 |
| 2020-11                         |     6378 |
| 2020-10                         |     7555 |
| 2020-09                         |     5717 |
| 2020-08                         |     6129 |
| 2020-07                         |     7596 |
| 2020-06                         |     8584 |
| 2020-05                         |     7178 |
| 2020-04                         |    17728 |
| 2020-03                         |     8288 |
| 2020-02                         |     8073 |
| 2020-01                         |     7890 |
| 2019-12                         |     4680 |
| 2019-11                         |     5949 |
| 2019-10                         |     6573 |
| 2019-09                         |     5766 |
| 2019-08                         |     5602 |
| 2019-07                         |     6138 |
| 2019-06                         |     8696 |
| 2019-05                         |     9998 |
| 2019-04                         |    11084 |
| 2019-03                         |    13917 |
| 2019-02                         |    15018 |
| 2019-01                         |    11039 |
| 2018-12                         |     8044 |
| 2018-11                         |     7832 |
| 2018-10                         |     7568 |
| 2018-09                         |     6682 |
| 2018-08                         |     7568 |
| 2018-07                         |     7877 |
| 2018-06                         |     7102 |
| 2018-05                         |     5946 |
| 2018-04                         |     9781 |
| 2018-03                         |     8879 |
| 2018-02                         |     7769 |
| 2018-01                         |     7067 |
| 2017-12                         |     6217 |
| 2017-11                         |     5987 |
| 2017-10                         |     6933 |
| 2017-09                         |     6188 |
| 2017-08                         |     6238 |
| 2017-07                         |     5804 |
| 2017-06                         |     7505 |
| 2017-05                         |     8349 |
| 2017-04                         |     6256 |
| 2017-03                         |     7977 |
| 2017-02                         |    10187 |
| 2017-01                         |     7916 |
| 2016-12                         |     9299 |
| 2016-11                         |     8042 |
| 2016-10                         |     6018 |
| 2016-09                         |     6022 |
| 2016-08                         |     6253 |
| 2016-07                         |     7153 |
| 2016-06                         |     5747 |
| 2016-05                         |     8049 |
| 2016-04                         |     6747 |
| 2016-03                         |     9087 |
| 2016-02                         |     6890 |
| 2016-01                         |     5481 |
| 2015-12                         |     4236 |
| 2015-11                         |     4510 |
| 2015-10                         |     5209 |
| 2015-09                         |     4165 |
| 2015-08                         |     5744 |
| 2015-07                         |     3862 |
| 2015-06                         |     3261 |
| 2015-05                         |     3722 |
| 2015-04                         |     4324 |
| 2015-03                         |     4591 |
| 2015-02                         |     3865 |
| 2015-01                         |     2756 |
| 2014-12                         |     1156 |
| 2014-11                         |      968 |
| 2014-10                         |     1159 |
| 2014-09                         |      691 |
| 2014-08                         |     1079 |
+---------------------------------+----------+
85 rows in set (0.63 sec)
bd808 added a comment.Aug 26 2021, 9:22 PM
MariaDB [quarry]> select date_format(timestamp, '%Y'), count(*) from query_run group by YEAR(timestamp) order by timestamp desc;
+------------------------------+----------+
| date_format(timestamp, '%Y') | count(*) |
+------------------------------+----------+
| 2021                         |    59394 |
| 2020                         |    96501 |
| 2019                         |   104460 |
| 2018                         |    92115 |
| 2017                         |    85557 |
| 2016                         |    84788 |
| 2015                         |    50245 |
| 2014                         |     5053 |
+------------------------------+----------+
8 rows in set (0.38 sec)
Andrew mentioned this in T289503: Write a blog post about our plans for Quarry.Aug 26 2021, 9:40 PM
• Jhernandez subscribed.Aug 30 2021, 5:45 PM

I've made a chart for the blog post based on some of this data https://commons.wikimedia.org/wiki/File:Quarry_queries_run_per_month_2014-08_to_2021-08.svg

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits