On 29 June 2016 at 22:20, Tom Lane wrote:
> Don't know if it would be practical for you at all, but if you could
> attach to a process that's stuck like this with a debugger and get a stack
> trace, that would probably be very informative.
It seems I have found the cause of my issues: my antiviru
On 29 June 2016 at 16:32, Igor Neyman wrote:
> Did you try AUTO_EXPLAIN extension
> (https://www.postgresql.org/docs/9.3/static/auto-explain.html) for
> diagnostic purposes?
> With auto_explain.loganalize = true it will log automatically EXPLAIN
> ANALYZE output, rather than just EXPLAIN output.
On 29 June 2016 at 14:45, Kevin Grittner wrote:
> Please monitor for the start of such an event and capture the full
> contents of pg_stat_activity and pg_locks during that 2 minute
> window.
I had already looked at that manually and found nothing unusual. To be more
thorough, I now had a batch f
Hi,
I have a weird slow query issue I can't seem to find the cause of, so I'm
hoping someone here can shed some light on this.
Context:
I have an application which (among other things) implements a sort of job
queue using postgres for persistence. While I know a RDBMS is not necessarily
the most
