Message-Id: 
 <1544654267.3583234.1607577016.1555678D@webmail.messagingengine.com>
From: Ravi Krishna <srkrishna@fastmail.com>
To: pgsql-general@lists.postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: multipart/alternative;
 boundary="_----------=_154465426735832342"
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>
Date: Wed, 12 Dec 2018 17:37:47 -0500
Subject: explain analyze cost
In-Reply-To: 
 <CAN_ctnhpRDJmQaBVZM6008RkLYdCwtYx17ytx3yDeVkJoJ7o2w@mail.gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.

--_----------=_154465426735832342
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="utf-8"

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.__

--_----------=_154465426735832342
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset="utf-8"

<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style>
</head>
<body><div style="font-family:arial, sans-serif;font-size:16px;">I am running&nbsp;explain analyze cost on a SQL which reads from two large tables (122mil and 37 mil).&nbsp; 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.<br></div>
<div style="font-family:arial, sans-serif;font-size:16px;"><br></div>
<div style="font-family:arial, sans-serif;font-size:16px;">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.<br></div>
<div style="font-family:arial, sans-serif;font-size:16px;"><u></u><br></div>
</body>
</html>

--_----------=_154465426735832342--