[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 31/189: try with explicit analyze as nested does not work
From: |
gnunet |
Subject: |
[taler-grid5k] 31/189: try with explicit analyze as nested does not work |
Date: |
Thu, 28 Apr 2022 10:46:41 +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 579f28f5644e7f0feae19563307150d12d9af523
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sat Feb 26 14:34:51 2022 +0100
try with explicit analyze as nested does not work
---
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 441df3a..bff9f11 100644
--- a/sql/exchange-0001.sql
+++ b/sql/exchange-0001.sql
@@ -882,7 +882,7 @@ THEN
END IF;
-SELECT
+EXPLAIN (ANALYZE, BUFFERS) 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.
-INSERT INTO reserves_out
+EXPLAIN (ANALYZE, BUFFERS) 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.
-UPDATE reserves SET
+EXPLAIN (ANALYZE, BUFFERS) 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).
- INSERT INTO cs_nonce_locks
+ EXPLAIN (ANALYZE, BUFFERS) 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.
- SELECT 1
+ EXPLAIN (ANALYZE, BUFFERS) 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!
-SELECT
+EXPLAIN (ANALYZE, BUFFERS) SELECT
kyc_ok
,wire_source_serial_id
INTO
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 23/189: update persistance script, (continued)
- [taler-grid5k] 23/189: update persistance script, gnunet, 2022/04/28
- [taler-grid5k] 41/189: lower slow query duration, gnunet, 2022/04/28
- [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 <=
- [taler-grid5k] 61/189: fix, gnunet, 2022/04/28
- [taler-grid5k] 32/189: undo explain, gnunet, 2022/04/28
- [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