Re: postgres 7.0.3 core dumps - Mailing list pgsql-general

From Tom Lane
Subject Re: postgres 7.0.3 core dumps
Date
Msg-id 22307.979780466@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres 7.0.3 core dumps  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] RE: Help with query. (*)
Next
From: Tom Lane
Date:
Subject: Re: plperl and sqrt.