aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-03-26 20:21:14 +0000
committerChristopher Baines <mail@cbaines.net>2020-03-26 20:21:14 +0000
commit3017765f0cc3aa10d067b6c410ddc271a8adbfee (patch)
tree77885dbebc204fb416e3d357803039923e0f8ade
parent9a79a5d7473b4b935b509d26941d267621e1d114 (diff)
downloaddata-service-3017765f0cc3aa10d067b6c410ddc271a8adbfee.tar
data-service-3017765f0cc3aa10d067b6c410ddc271a8adbfee.tar.gz
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.
-rwxr-xr-xscripts/guix-data-service-create-small-backup2
1 files changed, 1 insertions, 1 deletions
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