diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-03-26 20:21:14 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-03-26 20:21:14 +0000 |
| commit | 3017765f0cc3aa10d067b6c410ddc271a8adbfee (patch) | |
| tree | 77885dbebc204fb416e3d357803039923e0f8ade | |
| parent | 9a79a5d7473b4b935b509d26941d267621e1d114 (diff) | |
| download | data-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-x | scripts/guix-data-service-create-small-backup | 2 |
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 |