{"action":"created","issue":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/194","repository_url":"https://api.github.com/repos/pgbackrest/pgbackrest","labels_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/194/labels{/name}","comments_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/194/comments","events_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/194/events","html_url":"https://github.com/pgbackrest/pgbackrest/issues/194","id":155750108,"number":194,"title":"Incorrect size in pgbackrest info for backup size ? ","user":{"login":"blogh","id":16720048,"avatar_url":"https://avatars.githubusercontent.com/u/16720048?v=3","gravatar_id":"","url":"https://api.github.com/users/blogh","html_url":"https://github.com/blogh","followers_url":"https://api.github.com/users/blogh/followers","following_url":"https://api.github.com/users/blogh/following{/other_user}","gists_url":"https://api.github.com/users/blogh/gists{/gist_id}","starred_url":"https://api.github.com/users/blogh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blogh/subscriptions","organizations_url":"https://api.github.com/users/blogh/orgs","repos_url":"https://api.github.com/users/blogh/repos","events_url":"https://api.github.com/users/blogh/events{/privacy}","received_events_url":"https://api.github.com/users/blogh/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"dwsteele","id":5814217,"avatar_url":"https://avatars.githubusercontent.com/u/5814217?v=3","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2016-05-19T14:26:14Z","updated_at":"2016-05-19T14:39:01Z","closed_at":null,"body":"Hi thanks for the great software.\r\n\r\nI noticed something strange with this backup size. shouldn't it be 9.2M ?\r\n\r\n```\r\npostgres@x64lmwbio9e:/$ du -ch /data01/postgres/bast01 |grep total\r\n337M    total\r\npostgres@x64lmwbio9e:/$ du -ch /backup01/postgres/bast01/pgbackrest/backup/bast01 |grep total\r\n9.2M    total\r\n\r\npostgres@x64lmwbio9e:~$ pgbackrest info --stanza bast01\r\nstanza: bast01\r\n    status: ok\r\n\r\n    full backup: 20160519-140630F\r\n        start / stop timestamp: 2016-05-19 14:05:53 / 2016-05-19 14:06:30\r\n        database size: 336.3MB, backup size: 336.3MB\r\n        repository size: 4.3MB, repository backup size: 4.3MB\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/comments/220344524","html_url":"https://github.com/pgbackrest/pgbackrest/issues/194#issuecomment-220344524","issue_url":"https://api.github.com/repos/pgbackrest/pgbackrest/issues/194","id":220344524,"user":{"login":"dwsteele","id":5814217,"avatar_url":"https://avatars.githubusercontent.com/u/5814217?v=3","gravatar_id":"","url":"https://api.github.com/users/dwsteele","html_url":"https://github.com/dwsteele","followers_url":"https://api.github.com/users/dwsteele/followers","following_url":"https://api.github.com/users/dwsteele/following{/other_user}","gists_url":"https://api.github.com/users/dwsteele/gists{/gist_id}","starred_url":"https://api.github.com/users/dwsteele/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwsteele/subscriptions","organizations_url":"https://api.github.com/users/dwsteele/orgs","repos_url":"https://api.github.com/users/dwsteele/repos","events_url":"https://api.github.com/users/dwsteele/events{/privacy}","received_events_url":"https://api.github.com/users/dwsteele/received_events","type":"User","site_admin":false},"created_at":"2016-05-19T14:39:01Z","updated_at":"2016-05-19T14:39:01Z","body":"The repo size includes only the files that make up the database backup.  There are also files in the repo, info, history, manifests, etc.  Also, only the file size is counted, but extra space may be used do to block size, etc.  In larger databases this is negligible but in smaller databases it can be disproportionate.\r\n\r\nTo get a better idea of how much space the actual files are using, try:\r\n```\r\ndu -sh --exclude=backup.manifest /backup01/postgres/bast01/pgbackrest/backup/bast01/latest/\r\n```\r\nI'd be interested to see what that returns."}}