XIg& hddlZddlZddlZddlZddlmZddlZdZGddZGddZ de d e d e fd Z d e d e d e fdZ ddddddddddddd Zde de dede d e f dZde d e fdZde d e d e fdZde d e fd Zd!e d e fd"Zde d#ed dfd$Zd%e d e d dfd&Zd'e d(e d dfd)Zd,d*Zed+k(reyy)-N)reducea .styled-table { border-collapse: collapse; margin: 25px 0; font-size: 0.9em; font-family: sans-serif; min-width: 400px; box-shadow: 0 0 20px rgba(0, 0, 0, 0.15); } .styled-table thead tr { background-color: #009879; color: #ffffff; text-align: left; } .styled-table th, .styled-table td { padding: 12px 15px; } .styled-table tbody tr { border-bottom: 1px solid #dddddd; } .styled-table tbody tr:nth-of-type(even) { background-color: #f3f3f3; } .styled-table tbody tr:last-of-type { border-bottom: 2px solid #009879; } .node-body { font-size:15px; } .tf-nc { position: relative; width: 250px; text-align: center; background-color: #fff100; } cDeZdZdededefdZdeddfdZded edefd Zy) NodeTimingphasetimereturnc.||_||_d|_yNr)rr percentage)selfrrs X/var/www/html/answerous/venv/lib/python3.12/site-packages/duckdb/query_graph/__main__.py__init__zNodeTiming.__init__4s   total_timeNc,|j|z |_yN)rr )r rs r calculate_percentagezNodeTiming.calculate_percentage:s))j0rlrc`|j|jz}t|j|Sr)rrr)rrrs r combine_timingzNodeTiming.combine_timing=s$VVaff_ !'':..r) __name__ __module__ __qualname__strfloatobjectrrrrr rr2sIc6 1u11/&/V//rrcBeZdZdZdefdZdefdZdefdZdZ dZ y ) AllTimingsci|_yrphase_to_timings)r s r rzAllTimings.__init__Es "r node_timingc|j|jvr)|j|jj|y|g|j|j<yr)rr#append)r r$s r add_node_timingzAllTimings.add_node_timingHsP    5 5 5  ! !+"3"3 4 ; ;K H 4?=k//0rrc |j|Srr"r rs r get_phase_timingszAllTimings.get_phase_timingsNs$$U++rcPttj|j|Sr)rrrr#r)s r get_summary_phase_timingsz$AllTimings.get_summary_phase_timingsQs j//1F1Fu1MNNrctjj}|jfd|j |S)Nc:j|jSr)r,r)xr s r z'AllTimings.get_phases..Vs4#A#A!#D"J"Jr)key)listr#keyssortreverse)r phasess` r get_phaseszAllTimings.get_phasesTs:d++0023 J K rcd}|jjD] }||j|jz }"|Sr )r#r3r,r)r total_timing_sumrs r get_sum_of_all_timingsz!AllTimings.get_sum_of_all_timingsZsJ**//1 KE  > >u E J J J  KrN) rrrrrr'rr*r,r7r:rrr r r Cs9#A:A ,s,OsO  rr fpathflagsrct||dS)Nutf8)encoding)open)r;r<s r open_utf8rAas uv ..rtop_node query_timingsct|dt|d}|j||dD]}t||y)N operator_typeoperator_timingchildren)rrr'get_child_timings)rBrCr$childs r rHrHesJXo6hGX>Y8Z[K!!+.*%0%/0rz#ffffbaz#ffb3baz#baffc9z#ffdfbaz#bae1ffz#facd60z#1ac0c6) HASH_JOIN PROJECTIONSEQ_SCANUNGROUPED_AGGREGATEFILTERORDER_BYPERFECT_HASH_GROUP_BY HASH_GROUP_BYNESTED_LOOP_JOINSTREAMING_LIMITCOLUMN_DATA_SCANTOP_Nnameresult cardinality extra_infocd}|j}|tvr dt|d}d|d}|dz }|jdd}|d |d |d z }|d z }|d |dz }|d z }|d|dz }|dz }|dz }|S)Nzbackground-color: ;zz
_ z

