Okay, I had a misconception of the buffers option.
As I reread the documentation, I realized how stupid the question was.
I confirm that with the buffers option I now see:
Buffers: shared hit=9617011 read=1328356 dirtied=793 written=397, temp
read=2996659 written=5956399
Thank you both,
Matteo
On Tue, 27 Apr 2021 at 21:15, Matteo Bonardi wrote:
> Explain plan: https://explain.depesz.com/s/BXGT
>
> Usually I'm looking for "external merge Disk" to see temp files usage but, in
> this case, the only reference to that is 299,368kB in the last but one node
> of explain.
> Can anyone help me
On Tue, 2021-04-27 at 11:15 +0200, Matteo Bonardi wrote:
> I have a query that creates a large number of temporary files, in this
> example ~ 45GB.
> Looking at the query plan I can't figure out where temporary files are being
> generated.
>
> Explain plan: https://explain.depesz.com/s/BXGT
>
>
thank you very much you take for your time
We raised the work_mem to 130 mb and there was no more problem!
Now we are seeing to improve the query, it is complicated because it is
generated by a product that we have installed in production!
--
Sent from: https://www.postgresql-archive.org/Postgre
On Mon, Oct 07, 2019 at 01:52:41PM -0700, dangal wrote:
Hello everyone, I have a question to see if you can help me, I have set
work_mem in 100 MB but I have the following in the pgbadger
Queries generating the most temporary files (N)
Count Total size Min size Max sizeAvg size
58
