[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.
- [taler-grid5k] 33/189: try adding index, (continued)
- [taler-grid5k] 33/189: try adding index, gnunet, 2022/04/28
- [taler-grid5k] 34/189: typo, gnunet, 2022/04/28
- [taler-grid5k] 60/189: change cache dir, gnunet, 2022/04/28
- [taler-grid5k] 56/189: try to fix wallet build, gnunet, 2022/04/28
- [taler-grid5k] 71/189: further improve performance of log analysis, gnunet, 2022/04/28
- [taler-grid5k] 01/189: add sharding/partitioning, gnunet, 2022/04/28
- [taler-grid5k] 02/189: fixes, gnunet, 2022/04/28
- [taler-grid5k] 13/189: fix comments, gnunet, 2022/04/28
- [taler-grid5k] 31/189: try with explicit analyze as nested does not work, gnunet, 2022/04/28
- [taler-grid5k] 61/189: fix, gnunet, 2022/04/28
- [taler-grid5k] 32/189: undo explain,
gnunet <=
- [taler-grid5k] 45/189: ramdom 0-20 deposit, dont log uri params in nginx, disable seqscan, gnunet, 2022/04/28
- [taler-grid5k] 35/189: add index on known_coins to try to fix recoup_by_reserve, gnunet, 2022/04/28
- [taler-grid5k] 49/189: keepalive in nginx, gnunet, 2022/04/28
- [taler-grid5k] 46/189: add request size to nginx, gnunet, 2022/04/28
- [taler-grid5k] 12/189: don't shard wire_out, gnunet, 2022/04/28
- [taler-grid5k] 17/189: still not working with aggregator, gnunet, 2022/04/28
- [taler-grid5k] 22/189: add automatic backup script, gnunet, 2022/04/28
- [taler-grid5k] 48/189: fix, gnunet, 2022/04/28
- [taler-grid5k] 52/189: update merchant conf, gnunet, 2022/04/28
- [taler-grid5k] 58/189: try --unsafe-perm, gnunet, 2022/04/28