Python Advanced Help

Path	csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From	Luke Charlton <lcharlton@vldbsolutions.com>
Newsgroups	comp.lang.python
Subject	Python Advanced Help
Date	Tue, 15 Mar 2016 11:35:19 +0000
Lines	33
Message-ID	<mailman.159.1458042507.12893.python-list@python.org> (permalink)
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	<lcharlton@vldbsolutions.com>
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 <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Xref	csiph.com comp.lang.python:104935

Show key headers only | View raw

Okay, So basically I created a python script around 1 year ago to grab an explain_plan from a Greenplum system (Normal SQL) and change it around and explain each step/section, the thing is, I've came back to the python code and 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 and 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/81kNWVcy

What we're aiming for (Teradatas Explain_Plan) - http://pastebin.com/Nm4g12B3


Regards,

Luke Charlton
Technical Consultant

[cid:4BEA1319-4F97-4ED8-96FE-1A3EDF7DEC22]
lcharlton@vldbsolutions.com<mailto:lcharlton@vldbsolutions.com>
Mobile : +44 (0) 773 431 3140

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Python Advanced Help Luke Charlton <lcharlton@vldbsolutions.com> - 2016-03-15 11:35 +0000
  Re: Python Advanced Help Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-15 19:27 +0100

csiph-web