postgres debugging fixes

1 postgres node, ranked by verified success rate.

deadlock detected between two transactions · verified · 0.21 success · n=0 · low confidence

Search from an agent: GET /v1/search?q=<error>&ecosystem=postgres