Arne Roland writes:
> I want to examine the exhaustive search and not the geqo here. I'd expect the
> exhaustive search to give the plan with the lowest cost, but apparently it
> doesn't. I have found a few dozen different querys where that isn't the case.
> I attached one straight forward exam
> On Feb 25, 2021, at 4:04 PM, Igor Gois wrote:
>
> Philip,
>
> The results in first email in this thread were using explain analyze.
>
> I thought that you asked to run using only 'explain'. My bad.
>
> The point is, the execution time with explain analyze is less the 1 second.
> But the
> On Feb 25, 2021, at 3:46 PM, Igor Gois wrote:
>
> Hi, Philip
>
> We ran: EXPLAIN (FORMAT JSON) SELECT "Id", "DateTime", "SignalRegisterId",
> "Raw" FROM "SignalRecordsBlobs" WHERE "SignalSettingId" = 103 AND "DateTime"
> BETWEEN '2019-11-28T14:00:12.54020' AND '2020-07-23T21:12:32.249
> On Feb 24, 2021, at 10:11 AM, Igor Gois wrote:
>
> Hi, Julien
>
> Your hypothesis about network transfer makes sense. The query returns a big
> size byte array blobs.
>
> Is there a way to test the network speed against the instances? I have access
> to the network speed in gcp (5 Mb/s),
