From e46fb309654b82b596a2e5613dcc1c74af4366c0 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 27 Nov 2021 14:56:22 +0100
Subject: refactor get_ready_deposits query and index to hopefully make query
 faster

---
 src/exchangedb/exchange-0001.sql            | 5 +++--
 src/exchangedb/plugin_exchangedb_postgres.c | 4 ++--
 2 files changed, 5 insertions(+), 4 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';
diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c
index 2c863a323..3591470e7 100644
--- a/src/exchangedb/plugin_exchangedb_postgres.c
+++ b/src/exchangedb/plugin_exchangedb_postgres.c
@@ -1105,11 +1105,11 @@ prepare_statements (struct PostgresClosure *pg)
       " WHERE "
       "       shard >= $2"
       "   AND shard <= $3"
+      "   AND wire_deadline<=$1"
+      "   AND refund_deadline<$1"
       "   AND tiny=FALSE"
       "   AND done=FALSE"
       "   AND (kyc_ok OR $4)"
-      "   AND wire_deadline<=$1"
-      "   AND refund_deadline<$1"
       " ORDER BY "
       "   shard ASC"
       "  ,wire_deadline ASC"
-- 
cgit v1.2.3