Would turning on logging of temp files help? That often reports the query
that is using the temp files:
log_temp_files = 0
It probably wouldn't help if the cursor query never pulls from a temp file,
but if it does ...
On Fri, May 19, 2017 at 7:04 PM, Jeff Janes wrote:
> I'm spoiled by using pg
I'm spoiled by using pg_stat_statements to find the hotspot queries which
could use some attention.
But with some recent work, all of the hotspots are of the form "FETCH 1000
FROM c3". The vast majority of the queries return less than 1000 rows, so
only one fetch is issued per execution.
Is ther
