On Fri, Apr 03, 2020 at 09:03:49AM -0700, dangal wrote: > 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
The "cost" is in arbitrary units, and the time is in units of milliseconds. The cost is not an expected duration. > 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 Please check here. https://wiki.postgresql.org/wiki/Slow_Query_Questions > I share a part of the explain It's not very useful to see a fragment of it. -- Justin
