Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail From: Luke Charlton Newsgroups: comp.lang.python Subject: Python Advanced Help Date: Tue, 15 Mar 2016 11:35:19 +0000 Lines: 33 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Trace: news.uni-berlin.de +lLK4ZGwshAKLFRtdCflqwCrXEWeQS4AFmDbcl4Ty8AA== Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.019 X-Spam-Evidence: '*H*': 0.96; '*S*': 0.00; 'subject:Python': 0.05; 'i?m': 0.05; 'thats': 0.07; 'we?re': 0.07; 'skip:[ 40': 0.09; 'subject:Help': 0.10; 'python': 0.10; 'python.': 0.11; '(0)': 0.13; '(python)': 0.16; 'etc...': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'sql)': 0.16; 'subject:Advanced': 0.16; 'basically': 0.18; 'to:name:python-list@python.org': 0.20; '(the': 0.22; 'trying': 0.22; 'bit': 0.23; 'forgot': 0.23; '(this': 0.24; 'script': 0.25; "i've": 0.25; "doesn't": 0.26; 'ago': 0.29; "i'm": 0.30; "we're": 0.30; 'code': 0.30; 'putting': 0.30; '+44': 0.35; 'next': 0.35; 'step': 0.36; 'but': 0.36; 'instead': 0.36; 'created': 0.36; 'to:addr:python-list': 0.36; 'doing': 0.38; 'turned': 0.38; 'anything': 0.38; 'means': 0.39; 'goes': 0.39; 'does': 0.39; 'to:addr:python.org': 0.40; 'where': 0.40; 'consultant': 0.60; 'received:85': 0.60; 'received:network': 0.61; 'skip:u 10': 0.61; '&': 0.61; 'default': 0.61; 'show': 0.62; 'back': 0.62; 'more': 0.63; 'virus:src="cid:': 0.64; 'grab': 0.64; 'content-type:multipart/related': 0.65; 'received:217': 0.66; 'image-size:2**15': 0.72; 'charlton': 0.84; 'commenting': 0.84; 'upside': 0.84 X-Env-Sender: lcharlton@vldbsolutions.com X-Msg-Ref: server-6.tower-90.messagelabs.com!1458041654!29746272!18 X-Originating-IP: [217.28.138.145] X-StarScan-Received: X-StarScan-Version: 8.11; banners=-,-,- X-VirusChecked: Checked Thread-Topic: Python Advanced Help Thread-Index: AQHRfq7A8Ol1VuTV2EWtRt/oipdnlQ== Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [92.8.55.157] x-exclaimer-md-config: 266e7a57-cddd-49fd-bdea-19bca6d40303 X-Mailman-Approved-At: Tue, 15 Mar 2016 07:48:25 -0400 X-Content-Filtered-By: Mailman/MimeDel 2.1.21 X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.21 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Xref: csiph.com comp.lang.python:104935 Okay, So basically I created a python script around 1 year ago to grab an e= xplain_plan from a Greenplum system (Normal SQL) and change it around and e= xplain each step/section, the thing is, I've came back to the python code a= nd I don't understand anything of what it's doing (the code specifically). = The Script does work but I just want to explain each section to myself and = understand it a bit more as I've forgot Python. This means putting comments= /notes in next to each section to explain it but hidden so it doesn't show = up when ran, so using the # commenting out #. The aim of the script is to make the explain_plan understandable because it= comes out all garbled, so i've turned it upside down because thats how you= read it, it goes from bottom to top instead of the default top to bottom. = I've put step 1/2 in etc... but I want to know in the code what does what a= nd where etc so I can then expand on the explanation of the explain_plan. Code (Python) - http://pastebin.com/sVhW34fc (This is the one I'm trying to= understand) Before & After of an Explain_Plan in SQL Greenplum - http://pastebin.com/81= kNWVcy What we're aiming for (Teradatas Explain_Plan) - http://pastebin.com/Nm4g12= B3 Regards, Luke Charlton Technical Consultant [cid:4BEA1319-4F97-4ED8-96FE-1A3EDF7DEC22] lcharlton@vldbsolutions.com Mobile : +44 (0) 773 431 3140