agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedexplain analyze cost
4+ messages / 3 participants
[nested] [flat]
* explain analyze cost
@ 2018-12-12 22:37 Ravi Krishna <srkrishna@fastmail.com>
2018-12-12 22:45 ` Re: explain analyze cost Ron <ronljohnsonjr@gmail.com>
2018-12-12 23:05 ` Re: explain analyze cost Andres Freund <andres@anarazel.de>
0 siblings, 2 replies; 4+ messages in thread
From: Ravi Krishna @ 2018-12-12 22:37 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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.__
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: explain analyze cost
2018-12-12 22:37 explain analyze cost Ravi Krishna <srkrishna@fastmail.com>
@ 2018-12-12 22:45 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Ron @ 2018-12-12 22:45 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 12/12/2018 04:37 PM, 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).
Yes.
https://www.postgresql.org/docs/9.6/sql-explain.html
"The ANALYZE option causes the statement to be actually executed, not only
planned."
> If not, what can cause it to run this slow.
>
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: explain analyze cost
2018-12-12 22:37 explain analyze cost Ravi Krishna <srkrishna@fastmail.com>
@ 2018-12-12 23:05 ` Andres Freund <andres@anarazel.de>
2018-12-13 00:16 ` Re: explain analyze cost Ravi Krishna <srkrishna@fastmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Andres Freund @ 2018-12-12 23:05 UTC (permalink / raw)
To: Ravi Krishna <srkrishna@fastmail.com>; +Cc: pgsql-general@lists.postgresql.org
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@lists.postgresql.org, or whatever list you want to send an
email to.
Thanks,
Andres
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: explain analyze cost
2018-12-12 22:37 explain analyze cost Ravi Krishna <srkrishna@fastmail.com>
2018-12-12 23:05 ` Re: explain analyze cost Andres Freund <andres@anarazel.de>
@ 2018-12-13 00:16 ` Ravi Krishna <srkrishna@fastmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Ravi Krishna @ 2018-12-13 00:16 UTC (permalink / raw)
To: Andres Freund <andres@anarazel.de>; +Cc: pgsql-general@lists.postgresql.org
> Please do not hijack other threads by replying to a message and
> changing> the subject. Just send a new mail to
> pgsql-general@lists.postgresql.org, or whatever list you want
> to send an> email to.
>
I am truly sorry and this will not be repeated. I was just lazy.
I guess this would break threaded views , because on non threaded views
it does notmatter.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-12-13 00:16 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-12-12 22:37 explain analyze cost Ravi Krishna <srkrishna@fastmail.com>
2018-12-12 22:45 ` Ron <ronljohnsonjr@gmail.com>
2018-12-12 23:05 ` Andres Freund <andres@anarazel.de>
2018-12-13 00:16 ` Ravi Krishna <srkrishna@fastmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox