agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Ravi Krishna <srkrishna@fastmail.com>
To: pgsql-general@lists.postgresql.org
Subject: explain analyze cost
Date: Wed, 12 Dec 2018 17:37:47 -0500
Message-ID: <1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com> (raw)
In-Reply-To: <CAN_ctnhpRDJmQaBVZM6008RkLYdCwtYx17ytx3yDeVkJoJ7o2w@mail.gmail.com>
References: <HE1PR0402MB3625F9C2E5735459D63DA27C93A70@HE1PR0402MB3625.eurprd04.prod.outlook.com>
<d5acdc15-fbba-0a85-95c1-082bb6d60e0b@portavita.eu>
<CAN_ctnh4_f0SLNhm06NwutGHE5_Bx5hrn_0DskJJRW6kTEqnwQ@mail.gmail.com>
<HE1PR0402MB3625FC1878598594295EC30993A70@HE1PR0402MB3625.eurprd04.prod.outlook.com>
<CAN_ctnhpRDJmQaBVZM6008RkLYdCwtYx17ytx3yDeVkJoJ7o2w@mail.gmail.com>
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.__
view thread (4+ messages) latest in thread
Message-ID: <1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com>
Permalink: ../1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com/
Also on: postgresql.org/message-id/1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: srkrishna@fastmail.com, pgsql-general@lists.postgresql.org
Subject: Re: explain analyze cost
In-Reply-To: <1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox