Date: Fri, 3 Apr 2020 09:03:49 -0700 (MST)
From: dangal <danielito.gallo@gmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1585929829525-0.post@n3.nabble.com>
Subject: slow query
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk

Dear I have a question to ask you
I am having a slow problem with a query and I am seeing with the explain
that the current cost and time differ by 4 times
Postgres version 9.5.16 in centos 7.6
To try to solve this run the statistics to the table and the same problem
remains
It's a very big table 2 billion tuples
Do you have any idea what I can do to improve
Thank you very much for your time
Any data you need I can provide

I share a part of the explain

 Hash Right Join  (cost=11114339.65..12172907.42 rows=886647 width=158)
(actual time=1906344.617..1963668.889 rows=3362294 loops=1)"
"                    Output: ba.bus_ent_inst_id_auto, ba.att_value_1,
ba.att_value_num_1, att_call.ent_inst_att_str_value,
att_nro.ent_inst_att_str_value, att_bis.ent_inst_att_str_value,
att_pad.ent_inst_att_str_value, att_manz.ent_inst_att_str_value, att_a
(...)"
"                    Hash Cond: ((att_barr.env_id = ba.env_id) AND
(att_barr.bus_ent_inst_id = ba.bus_ent_inst_id_auto))"
"                    Buffers: shared hit=5814458 read=1033324 dirtied=790"


--
Sent from: https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html