Slow Query, many tmpfiles

From: basti <mailinglist(at)unix-solution(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Slow Query, many tmpfiles
Date: 2020-02-03 13:09:21
Message-ID: f5317b9b-8421-7c39-8a3e-d9371a05f326@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, some simple query are very slow since a few days, no significant
changes are done the last days. I look for disk-io, swap, looked tables,
all seems to be good.

What I have found is this:

postgres=# SELECT temp_files AS "Temporary files"
, temp_bytes AS "Size of temporary files"
FROM pg_stat_database db;
Temporary files | Size of temporary files
-----------------+-------------------------
0 | 0
0 | 0
0 | 0
0 | 0
13542 | 5313912899891
(5 rows)

postgres(at)dolly:~/9.6/main/base/pgsql_tmp$ ls -la
total 20
drwx------ 2 postgres postgres 16384 Feb 3 02:25 .
drwx------ 8 postgres postgres 4096 Jul 26 2017 ..

Where does the 13542 tmp files are come from?
How can I delete that?
Where are they stored?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Lembark 2020-02-03 16:01:04 Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI
Previous Message Andrei Zhidenkov 2020-02-03 08:29:58 Re: How to avoid UPDATE on same data in table ?