Jean-Paul Argudo
@jpargudo.bsky.social
PostgreSQL fan and advocate, since 2000. Founding member of PostgreSQLFr, PostgreSQLEu and Dalibo. Started Crunchy Data France in 2022! Opinions are my own here
pg_stat_archiver doc at : www.postgresql.org/docs/current...
27.2. The Cumulative Statistics System
27.2. The Cumulative Statistics System # 27.2.1. Statistics Collection Configuration 27.2.2. Viewing Statistics 27.2.3. pg_stat_activity 27.2.4. pg_stat_replication 27.2.5. pg_stat_replication_sl...
www.postgresql.org
February 12, 2025 at 7:28 AM
pg_stat_archiver doc at : www.postgresql.org/docs/current...
-[ RECORD 1 ]--
wals_done | 10
wals_ready | 0
-[ RECORD 1 ]--+-
archived_count | 641
last_archived_wal | 00000001000000020000007C
last_archived_time | 2025-02-12 07:19:41.553684+00
failed_count | 0
last_failed_wal |
last_failed_time |
stats_reset | 2025-02-10 11:03:18.025733+00
wals_done | 10
wals_ready | 0
-[ RECORD 1 ]--+-
archived_count | 641
last_archived_wal | 00000001000000020000007C
last_archived_time | 2025-02-12 07:19:41.553684+00
failed_count | 0
last_failed_wal |
last_failed_time |
stats_reset | 2025-02-10 11:03:18.025733+00
February 12, 2025 at 7:28 AM
-[ RECORD 1 ]--
wals_done | 10
wals_ready | 0
-[ RECORD 1 ]--+-
archived_count | 641
last_archived_wal | 00000001000000020000007C
last_archived_time | 2025-02-12 07:19:41.553684+00
failed_count | 0
last_failed_wal |
last_failed_time |
stats_reset | 2025-02-10 11:03:18.025733+00
wals_done | 10
wals_ready | 0
-[ RECORD 1 ]--+-
archived_count | 641
last_archived_wal | 00000001000000020000007C
last_archived_time | 2025-02-12 07:19:41.553684+00
failed_count | 0
last_failed_wal |
last_failed_time |
stats_reset | 2025-02-10 11:03:18.025733+00
2/ watch the psql exec of that query
watch -n 1 psql -x -f /tmp/query.sql
(3/..)
watch -n 1 psql -x -f /tmp/query.sql
(3/..)
February 12, 2025 at 7:28 AM
2/ watch the psql exec of that query
watch -n 1 psql -x -f /tmp/query.sql
(3/..)
watch -n 1 psql -x -f /tmp/query.sql
(3/..)
1/ create a /tmp/query.sql with
select count(*) filter (where pg_ls_dir~'done') as wals_done, count(*) filter (where pg_ls_dir~'ready') as wals_ready from pg_ls_dir('pg_wal/archive_status');
select * from pg_stat_archiver;
(2/..)
select count(*) filter (where pg_ls_dir~'done') as wals_done, count(*) filter (where pg_ls_dir~'ready') as wals_ready from pg_ls_dir('pg_wal/archive_status');
select * from pg_stat_archiver;
(2/..)
February 12, 2025 at 7:28 AM
1/ create a /tmp/query.sql with
select count(*) filter (where pg_ls_dir~'done') as wals_done, count(*) filter (where pg_ls_dir~'ready') as wals_ready from pg_ls_dir('pg_wal/archive_status');
select * from pg_stat_archiver;
(2/..)
select count(*) filter (where pg_ls_dir~'done') as wals_done, count(*) filter (where pg_ls_dir~'ready') as wals_ready from pg_ls_dir('pg_wal/archive_status');
select * from pg_stat_archiver;
(2/..)
Marcin Juszkiewicz is maintaining that page too, updated every 2h and with a search box ! Thanks to him!
gpages.juszkiewicz.com.pl/fosdem-videos/
gpages.juszkiewicz.com.pl/fosdem-videos/
FOSDEM 2025 schedule with links to slides and videos
Alternative view for FOSDEM schedule. With direct links to slides and video files (where available).
gpages.juszkiewicz.com.pl
February 3, 2025 at 2:19 PM
Marcin Juszkiewicz is maintaining that page too, updated every 2h and with a search box ! Thanks to him!
gpages.juszkiewicz.com.pl/fosdem-videos/
gpages.juszkiewicz.com.pl/fosdem-videos/
Je suis toujours étonné de voir combien de fois ça m'arrive encore... et encore. Et pourtant, c'est pas comme si ça faisait 30 ans que j'envoyais des mails :-(
January 13, 2025 at 1:05 PM
Je suis toujours étonné de voir combien de fois ça m'arrive encore... et encore. Et pourtant, c'est pas comme si ça faisait 30 ans que j'envoyais des mails :-(