| From: | Ravi Krishna <srkrishna(at)fastmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | explain analyze cost |
| Date: | 2018-12-12 22:37:47 |
| Message-ID: | 1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general pgsql-jdbc pgsql-sql |
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.__
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| Previous Message | Thomas Poty | 2018-12-12 18:26:11 | Re: Idle connections / sessions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| Previous Message | Thomas Munro | 2018-12-12 21:34:27 | Re: Does PostgreSQL use atomic file creation of FS? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| Previous Message | Thomas Poty | 2018-12-12 18:26:11 | Re: Idle connections / sessions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-12-12 22:45:43 | Re: explain analyze cost |
| Previous Message | Thomas Poty | 2018-12-12 18:26:11 | Re: Idle connections / sessions |