On 9/13/18 4:55 PM, Neto pr wrote:
Em qui, 13 de set de 2018 às 19:53, David G. Johnston
mailto:david.g.johns...@gmail.com>> escreveu:
On Thu, Sep 13, 2018 at 3:30 PM, Neto pr mailto:netopr...@gmail.com>>wrote:
The problem is that using the explain analyze I have to
wai
Em qui, 13 de set de 2018 às 19:53, David G. Johnston <
david.g.johns...@gmail.com> escreveu:
> On Thu, Sep 13, 2018 at 3:30 PM, Neto pr wrote:
>
>> The problem is that using the explain analyze I have to wait for
>> the query to execute.
>> I would like to estimate the time without having to wa
On Thu, Sep 13, 2018 at 3:30 PM, Neto pr wrote:
> The problem is that using the explain analyze I have to wait for
> the query to execute.
> I would like to estimate the time without having to wait for the query
> execution.
> Does anyone know how to estimate the time without waiting for the que
Em qui, 13 de set de 2018 às 18:49, Vijaykumar Jain
escreveu:
> explain analyze would *run* the query and it can be dangerous if it is a
> DML statement like insert/update/delete 😊
>
>
>
> If you still want to go with explain analyze,
>
> You can do
>
>
>
> begin;
>
> explain analyze ;
>
> rollba
explain analyze would *run* the query and it can be dangerous if it is a DML
statement like insert/update/delete 😊
If you still want to go with explain analyze,
You can do
begin;
explain analyze ;
rollback;
thanks,
Vijay
From: Johnes Castro
Date: Friday, September 14, 2018 at 3:12 AM
To: Neto
