gnunet-svn
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[taler-grid5k] 32/189: undo explain


From: gnunet
Subject: [taler-grid5k] 32/189: undo explain
Date: Thu, 28 Apr 2022 10:46:42 +0200

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit 621cd58e758b7e3f7f61dcbd7e19003388bddf3e
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sat Feb 26 15:03:00 2022 +0100

    undo explain
---
 sql/exchange-0001.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/sql/exchange-0001.sql b/sql/exchange-0001.sql
index bff9f11..441df3a 100644
--- a/sql/exchange-0001.sql
+++ b/sql/exchange-0001.sql
@@ -882,7 +882,7 @@ THEN
 END IF;
 
 
-EXPLAIN (ANALYZE, BUFFERS) SELECT
+SELECT
    current_balance_val
   ,current_balance_frac
   ,gc_date
@@ -908,7 +908,7 @@ END IF;
 
 -- We optimistically insert, and then on conflict declare
 -- the query successful due to idempotency.
-EXPLAIN (ANALYZE, BUFFERS) INSERT INTO reserves_out
+INSERT INTO reserves_out
   (h_blind_ev
   ,denominations_serial
   ,denom_sig
@@ -967,7 +967,7 @@ END IF;
 min_reserve_gc=GREATEST(min_reserve_gc,reserve_gc);
 
 -- Update reserve balance.
-EXPLAIN (ANALYZE, BUFFERS) UPDATE reserves SET
+UPDATE reserves SET
   gc_date=min_reserve_gc
  ,current_balance_val=reserve_val
  ,current_balance_frac=reserve_frac
@@ -984,7 +984,7 @@ IF NOT NULL cs_nonce
 THEN
   -- Cache CS signature to prevent replays in the future
   -- (and check if cached signature exists at the same time).
-  EXPLAIN (ANALYZE, BUFFERS) INSERT INTO cs_nonce_locks
+  INSERT INTO cs_nonce_locks
     (nonce
     ,max_denomination_serial
     ,op_hash)
@@ -997,7 +997,7 @@ THEN
   IF NOT FOUND
   THEN
     -- See if the existing entry is identical.
-    EXPLAIN (ANALYZE, BUFFERS) SELECT 1
+    SELECT 1
       FROM cs_nonce_locks
      WHERE nonce=cs_nonce
        AND op_hash=h_coin_envelope;
@@ -1017,7 +1017,7 @@ END IF;
 
 -- Obtain KYC status based on the last wire transfer into
 -- this reserve. FIXME: likely not adequate for reserves that got P2P 
transfers!
-EXPLAIN (ANALYZE, BUFFERS) SELECT
+SELECT
    kyc_ok
   ,wire_source_serial_id
   INTO

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]