| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ s; d d l Z d d l m Z d d l m Z m Z m Z m Z m Z m Z m
Z
m Z d d l m
Z
m Z d d l Z d d l Z d d l Z d � Z d � Z d � Z d � Z d e f d
� � YZ d e f d � � YZ d
e f d � � YZ d d d d f Z d d d d f Z d d d d f Z d d d d f Z d d d d f Z d d d d f Z d d d d f Z d e f d � � YZ d e f d � � YZ! d e f d � � YZ" d e f d � � YZ# d e# f d � � YZ$ d e f d � � YZ% d! e f d" � � YZ& d# e& f d$ � � YZ' d% f d& � � YZ( d S(' i����N( t log_error( t
VBoxFiguret Canvast DiamondShapeFiguret RectangleShapeFiguret
TextFiguret HFillt draw_varrowt draw_harrow( t ImageSurfacet Contextc C s t j | � } t j | � S( N( t StringIOt jsont load( t textt fp( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt decode_json s c C sd d | } y8 d d l } | j | � } | j d � d j � } Wn t k
r_ t d � n X| S( Ns SELECT i����t s; Can't import sqlide_grt, disabling expression reformatting
( t
sqlide_grtt reformatSQLStatementt partitiont stript ImportErrorR ( t
expressiont sqlR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt reformat_expression$ s
c C sR | d k r d | d S| d
k r0 d | d S| d k rH d | d St | � S( Ni� s %.2fGg @�@s %.02fMs %.0fKi@B i ʚ;i@B g e��Ai@B g ��.A( t str( t c( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
fmt_number1 s c C sh | d k r d | S| d k r, d | d S| d k rD d | d S| d k r\ d
| d Sd | Sd S(
Ni s %i rowi ʚ;s
%.2fG rowsg e��Ai@B s
%.2fM rowsg ��.Ai� s
%.2fK rowsg @�@s %s rows( ( t r( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt fmt_rows; s t MyCanvasc B s e Z d � Z d � Z RS( c C s t j | | � d S( N( R t __init__( t selft cb( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR J s c C s/ t j | | | � } | r+ | j | | � Sd S( N( R t figure_att
get_figure_att None( R! t xt yt fig( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR# N s ( t __name__t
__module__R R# ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR I s t ExplainNodec B sv e Z d Z d Z e Z e Z d � Z e d � � Z e d � � Z
e d � � Z e d � � Z e d � � Z
e d � � Z e d � � Z e d
� � Z e d � � Z d � Z e d
� � Z e d � � Z d � Z d d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d d d � Z d � Z! e d � � Z" d � Z# d! � Z$ RS(" i i c C s_ t j | � | | _ d | _ d | _ d | _ d | _ d | _ | j | _
| j | _ d S( N(
R R t _contextR% t parentt cost_infot _figuret _aggr_cost_valuet _aggr_cost_pctt handle_hover_int on_hover_int handle_hover_outt on_hover_out( R! t context( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR [ s
c C s
| j j S( s> Width of the figure itself, without accounting for child nodes( R/ t width( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt inner_widthj s c C s
| j j S( N( R/ t height( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt inner_heighto s c C s$ t | j | j � d | j j f S( Ng �?( t intt root_xt vconnect_pos_offsetR/ t root_y( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
varrow_sourcet s c C s+ t | j | j � d | j j | j f S( Ng �?( R; R< R= R/ R> R: ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
varrow_targety s c C s$ | j j t | j | j � d f S( Ng �?( R/ R< R; R> t hconnect_pos_offset( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
harrow_target~ s c C s8 t | j j | j j � d t | j | j � d f S( Ng �?( R; R/ R< R7 R> RA ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt harrow_target_right� s c C s+ | j j | j t | j | j � d f S( Ng �?( R/ R< R8 R; R> RA ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
harrow_source� s c C s | j j | j d S( Ni ( R/ R& R8 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR= � s c C s | j j | j j d S( Ni ( R/ R' R9 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRA � s c C s d S( N( R% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt get_read_eval_cost� s c C s� d } | j j d k r' | j � } n | d k r� y t | � SWq� t k
r� | d } | d } t | � } | d k r� | d S| d k r� | d d S| d k r� | d d d S| Sq� Xn d S( Nt read_eval_costi����t Ki� t Mt G( R% R, t displayed_cost_infoRE t floatt
ValueError( R! t
cost_valuet valuet unit( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRM � s$
c C s d S( sE The row count number to be shown in outgoing node arrows
N( R% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
rows_count� s c C s� | j | k o$ | j | j k n r� | j | k oM | j | j k n r� x- | j D]" } | j | | � } | r\ | Sq\ W| j j | k o� | j j | j k n r� | j j | k o� | j j | j k n r� | Sn d S( N(
R< R7 R> R9 t childrenR$ R/ R8 R: R% ( R! R& R' t ft ff( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR$ � s R^i c C s� | j ru | j | d t | � d � x2 | j D]' } | j | | d � | j d � q2 W| j | d d � n | j | d t | � � d S( Ns s (
i s
t )( RQ t writet reprt dump( R! t st levelR& ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRW � s c C sW | j } d } | rS d d l m } t t t | | d � d � d � d � } n | S( Ni i����( t logi g �?( RP t mathRZ t maxt minR; ( R! RP t
line_widthRZ ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt get_line_width� s .c C sh | j } | d k rd | j d d d d � | j | | � | j d � | j | j j | � � n d S( Ni i i
( RM R% t set_source_rgbat move_tot
set_font_sizet show_textR, t fmt_cost( R! t crR& R' t cost( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt render_cost� s
c C sb | j } | d k r^ | j d d d d � | j | | � | j d � | j t | � � n d S( Ni i i
( RP R% R` Ra Rb Rc R ( R! Re R& R' RP ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt render_row_count� s
c C s d S( N( ( R! Re ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt do_render_extras� s c C sG | j | � x3 | j D]( } | j | k s2 t � | j | � q Wd S( N( Ri RQ R- t AssertionErrort
render_extras( R! Re t ch( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRk � s
c C s | j | � | j | � d S( N( t do_renderRk ( R! Re ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt render� s
c C s_ t j | | � | j � | j | j | j � x | j D] } | j | � q: W| j � d S( N( R Rn t savet translateR& R' RQ Rm t restore( R! Re Rl ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRm � s
c C s� t j | | � | j r� | j d } | j | � | j } | j } | | _ | j | j j | j | _
| j d | j | j j � | j j | | j
d | j j � n d S( Ni i ( R t do_relayoutRQ R= R7 t _widthR: R, t vspacingR9 t _heightt moveR/ R8 R' ( R! t ctxt childt
child_align_xt child_width( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr s
c C s� | j | j � � | j | | � | j | | d | j � � | j � t | | | f d | j � d | j � � | j � d S( Ni i
( t set_line_widthR_ Ra t line_tot strokeR t fill( R! Re R& t y1t y2( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR * s
-i
i c C s� | j | j � � | j | | � | j | | | j � | � | j � t | | | f | | j � | | j � � | j � d S( N( R{ R_ Ra R| R} R R~ ( R! Re t x1t x2R' t wt h( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR 3 s
-c C s/ | j j r+ | j j j � d | j _ n d S( N( R, t tooltipt closeR% ( R! R( R& R' ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR4 = s c C s | j | j S( N( R< R7 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
hint_pos_xC s c C s d S( N( R% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
get_hint_textH s c C s� | j j r+ | j j j � d | j _ n | j j r; d S| j � } | r�t | � t k rq | j d � } n t j
t j � | j _ | j r� | j j
| d | � \ } } n9 | j j
| j j | j | j j | j d � \ } } t j t � } | j d � d } x� | j d � D]� } | j d � r�| r�| j d � rV| d } n t j | � }
|
j t j � | j |
t t � d } n t j | d j d � � }
|
j t j � | j |
t t � q | | d 7} q W| r)t j | j d � � }
|
j t j � | j |
t t � n | j j j t | j! � d
� t | j" � d � � | j j j# | � | j j j$ | j j% � | j j j& | j j' | | t j( � n d S( Nt utf8i
i i t s
t *i����i id i2 () R, R� R� R% t
overview_modeR� t typet unicodet encodet mformst
newPopovert PopoverStyleTooltipt is_containert client_to_screenR/ R< R8 R> R: t newBoxt Falset set_spacingt splitt
startswitht endswitht newLabelt set_stylet
SmallStylet addt rstript SmallBoldStylet set_sizeR\ t get_widtht
get_heightt set_contentt add_close_callbackt
close_tooltipt show_and_trackt _viewt
StartRight( R! R( R& R' R t xxt yyt boxt tt linet label( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR2 L sJ "9
4(% R) R* t arrow_wt arrow_hR� t is_operationR� R t propertyR8 R: R? R@ RB RC RD R= RA RE RM RP R$ RW R_ Rg Rh Ri Rk Rn Rm Rr R R R4 R� R� R2 ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR+ U sB
t NestedLoopNodec B sq e Z e Z d � Z e d � � Z e d � � Z e d � � Z d � Z d � Z
d � Z d � Z d � Z
RS( c C sG t j | | � | | _ | | _ | | _ | | _ | | _ | d k rR d } nQ | d k rg d } n< | d k r| d } n' | d k r� d } n | j d d
� } t | � | _ | j j d � | j j
d d d d
� | j j d d d d
� | j j d � | j j
d � | j j | j j | j j � | j | j � d S( Nt nested_loops nested
loops Block Nested Loops block
nested
loops Batched Key Accesss batched
key
accesss Batched Key Access (unique)s batched
key
access (u)R s
i g �?i i i ( R+ R t join_bufferR- t child_asidet child_belowt replaceR R/ t set_layout_flagst set_colort set_text_colorR{ Rb t set_usizeR, t default_heightR� ( R! R6 R� t
left_childt right_childt caption( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR s. c C s | j | j g S( N( R� R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRQ � s c C s" | j j | j j | j j d S( Ni ( R� R7 R, t hspacingR� R8 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR= � s c C s& | j j j d d � r" | j j Sd S( Ni i ( R, t server_versiont# is_supported_mysql_version_at_leastR� t
rows_producedR% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRP � s
c C s, | j j r( t | j j j d d � � Sd S( Nt prefix_costi ( R� R. RK t getR% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRE � s c C s | j S( N( R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt __repr__� s c C sV | j rRt | j t � p* t | j t � } | j � | j d d d d � t | j t � r� | s� | j | | j d | j j d | j j d � n | j
| | j d d | j d d � n\ | s� | j | | j d | j d | j j
d � n | j
| | j d d | j d � | j | | j j | j d d � | j � n d S( Ni i i i i ( R- t
isinstancet MaterializedTableNodet MaterializedJoinNodeRo R` R� R RD RB Rh R R? R@ Rg R/ R< Rq ( R! Re t is_inside_a_box( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRi � s $
4,1%$c C s~ | j } | j } | j j | � | j | � | j | � | j | j | j j } t | j | � | _ t
| t � r� t | j j | j j
| j | j � | _ | j j | j | j d d � | j d | j j � nm | j j | j j
t | j | j � | _ | j j | j | j d d � | j d | j j | j j
� | j | j | j j | j j | j j
� d S( Ni i ( R� R� R/ Rr R7 R, R� R\ R8 Rs R� R� R9 Rt Ru Rv R= R' ( R! Rw t belowt asidet total_width( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr � s"
,! c C s; d i | j d 6} | j j r7 | d | j j 7} n | S( Ns *%(join_buffer)s
R� s Prefix Cost: %(prefix_cost)s( R� R� R. ( R! R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s ( R) R* t TrueR� R R� RQ R= RP RE R� Ri Rr R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� | s g �?g �?g �?i g i t TableNodec B ss e Z d e d d f d e d d f d e d d f d e d d
f d e d d
f d e d d f d e d d f d e d d f d e d d f d e d d f d e d d f d e d d! f d" e d# d$ f g
Z d1 g d1 d1 d1 d1 d% � Z
e d& � � Z d' � Z
e d( � � Z e d) � � Z e d* � � Z e d+ � � Z e d1 d, � Z d- � Z d. � Z d/ � Z d0 � Z RS(2 t systems Single Row
(system constant)s
Very low costt consts Single Row
(constant)t eq_refs Unique Key Lookups� Low - The optimizer is able to find an index that it can use to retrieve required records.
Fast because the index search leads directly to the page with all the row datat refs Non-Unique Key Lookups] Low-medium - Low if number of matching rows is small, higher as the number of rows increases.t fulltexts Fulltext Index SearchsL Specialized FULL TEXT search. Low - for this specialized search requirement.t ref_or_nulls Key Lookup +
Fetch NULL ValuessY Low-medium - if number of matching rows is small, higher as the number of rows increases.t index_merges Index MergesY Medium - may want to look for better index selection in the query to improve performance.t unique_subquerys( Unique Key Lookup
into table of subquerys, Low - Used for efficient Subquery processingt index_subquerys, Non-Unique Key Lookup
into table of subqueryt ranges Index Range Scans Medium - partial index scant indexs Full Index Scans# High - especially for large indexest ALLs Full Table Scans� Very High - very costly for large tables (not so much for small ones).
No usable indexes were found for the table and the optimizer must search every row.
This could also mean the search range is so broad that the index would be useless.t UNKNOWNt unknownR� c
C sp t j | | � | | _ | | _ | | _ | | _ | | _ | | _ | | _ | | _ | rj | | _
n x- | j D]" \ }
} } }
| |
k rt Pqt qt W|
| j d <| | j d <| j d � t
| � | _ | j j d � | j j d � | j j t � | j j | � | j j d d d d � | j j d d d d � | j | j � t
| j � | _ | j j d � | j j d d d d � | j j d � | j j d d d d � | j j d d � | j | j � | j rct | j � | _ | j j d � | j j d � | j j t � | j j d d d d � | j j d d � | j | j � n d | _ d S( Nt _hintt _access_typei i i i i
g �?( R+ R t namet key_namet access_typet infoR. t
rows_examinedR� t child_attached_subqueriesR- t col_join_typesR� R R/ R� Rb t
set_font_boldR� t set_fill_colorR� t set_paddingR� t _figure_nameR� t
set_alignmentR t _figure_keyR% ( R! R6 R� R� t attached_subqueriesR� R� R. R� R� t keyt colorR� t hint( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR sR
c C s | j r | j g Sg S( N( R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRQ ? s
c C s? | j r; t | j j d d � � t | j j d d � � Sd S( Nt read_costi t eval_cost( R. RK R� R% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRE E s 2c C s | j S( N( R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRP J s c C s6 | j r! | j j | j j d S| j j | j d S( Ni ( R� R/ R& R7 R8 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR= N s c C sP | j j } | j r, | d | j j 7} n | j rL | d | j j 7} n | S( Ni ( R/ R9 R� R� ( R! R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR: T s c C s | j j | j j S( N( R/ R< R7 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� ^ s c C s� | j j | � s | r� | rD | j j | � rD | | j | } n | j j | d � } t | � t k r} d j | � } n d | | f Sd S( Nt -s ,
s %s %s
R� ( R� t has_keyR� R� t listt join( R! R� R� t always_showt value_formatRN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
_hint_lineb s c C s d | j } | | j d d � 7} | d 7} | | j d d t � 7} | | j d d � 7} | | j d d
� 7} | | j d d � 7} d | j k s� d
| j k s� d | j k r� | d 7} n d
| j k rFd | j k rFy t | j d � | j d
<WqFt k
rB} t d | j d | f � | j d | j d
<qFXn | | j d d
� 7} d | j k rx| d 7} n | | j d d � 7} | | j d d � 7} | | j d d � 7} | | j d d d d �7} | d 7} | d 7} | j r| d | j 7} n | S( Nsa *%(table_name)s
Access Type: %(access_type)s
%(_access_type)s
Cost Hint: %(_hint)s
s Used Columns:t used_columnss
s *Key/Index:R� s Ref.:R� s Used Key Parts:t used_key_partss Possible Keys:t
possible_keyst attached_condition_fmtt attached_conditions Could not reformat %s: %s
s *Attached Condition:
s Using Join Buffer:t using_join_buffers Rows Examined per Scan:t rows_examined_per_scans Rows Produced per Join:t rows_produced_per_joins4 Filtered (ratio of rows produced per rows examined):t filteredR� s %s%%s' Hint: 100% is best, <= 1% is worst
sN A low value means the query examines a lot of rows that are not returned.
su *Cost Info
Read: %(read_cost)s
Eval: %(eval_cost)s
Prefix: %(prefix_cost)s
Data Read: %(data_read_per_join)s
( R� R� R� R t ExceptionR R. ( R! R t e( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� n s8
-
c C sQ | j rMt | j t � rM| j � | j d d d d � t | j t � r� | j j | k r� | j | j � | j | j d | j j
d � | j | | j d | j j
d | j j
d � n. | j | | j d | j d | j j
d � | j | | j j | j d d � | j | | j d d | j d d � | j � n d S( Ni i i i ( R- R� R� Ro R` R� R� Ra R? R| RB R R R@ Rg R/ R< Rh Rq ( R! Re ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRi � s
$!4.$)c C s� | j j d d � | j j | � | j j t | j j d � | j j � | j r | j j t | j j d � | j j � n | j r� | j j t | j j d � | j j � n | j | _
t j | | � | j } | r�| j | � | j j
d | j j � | j r)| j j
d | j j � n | j rN| j j
d | j j � n | j
| j j | j j | j j | j j � | j j | j j | j | _ t | j
| j � | _
n d S( NiZ i ( R/ R� R% Rr R\ R7 t _uheightR� R� R: Ru R R� Rv R' R& R, R� Rs R9 ( R! Rw Rx ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr � s( ( + +
0 c C s d | j d | j d S( Ns <table: s (s )>( R� R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s N( R) R* t BLUEt GREENt YELLOWt ORANGEt REDt BLACKR� R% R R� RQ RE RP R= R: R� R� R� R� Ri Rr R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s: 4
. R� c B sq e Z e Z d d d g d d d d d � Z d � Z e d � � Z d � Z d � Z
e d � � Z d � Z RS( c
C sO t j | | | d | d | d | d | d | d |
d | �| j d � | j j } | j j | d | d | d
d � | j j | d | d | d
d � | j j d d d d � | j d
� r� | j d � r� | j j
| � n | j j
d | � | j j d d d d � | j j d d d d � | | _ | | _
| | _ d S( NR� R� R� R� R. R� R� i i i g�������?g�������?t <t >s %s (materialized)i ( R� R R� R/ t _fill_colorR� R� R� R� R� t set_textR� t materialize_attributest child_materialized_fromR- (
R! R6 R� R� R� t materialized_fromR R� R� R. R� R� R~ ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR � s"
%% c C s d | j d | j d S( Ns <materialized table: s (s )>( R� R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s c C s t j j | � | j g S( N( R� RQ t fgetR ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRQ � s c C s� | j j | � | j j | j j d } t j | | � x- | j D]" } | j d | j � | | _ qD W| | _ t
| j t | j
| j j | j j d � � | _ | j | j j k r� | j j | j j | j
| j j � n. | j j | | j j d | j
| j j � | j } | r�| j | � | j | | j j | j j � | | j j | j | _ t
| j | j � | _ n d S( Ni i ( R Rr R7 R, t
frame_paddingR t _itemsRv R' Rs R\ Ru R; R: R9 R� R� R/ ( R! Rw R7 RR Rx ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr � s&
6
c C s� t j | | � | j � | j | j | j � | j d d t | j j | j j | j
j � t | j j | j j | j
j � � | j
d � | j d d g d � | j d d d d � | j � | j � d S( Ng �?i g @g @i g�������?( R� Rm Ro Rp R& R' t rectangleR; R R7 R, R R9 R{ t set_dashR` R} Rq ( R! Rw ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRm s
#'
c C s | j S( N( R7 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR8 " s c C sP i t d 6t d 6t d 6} | j | j � d | } | d t j | � } d S( Nt dependentt cacheablet using_temporary_tables *Materialized from Subquery
Using Temporary Table: %(using_temporary_table)s
Dependent: %(dependent)s
Cacheable: %(cacheable)s
s
( R� t updateR R� R� ( R! t dR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� & s
N(
R) R* R� R� R% R R� R� RQ Rr Rm R8 R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s t
OperationNodec B sq e Z e Z d d d d � Z e d � � Z e d � � Z d � Z d � Z
d � Z e d � � Z d � Z
RS( c C s� t j | | � | | _ | r+ | | _ n | | _ | | _ | | _ | | _ | d k r� d } d } | j j d t � r� | d 7} n | j j d t � rB| d 7} qBn� | d k r� d } d } | j j d t � rB| d 7} qBnW | d
k r(d } d } | j j d t � rB| d 7} qBn t
d | � | } d } t } | d k r]t } n | d k rrt
} n | j d
� t | � | _ | j j d � | j j d � | j j d d d d � | j j | � | j j d � | j j d d d d � | j | j � g }
| j j d � r8|
j d � n | j j d � rZ|
j d � n |
r�t d j |
� � | _ | j j t � | j j d � | j | j � n d | _ d S( Nt grouping_operationt GROUPi R i t using_filesortt duplicates_removalt DISTINCTi t ordering_operationt ORDERs Unknown operation: %s
i i g i s tmp tablet filesortt ,i
( R+ R t operationR- Rx R. t
attributest child_optimized_awayR� R� R R
R R R� R R/ R� t set_corner_radiusR� R{ R� R� t appendR R� t _figure_messageR� R� Rb R% ( R! R6 R) Rx R. R* t optimized_away_subnodet operation_captiont scoret
fill_colort attrs( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR 7 sj
c C su | j rB t | j | j � d | j j | j j | j d f St | j | j � d | j j | j d f Sd S( Ng �?i i ( R. R; R< R= R/ R> R9 R: ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR@ v s 9c C s | j r | j g Sg S( N( Rx ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRQ } s c C s) | j r%t | j t � r%t | j t � r%| j � | j d d d d � t | j t � r� | j j | k r� | j | | j d | j j
d | j j
d � nq t | j t � r� | j | | j d | j j
d | j d � n. | j
| | j d | j d | j j d � | j � n d S( Ni i ( R- R� R� R� Ro R` R� R� R R? RB R RD R R@ Rq ( R! Re ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRi � s /
$41.c C s� t j | | � | j } | j | � t | t � sS t | t � sS t | t � r+t | j | j � | _ | j
| j j | j
| _ | j | j j k r� | j j | j | j j d d � | j d | j j
| j j � q�| j j d d � | j | j j | j d | j j
| j j � ne | j | j j | j | _ t | j
| j
� | _ | j j | j | j j d � | j d d � | j r�| j j | j j | j j | j j
d � n d S( Ni i i ( R Rr Rx R� R� R� R� R\ R7 Rs R9 R, Rt R: Ru R/ Rv R= R� R8 R. R& R' ( R! Rw Rx ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr � s(
- # c C s� | j d k r d } n= | j d k r0 d } n% | j d k rH d } n
| j d } | d 7} d | j k r� | d | j d 7} n d
| j k r� | d | j d
7} n | j r� d | j k r� | d
| j d 7} n | S( NR s *Grouping Operation
R% s *Ordering Operation
R# s *Duplicates Removal
s
R s Using Temporary Table: %s
R" s Using Filesort: %s
t sort_costs Sort Cost: %s
( R) R* R. ( R! R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s
c C s, | j r | j d j Sd G| Gd GHd Sd S( Ni t Nodes has no children( RQ RP ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRP � s
c C s | j S( N( R) ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s N( R) R* R� R� R% R R� R@ RQ Ri Rr R� RP R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR 4 s ? t QueryBlockNodec B sh e Z d d d d d � Z e d � � Z e d � � Z d � Z d � Z d � Z d � Z
d � Z RS( c C su t j | | � | r" | | _ n | | _ | | _ | | _ | | _ | rX | | _ n | | _ | rs | | _ n | j d � | r� d | k r� t d | d � | _
n t d � | _
| j
j d � | j
j d d d d � | j
| j
� | rhd | k rht | d � | _ | j j d � | j j d d d d � | j j d
d � | j
| j � n d | _ d S( Ni t select_ids query_block #%st query_blocki i
t messagei i g �?( R+ R R- R� R. Rx R+ t select_list_subqueriesR� R R/ R� R� R� R R. Rb R� R� R% ( R! R6 R� R/ R: R� R. ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR � s4
c C s, | j j } | j r( | | j j 7} n | S( N( R/ R9 R. ( R! R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR: � s c C sB g } | j r" | j | j � n | j r> | j | j � n | S( N( Rx R- R: ( R! t result( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRQ � s c C se t j | | � | j } | r� | j | � d } | j } | j } | | _ | j | j j | j | | _
| j d | j | j j � | j j | | j
d | � n | j } | r3| j | � | j | j | j j | j j | j j � | j | j j | j 7_ t | j
| j | j � | _
n | j | j j d 7_ | j
| j j 7_
d S( Ni i i ( R Rr Rx R= R7 Rs R: R, Rt R9 Ru Rv R/ R8 R: t small_hspacingR' R R\ ( R! Rw Rx t voffsetRy Rz ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr s&
! !
- "c C sE d | j d } | j rA d | j k rA | d | j d 7} n | S( Ns Select ID: %s
R7 t
query_costs Query Cost: %s
( R� R. ( R! R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� + s c C su | j rq | j j d � } | d k rq | j d d d d � | j | | � | j d � | j d | � qq n d S( NR> i i i
s Query cost: %s( R. R� R% R` Ra Rb Rc ( R! Re R& R' Rf ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRg 2 s
c C s! | j � t r� | j � | j d d d d � | j d � | j | j | j j | j j | j
| j | j j � | j
� | j � n | j d d d d � | j | | j j | j j d � | j rt | j t � r| j | | j d | j d | j j d � n | j � d S( Ni g333333�?i i i ( Ro R� R` R{ R R< R, R R/ R> R7 R9 R' R} Rq Rg R- R� R� R R? R@ ( R! Re ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRi < s
9
# 1c C s d S( NR8 ( ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� P s N( R) R* R% R R� R: RQ Rr R� Rg Ri R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR6 � s #
)
t SubQueryBlockNodec B s8 e Z d d d d d � Z d � Z d � Z d � Z RS( c C si t j | | | | | | | � d | _ | rU d | k rU | j j d | d � n | j j d � d S( NR7 s subquery #%st subquery( R6 R R% R* R/ R ( R! R6 R� R/ R: R� R. ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR U s
c C s
| | _ d S( N( R* ( R! R* ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt set_attributes_ s c C s� d } d | j k r- | d | j d 7} n | j r] d | j k r] | d | j d 7} n | d 7} d | j k r� | d | j d 7} n d | j k r� | d
| j d 7} n d | j k r� | d | j d 7} n | S(
Ns Subquery
R7 s Select ID: %s
R> s Query Cost: %s
s
R s Using Temporary Table: %s
R s Dependent: %s
R s Cacheable: %s
( R� R. R* ( R! R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� g s
c C s d S( NR@ ( ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� w s N( R) R* R% R RA R� R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR? T s
R� c B s� e Z e Z d � Z e d � � Z e d � � Z e d � � Z e d � � Z d � Z
d � Z d � Z d � Z
d � Z RS(
c C s� t j | | � | j d � | j d d d d � t | � | _ | j j t � | j j d � | j j d d d d � | j j
d d d d � | j j t � | j j d d d d � | j
| j � | | _ g } | j j d � r� | j d � n | rOt d
j | � � | _ | j j t � | j j d � | j
| j � n d | _ | | _ | | _ | | _ | | _ | | _ d S( Ni i
i g �?g�������?i i R s tmp tableR( ( R+ R R� R� R R/ R� R R{ R� R� R� R� R� R* R� R- R R� R. Rb R% R� R- R� R. Rx ( R! R6 R� R� R� R. R* R3 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR s4
c C s | j j } | S( N( R/ R9 ( R! R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR: � s c C s | j S( N( R7 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR8 � s c C s | j d S( Ni ( R7 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR= � s c C s& g } | j r" | j | j � n | S( N( Rx R- ( R! R; ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRQ � s c C s+ i t d 6} | j | j � d | } | S( NR sG *Buffered Join Result
Using Temporary Table: %(using_temporary_table)s
( R� R R* ( R! R R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s
c C s� t j | | � | j } | r� | j | � | j } | | j | j | _ | j | j j | j
| j | j | _
| j | j | j | j j � | j j d d � n d S( Ni ( R+ Rr Rx R7 t padding_leftt
padding_rightRs R: R, Rt R9 t padding_topt padding_bottomRu Rv R/ ( R! Rw Rx Rz ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr � s
+ c C s d | j d S( NR R ( R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s c C s� t j | | � | j � | j | j | j � | j d d t | j � t | j � d � | j
d � | j d d g d � | j d d d d � | j
� | j � d S( Ng �?i i g @g @i g�������?( R+ Rm Ro Rp R& R' R R; Rs Ru R{ R R` R} Rq ( R! Rw ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRm � s
,
c C s | j r t | j t � r | j � | j d d d d � t | j t � r� | j | | j d | j j d | j j d � | j | | j d d | j d d � nS | j
| | j d | j d | j j d � | j | | j d d | j d � | j
� n d S( Ni i i i ( R- R� R� Ro R` R� R RD RB Rh R R? R@ Rq ( R! Re ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRi � s
1,.%( R) R* R� R� R R� R: R8 R= RQ R� Rr R� Rm Ri ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� | s #
t
SubQueriesc B s; e Z d � Z d � Z d � Z d � Z e d � � Z RS( c C s� t j | | � | | _ x | D] } | | _ q W| | _ t | � | _ | j j d d g d � | j j d d d d � | j j d � | j
| j � d S( Ng @i i i
i ( R+ R t whatR- RQ R R/ t
set_line_dashR� R{ R� ( R! R6 RG t nodest n( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR � s
c C s | j S( N( RG ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s c C s� t j | | � d } d } xj t | j � D]Y } | j | � | j | | j | j j � | | j | j j 7} t
| | j � } q, W| j r� | | j j 8} n | | _ | j | j j | | _
d S( Ni ( R Rr t reversedRQ Rv R: R, t small_vspacingR7 R< R\ R9 Rs Ru ( R! Rw t
max_heightR� Rx ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRr s
c C s� | j � | j d d d d � | j | | j j | j j d � | j d k r� | j j j | j j j } | j | | j | | j
d d d � nM | j r� t | j t � r� | j
| | j d | j d | j j d � n | j � d S( Ni i i R: R� i����i ( s select_list_subqueriess attached_subqueries( Ro R` Rg R/ R< R> RG R- R7 R RD R� R� R R? R@ Rq ( R! Re t target_x( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRi s
# ) 1c C s
| j j S( N( R/ R9 ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR: $ s ( R) R* R R� Rr Ri R� R: ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRF � s
t UnionResultc B s2 e Z d � Z e d � � Z d � Z d � Z RS( c C s� t j | | d | � | j d � | j j d d � | j j d d d d � | j j d d d d � d | k r� t | d � | _ | j j
d � | j j d d d d � | j j d d � | j
| j � n d | _ | | _ d S( Nt UNIONi i i gffffff�?t
table_namei g �?( RF R R� R/ RH R% R� R� R R� Rb R� R� R� R� ( R! R6 R� t queries( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR + s
c C s6 t j j | � } | j r2 | d | j j 7} n | S( Ni ( RF R: R R� R9 ( R! R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR: > s c C s | G| Gd GHd S( Ns !!!!!!( ( R! R* ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRA E s c C s d } d | j } | S( Ns
UNION Result
sj *%(table_name)s
Access Type: %(access_type)s
Using Temporary Table: %(using_temporary_table)s( R� ( R! R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� L s
( R) R* R R� R: RA R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRO * s t ExplainContextc B sI e Z d Z d Z d Z d Z d Z d Z d Z d � Z d d � Z
d � Z d � Z d
� Z
d � Z d � Z d
� Z e e d � Z d � Z d � Z d � Z d � Z d � Z e e e � Z d � Z d � Z d � Z d � Z d d � Z d � Z d � Z d � Z! d � Z" d � Z# d � Z$ d � Z% d � Z& d! � Z' RS(" iA i2 i i
i c C s� | | _ | | _ | j | � } | s= t d � d | _ n= | d | _ t rz t j � } | j j | � | j � GHn d | _
t | _ d | _ d | _
d | _ d | _ d | _ d | _ t | _ d | _ t | _ d S( Ns Could not process JSON data
i g �?( i i ( i i ( t _jsonR� t process_explain_outputR R% t _rootR� R RW t getvaluet _old_offsetR� t _scalet _offsett
_extra_offsett _canvasR� t sizet aggregate_costsRJ t cost_value_is_amount( R! R R� RI RX ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR d s,
R� c C s/ | r t d | | f � n t d | � d S( Ns5 While parsing JSON output: unexpected node in %s: %s
s/ While parsing JSON output: unexpected node: %s
( R ( R! t nodeR6 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
unexpected� s c C s� | j d d � } | j d � } d } i } | rN | j d | � \ } } n | j d � } | rx | j d | � } n d } d | k r� | j d � p� d | d <n d | k r� | j d � p� d t | j d d � � d
| d <n | rdt | | d | d | d | d
| j d
d � d | j d d � d | d | j d � d | j d � d | j d � � St | | d | d
| j d
d � d | j d d � d | d | j d � d | j d � d | j d � �Sd S( NRQ R� t materialized_from_subqueryR� R t rowsi R R id R R R� R� R� R� R. R� R� ( R� R% t! handle_materialized_from_subqueryt handle_attached_subqueriesR; R� R� ( R! t tableR� Rb t materialized_from_subquery_nodet materialized_attributest attached_subqueries_R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt handle_table� sB 6 c C s� g } x�| D]�} t | � t k r� t | � d k r� d | k r� | j | d � } | j | � t | � d k r� d | d k r� | d d } n d } t | | | d | d � } | g } q�t | � d k r�t d � � q�q
t | � t k r�t | � d k r�d | k r�| j d | d � } | j | � t | � d k r}d } t | | | d | d � } | g } q�t | � d k r�t d � � q�q
| j | d � q
Wt | � d k s�t � | d S( Ni Rf i R R� i s uh ohR# (
R� t dictt lenRj R- R� R t handle_query_blockRa Rj ( R! t datat partsR` Rf R� t loop_nodeR) ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt handle_nested_loop� s2
0
0
c C s� g } x� | D]� } d } i } xg | j � D]Y \ } } | d k r\ | j | | t � } q, | d k ru | | | <q, | j | | � q, W| j | � | j | � q
Wt | | | � S( NR8 R R R ( s dependents cacheables using_temporary_table( R% t itemsRm R� Ra RA R- RF ( R! R� t
subquery_listt
subqueriesRn t qblockR* R� RN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt handle_optimized_away_subqueries� s
c C s� g } x� | D]� } d } i } x� | j � D]w \ } } | d k r\ | j | | t � } q, | d k ru | | | <q, | d k r� | j | � } q, | j | | � q, W| r� | j | � n | j | � q
Wt | | | � S( NR8 R R R Rf ( s dependents cacheables using_temporary_table( R% Rr Rm R� Rj Ra RA R- RF ( R! R� Rs Rt Rn Ru R* R� RN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRe � s
c C s� d } i } xp | j � D]b \ } } | d k rR | j | | d t d t �} q | d k rk | | | <q | j | | � q W| | f S( NR8 t is_subqueryt is_materializedR R R ( s dependents cacheables using_temporary_table( R% Rr Rm R� Ra ( R! R� Rn t inner_qblockR* R� RN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRd � s !
c C s� i } g } x� | j � D]� \ } } | d
k r> | | | <q | d k r� x] | D]B } | j d � | j d � | j | j d | j d � � � qQ Wq | j | | � q Wt | d | d | �S( NR R� RQ t query_specificationsR R R8 R� RR ( s using_temporary_tables access_types
table_name( Rr R� R- Rm Ra RO ( R! R� Rn R� t qblocksR� RN t qspec( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt handle_union_result s
)c C s� d } d } i } d } d } x�| j � D]�\ }
} |
d k rg | d k sU t � | j | � } q+ |
d k r� d | k r� t | � d k r� | d | d <q�| j | � } q+ |
d k r� | j |
| � } q+ |
d k r| d k s� t � | j |
| � } q+ |
d k r!| | |
<q+ |
d k r6| } q+ |
d
k rEq+ |
d k rTq+ |
d k r�| d k srt � | j |
| � } q+ |
d k r�| j |
| � } q+ |
d k r�| d k s�t � | j |
| � } q+ | j
|
| � q+ W| d k rL| r| S| r*t | | | | d | d | �St | | | | d | d | �SnZ | d k rqt
| | | | | | � S| r�t | | | | | | � St | | | | | � Sd S( NR� Rf R9 i t optimized_away_subqueriesR R% R# R R" R R. R7 t union_resultR: t
buffer_resultR8 R� ( s grouping_operations ordering_operations duplicates_removal( s using_temporary_tables using_filesorts dependent( R% Rr Rj Rq Rl Rj Rv Rm R} Re Ra R? R6 R� R ( R! R� Rn Rw Rx t contentR. R* R: R~ R� RN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRm sp
c C sO g } xB | j � D]4 \ } } | d k r | j | j | | � � q q W| S( NR8 ( Rr R- Rm ( R! Rn t outputR� RN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt handle_ s
c C s
| j | � S( N( R� ( R! Rn ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRU g s c C s: | j r6 t j � } | j j | d � | j � GHn d S( Ni ( RV R RW RW ( R! RX ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRW l s c C s | | j _ d S( N( R\ R� ( R! t v( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt _set_tooltips s c C s
| j j S( N( R\ R� ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt _get_tooltipv s c C sT t | � | _ | j j | j � | | _ | | _ | j j j d d d d � d S( Ng�������?i ( R R\ R� RV R� t _scrollR/ R� ( R! t viewt scrollt queue_repaint_cb( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt init_canvas| s
c C s | | f | _ d S( N( RZ ( R! R& R' ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
set_offset� s c C sW | | j d | j d 7} | | j d | j d 7} | j j t | � t | � � S( Ni i ( RZ R[ R� R� R; ( R! R& R' ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s c C sj t d | j d d | j d � } t | � } | j j | d d | j d | j d � | j | � d S( NR7 i R9 i ( R R] R
R\ t repaintt write_to_png( R! t patht imgRe ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
export_to_png� s # *c C s� t t d d d d � � } | j j | � | j j | j | j � | j j \ } } | | j d | | j d f | _ | j S( NR7 i R9 i ( R
R RV Rr Rv t global_paddingR] ( R! t paddingR R� R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt layout� s %c C s� | j | j d | j d | j d | j d � | j | j | j � y%| j j | d d | j d | j d � | j rn| j \ } } } } | j \ } } t
| | � } t
| | � } | j d � | j d d | | � | j
� | j | | | | � | j t j � | j d d d d � | j � | j | | | | � | j d d d d � | j � n Wn1 t k
r�d d l } t d | j � � n Xd S( Ni i g333333�?g �?i����s! Exception repainting explain: %s
( Rp RZ R[ t scaleRY R\ R� R] R� t _overview_visible_rectR\ R{ R t new_sub_patht
set_fill_rulet cairot CAIRO_FILL_RULE_EVEN_ODDR` R~ R} R t tracebackR t
format_exc( R! Re R& R' R� R� t total_wt total_hR� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� � s, 4*
c C s, | j | _ | j | _ | j j � } | \ } } } } | j \ } } | | k rd | | k rd d St | � | } t | � | } | | k r� d | | _ n
d | | _ t | _ | | _
| | | j d | | | j d f | _ | j j
d � | j j t | � t | � � | j j � d S( Ni i s #b3b3b3( RZ RX RY t
_old_scaleR� t get_content_rectR] RK R� R� R� R[ R� t set_back_colorR� R; t set_needs_repaint( R! R t _t
view_widtht view_heightR� t total_heightt dwt dh( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt enter_overview_mode� s$
- c C s� | j \ } } } } t | _ | j | _ d | _ | j j d � | j j t | j
j � | j d � t | j
j
� | j d � � | j
j | | � | j j � d S( Ni s #ffffffi ( i i ( R� R� R� R� RY R[ R� R� R� R\ R� R� R] R� t scroll_toR� ( R! R& R' R� R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt leave_overview_mode� s Ec C s | | j d | j d 8} | | j d | j d 8} | | j :} | | j :} | j \ } } | j \ } } } } | | d 8} | | d 8} t | | � } t | | � } t t | d � | | � } t t | d � | | � } t | � t | � | | f | _ | j j � d S( Ni i i (
RZ R[ RY R] R� R] R\ R; R� R� ( R! R& R' R� R� R� R� t wwt hh( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt mouse_moved� s
!c C s | j � d S( N( R� ( R! R& R' ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt
mouse_down� s c C s! | j r t | � St | � Sd S( N( R_ R R ( R! RN ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRd � s
c C s d | k | _ | | _ d S( Nt data_read_per_join( R_ RJ ( R! R� ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt show_cost_info_type s c C s
| | _ d S( N( R^ ( R! t flag( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt show_aggregated_cost_info s c C s& | j r" | j j � d | _ n d S( N( R� R� R% ( R! ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyR� s
(( R) R* R� Rt R� RL R< R R� R Ra Rj Rq Rv Re Rd R} R� Rm R� RU RW R� R� R� R� R� R� R� R� R� R� R� R� R� R� Rd R� R� R� ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyRS Z sH , !
H
() R� t
workbench.logR t workbench.graphics.canvasR R R R R R R R t workbench.graphics.cairo_utilsR R
R� R R R R R R R R+ R� R R R
R R R
t WHITER� R� R R6 R? R� RF RO RS ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\explain_renderer.pyt <module> s< :
� (q�f��(u90