Re: What can cause quick queries to run unusually slow?

On 3/14/2013 9:46 AM, Igor Polishchuk wrote:
> When you r delete was running slowly, did you check id th
> epg_stat_activity if it was waiting for something?
> It might just wait for a lock to be granted.

Thanks for the replies.

Unfortunately I wasn't around when it ran - I only noticed it in our
pgfouine report this morning. It is the PK for the table to Elein's
question. I don't know why that row or table would be locked or have
long running processes on them as it's a transactional table.

I see log_lock_waits and deadlock_timeout but would those be the right
way to capture when locks unexpectedly run a long time like this?

Brian