| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Ravi Krishna <srkrishna(at)fastmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: explain analyze cost |
| Date: | 2018-12-12 23:05:45 |
| Message-ID: | 20181212230545.xg22ufkuqnv4hsbz@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general pgsql-jdbc pgsql-sql |
On 2018-12-12 17:37:47 -0500, Ravi Krishna wrote:
> I am running explain analyze cost on a SQL which reads from two large
> tables (122mil and 37 mil). The query is an UPDATE SQL where we use
> derives table in the from clause and then join it back to the table
> being updated.
> The explain analyze cost itself is taking forever to run. It is running
> for the last 1 hr. Does that actually run the SQL to find out the
> impact of I/O (as indicated in COSTS). If not, what can cause it to run
> this slow.__
Please do not hijack other threads by replying to a message and changing
the subject. Just send a new mail to
pgsql-general(at)lists(dot)postgresql(dot)org, or whatever list you want to send an
email to.
Thanks,
Andres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2018-12-13 00:16:50 | Re: explain analyze cost |
| Previous Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Lissner | 2018-12-12 23:19:20 | Re: Errors with schema migration and logical replication — expected? |
| Previous Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2018-12-13 00:16:50 | Re: explain analyze cost |
| Previous Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2018-12-13 00:16:50 | Re: explain analyze cost |
| Previous Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |