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