How to calculate quantity of WAL in db without archiving?
0
votes
1
answer
706
views
I would like to find out a quantity of WAL files which are being used in PostgreSQL database in last 24h. I was assigned to do Log-shipping but before I do it I want to know how many WAL files are being used in last 24hours in order to predict how much space I need on external storage.
Unfortunately pgmetrics doesn't have such information. Do you know how to do it?
WAL Files:
WAL Archiving? no
WAL Files: 5
+--------------------+--------------+
| Setting | Value |
+--------------------+--------------+
| wal_level | minimal |
| archive_timeout | 0 |
| wal_compression | off |
| max_wal_size | 64 (1.0 GiB) |
| min_wal_size | 5 (80 MiB) |
| checkpoint_timeout | 300 |
| full_page_writes | on |
| wal_keep_segments | 0 |
+--------------------+--------------+
Asked by KUE
(25 rep)
May 29, 2019, 12:22 PM
Last activity: Dec 30, 2024, 12:00 PM
Last activity: Dec 30, 2024, 12:00 PM