Re: Query hitting empty tables taking 48 minutes

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Query hitting empty tables taking 48 minutes
Date: 2018-06-07 19:16:04
Message-ID: f1270905-80e6-d391-4bc0-09982fb182f9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/07/2018 01:13 PM, Adrian Klaver wrote:
> On 06/07/2018 12:11 PM, Rob Sargent wrote:
>>
>
>>>
>> What's the url doing in "blob_id = ds3.blob.id <http://ds3.blob.id"?
>
> I have run into this before, it is an email artifact.
>
OK, thanks.
The code presented is just a generalized sql executor.  Might need to
see the code generating the sql.  A complete definition of the stack
might be in order too.  Might explain the "fetch" remark.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Creager 2018-06-07 19:26:05 Re: Query hitting empty tables taking 48 minutes
Previous Message Steve Atkins 2018-06-07 19:14:56 Re: Query hitting empty tables taking 48 minutes