Re: Slow Query, many tmpfiles

2020-02-03 Thread Tom Lane
basti writes: > 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 |

Slow Query, many tmpfiles

2020-02-03 Thread basti
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