Joseph Shraibman <jks@selectacast.net> writes:
>> If it is a select from cursor that's dying, we'll really need the query
>> log so that we can see what the cursor definition was...
>>
> From my postgres log (this wasn't from a crash, I'm just showing you
> what the cursor was like):
> ProcessUtility: BEGIN;
> query: DECLARE cname CURSOR FOR SELECT u.userkey, u.profile, u.config,
> u.rules FROM usertable u, directory d WHERE u.podkey = 2 AND u.status =
> 2 AND u.subper AND NOT u.banned AND u.userkey = d.userkey AND d.status
> IN(2, 5);
> <...>
> query: FETCH 100 FROM cname;
> ProcessUtility: FETCH 100 FROM cname;
Okay. What do you get from EXPLAIN for that SELECT? Actually I'd like
to see EXPLAIN VERBOSE ...
regards, tom lane
