diff options
author | Christian Grothoff <christian@grothoff.org> | 2021-11-27 14:56:22 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2021-11-27 14:56:28 +0100 |
commit | e46fb309654b82b596a2e5613dcc1c74af4366c0 (patch) | |
tree | 2273546b9cc4f262193ef7cdc831f650d62c77e6 /src/exchangedb/exchange-0001.sql | |
parent | 6ee13445cee3909d23b8ff3162f465835e89a2ce (diff) |
refactor get_ready_deposits query and index to hopefully make query faster
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
-rw-r--r-- | src/exchangedb/exchange-0001.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index 0426dc50a..7ad0676cc 100644 --- a/src/exchangedb/exchange-0001.sql +++ b/src/exchangedb/exchange-0001.sql @@ -418,11 +418,12 @@ COMMENT ON INDEX deposits_coin_pub_merchant_contract_index CREATE INDEX IF NOT EXISTS deposits_get_ready_index ON deposits (shard + ,wire_deadline + ,refund_deadline ,tiny ,done + ,kyc_ok ,extension_blocked - ,wire_deadline - ,refund_deadline ); COMMENT ON INDEX deposits_coin_pub_merchant_contract_index IS 'for deposits_get_ready'; |