Restart of indexer floods the metastore
Closed this issue · 2 comments
fulmicoton commented
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.
guilload commented
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