01/02: doc: Add Cuirass backlog analysis tips.

[Ludovic Courtès]

civodul pushed a commit to branch master
in repository maintenance.

commit 77c478e5bde0272d9e2cddceac9b70b5e36a0300
Author: Ludovic Courtès <ludo@gnu.org>
AuthorDate: Sun Dec 1 11:54:02 2024 +0100

    doc: Add Cuirass backlog analysis tips.
    
    * doc/cuirass.org (Analyzing the build backlog): New section.
---
 doc/cuirass.org | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

diff --git a/doc/cuirass.org b/doc/cuirass.org
index 3571e9b7..e536c744 100644
--- a/doc/cuirass.org
+++ b/doc/cuirass.org
@@ -146,3 +146,22 @@ evaluations before 1731776:
    as old
    where builds.id = old.id;
 #+end_src
+
+** Analyzing the build backlog
+
+The command below displays pending aarch64-linux builds scheduled more
+than 3 months ago:
+
+#+begin_src sql
+  select id, nix_name, evaluation
+  from builds where status < -1 and system  = 'aarch64-linux'
+   and timestamp < (extract (epoch from now())::int - 7776000);
+#+end_src
+
+The following one cancels them:
+
+#+begin_src sql
+  update builds set status = 4
+  where status < -1 and system  = 'aarch64-linux'
+    and timestamp < (extract (epoch from now())::int - 7776000);
+#+end_src