Skip to content

Instantly share code, notes, and snippets.

@lawulu
Last active May 12, 2022 07:21
Show Gist options
  • Save lawulu/8f661658e0deb458e34fe66cf6090ed0 to your computer and use it in GitHub Desktop.
Save lawulu/8f661658e0deb458e34fe66cf6090ed0 to your computer and use it in GitHub Desktop.
trino
object_name | time.count | hits | time.avg | time.min | time.p50 | time.p99 | time.max | time.percentiles
-------------------------------------------------------------------------------------------------+------------+------+--------------------+----------+--------------------+--------------------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
trino.sql.planner.iterative:name=IterativeOptimizer,rule=ValuesExpressionRewrite | 647.0 | 5 | 11022.315904173107 | 182.415 | 1143.8593402646504 | 151408.749 | 510902.645 | {0.0=182.415, 0.01=188.645, 0.02=196.08, 0.03=213.9259475, 0.04=225.84879999999998, 0.05=236.9987607142857, 0.06=242.5881351111111, 0.07=246.66613254545453, 0.08=253.95388222222223, 0.09=262.66906956043954, 0.1=269.55822142857147, 0.11=274.7875633169935, 0.12=279.7618595555556, 0.13=285.838196, 0.14=296.2283505108225, 0.15=308.3193887351778, 0.16=319.55716498023713, 0.17=335.4724504923077, 0.18=361.9180081230769, 0.19=386.22774901098904, 0.2=406.98658469678475, 0.21=426.6600640788178, 0.22=443.66368303448274, 0.23=460.90718799999996, 0.24=482.9174601290322, 0.25=504.92773225806445, 0.26=557.0630479084967, 0.27=625.2602943464052, 0.28=692.5853786028135, 0.29=725.5145668263, 0.3=758.4437550497867, 0.31=789.6286441282051, 0.32=812.0105281754385, 0.33=834.392412222672, 0.34=855.3507512845528, 0.35=868.3343332346109, 0.36=881.317915184669, 0.37=894.3014971347271, 0.38=917.3185590375516, 0.39=940.5091559710058, 0.4=963.69975290446, 0.41=984.8343151859503, 0.42=1004.9095621900827, 0.43=1024.984809194215, 0.44=1043.3602896706193, 0.45=1056.8894120114187, 0.46=1070.418534352218, 0.47=1083.947656693017, 0.48=1102.9090591304348, 0.49=1123.3841996975427, 0.5=1143.8593402646504, 0.51=1165.5221393175234, 0.52=1191.2245930838824, 0.53=1216.9270468502418, 0.54=1242.6295006166008, 0.55=1297.0506648760331, 0.56=1361.0644705785126, 0.57=1425.078276280991, 0.58=1503.4027167945228, 0.59=1608.3854637481113, 0.6=1713.3682107017012, 0.61=1820.9860966120798, 0.62=2026.2591320975607, 0.63=2231.5321675830437, 0.64=2436.8052030685244, 0.65=2834.299514028341, 0.66=3263.657531913633, 0.67=3693.0155497989213, 0.68=4220.078311341871, 0.69=4765.214660997309, 0.7=5310.351010652755, 0.71=5802.80104207843, 0.72=6294.423972746964, 0.73=6935.457013507131, 0.74=7961.1591774866265, 0.75=8986.861341466132, 0.76=10439.559816247318, 0.77=12050.572601177419, 0.78=13527.760279973732, 0.79=14737.917307178981, 0.8=15901.64643833944, 0.81=16611.155986528294, 0.82=17318.975623030306, 0.83=17755.141955874125, 0.84=18191.289858909095, 0.85=18627.334517402596, 0.86=19388.011631999994, 0.87=20689.338345925917, 0.88=25905.84517876544, 0.89=29102.634936421582, 0.9=31179.321141904784, 0.91=34019.01089080584, 0.92=40348.27594072728, 0.93=43600.92432080001, 0.94=44838.18252444444, 0.95=45662.53991071428, 0.96=48265.82262666667, 0.97=61708.013810000055, 0.98=72222.742, 0.99=151408.749}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=MergeProjectWithValues | 5.0 | 5 | 3952.5786 | 2188.821 | 2653.924 | 9181.981 | 9181.981 | {0.0=2188.821, 0.01=2188.821, 0.02=2188.821, 0.03=2188.821, 0.04=2188.821, 0.05=2188.821, 0.06=2188.821, 0.07=2188.821, 0.08=2188.821, 0.09=2188.821, 0.1=2188.821, 0.11=2188.821, 0.12=2188.821, 0.13=2188.821, 0.14=2188.821, 0.15=2188.821, 0.16=2188.821, 0.17=2188.821, 0.18=2188.821, 0.19=2188.821, 0.2=2303.907, 0.21=2303.907, 0.22=2303.907, 0.23=2303.907, 0.24=2303.907, 0.25=2303.907, 0.26=2303.907, 0.27=2303.907, 0.28=2303.907, 0.29=2303.907, 0.3=2303.907, 0.31=2303.907, 0.32=2303.907, 0.33=2303.907, 0.34=2303.907, 0.35=2303.907, 0.36=2303.907, 0.37=2303.907, 0.38=2303.907, 0.39=2303.907, 0.4=2653.924, 0.41=2653.924, 0.42=2653.924, 0.43=2653.924, 0.44=2653.924, 0.45=2653.924, 0.46=2653.924, 0.47=2653.924, 0.48=2653.924, 0.49=2653.924, 0.5=2653.924, 0.51=2653.924, 0.52=2653.924, 0.53=2653.924, 0.54=2653.924, 0.55=2653.924, 0.56=2653.924, 0.57=2653.924, 0.58=2653.924, 0.59=2653.924, 0.6=3434.26, 0.61=3434.26, 0.62=3434.26, 0.63=3434.26, 0.64=3434.26, 0.65=3434.26, 0.66=3434.26, 0.67=3434.26, 0.68=3434.26, 0.69=3434.26, 0.7=3434.26, 0.71=3434.26, 0.72=3434.26, 0.73=3434.26, 0.74=3434.26, 0.75=3434.26, 0.76=3434.26, 0.77=3434.26, 0.78=3434.26, 0.79=3434.26, 0.8=9181.981, 0.81=9181.981, 0.82=9181.981, 0.83=9181.981, 0.84=9181.981, 0.85=9181.981, 0.86=9181.981, 0.87=9181.981, 0.88=9181.981, 0.89=9181.981, 0.9=9181.981, 0.91=9181.981, 0.92=9181.981, 0.93=9181.981, 0.94=9181.981, 0.95=9181.981, 0.96=9181.981, 0.97=9181.981, 0.98=9181.981, 0.99=9181.981}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=MergeUnion | 1534.0 | 1532 | 733.7257522816167 | 10.873 | 656.5550848577085 | 1590.9051850000003 | 6800.843 | {0.0=10.873, 0.01=23.687275000000003, 0.02=38.157255, 0.03=51.25017277777777, 0.04=63.032797, 0.05=75.09445212121213, 0.06=84.46453192358366, 0.07=93.70999625, 0.08=103.9671970261438, 0.09=118.16193419883042, 0.1=131.9653147368421, 0.11=143.732325982684, 0.12=153.7903788688588, 0.13=162.19668225299804, 0.14=172.75808924444445, 0.15=184.14656174139049, 0.16=197.93118342300195, 0.17=210.39884397114002, 0.18=219.95706737085138, 0.19=228.76202297760204, 0.2=235.4022847752891, 0.21=242.0807790785522, 0.22=252.9102311300775, 0.23=263.73968318160274, 0.24=276.1609927417494, 0.25=289.6562847695032, 0.26=303.1924395192177, 0.27=318.53136141425597, 0.28=333.8702833092943, 0.29=348.3494707484143, 0.3=360.66354710359406, 0.31=372.97762345877385, 0.32=385.74795365772434, 0.33=399.1590416059205, 0.34=412.5701295541166, 0.35=426.7340208883911, 0.36=441.9494844525942, 0.37=457.1649480167974, 0.38=471.2052138416088, 0.39=482.7565446167333, 0.4=494.3078753918578, 0.41=506.6030285051546, 0.42=522.8306849637071, 0.43=539.0583414222596, 0.44=555.285997880812, 0.45=572.9150769708847, 0.46=590.5478199109742, 0.47=608.1805628510638, 0.48=624.4084152706076, 0.49=640.4817500641581, 0.5=656.5550848577085, 0.51=674.2478304188407, 0.52=692.1833662, 0.53=710.1189019811594, 0.54=727.168072860281, 0.55=743.9067039233718, 0.56=760.6453349864624, 0.57=778.7719970334832, 0.58=801.8101533313344, 0.59=824.8483096291853, 0.6=847.8864659270364, 0.61=867.7782983797053, 0.62=884.1500723867977, 0.63=900.5218463938897, 0.64=916.8316544710609, 0.65=932.4490178710179, 0.66=948.0663812709748, 0.67=963.6837446709318, 0.68=979.0422954979206, 0.69=994.3570533438123, 0.7=1011.3951845271653, 0.71=1034.7210172205273, 0.72=1058.04684991389, 0.73=1073.475697592337, 0.74=1086.100138931565, 0.75=1102.3842422993241, 0.76=1131.048459500744, 0.77=1159.7126767021641, 0.78=1187.2181890876, 0.79=1214.6146080096196, 0.8=1243.0747277297721, 0.81=1273.6090640062848, 0.82=1303.5211303030303, 0.83=1330.0447012477716, 0.84=1355.857432363636, 0.85=1380.6646122222219, 0.86=1403.533421426901, 0.87=1418.340678883721, 0.88=1430.8161932147004, 0.89=1441.918039025145, 0.9=1452.1481611842107, 0.91=1462.0115910784318, 0.92=1472.3771947736514, 0.93=1482.2179161904762, 0.94=1501.0245922461536, 0.95=1516.5871081818182, 0.96=1529.7694002564103, 0.97=1543.918153846154, 0.98=1560.7230299999999, 0.99=1590.9051850000003}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=PushPredicateIntoTableScan | 13959.0 | 1543 | 252.79564338419658 | 96.332 | 189.90841395349645 | 819.2288279181347 | 22664.323 | {0.0=96.332, 0.01=130.2440556, 0.02=132.9004023972125, 0.03=135.03912759136244, 0.04=137.2693070834006, 0.05=140.82219003565825, 0.06=143.17595495111448, 0.07=144.13358530177064, 0.08=144.78166118266023, 0.09=145.3085813298452, 0.1=145.77716812642626, 0.11=146.2686490978175, 0.12=146.73169325707605, 0.13=147.1775897704333, 0.14=147.61544596387992, 0.15=148.04911113181086, 0.16=148.50032492333156, 0.17=148.97857713834836, 0.18=149.45682935336518, 0.19=150.0560073659091, 0.2=150.6939420336438, 0.21=151.3318767013785, 0.22=152.30009995480876, 0.23=153.38357949766183, 0.24=154.46705904051484, 0.25=155.62215443910003, 0.26=156.8271763199671, 0.27=158.03219820083413, 0.28=159.4648725081566, 0.29=161.49486848582816, 0.3=163.52486446349974, 0.31=165.55486044117134, 0.32=167.5727543807422, 0.33=169.5823675941947, 0.34=171.59198080764716, 0.35=173.16338516070405, 0.36=174.44174224955853, 0.37=175.72009933841304, 0.38=177.0355335034762, 0.39=178.42538540206706, 0.4=179.81523730065797, 0.41=181.20508919924882, 0.42=182.42915929938007, 0.43=183.41144724504773, 0.44=184.39373519071538, 0.45=185.29587472691495, 0.46=186.15792713816404, 0.47=187.02441057711, 0.48=187.98574503590547, 0.49=188.94707949470097, 0.5=189.90841395349645, 0.51=190.86974841229195, 0.52=191.6167853484772, 0.53=192.3509494611217, 0.54=193.0851135737662, 0.55=193.8192776864107, 0.56=194.52628958816962, 0.57=195.22537246129622, 0.58=195.9244553344228, 0.59=196.75455146160544, 0.6=197.803245119165, 0.61=198.85193877672455, 0.62=200.32285679255455, 0.63=202.02222717975604, 0.64=203.97096080789927, 0.65=206.85996259643565, 0.66=209.74896438497206, 0.67=214.22208543005442, 0.68=220.15985610072588, 0.69=225.84237941713653, 0.7=230.8597166550708, 0.71=235.63156791727593, 0.72=238.83485606299035, 0.73=242.03814420870475, 0.74=245.26437230403067, 0.75=248.498551705449, 0.76=252.55208018093396, 0.77=257.4721814168004, 0.78=263.0098880039422, 0.79=269.5408175466944, 0.8=275.9681783167203, 0.81=282.2823587592496, 0.82=288.0571480820655, 0.83=293.6098640585676, 0.84=300.79798491599627, 0.85=308.91686142536344, 0.86=325.98646998508417, 0.87=355.7051229988754, 0.88=414.98558777049465, 0.89=455.9475471322771, 0.9=482.029050122634, 0.91=520.9410308999181, 0.92=577.0032869674382, 0.93=596.7674099431173, 0.94=624.4547881447453, 0.95=642.0586179902684, 0.96=658.5764170568465, 0.97=681.1324146259564, 0.98=720.8177045378151, 0.99=819.2288279181347}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=RemoveRedundantPredicateAboveTableScan | 3072.0 | 0 | 206.355220703125 | 134.475 | 193.47622657840856 | 300.7331085714284 | 27890.556 | {0.0=134.475, 0.01=142.489244, 0.02=148.52828791208793, 0.03=152.332774, 0.04=160.14890331981067, 0.05=169.39686444444445, 0.06=173.59243791570879, 0.07=174.76479995550608, 0.08=175.3079803463845, 0.09=175.72459953786907, 0.1=176.07160729593812, 0.11=176.3243764471954, 0.12=176.5950154371968, 0.13=176.87244034375001, 0.14=177.1843020580357, 0.15=177.4934528123233, 0.16=177.75904747597517, 0.17=178.02658245336355, 0.18=178.31878713397398, 0.19=178.61479166995653, 0.2=178.95055290169756, 0.21=179.2863141334386, 0.22=179.67814954992622, 0.23=180.09860099579785, 0.24=180.51905244166943, 0.25=181.04387861797971, 0.26=181.6037383994633, 0.27=182.18550580650722, 0.28=182.8098294057315, 0.29=183.63223148299585, 0.3=184.74807130559577, 0.31=185.8368922106869, 0.32=186.65839829361602, 0.33=187.47990437654516, 0.34=188.08682620524067, 0.35=188.46827699510854, 0.36=188.84972778497644, 0.37=189.23105874681184, 0.38=189.61224920307595, 0.39=189.99343965934005, 0.4=190.39245025759547, 0.41=190.82003349029804, 0.42=191.24761672300062, 0.43=191.60354341013826, 0.44=191.93729505376348, 0.45=192.2685623431429, 0.46=192.5175146951781, 0.47=192.76646704721333, 0.48=193.0104242958944, 0.49=193.24332543715147, 0.5=193.47622657840856, 0.51=193.72753770405583, 0.52=193.98840891061792, 0.53=194.24928011718, 0.54=194.51306249316, 0.55=194.77821679955534, 0.56=195.04682092580796, 0.57=195.34955624852074, 0.58=195.65229157123352, 0.59=195.96833669191918, 0.6=196.3100869949495, 0.61=196.65183729797982, 0.62=197.04500083378028, 0.63=197.49463464163975, 0.64=197.9442684494992, 0.65=198.38147344339762, 0.66=198.8113241857191, 0.67=199.24117492804052, 0.68=199.6555514319028, 0.69=200.03767440259108, 0.7=200.41979737327935, 0.71=200.80443914206745, 0.72=201.20331048453636, 0.73=201.6021818270053, 0.74=202.0658606186577, 0.75=202.59089703330133, 0.76=203.12174858716676, 0.77=203.8948976086071, 0.78=204.6680466300474, 0.79=205.52105831750032, 0.8=206.55576182720355, 0.81=207.5904653369068, 0.82=208.89422757139468, 0.83=210.26825405303032, 0.84=211.53708591450214, 0.85=213.05610750179807, 0.86=214.84778483111455, 0.87=216.75542815274585, 0.88=218.77488523167307, 0.89=220.67904981969556, 0.9=222.6424913873874, 0.91=224.86541803921568, 0.92=227.60546000000002, 0.93=230.96402389863545, 0.94=234.97928248366006, 0.95=241.27417454545446, 0.96=248.3554098325123, 0.97=256.216932937063, 0.98=271.79606595238096, 0.99=300.7331085714284}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=RemoveRedundantSort | 24.0 | 0 | 147.56154166666667 | 5.613 | 15.089 | 3000.007 | 3000.007 | {0.0=5.613, 0.01=5.613, 0.02=5.613, 0.03=5.613, 0.04=5.613, 0.05=6.254, 0.06=6.254, 0.07=6.254, 0.08=6.254, 0.09=7.12, 0.1=7.12, 0.11=7.12, 0.12=7.12, 0.13=7.13, 0.14=7.13, 0.15=7.13, 0.16=7.13, 0.17=7.302, 0.18=7.302, 0.19=7.302, 0.2=7.302, 0.21=8.856, 0.22=8.856, 0.23=8.856, 0.24=8.856, 0.25=8.972, 0.26=8.972, 0.27=8.972, 0.28=8.972, 0.29=8.972, 0.3=9.051, 0.31=9.051, 0.32=9.051, 0.33=9.051, 0.34=10.567, 0.35=10.567, 0.36=10.567, 0.37=10.567, 0.38=12.34, 0.39=12.34, 0.4=12.34, 0.41=12.34, 0.42=13.236, 0.43=13.236, 0.44=13.236, 0.45=13.236, 0.46=14.654, 0.47=14.654, 0.48=14.654, 0.49=14.654, 0.5=15.089, 0.51=15.089, 0.52=15.089, 0.53=15.089, 0.54=15.089, 0.55=16.462, 0.56=16.462, 0.57=16.462, 0.58=16.462, 0.59=18.905, 0.6=18.905, 0.61=18.905, 0.62=18.905, 0.63=26.681, 0.64=26.681, 0.65=26.681, 0.66=26.681, 0.67=27.864, 0.68=27.864, 0.69=27.864, 0.7=27.864, 0.71=29.866, 0.72=29.866, 0.73=29.866, 0.74=29.866, 0.75=30.445, 0.76=30.445, 0.77=30.445, 0.78=30.445, 0.79=30.445, 0.8=31.664, 0.81=31.664, 0.82=31.664, 0.83=31.664, 0.84=54.058, 0.85=54.058, 0.86=54.058, 0.87=54.058, 0.88=79.086, 0.89=79.086, 0.9=79.086, 0.91=79.086, 0.92=100.255, 0.93=100.255, 0.94=100.255, 0.95=100.255, 0.96=3000.007, 0.97=3000.007, 0.98=3000.007, 0.99=3000.007}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=PruneExchangeColumns | 5.0 | 0 | 113.57260000000001 | 19.448 | 44.342 | 412.366 | 412.366 | {0.0=19.448, 0.01=19.448, 0.02=19.448, 0.03=19.448, 0.04=19.448, 0.05=19.448, 0.06=19.448, 0.07=19.448, 0.08=19.448, 0.09=19.448, 0.1=19.448, 0.11=19.448, 0.12=19.448, 0.13=19.448, 0.14=19.448, 0.15=19.448, 0.16=19.448, 0.17=19.448, 0.18=19.448, 0.19=19.448, 0.2=40.905, 0.21=40.905, 0.22=40.905, 0.23=40.905, 0.24=40.905, 0.25=40.905, 0.26=40.905, 0.27=40.905, 0.28=40.905, 0.29=40.905, 0.3=40.905, 0.31=40.905, 0.32=40.905, 0.33=40.905, 0.34=40.905, 0.35=40.905, 0.36=40.905, 0.37=40.905, 0.38=40.905, 0.39=40.905, 0.4=44.342, 0.41=44.342, 0.42=44.342, 0.43=44.342, 0.44=44.342, 0.45=44.342, 0.46=44.342, 0.47=44.342, 0.48=44.342, 0.49=44.342, 0.5=44.342, 0.51=44.342, 0.52=44.342, 0.53=44.342, 0.54=44.342, 0.55=44.342, 0.56=44.342, 0.57=44.342, 0.58=44.342, 0.59=44.342, 0.6=50.802, 0.61=50.802, 0.62=50.802, 0.63=50.802, 0.64=50.802, 0.65=50.802, 0.66=50.802, 0.67=50.802, 0.68=50.802, 0.69=50.802, 0.7=50.802, 0.71=50.802, 0.72=50.802, 0.73=50.802, 0.74=50.802, 0.75=50.802, 0.76=50.802, 0.77=50.802, 0.78=50.802, 0.79=50.802, 0.8=412.366, 0.81=412.366, 0.82=412.366, 0.83=412.366, 0.84=412.366, 0.85=412.366, 0.86=412.366, 0.87=412.366, 0.88=412.366, 0.89=412.366, 0.9=412.366, 0.91=412.366, 0.92=412.366, 0.93=412.366, 0.94=412.366, 0.95=412.366, 0.96=412.366, 0.97=412.366, 0.98=412.366, 0.99=412.366}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=PruneExchangeSourceColumns | 41.0 | 0 | 109.55182926829268 | 2.156 | 6.693 | 2067.481 | 2067.481 | {0.0=2.156, 0.01=2.156, 0.02=2.156, 0.03=3.076, 0.04=3.076, 0.05=3.163, 0.06=3.163, 0.07=3.163, 0.08=3.187, 0.09=3.187, 0.1=3.317, 0.11=3.317, 0.12=3.317, 0.13=3.682, 0.14=3.682, 0.15=3.979, 0.16=3.979, 0.17=3.979, 0.18=4.182, 0.19=4.182, 0.2=4.276, 0.21=4.276, 0.22=5.028, 0.23=5.028, 0.24=5.028, 0.25=5.63, 0.26=5.63, 0.27=6.036, 0.28=6.036, 0.29=6.036, 0.3=6.128, 0.31=6.128, 0.32=6.292, 0.33=6.292, 0.34=6.292, 0.35=6.295, 0.36=6.295, 0.37=6.295, 0.38=6.295, 0.39=6.295, 0.4=6.331, 0.41=6.331, 0.42=6.372, 0.43=6.372, 0.44=6.527, 0.45=6.527, 0.46=6.527, 0.47=6.556, 0.48=6.556, 0.49=6.693, 0.5=6.693, 0.51=6.693, 0.52=6.94, 0.53=6.94, 0.54=7.496, 0.55=7.496, 0.56=7.496, 0.57=7.582, 0.58=7.582, 0.59=7.655, 0.6=7.655, 0.61=7.787, 0.62=7.787, 0.63=7.787, 0.64=7.792, 0.65=7.792, 0.66=7.987, 0.67=7.987, 0.68=7.987, 0.69=8.207, 0.7=8.207, 0.71=8.668, 0.72=8.668, 0.73=8.668, 0.74=9.217, 0.75=9.217, 0.76=9.377, 0.77=9.377, 0.78=9.377, 0.79=9.446, 0.8=9.446, 0.81=10.143, 0.82=10.143, 0.83=14.854, 0.84=14.854, 0.85=14.854, 0.86=16.661, 0.87=16.661, 0.88=24.572, 0.89=24.572, 0.9=24.572, 0.91=33.691, 0.92=33.691, 0.93=197.621, 0.94=197.621, 0.95=197.621, 0.96=1923.247, 0.97=1923.247, 0.98=2067.481, 0.99=2067.481}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=PruneLimitColumns | 6.0 | 6 | 88.106 | 22.23 | 26.72 | 404.305 | 404.305 | {0.0=22.23, 0.01=22.23, 0.02=22.23, 0.03=22.23, 0.04=22.23, 0.05=22.23, 0.06=22.23, 0.07=22.23, 0.08=22.23, 0.09=22.23, 0.1=22.23, 0.11=22.23, 0.12=22.23, 0.13=22.23, 0.14=22.23, 0.15=22.23, 0.16=22.23, 0.17=23.112, 0.18=23.112, 0.19=23.112, 0.2=23.112, 0.21=23.112, 0.22=23.112, 0.23=23.112, 0.24=23.112, 0.25=23.112, 0.26=23.112, 0.27=23.112, 0.28=23.112, 0.29=23.112, 0.3=23.112, 0.31=23.112, 0.32=23.112, 0.33=23.112, 0.34=23.351, 0.35=23.351, 0.36=23.351, 0.37=23.351, 0.38=23.351, 0.39=23.351, 0.4=23.351, 0.41=23.351, 0.42=23.351, 0.43=23.351, 0.44=23.351, 0.45=23.351, 0.46=23.351, 0.47=23.351, 0.48=23.351, 0.49=23.351, 0.5=26.72, 0.51=26.72, 0.52=26.72, 0.53=26.72, 0.54=26.72, 0.55=26.72, 0.56=26.72, 0.57=26.72, 0.58=26.72, 0.59=26.72, 0.6=26.72, 0.61=26.72, 0.62=26.72, 0.63=26.72, 0.64=26.72, 0.65=26.72, 0.66=26.72, 0.67=28.918, 0.68=28.918, 0.69=28.918, 0.7=28.918, 0.71=28.918, 0.72=28.918, 0.73=28.918, 0.74=28.918, 0.75=28.918, 0.76=28.918, 0.77=28.918, 0.78=28.918, 0.79=28.918, 0.8=28.918, 0.81=28.918, 0.82=28.918, 0.83=28.918, 0.84=404.305, 0.85=404.305, 0.86=404.305, 0.87=404.305, 0.88=404.305, 0.89=404.305, 0.9=404.305, 0.91=404.305, 0.92=404.305, 0.93=404.305, 0.94=404.305, 0.95=404.305, 0.96=404.305, 0.97=404.305, 0.98=404.305, 0.99=404.305}
trino.sql.planner.iterative:name=IterativeOptimizer,rule=PushDownDereferencesThroughLimit | 6.0 | 0 | 80.8655 | 12.992 | 15.877 | 411.725 | 411.725 | {0.0=12.992, 0.01=12.992, 0.02=12.992, 0.03=12.992, 0.04=12.992, 0.05=12.992, 0.06=12.992, 0.07=12.992, 0.08=12.992, 0.09=12.992, 0.1=12.992, 0.11=12.992, 0.12=12.992, 0.13=12.992, 0.14=12.992, 0.15=12.992, 0.16=12.992, 0.17=13.496, 0.18=13.496, 0.19=13.496, 0.2=13.496, 0.21=13.496, 0.22=13.496, 0.23=13.496, 0.24=13.496, 0.25=13.496, 0.26=13.496, 0.27=13.496, 0.28=13.496, 0.29=13.496, 0.3=13.496, 0.31=13.496, 0.32=13.496, 0.33=13.496, 0.34=13.692, 0.35=13.692, 0.36=13.692, 0.37=13.692, 0.38=13.692, 0.39=13.692, 0.4=13.692, 0.41=13.692, 0.42=13.692, 0.43=13.692, 0.44=13.692, 0.45=13.692, 0.46=13.692, 0.47=13.692, 0.48=13.692, 0.49=13.692, 0.5=15.877, 0.51=15.877, 0.52=15.877, 0.53=15.877, 0.54=15.877, 0.55=15.877, 0.56=15.877, 0.57=15.877, 0.58=15.877, 0.59=15.877, 0.6=15.877, 0.61=15.877, 0.62=15.877, 0.63=15.877, 0.64=15.877, 0.65=15.877, 0.66=15.877, 0.67=17.411, 0.68=17.411, 0.69=17.411, 0.7=17.411, 0.71=17.411, 0.72=17.411, 0.73=17.411, 0.74=17.411, 0.75=17.411, 0.76=17.411, 0.77=17.411, 0.78=17.411, 0.79=17.411, 0.8=17.411, 0.81=17.411, 0.82=17.411, 0.83=17.411, 0.84=411.725, 0.85=411.725, 0.86=411.725, 0.87=411.725, 0.88=411.725, 0.89=411.725, 0.9=411.725, 0.91=411.725, 0.92=411.725, 0.93=411.725, 0.94=411.725, 0.95=411.725, 0.96=411.725, 0.97=411.725, 0.98=411.725, 0.99=411.725}
(10 rows)
sql:SELECT object_name, "time.count", "hits", "time.avg", "time.min", "time.p50", "time.p99", "time.max", "time.percentiles"
FROM jmx.current."trino.sql.planner.iterative:name=*"
WHERE "time.count" > 0
ORDER BY "time.avg" DESC limit 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment