Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Restart of indexer floods the metastore #4909

Open
fulmicoton opened this issue Apr 25, 2024 · 1 comment
Open

Restart of indexer floods the metastore #4909

fulmicoton opened this issue Apr 25, 2024 · 1 comment
Assignees
@guilload
Labels
bug Something isn't working high-priority

Comments

@fulmicoton
Copy link
Contributor

restart of an indexer in presence of many indexes looks like this:

ecs=0.000338
2024-04-25T06:19:09.233Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=335.708µs elapsed_secs=0.000335708
2024-04-25T06:19:09.234Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=328.625µs elapsed_secs=0.000328625
2024-04-25T06:19:09.234Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=341.333µs elapsed_secs=0.000341333
2024-04-25T06:19:09.235Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=326.959µs elapsed_secs=0.000326959
2024-04-25T06:19:09.236Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=316.875µs elapsed_secs=0.000316875
2024-04-25T06:19:09.236Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=296.833µs elapsed_secs=0.000296833
2024-04-25T06:19:09.237Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=288.542µs elapsed_secs=0.000288542
2024-04-25T06:19:09.238Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=318µs elapsed_secs=0.000318
2024-04-25T06:19:09.241Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=276.959µs elapsed_secs=0.000276959
2024-04-25T06:19:09.242Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=332.542µs elapsed_secs=0.000332542
2024-04-25T06:19:09.242Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=309.791µs elapsed_secs=0.000309791
2024-04-25T06:19:09.243Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=321.5µs elapsed_secs=0.0003215
2024-04-25T06:19:09.243Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=366.042µs elapsed_secs=0.000366042
2024-04-25T06:19:09.244Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=365.292µs elapsed_secs=0.000365292
2024-04-25T06:19:09.244Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=347.959µs elapsed_secs=0.000347959
2024-04-25T06:19:09.245Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=292.666µs elapsed_secs=0.000292666
2024-04-25T06:19:09.246Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=325.958µs elapsed_secs=0.000325958
2024-04-25T06:19:09.246Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=330.833µs elapsed_secs=0.000330833
2024-04-25T06:19:09.246Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=320.333µs elapsed_secs=0.000320333
2024-04-25T06:19:09.246Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=329.083µs elapsed_secs=0.000329083
2024-04-25T06:19:09.247Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=287.042µs elapsed_secs=0.000287042
2024-04-25T06:19:09.248Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=282.708µs elapsed_secs=0.000282708
2024-04-25T06:19:09.248Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=284.875µs elapsed_secs=0.000284875
2024-04-25T06:19:09.249Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=298.833µs elapsed_secs=0.000298833
2024-04-25T06:19:09.250Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=269.792µs elapsed_secs=0.000269792
2024-04-25T06:19:09.251Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=284.583µs elapsed_secs=0.000284583
2024-04-25T06:19:09.253Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=270.833µs elapsed_secs=0.000270833
2024-04-25T06:19:09.253Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=263.333µs elapsed_secs=0.000263333
2024-04-25T06:19:09.254Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=257.5µs elapsed_secs=0.0002575
2024-04-25T06:19:09.255Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=283.75µs elapsed_secs=0.00028375
2024-04-25T06:19:09.255Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=282.834µs elapsed_secs=0.000282834
2024-04-25T06:19:09.256Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=309µs elapsed_secs=0.000309
2024-04-25T06:19:09.256Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=294.75µs elapsed_secs=0.00029475
2024-04-25T06:19:09.257Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=291.208µs elapsed_secs=0.000291208
2024-04-25T06:19:09.257Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=269.792µs elapsed_secs=0.000269792
2024-04-25T06:19:09.258Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=280.25µs elapsed_secs=0.00028025
2024-04-25T06:19:09.258Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=283.958µs elapsed_secs=0.000283958
2024-04-25T06:19:09.259Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=299.625µs elapsed_secs=0.000299625
2024-04-25T06:19:09.259Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=316.417µs elapsed_secs=0.000316417
2024-04-25T06:19:09.260Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=268.917µs elapsed_secs=0.000268917
2024-04-25T06:19:09.262Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=273.833µs elapsed_secs=0.000273833
2024-04-25T06:19:09.262Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=295µs elapsed_secs=0.000295
2024-04-25T06:19:09.262Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=280.291µs elapsed_secs=0.000280291
2024-04-25T06:19:09.263Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=371.75µs elapsed_secs=0.00037175
2024-04-25T06:19:09.263Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=299.959µs elapsed_secs=0.000299959
2024-04-25T06:19:09.264Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=254.333µs elapsed_secs=0.000254333
2024-04-25T06:19:09.264Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=257.042µs elapsed_secs=0.000257042
2024-04-25T06:19:09.265Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=248.792µs elapsed_secs=0.000248792
2024-04-25T06:19:09.267Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=267µs elapsed_secs=0.000267
2024-04-25T06:19:09.267Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=270.333µs elapsed_secs=0.000270333
2024-04-25T06:19:09.268Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=304.917µs elapsed_secs=0.000304917
2024-04-25T06:19:09.268Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=312.708µs elapsed_secs=0.000312708
2024-04-25T06:19:09.268Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=325.667µs elapsed_secs=0.000325667
2024-04-25T06:19:09.269Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=275.875µs elapsed_secs=0.000275875
2024-04-25T06:19:09.269Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=285.083µs elapsed_secs=0.000285083
2024-04-25T06:19:09.270Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=266.917µs elapsed_secs=0.000266917
2024-04-25T06:19:09.271Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=273.542µs elapsed_secs=0.000273542
2024-04-25T06:19:09.271Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=269.542µs elapsed_secs=0.000269542
2024-04-25T06:19:09.272Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=270.792µs elapsed_secs=0.000270792
2024-04-25T06:19:09.272Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=294.416µs elapsed_secs=0.000294416
2024-04-25T06:19:09.273Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=240.375µs elapsed_secs=0.000240375
2024-04-25T06:19:09.274Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=317.583µs elapsed_secs=0.000317583
2024-04-25T06:19:09.274Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=273.375µs elapsed_secs=0.000273375
2024-04-25T06:19:09.275Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=291.583µs elapsed_secs=0.000291583
2024-04-25T06:19:09.275Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=283.917µs elapsed_secs=0.000283917
2024-04-25T06:19:09.276Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=284.458µs elapsed_secs=0.000284458
2024-04-25T06:19:09.276Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=259.542µs elapsed_secs=0.000259542
2024-04-25T06:19:09.277Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=276.458µs elapsed_secs=0.000276458
2024-04-25T06:19:09.277Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=281.792µs elapsed_secs=0.000281792
2024-04-25T06:19:09.278Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=256.25µs elapsed_secs=0.00025625
2024-04-25T06:19:09.278Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=248.292µs elapsed_secs=0.000248292
2024-04-25T06:19:09.279Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=250.333µs elapsed_secs=0.000250333
2024-04-25T06:19:09.281Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=273.958µs elapsed_secs=0.000273958
2024-04-25T06:19:09.281Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=271.875µs elapsed_secs=0.000271875
2024-04-25T06:19:09.282Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=274.25µs elapsed_secs=0.00027425
2024-04-25T06:19:09.282Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=262.917µs elapsed_secs=0.000262917
2024-04-25T06:19:09.282Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=273.209µs elapsed_secs=0.000273209
2024-04-25T06:19:09.283Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=286.917µs elapsed_secs=0.000286917
2024-04-25T06:19:09.284Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=242.833µs elapsed_secs=0.000242833
2024-04-25T06:19:09.284Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=272.167µs elapsed_secs=0.000272167
2024-04-25T06:19:09.285Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=245.167µs elapsed_secs=0.000245167
2024-04-25T06:19:09.285Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=302.709µs elapsed_secs=0.000302709
2024-04-25T06:19:09.286Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=333.125µs elapsed_secs=0.000333125
2024-04-25T06:19:09.287Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=297.875µs elapsed_secs=0.000297875
2024-04-25T06:19:09.287Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=293.166µs elapsed_secs=0.000293166
2024-04-25T06:19:09.288Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=306.209µs elapsed_secs=0.000306209
2024-04-25T06:19:09.288Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=296.792µs elapsed_secs=0.000296792
2024-04-25T06:19:09.289Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=328.292µs elapsed_secs=0.000328292
2024-04-25T06:19:09.289Z  INFO sqlx::query: summary="SELECT COALESCE(MAX(opstamp), 0) FROM …" db.statement="\n\nSELECT\n  COALESCE(MAX(opstamp), 0)\nFROM\n  delete_tasks\nWHERE\n  index_uid = $1\n" rows_affected=0 rows_returned=1 elapsed=315.25µs elapsed_secs=0.00031525
2024-04-25T06:19:09.291Z  INFO sqlx::query: summary="SELECT * FROM splits …" db.statement="\n\nSELECT\n  *\nFROM\n  splits\nWHERE\n  index_uid = $1\n  AND delete_opstamp < $2\n  AND split_state = $3\n  AND (\n    maturity_timestamp = to_timestamp(0)\n    OR (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') >= maturity_timestamp\n  )\nORDER BY\n  delete_opstamp ASC,\n  publish_timestamp ASC\nLIMIT\n  $4\n" rows_affected=0 rows_returned=0 elapsed=921.875µs elapsed_secs=0.000921875
2024-04-25T06:19:09.313Z  INFO sqlx::query: summary="SELECT * FROM indexes" db.statement="" rows_affected=102 rows_returned=102 elapsed=1.162166ms elapsed_secs=0.001162166
2024-04-25T06:19:14.081Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.875375ms elapsed_secs=0.003875375
2024-04-25T06:19:14.084Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=6.6855ms elapsed_secs=0.0066855
2024-04-25T06:19:14.084Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=7.242583ms elapsed_secs=0.007242583
2024-04-25T06:19:14.086Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=8.710208ms elapsed_secs=0.008710208
2024-04-25T06:19:14.086Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=9.097208ms elapsed_secs=0.009097208
2024-04-25T06:19:14.086Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=9.166375ms elapsed_secs=0.009166375
2024-04-25T06:19:14.087Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=9.874667ms elapsed_secs=0.009874667
2024-04-25T06:19:14.087Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=10.16925ms elapsed_secs=0.01016925
2024-04-25T06:19:14.087Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=10.0905ms elapsed_secs=0.0100905
2024-04-25T06:19:14.088Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=10.728875ms elapsed_secs=0.010728875
2024-04-25T06:19:14.093Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.643208ms elapsed_secs=0.003643208
2024-04-25T06:19:14.093Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.665167ms elapsed_secs=0.003665167
2024-04-25T06:19:14.093Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.398916ms elapsed_secs=0.003398916
2024-04-25T06:19:14.093Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.584291ms elapsed_secs=0.003584291
2024-04-25T06:19:14.094Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=4.215834ms elapsed_secs=0.004215834
2024-04-25T06:19:14.094Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=4.34875ms elapsed_secs=0.00434875
2024-04-25T06:19:14.094Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.336208ms elapsed_secs=0.002336208
2024-04-25T06:19:14.094Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=4.14725ms elapsed_secs=0.00414725
2024-04-25T06:19:14.094Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=4.346542ms elapsed_secs=0.004346542
2024-04-25T06:19:14.094Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=4.509541ms elapsed_secs=0.004509541
2024-04-25T06:19:14.097Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.831292ms elapsed_secs=0.001831292
2024-04-25T06:19:14.098Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.382833ms elapsed_secs=0.002382833
2024-04-25T06:19:14.098Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.622667ms elapsed_secs=0.002622667
2024-04-25T06:19:14.098Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.817ms elapsed_secs=0.002817
2024-04-25T06:19:14.098Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.080584ms elapsed_secs=0.003080584
2024-04-25T06:19:14.099Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.52175ms elapsed_secs=0.00352175
2024-04-25T06:19:14.099Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.76775ms elapsed_secs=0.00376775
2024-04-25T06:19:14.099Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.866791ms elapsed_secs=0.003866791
2024-04-25T06:19:14.099Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=3.979208ms elapsed_secs=0.003979208
2024-04-25T06:19:14.099Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.95575ms elapsed_secs=0.00295575
2024-04-25T06:19:14.102Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.547ms elapsed_secs=0.001547
2024-04-25T06:19:14.103Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.590541ms elapsed_secs=0.001590541
2024-04-25T06:19:14.103Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.733667ms elapsed_secs=0.001733667
2024-04-25T06:19:14.103Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.99775ms elapsed_secs=0.00199775
2024-04-25T06:19:14.103Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.454917ms elapsed_secs=0.002454917
2024-04-25T06:19:14.103Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.381083ms elapsed_secs=0.002381083
2024-04-25T06:19:14.104Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.072416ms elapsed_secs=0.002072416
2024-04-25T06:19:14.104Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.301208ms elapsed_secs=0.002301208
2024-04-25T06:19:14.104Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.796916ms elapsed_secs=0.002796916
2024-04-25T06:19:14.104Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.818209ms elapsed_secs=0.001818209
2024-04-25T06:19:14.106Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.399791ms elapsed_secs=0.001399791
2024-04-25T06:19:14.107Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.992084ms elapsed_secs=0.001992084
2024-04-25T06:19:14.107Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.556458ms elapsed_secs=0.002556458
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.315667ms elapsed_secs=0.002315667
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.812166ms elapsed_secs=0.002812166
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.548292ms elapsed_secs=0.002548292
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.089334ms elapsed_secs=0.002089334
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.176084ms elapsed_secs=0.002176084
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.485334ms elapsed_secs=0.002485334
2024-04-25T06:19:14.108Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.431666ms elapsed_secs=0.002431666
2024-04-25T06:19:14.110Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.122833ms elapsed_secs=0.001122833
2024-04-25T06:19:14.110Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.349792ms elapsed_secs=0.001349792
2024-04-25T06:19:14.111Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.424458ms elapsed_secs=0.001424458
2024-04-25T06:19:14.111Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.627125ms elapsed_secs=0.001627125
2024-04-25T06:19:14.111Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.794083ms elapsed_secs=0.001794083
2024-04-25T06:19:14.112Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.889625ms elapsed_secs=0.001889625
2024-04-25T06:19:14.112Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.899709ms elapsed_secs=0.001899709
2024-04-25T06:19:14.112Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.263292ms elapsed_secs=0.002263292
2024-04-25T06:19:14.112Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.454125ms elapsed_secs=0.002454125
2024-04-25T06:19:14.112Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.573875ms elapsed_secs=0.002573875
2024-04-25T06:19:14.114Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.454ms elapsed_secs=0.001454
2024-04-25T06:19:14.114Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.848917ms elapsed_secs=0.001848917
2024-04-25T06:19:14.115Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.363458ms elapsed_secs=0.001363458
2024-04-25T06:19:14.115Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.503292ms elapsed_secs=0.001503292
2024-04-25T06:19:14.115Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.804583ms elapsed_secs=0.001804583
2024-04-25T06:19:14.116Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.929583ms elapsed_secs=0.001929583
2024-04-25T06:19:14.116Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.062292ms elapsed_secs=0.002062292
2024-04-25T06:19:14.116Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.456875ms elapsed_secs=0.002456875
2024-04-25T06:19:14.116Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.489209ms elapsed_secs=0.002489209
2024-04-25T06:19:14.116Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.859125ms elapsed_secs=0.001859125
2024-04-25T06:19:14.117Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.206083ms elapsed_secs=0.001206083
2024-04-25T06:19:14.118Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.367375ms elapsed_secs=0.001367375
2024-04-25T06:19:14.118Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.850292ms elapsed_secs=0.001850292
2024-04-25T06:19:14.118Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.430042ms elapsed_secs=0.001430042
2024-04-25T06:19:14.118Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.211083ms elapsed_secs=0.001211083
2024-04-25T06:19:14.119Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.234292ms elapsed_secs=0.001234292
2024-04-25T06:19:14.119Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.716041ms elapsed_secs=0.001716041
2024-04-25T06:19:14.119Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.814833ms elapsed_secs=0.001814833
2024-04-25T06:19:14.119Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.659083ms elapsed_secs=0.001659083
2024-04-25T06:19:14.120Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.559292ms elapsed_secs=0.001559292
2024-04-25T06:19:14.120Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.055541ms elapsed_secs=0.001055541
2024-04-25T06:19:14.121Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=968.791µs elapsed_secs=0.000968791
2024-04-25T06:19:14.121Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.2185ms elapsed_secs=0.0012185
2024-04-25T06:19:14.122Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.839083ms elapsed_secs=0.001839083
2024-04-25T06:19:14.122Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.507125ms elapsed_secs=0.001507125
2024-04-25T06:19:14.122Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=2.094625ms elapsed_secs=0.002094625
2024-04-25T06:19:14.122Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.30075ms elapsed_secs=0.00130075
2024-04-25T06:19:14.122Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.405083ms elapsed_secs=0.001405083
2024-04-25T06:19:14.123Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.655333ms elapsed_secs=0.001655333
2024-04-25T06:19:14.123Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.459666ms elapsed_secs=0.001459666
2024-04-25T06:19:14.124Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.578458ms elapsed_secs=0.001578458
2024-04-25T06:19:14.124Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.105541ms elapsed_secs=0.001105541
2024-04-25T06:19:14.125Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.225541ms elapsed_secs=0.001225541
2024-04-25T06:19:14.125Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.033625ms elapsed_secs=0.001033625
2024-04-25T06:19:14.125Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.138ms elapsed_secs=0.001138
2024-04-25T06:19:14.125Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.241833ms elapsed_secs=0.001241833
2024-04-25T06:19:14.125Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.406208ms elapsed_secs=0.001406208
2024-04-25T06:19:14.125Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.516208ms elapsed_secs=0.001516208
2024-04-25T06:19:14.126Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.521375ms elapsed_secs=0.001521375
2024-04-25T06:19:14.126Z  INFO sqlx::query: summary="SELECT * FROM indexes …" db.statement="\n\nSELECT\n  *\nFROM\n  indexes\nWHERE\n  index_id = $1 FOR\nUPDATE\n" rows_affected=0 rows_returned=1 elapsed=1.120459ms elapsed_secs=0.001120459
2024-04-25T06:19:14.126Z  WARN quickwit_control_plane::indexing_scheduler: failed to apply indexing plan to indexer error=metastore error: too many requests node_id=node-1 generation_id=1714025888952887000

reproduce on a single node with postgresql.
@fulmicoton fulmicoton added the bug Something isn't working label Apr 25, 2024
@guilload guilload self-assigned this Apr 27, 2024
@guilload
Copy link
Member

guilload commented Apr 27, 2024 •
edited

TODO:

  • Fetch source checkpoint lazily
  • Batch index metadata requests in indexing service when spawning indexing pipelines
  • Batch list splits requests in indexing service when spawning merge pipelines
  • Optimize open shards SQL query
  • Batch get or open shard requests in router
  • Batch create index requests in control plane

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@guilload guilload

Labels
bug Something isn't working high-priority
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@fulmicoton @guilload