From: | kg(dot)postgresql(at)olympiakos(dot)com |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Bogus temp file reporting? |
Date: | 2023-07-27 07:30:41 |
Message-ID: | FBC3A2FB-D1BC-4903-8211-E4D6D0700F0A@olympiakos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | gzh | 2023-07-27 08:09:27 | Re: How to improve the performance of my SQL query? |
Previous Message | David Rowley | 2023-07-27 03:36:20 | Re: How to improve the performance of my SQL query? |