Differences

This shows you the differences between two versions of the page.

--- postgresql [2023/10/23 08:40] – created tychocelchu
+++ postgresql [2024/06/28 14:13] (current) – tychocelchu
@@ Line 1: / Line 1: @@
-# Mise à jour du serveur postgresql de la version 11 à la version 16
+# Connaître l'avancement d'un auto-vaccum
+```
+SELECT
+    pid,
+    relid::regclass AS table_name,
+    phase,
+    heap_blks_total,
+    heap_blks_scanned,
+    heap_blks_scanned * 100 / heap_blks_total::float AS percent_complete,
+    index_vacuum_count,
+    max_dead_tuples,
+    num_dead_tuples
+FROM
+    pg_stat_progress_vacuum;
+```
+# Mise à jour du serveur postgresql de la version 11 à la version 16
+## Procédure
 <code>
 apt list --installed | grep postg
@@ Line 12: / Line 28: @@
 </code>
-# Bibliographie
+## Bibliographie
 https://karloluiten.nl/upgrade-postgresql-cluster-from-13-to-15/