pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Bogus temp file reporting?
Date: Fri, 28 Jul 2023 12:29:32 -0500
Message-ID: <99686954-6faa-4022-6361-df4181a4349e@gmail.com> (raw)
In-Reply-To: <FBC3A2FB-D1BC-4903-8211-E4D6D0700F0A@olympiakos.com>
References: <FBC3A2FB-D1BC-4903-8211-E4D6D0700F0A@olympiakos.com>

231*TB* 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.

view thread (4+ messages)

Message-ID: <99686954-6faa-4022-6361-df4181a4349e@gmail.com>
Permalink:  ../99686954-6faa-4022-6361-df4181a4349e@gmail.com/
Also on:    postgresql.org/message-id/99686954-6faa-4022-6361-df4181a4349e@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: Bogus temp file reporting?
  In-Reply-To: <99686954-6faa-4022-6361-df4181a4349e@gmail.com>
  References: <FBC3A2FB-D1BC-4903-8211-E4D6D0700F0A@olympiakos.com> <99686954-6faa-4022-6361-df4181a4349e@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox