02/03: Use EXPLAIN ANALYZE for the creation of tmp_derivations

[Christopher Baines]

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