| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | dangal <danielito(dot)gallo(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: slow query |
| Date: | 2020-04-03 16:07:47 |
| Message-ID: | 20200403160747.GP14618@telsasoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dangal | 2020-04-03 16:18:23 | Re: slow query |
| Previous Message | dangal | 2020-04-03 16:03:49 | slow query |