Re: Bogus temp file reporting? - Mailing list pgsql-general

From Ron
Subject Re: Bogus temp file reporting?
Date
Msg-id 99686954-6faa-4022-6361-df4181a4349e@gmail.com
Whole thread Raw
In response to Bogus temp file reporting?  (kg.postgresql@olympiakos.com)
List pgsql-general
231TB seems, to me, an unreasonably large number.

On 7/27/23 02:30, kg.postgresql@olympiakos.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.

pgsql-general by date:

Previous
From: Gert Cuykens
Date:
Subject: Re: impact pgbench on a physical replicated stream
Next
From: Michael Paquier
Date:
Subject: Re: backup_manifest rename to backup_manifest.old after successful postgres start up