Hi!!!
I try to explain my problem...sorry for my english :(
In pgsql 9.5.1 I have a two tables with the next structure:
1. Tabla unlogged «public._gc_cat»
Columna | Tipo | Modificadores
-+--+---
idppicat| integer |
David G. Johnston wrote:
> To be more clear, you need to run a query that will complete in our
> lifetime (and without an OOM error) with all three of ANALYZE, BUFFERS, and
> TIMING specified for the EXPLAIN.
I think the problem is pretty clear. The plan is sensible yet the
result doesn't seem
On Fri, Mar 4, 2016 at 3:09 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
>
>> 2016-03-04 15:58 GMT-06:00 David G. Johnston
>> :
>>
>>> On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <
>>> fjmolinabr...@gmail.com> wrote:
>>>
when i run
>
>
> 2016-03-04 15:58 GMT-06:00 David G. Johnston :
>
>> On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <
>> fjmolinabr...@gmail.com> wrote:
>>
>>> when i run without the ANALIZE the output is:
>>>
>>> pba=# EXPLAIN ( TIMING, BUFFERS) SELECT
No, these messages are not confuse; I just wanted to show output
2016-03-04 15:58 GMT-06:00 David G. Johnston :
> On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <
> fjmolinabr...@gmail.com> wrote:
>
>> when i run without the ANALIZE the output is:
>>
>>
On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <
fjmolinabr...@gmail.com> wrote:
> when i run without the ANALIZE the output is:
>
> pba=# EXPLAIN ( TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb a
> LEFT join _gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama );
>
when i run without the ANALIZE the output is:
pba=# EXPLAIN ( TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb a LEFT
join _gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama );
ERROR: la opción BUFFERS de EXPLAIN requiere ANALYZE
pba=# EXPLAIN ( TIMING) SELECT idprodxintegrar FROM
Felipe de Jesús Molina Bravo wrote:
> pba=# \i tablas.sql
> DROP TABLE
> SELECT 120130
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> DROP TABLE
> SELECT 91932
> CREATE INDEX
> CREATE INDEX
> pba=# EXPLAIN (ANALYZE, TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb
> a LEFT join _gc_cat b on (
sorry...i made a mistake...my tables are unlogged
and in the last test these was wiped... :(
when i create the tables again (with all record) the result is:
pba=# \i tablas.sql
DROP TABLE
SELECT 120130
CREATE INDEX
CREATE INDEX
CREATE INDEX
DROP TABLE
SELECT 91932
CREATE INDEX
CREATE INDEX
pba=#
On Fri, Mar 4, 2016 at 2:16 PM, Felipe de Jesús Molina Bravo <
fjmolinabr...@gmail.com> wrote:
> the output is:
>
> pba=# EXPLAIN (ANALYZE, TIMING, BUFFERS) SELECT idprodxintegrar FROM
> _gc_tb a LEFT join _gc_cat b on ( b.arama <@ a.arama and a.arama <@
> b.arama )
> ;
>
the output is:
pba=# EXPLAIN (ANALYZE, TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb
a LEFT join _gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama )
;
QUERY
PLAN
the result was the same:
*pba=# ANALYZE VERBOSE public._gc_cat;INFO: analizando
«public._gc_cat»INFO: «_gc_cat»: se procesaron 1999 de 1999 páginas, que
contenían 91932 filas vigentes y 0 filas no vigentes; 3 filas en la
muestra, 91932 total de filas estimadasANALYZEpba=#
On Fri, Mar 4, 2016 at 1:52 PM, Felipe de Jesús Molina Bravo <
fjmolinabr...@gmail.com> wrote:
>
>
>>> Now i execute the same in pgsql 9.4.5 and all is fine!!!
>>>
>>> The EXPLAINs are:
>>>
>>> - pgsql 9.5.1:
>>>
>>>Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
>>> ->
On Fri, Mar 4, 2016 at 3:52 PM, Felipe de Jesús Molina Bravo <
fjmolinabr...@gmail.com> wrote:
>
>
>>> Now i execute the same in pgsql 9.4.5 and all is fine!!!
>>>
>>> The EXPLAINs are:
>>>
>>> - pgsql 9.5.1:
>>>
>>>Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
>>> ->
>
>> Now i execute the same in pgsql 9.4.5 and all is fine!!!
>>
>> The EXPLAINs are:
>>
>> - pgsql 9.5.1:
>>
>>Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
>> -> Seq Scan on _gc_tb a (cost=0.00..3321.30 rows=120130 width=66)
>>-> Bitmap Heap Scan on
On 03/04/2016 12:09 PM, Felipe de Jesús Molina Bravo wrote:
Hi!!!
I try to explain my problem...sorry for my english :(
In pgsql 9.5.1 I have a two tables with the next structure:
1. Tabla unlogged «public._gc_cat»
Columna | Tipo | Modificadores
Hi!!!
I try to explain my problem...sorry for my english :(
In pgsql 9.5.1 I have a two tables with the next structure:
1. Tabla unlogged «public._gc_cat»
Columna | Tipo | Modificadores
-+--+---
idppicat| integer |
17 matches
Mail list logo