Atri Sharma <atri(dot)jiit(at)gmail(dot)com> writes:
> I am not sure, but does statement_timeout depend on *what* the query
> is doing internally(i.e. if it is holding lots of locks,pins etc)?
A little bit --- the timeout won't actually kill the query until the
next time control reaches a CHECK_FOR_INTERRUPTS macro that's not inside
a critical section. We've had issues in the past with particular code
paths that failed to include such a check in a long-running loop, and
there might still be some left. But by and large, it won't take very
long for the query to notice the interrupt.
regards, tom lane