z (z s)

z

----------------

z

z

z

cardinality = z

z)strip color_mapreplace)rVrWrXrY node_style stripped_namebodynew_names r get_node_bodyrf|sJJJLM !))M*B)C1E +Jzr[rYz: z
rErFoperator_cardinalityrGz
    z
)rflengenerate_tree_recursive)rgnode_prefix_htmlnode_suffix_htmlrYr1 node_body children_htmlrIs r rlrlsJ,'ER < 8 =>eDD Ej9():;()?@(*I M :j !"a'  + Phase Time Percentage zzz TOTAL TIMEzExecution Timezzz z dz% )jsonloadsgather_timing_informationrgetr:r7r'rr,rrroundr ) rqrCrgr table_head table_body table_endexecution_time all_phasesrsummarized_phase phase_columns r generate_timing_htmlrsXJ'Jj-8z~~&78UJNN9J (BB5I--j9,1\,AUN^E^UG4(di ~!&&'('2236q9:;   )J  ""rcftj|}d}d}t|dd}||z|zS)Nz&
    z
rGr)rvrwrl)rqrg tree_prefix tree_suffix tree_bodys r generate_tree_htmlrs@J'J=K K( :(>q(ABI  "[ 00r json_inputcddlm}t|d}|djd|djd|djd |d S) Nr)HTMLFzW ${CSS} ${LIBRARIES}
${CHART_SCRIPT} z${CSS}cssz${CHART_SCRIPT} chart_scriptz ${LIBRARIES} libraries)IPython.core.displayr generate_htmlra)rr html_outputs r generate_ipythonrsb) E2K  gh E(:;GGDUGRSaGb=ddkdk K0e2  33rinclude_meta_infoc:d}d}|tdzz }|dz }||dddS)NzP z r[) treeflex_css duckdb_cssrr) qgraph_css)rqrrrs r generate_style_htmlrs;jL C: C<C$  rrvc(t|dd|y)NrGr)rH)rvrCs r rxrxsd:&q)=9r input_file output_filect}t|d5}|j}dddtd}t ||}t |}t|d5}d}|j d|d}|j d|d}|j d |}|j d |}|j|dddy#1swYxYw#1swYyxYw) NrTzw+aT Query Profile Graph for Query ${TREEFLEX_CSS}
${TIMING_TABLE}
${TREE} z${TREEFLEX_CSS}rz ${DUCKDB_CSS}rz${TIMING_TABLE}z${TREE})r rAreadrrrrawrite) rrrCftextr timing_table tree_outputhtmls r translate_json_to_htmlrsLM :s #qvvx&dD1K'm/JK||O[-FG||-|<||I{3  3sC A"C CCctjddkrtdtdt j dd}|j dd |j d d d |j dd dd|j}|j}|j}|js.d|vr|jdd}nHtdtdn1d|jvr |j}ntdtd|j}t|||r8tjdtjj!|zdyy)NrzPlease use python3rjzQuery Graph GeneratorzbGiven a json profile output, generate a html file showing the query graph and timings of operators)prog description profile_inputzprofile input in json)helpz--outF)requireddefaultz--open store_trueT)ractionrz.jsonz.htmlz%please provide profile output in jsonz/please provide valid .html file for output namezfile://)new)sys version_infoprintexitargparseArgumentParser add_argument parse_argsroutrar@r webbrowserospathabspath)parserargsinputoutput open_outputs r mainr s/ Q "# Q  $ $ $xzF .EF %? 5tT    D   E XXF 88 e ]]7G4F 9 : G dhh XXF C D G))K5&) BGGOOF$;;Cr__main__)rN)rvrrr functoolsrrrrr rrrArHr`rrfrlrrrboolrrxrrrrrr rs~ ' T//"  </S///00v0#0$&! !   Su#RU(KK3K.##V##F##v##L161c1 3 3 3 C D T :C::4:#s###L DF zFr