From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Bogus temp file reporting? |
Date: | 2023-07-28 17:29:32 |
Message-ID: | 99686954-6faa-4022-6361-df4181a4349e@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
231*TB* seems, to me, an unreasonably large number.
On 7/27/23 02:30, kg(dot)postgresql(at)olympiakos(dot)com wrote:
> Hello,
>
> Is there a known issue with temp file reporting? I have a production db
> that is reporting 231TB of temp space usage, which can’t be true.
> temp_blks_written in pg_stat_statements sort of confirms this, as the
> reported queries show just a few MB of temp space usage. I suspect a
> reboot will clear this (to do) and wanted to check with you to see if
> someone else has had similar experiences.
>
> Regards,
> Kiriakos Georgiou
>
>
> select version();
> version
> -----------------------------------------------------------------------------------------------------------------------------------
> PostgreSQL 14.8 (Ubuntu 14.8-1.pgdg20.04+1) on x86_64-pc-linux-gnu,
> compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
> (1 row)
> select
> datname,
> temp_files as "# of temp files",
> pg_size_pretty(temp_bytes) as "size of temp files"
> from
> pg_stat_database;
>
> datname | # of temp files | size of temp files
> ---------------+-----------------+--------------------
> | 0 | 0 bytes
> postgres | 0 | 0 bytes
> testdb | 269647 | 231 TB
> template0 | 0 | 0 bytes
> template1 | 0 | 0 bytes
--
Born in Arizona, moved to Babylonia.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2023-07-29 02:55:41 | Re: backup_manifest rename to backup_manifest.old after successful postgres start up |
Previous Message | Gert Cuykens | 2023-07-28 16:32:58 | Re: impact pgbench on a physical replicated stream |