[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
02/03: Use EXPLAIN ANALYZE for the creation of tmp_derivations
From: |
Christopher Baines |
Subject: |
02/03: Use EXPLAIN ANALYZE for the creation of tmp_derivations |
Date: |
Thu, 26 Mar 2020 16:22:27 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 3017765f0cc3aa10d067b6c410ddc271a8adbfee
Author: Christopher Baines <address@hidden>
AuthorDate: Thu Mar 26 20:21:14 2020 +0000
Use EXPLAIN ANALYZE for the creation of tmp_derivations
In the create-small-backup script, as this is quite a slow part, it's useful
to get more information.
---
scripts/guix-data-service-create-small-backup | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/scripts/guix-data-service-create-small-backup
b/scripts/guix-data-service-create-small-backup
index 10fae8c..e35841f 100755
--- a/scripts/guix-data-service-create-small-backup
+++ b/scripts/guix-data-service-create-small-backup
@@ -89,7 +89,7 @@ SELECT * FROM package_derivations WHERE id IN (
SELECT package_derivation_id FROM tmp_guix_revision_package_derivations
);
-CREATE UNLOGGED TABLE tmp_derivations AS
+EXPLAIN ANALYZE CREATE UNLOGGED TABLE tmp_derivations AS
WITH RECURSIVE derivation_ids(id) AS (
(
SELECT tmp_package_derivations.derivation_id FROM
tmp_package_derivations