work_mem设置为2G!
一共16张表采用Merge join方式。
Sort Method: 一共使用到3种分别为 并分别统计他们的width!
Sort Method: quicksort Memory:93,37,77,61,101,45,61,53
Sort Method: external sort Disk: 117,125,125,117
Sort Method: external merge Disk:173,213,317,341
width表示平均每行宽度。
则可认为表的宽度大小,决定了排序方式。
同时观察得知除了第一次出现Sort Method: external merge Disk。
如果内层是 Sort Method: external merge Disk: 外层会有materialized。
另外猜想一下 Sort 浪费了大量的时间。是否可以创建排序的索引和join的一致?这样就不会再次进行排序?
有待进行测试验证。
下面贴上执行计划
"Merge Left Join (cost=31776857.83..40879537.65 rows=9032851 width=1733) (actual time=2480147.961..3232391.478 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, ((100::double precision * s0.c67190699) / CASE WHEN ((s0.c67190698 = 0::double precision) OR (s0.c67190698 IS NULL)) THEN NULL::double precision ELSE s0.c67190698 END), s1.c67192115, s1.c67192110, s6.c67199806, s11.c67181072, s5. (...)"
" Merge Cond: (((s0.mo)::text = (s15.mo)::text) AND (s0.rtime = s15.rtime) AND ((s0.rnc)::text = (s15.rnc)::text))"
" -> Merge Left Join (cost=29638965.62..33187689.37 rows=9032851 width=1709) (actual time=2334342.017..2882417.488 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c67189832, s0.c67189833, s0.c67191158, (...)"
" Merge Cond: (((s0.mo)::text = (s14.mo)::text) AND (s0.rtime = s14.rtime) AND ((s0.rnc)::text = (s14.rnc)::text))"
" -> Merge Left Join (cost=28247502.13..31549280.89 rows=9032851 width=1613) (actual time=2074445.177..2585164.706 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c67189832, s0.c67189833, s0.c671 (...)"
" Merge Cond: (((s0.mo)::text = (s13.mo)::text) AND (s0.rtime = s13.rtime) AND ((s0.rnc)::text = (s13.rnc)::text))"
" -> Merge Left Join (cost=26903329.98..29957856.35 rows=9032851 width=1573) (actual time=1957411.422..2432414.106 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c67189832, s0.c67189833, s (...)"
" Merge Cond: (((s0.mo)::text = (s12.mo)::text) AND (s0.rtime = s12.rtime) AND ((s0.rnc)::text = (s12.rnc)::text))"
" -> Merge Left Join (cost=25407866.49..28215144.31 rows=9032851 width=1549) (actual time=1855017.128..2294874.213 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c67189832, s0.c67189 (...)"
" Merge Cond: (((s0.mo)::text = (s11.mo)::text) AND (s0.rtime = s11.rtime) AND ((s0.rnc)::text = (s11.rnc)::text))"
" -> Merge Left Join (cost=21046501.74..23584030.12 rows=9032851 width=1229) (actual time=1597679.070..1979020.602 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c67189832, s0. (...)"
" Merge Cond: (((s0.mo)::text = (s10.mo)::text) AND (s0.rtime = s10.rtime) AND ((s0.rnc)::text = (s10.rnc)::text))"
" -> Merge Left Join (cost=19692123.03..21982424.50 rows=9032851 width=1125) (actual time=1448162.630..1793365.715 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c6718983 (...)"
" Merge Cond: (((s0.mo)::text = (s9.mo)::text) AND (s0.rtime = s9.rtime) AND ((s0.rnc)::text = (s9.rnc)::text))"
" -> Merge Left Join (cost=18223411.02..20266195.29 rows=9032851 width=1045) (actual time=1337670.507..1647478.160 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, s0.c6 (...)"
" Merge Cond: (((s0.mo)::text = (s8.mo)::text) AND (s0.rtime = s8.rtime) AND ((s0.rnc)::text = (s8.rnc)::text))"
" -> Merge Left Join (cost=16659046.83..18454853.54 rows=9032851 width=1005) (actual time=1219502.809..1495636.560 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c67191164, (...)"
" Merge Cond: (((s0.mo)::text = (s7.mo)::text) AND (s0.rtime = s7.rtime) AND ((s0.rnc)::text = (s7.rnc)::text))"
" -> Merge Left Join (cost=12907315.74..14433386.16 rows=9032851 width=709) (actual time=998859.346..1221422.268 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s0.c671 (...)"
" Merge Cond: (((s0.mo)::text = (s6.mo)::text) AND (s0.rtime = s6.rtime) AND ((s0.rnc)::text = (s6.rnc)::text))"
" -> Merge Left Join (cost=11208470.31..12487749.03 rows=9032851 width=605) (actual time=827127.973..1014507.341 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194869, s (...)"
" Merge Cond: (((s0.mo)::text = (s5.mo)::text) AND (s0.rtime = s5.rtime) AND ((s0.rnc)::text = (s5.rnc)::text))"
" -> Merge Left Join (cost=8326742.49..9336620.60 rows=9032851 width=413) (actual time=652408.317..793284.299 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0.c67194 (...)"
" Merge Cond: (((s0.mo)::text = (s4.mo)::text) AND (s0.rtime = s4.rtime) AND ((s0.rnc)::text = (s4.rnc)::text))"
" -> Merge Left Join (cost=6934749.19..7697632.05 rows=9032851 width=357) (actual time=545517.896..654234.626 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c67202894, s0. (...)"
" Merge Cond: (((s0.mo)::text = (s3.mo)::text) AND (s0.rtime = s3.rtime) AND ((s0.rnc)::text = (s3.rnc)::text))"
" -> Merge Left Join (cost=5636412.96..6152554.87 rows=9032851 width=341) (actual time=448350.000..526112.373 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c6720289 (...)"
" Merge Cond: (((s0.mo)::text = (s2.mo)::text) AND (s0.rtime = s2.rtime) AND ((s0.rnc)::text = (s2.rnc)::text))"
" -> Merge Left Join (cost=4276390.68..4545934.02 rows=9032851 width=269) (actual time=344431.555..391452.172 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, s0.c6 (...)"
" Merge Cond: (((s0.mo)::text = (s1.mo)::text) AND (s0.rtime = s1.rtime) AND ((s0.rnc)::text = (s1.rnc)::text))"
" -> Sort (cost=2138108.66..2160690.79 rows=9032851 width=173) (actual time=169975.765..180154.269 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c67194867, (...)"
" Sort Key: s0.mo, s0.rtime, s0.rnc"
" Sort Method : external merge Disk: 1642344kB"
" -> Seq Scan on public.hup_hsdpa_cell_30 s0 (cost=0.00..1094509.51 rows=9032851 width=173) (actual time=14.202..47660.050 rows=9032851 loops=1)"
" Output: s0.mo, s0.rtime, s0.c67190699, s0.c67190698, s0.c67194871, s0.c67191162, s0.c67202932, s0.c67191163, s0.c73423900, s0.c73423901, s0.c67202941, s0.c671 (...)"
" -> Sort (cost=2138273.82..2160859.54 rows=9034291 width=117) (actual time=174455.752..179854.270 rows=9032851 loops=1)"
" Output: s1.c67192115, s1.c67192110, s1.c67192114, s1.c67192364, s1.c67203932, s1.c73391136, s1.c67203850, s1.c67192365, s1.c67192472, s1.c67192474, s1.c67192481, s1 (...)"
" Sort Key: s1.mo, s1.rtime, s1.rnc"
" Sort Method: external sort Disk: 1162336kB"
" -> Seq Scan on public.hup_hsupa_cell_30 s1 (cost=0.00..1094497.91 rows=9034291 width=117) (actual time=32.428..46500.714 rows=9032851 loops=1)"
" Output: s1.c67192115, s1.c67192110, s1.c67192114, s1.c67192364, s1.c67203932, s1.c73391136, s1.c67203850, s1.c67192365, s1.c67192472, s1.c67192474, s1.c671924 (...)"
" -> Sort (cost=1360014.06..1382594.47 rows=9032161 width=93) (actual time=103918.432..106446.649 rows=9032851 loops=1)"
" Output: s2.c67190407, s2.c67189494, s2.c67192610, s2.c67190406, s2.c67192611, s2.c67193612, s2.c67193611, s2.c67179864, s2.c67189495, s2.rtime, s2.rnc, s2.mo"
" Sort Key: s2.mo, s2.rtime, s2.rnc"
" Sort Method: quicksort Memory: 1569838kB"
" -> Seq Scan on public.hup_rab_estfailcs_cell_30 s2 (cost=0.00..316499.61 rows=9032161 width=93) (actual time=117.738..19199.402 rows=9032851 loops=1)"
" Output: s2.c67190407, s2.c67189494, s2.c67192610, s2.c67190406, s2.c67192611, s2.c67193612, s2.c67193611, s2.c67179864, s2.c67189495, s2.rtime, s2.rnc, s2.mo"
" -> Sort (cost=1298328.03..1320906.32 rows=9031317 width=37) (actual time=97167.883..100673.568 rows=9032851 loops=1)"
" Output: s3.c73440131, s3.c73440132, s3.rtime, s3.rnc, s3.mo"
" Sort Key: s3.mo, s3.rtime, s3.rnc"
" Sort Method: quicksort Memory: 1098908kB"
" -> Seq Scan on public.hup_mear_report_cell_30 s3 (cost=0.00..254917.17 rows=9031317 width=37) (actual time=7.958..10467.885 rows=9032851 loops=1)"
" Output: s3.c73440131, s3.c73440132, s3.rtime, s3.rnc, s3.mo"
" -> Sort (cost=1391985.11..1414560.20 rows=9030037 width=77) (actual time=106890.408..110578.975 rows=9032851 loops=1)"
" Output: s4.c67192608, s4.c67193609, s4.c67193610, s4.c67192609, s4.c67190404, s4.c67190405, s4.c67179524, s4.rtime, s4.rnc, s4.mo"
" Sort Key: s4.mo, s4.rtime, s4.rnc"
" Sort Method: quicksort Memory: 1569838kB"
" -> Seq Scan on public.hup_rrc_setupfail_cell_30 s4 (cost=0.00..348731.37 rows=9030037 width=77) (actual time=22.976..16924.873 rows=9032851 loops=1)"
" Output: s4.c67192608, s4.c67193609, s4.c67193610, s4.c67192609, s4.c67190404, s4.c67190405, s4.c67179524, s4.rtime, s4.rnc, s4.mo"
" -> Materialize (cost=2881719.60..2926882.05 rows=9032489 width=213) (actual time=174719.641..190057.067 rows=9032851 loops=1)"
" Output: s5.c67180076, s5.c67180082, s5.c67190467, s5.c67190468, s5.c67190469, s5.c67190470, s5.c67192600, s5.c67190518, s5.c67191786, s5.c67180067, s5.c67180074, s5.c67180068, s5.c67180080 (...)"
" -> Sort (cost=2881719.60..2904300.83 rows=9032489 width=213) (actual time=174719.624..187072.163 rows=9032851 loops=1)"
" Output: s5.c67180076, s5.c67180082, s5.c67190467, s5.c67190468, s5.c67190469, s5.c67190470, s5.c67192600, s5.c67190518, s5.c67191786, s5.c67180067, s5.c67180074, s5.c67180068, s5.c67 (...)"
" Sort Key: s5.mo, s5.rtime, s5.rnc"
" Sort Method: external merge Disk: 1974672kB"
" -> Seq Scan on public.hup_rab_relabnormal_cell_30 s5 (cost=0.00..911980.89 rows=9032489 width=213) (actual time=38.997..38505.984 rows=9032851 loops=1)"
" Output: s5.c67180076, s5.c67180082, s5.c67190467, s5.c67190468, s5.c67190469, s5.c67190470, s5.c67192600, s5.c67190518, s5.c67191786, s5.c67180067, s5.c67180074, s5.c67180068, (...)"
" -> Sort (cost=1698837.21..1721417.54 rows=9032132 width=125) (actual time=171731.348..177007.792 rows=9032851 loops=1)"
" Output: s6.c67199806, s6.c67199812, s6.c67199810, s6.c73410495, s6.c67199809, s6.c67199797, s6.c67199807, s6.c67199808, s6.c73410496, s6.c73394082, s6.c67202447, s6.c67199813, s6.c67199811, s6.r (...)"
" Sort Key: s6.mo, s6.rtime, s6.rnc"
" Sort Method: external sort Disk: 1232976kB"
" -> Seq Scan on public.hup_bler_cell_30 s6 (cost=0.00..655326.32 rows=9032132 width=125) (actual time=24.477..27987.303 rows=9032851 loops=1)"
" Output: s6.c67199806, s6.c67199812, s6.c67199810, s6.c73410495, s6.c67199809, s6.c67199797, s6.c67199807, s6.c67199808, s6.c73410496, s6.c73394082, s6.c67202447, s6.c67199813, s6.c67199811 (...)"
" -> Materialize (cost=3751722.88..3796873.89 rows=9030201 width=317) (actual time=220643.450..240930.411 rows=9032851 loops=1)"
" Output: s7.c67179457, s7.c67179458, s7.c67179459, s7.c67179460, s7.c67179461, s7.c67179462, s7.c67179463, s7.c67179464, s7.c67179465, s7.c67179466, s7.c67179476, s7.c67179471, s7.c67179472, s7.c671794 (...)"
" -> Sort (cost=3751722.88..3774298.38 rows=9030201 width=317) (actual time=220643.431..238018.264 rows=9032851 loops=1)"
" Output: s7.c67179457, s7.c67179458, s7.c67179459, s7.c67179460, s7.c67179461, s7.c67179462, s7.c67179463, s7.c67179464, s7.c67179465, s7.c67179466, s7.c67179476, s7.c67179471, s7.c67179472, s7.c (...)"
" Sort Key: s7.mo, s7.rtime, s7.rnc"
" Sort Method: external merge Disk: 2892960kB"
" -> Seq Scan on public.hup_rrc_setup_cell_30 s7 (cost=0.00..1381256.01 rows=9030201 width=317) (actual time=20.662..63112.017 rows=9032851 loops=1)"
" Output: s7.c67179457, s7.c67179458, s7.c67179459, s7.c67179460, s7.c67179461, s7.c67179462, s7.c67179463, s7.c67179464, s7.c67179465, s7.c67179466, s7.c67179476, s7.c67179471, s7.c67179472 (...)"
" -> Sort (cost=1564355.99..1586936.13 rows=9032055 width=61) (actual time=118167.670..122005.756 rows=9032851 loops=1)"
" Output: s8.c73393920, s8.c73393918, s8.c73393916, s8.c67179825, s8.c67179826, s8.rtime, s8.rnc, s8.mo"
" Sort Key: s8.mo, s8.rtime, s8.rnc"
" Sort Method: quicksort Memory: 1569838kB"
" -> Seq Scan on public.hup_rab_estabcs_cell_30 s8 (cost=0.00..520854.55 rows=9032055 width=61) (actual time=27.183..24054.795 rows=9032851 loops=1)"
" Output: s8.c73393920, s8.c73393918, s8.c73393916, s8.c67179825, s8.c67179826, s8.rtime, s8.rnc, s8.mo"
" -> Sort (cost=1468703.80..1491282.75 rows=9031579 width=101) (actual time=110492.109..114719.530 rows=9032851 loops=1)"
" Output: s9.c67180522, s9.c67180521, s9.c73393850, s9.c73393849, s9.c67180499, s9.c67180509, s9.c67180498, s9.c67180508, s9.c67180520, s9.c67180519, s9.rtime, s9.rnc, s9.mo"
" Sort Key: s9.mo, s9.rtime, s9.rnc"
" Sort Method: quicksort Memory: 1569838kB"
" -> Seq Scan on public.hup_sho_cell_30 s9 (cost=0.00..425260.79 rows=9031579 width=101) (actual time=11.420..17694.308 rows=9032851 loops=1)"
" Output: s9.c67180522, s9.c67180521, s9.c73393850, s9.c73393849, s9.c67180499, s9.c67180509, s9.c67180498, s9.c67180508, s9.c67180520, s9.c67180519, s9.rtime, s9.rnc, s9.mo"
" -> Sort (cost=1354370.50..1376948.47 rows=9031185 width=125) (actual time=149516.418..155171.788 rows=9032851 loops=1)"
" Output: s10.c73393919, s10.c67179921, s10.c67179924, s10.c67179923, s10.c67179922, s10.c73393917, s10.c67179925, s10.c67179926, s10.c67179927, s10.c67179928, s10.c73393921, s10.c73403808, s10.c73403809, s10.rtime, s10. (...)"
" Sort Key: s10.mo, s10.rtime, s10.rnc"
" Sort Method: external sort Disk: 1232976kB"
" -> Seq Scan on public.hup_rab_estabps_cell_30 s10 (cost=0.00..310975.85 rows=9031185 width=125) (actual time=15.642..13566.278 rows=9032851 loops=1)"
" Output: s10.c73393919, s10.c67179921, s10.c67179924, s10.c67179923, s10.c67179922, s10.c73393917, s10.c67179925, s10.c67179926, s10.c67179927, s10.c67179928, s10.c73393921, s10.c73403808, s10.c73403809, s10.rtime (...)"
" -> Materialize (cost=4361356.54..4406522.90 rows=9033272 width=341) (actual time=257338.040..280518.348 rows=9032851 loops=1)"
" Output: s11.c67181072, s11.c67191150, s11.c67192920, s11.c67181080, s11.c67181071, s11.c67191843, s11.c67192939, s11.c67192940, s11.c67203402, s11.c67204839, s11.c73393961, s11.c67192917, s11.c67192916, s11.c67181076, s11.c6 (...)"
" -> Sort (cost=4361356.54..4383939.72 rows=9033272 width=341) (actual time=257338.023..277128.585 rows=9032851 loops=1)"
" Output: s11.c67181072, s11.c67191150, s11.c67192920, s11.c67181080, s11.c67181071, s11.c67191843, s11.c67192939, s11.c67192940, s11.c67203402, s11.c67204839, s11.c73393961, s11.c67192917, s11.c67192916, s11.c67181076, (...)"
" Sort Key: s11.mo, s11.rtime, s11.rnc"
" Sort Method: external merge Disk: 3104880kB"
" -> Seq Scan on public.hup_algo_cell_30 s11 (cost=0.00..1897433.72 rows=9033272 width=341) (actual time=15.709..88632.845 rows=9032851 loops=1)"
" Output: s11.c67181072, s11.c67191150, s11.c67192920, s11.c67181080, s11.c67181071, s11.c67191843, s11.c67192939, s11.c67192940, s11.c67203402, s11.c67204839, s11.c73393961, s11.c67192917, s11.c67192916, s11.c6718 (...)"
" -> Sort (cost=1495455.29..1518033.87 rows=9031432 width=45) (actual time=102394.277..106393.162 rows=9032851 loops=1)"
" Output: s12.c73441215, s12.c73441212, s12.c73441505, s12.rtime, s12.rnc, s12.mo"
" Sort Key: s12.mo, s12.rtime, s12.rnc"
" Sort Method: quicksort Memory: 1098908kB"
" -> Seq Scan on public.hup_algo2_cell_30 s12 (cost=0.00..452030.32 rows=9031432 width=45) (actual time=15.150..17206.352 rows=9032851 loops=1)"
" Output: s12.c73441215, s12.c73441212, s12.c73441505, s12.rtime, s12.rnc, s12.mo"
" -> Sort (cost=1344163.95..1366742.86 rows=9031565 width=61) (actual time=117033.724..121292.344 rows=9032851 loops=1)"
" Output: s13.c67199617, s13.c73415859, s13.c67202984, s13.c67199618, s13.c67202902, s13.rtime, s13.rnc, s13.mo"
" Sort Key: s13.mo, s13.rtime, s13.rnc"
" Sort Method: quicksort Memory: 1569838kB"
" -> Seq Scan on public.hup_rtwptcp_cell_30 s13 (cost=0.00..300722.65 rows=9031565 width=61) (actual time=22.683..25581.128 rows=9032851 loops=1)"
" Output: s13.c67199617, s13.c73415859, s13.c67202984, s13.c67199618, s13.c67202902, s13.rtime, s13.rnc, s13.mo"
" -> Sort (cost=1391455.28..1414020.05 rows=9025910 width=117) (actual time=259895.782..265442.524 rows=9032851 loops=1)"
" Output: s14.c73424888, s14.c67190409, s14.c67192612, s14.c73424889, s14.c67189556, s14.c67179967, s14.c67193613, s14.c67192613, s14.c67190408, s14.c67193614, s14.c73393837, s14.c73394298, s14.rtime, s14.rnc, s14.mo"
" Sort Key: s14.mo, s14.rtime, s14.rnc"
" Sort Method: external sort Disk: 1162336kB"
" -> Seq Scan on public.hup_rab_estfailps_cell_30 s14 (cost=0.00..348708.10 rows=9025910 width=117) (actual time=20.940..112302.513 rows=9032851 loops=1)"
" Output: s14.c73424888, s14.c67190409, s14.c67192612, s14.c73424889, s14.c67189556, s14.c67179967, s14.c67193613, s14.c67192613, s14.c67190408, s14.c67193614, s14.c73393837, s14.c73394298, s14.rtime, s14.rnc, s14.mo"
" -> Sort (cost=2137884.00..2160462.69 rows=9031475 width=53) (actual time=145803.872..149677.486 rows=9032851 loops=1)"
" Output: s15.c67204785, s15.c67204787, s15.c67204789, s15.c67204788, s15.rtime, s15.rnc, s15.mo"
" Sort Key: s15.mo, s15.rtime, s15.rnc"
" Sort Method: quicksort Memory: 1569838kB"
" -> Seq Scan on public.hup_qos_cell_30 s15 (cost=0.00..1094453.75 rows=9031475 width=53) (actual time=24.230..55985.272 rows=9032851 loops=1)"
" Output: s15.c67204785, s15.c67204787, s15.c67204789, s15.c67204788, s15.rtime, s15.rnc, s15.mo"
"Total runtime: 3236549.528 ms"
"Merge Left Join (cost=17923794.70..18215923.96 rows=9032851 width=1714) (actual time=439798.938..499586.575 rows=9032851 loops=1)"
" Output: s0.rtime, s0.rnc, s0.mo, s0.c73410491, s0.c73410492, s0.c73410493, s0.c73410484, s0.c67195481, s0.c67195484, s0.c67195507, s0.c67195511, s0.c67195510, s0.c73423469, s0.c73423462, s0.c67195509, s0.c67195508, s0.c67195512, s0.c67195483, s0.c6719548 (...)"
" Merge Cond: ((s0.rtime = s1.rtime) AND ((s0.rnc)::text = (s1.rnc)::text) AND ((s0.mo)::text = (s1.mo)::text))"
" -> Sort (cost=8992137.66..9014719.79 rows=9032851 width=861) (actual time=197172.576..203142.206 rows=9032851 loops=1)"
" Output: s0.rtime, s0.rnc, s0.mo, s0.c73410491, s0.c73410492, s0.c73410493, s0.c73410484, s0.c67195481, s0.c67195484, s0.c67195507, s0.c67195511, s0.c67195510, s0.c73423469, s0.c73423462, s0.c67195509, s0.c67195508, s0.c67195512, s0.c67195483, s0.c6 (...)"
" Sort Key: s0.rtime, s0.rnc, s0.mo"
" Sort Method: external merge Disk: 7717272kB"
" -> Seq Scan on public.hup_hsdpa_cell_30 s0 (cost=0.00..1094509.51 rows=9032851 width=861) (actual time=20.036..42738.309 rows=9032851 loops=1)"
" Output: s0.rtime, s0.rnc, s0.mo, s0.c73410491, s0.c73410492, s0.c73410493, s0.c73410484, s0.c67195481, s0.c67195484, s0.c67195507, s0.c67195511, s0.c67195510, s0.c73423469, s0.c73423462, s0.c67195509, s0.c67195508, s0.c67195512, s0.c67195483, (...)"
" -> Materialize (cost=8931640.82..8976812.27 rows=9034291 width=853) (actual time=242626.332..250640.058 rows=9032851 loops=1)"
" Output: s1.rtime, s1.rnc, s1.mo, s1.c73441236, s1.c73410485, s1.c73410507, s1.c67204515, s1.c67195487, s1.c67195486, s1.c73423362, s1.c73423361, s1.c73423360, s1.c67195488, s1.c67195485, s1.c67194889, s1.c67192365, s1.c67192364, s1.c73424967, s1.c6 (...)"
" -> Sort (cost=8931640.82..8954226.54 rows=9034291 width=853) (actual time=242626.312..248680.814 rows=9032851 loops=1)"
" Output: s1.rtime, s1.rnc, s1.mo, s1.c73441236, s1.c73410485, s1.c73410507, s1.c67204515, s1.c67195487, s1.c67195486, s1.c73423362, s1.c73423361, s1.c73423360, s1.c67195488, s1.c67195485, s1.c67194889, s1.c67192365, s1.c67192364, s1.c73424967, (...)"
" Sort Key: s1.rtime, s1.rnc, s1.mo"
" Sort Method: external merge Disk: 7646608kB"
" -> Seq Scan on public.hup_hsupa_cell_30 s1 (cost=0.00..1094497.91 rows=9034291 width=853) (actual time=133.033..57236.533 rows=9032851 loops=1)"
" Output: s1.rtime, s1.rnc, s1.mo, s1.c73441236, s1.c73410485, s1.c73410507, s1.c67204515, s1.c67195487, s1.c67195486, s1.c73423362, s1.c73423361, s1.c73423360, s1.c67195488, s1.c67195485, s1.c67194889, s1.c67192365, s1.c67192364, s1.c734 (...)"
"Total runtime: 506580.794 ms"
"Merge Left Join (cost=4276398.70..4545942.23 rows=9032851 width=1714) (actual time=266968.359..319396.887 rows=9032851 loops=1)"
" Output: s0.rtime, s0.rnc, s0.mo, s0.c73410491, s0.c73410492, s0.c73410493, s0.c73410484, s0.c67195481, s0.c67195484, s0.c67195507, s0.c67195511, s0.c67195510, s0.c73423469, s0.c73423462, s0.c67195509, s0.c67195508, s0.c67195512, s0.c67195483, s0.c6719548 (...)"
" Merge Cond: ((s0.rtime = s1.rtime) AND ((s0.rnc)::text = (s1.rnc)::text) AND ((s0.mo)::text = (s1.mo)::text))"
" -> Sort (cost=2138108.66..2160690.79 rows=9032851 width=861) (actual time=105574.796..107264.715 rows=9032851 loops=1)"
" Output: s0.rtime, s0.rnc, s0.mo, s0.c73410491, s0.c73410492, s0.c73410493, s0.c73410484, s0.c67195481, s0.c67195484, s0.c67195507, s0.c67195511, s0.c67195510, s0.c73423469, s0.c73423462, s0.c67195509, s0.c67195508, s0.c67195512, s0.c67195483, s0.c6 (...)"
" Sort Key: s0.rtime, s0.rnc, s0.mo"
" Sort Method: quicksort Memory: 9457815kB"
" -> Seq Scan on public.hup_hsdpa_cell_30 s0 (cost=0.00..1094509.51 rows=9032851 width=861) (actual time=0.007..4288.101 rows=9032851 loops=1)"
" Output: s0.rtime, s0.rnc, s0.mo, s0.c73410491, s0.c73410492, s0.c73410493, s0.c73410484, s0.c67195481, s0.c67195484, s0.c67195507, s0.c67195511, s0.c67195510, s0.c73423469, s0.c73423462, s0.c67195509, s0.c67195508, s0.c67195512, s0.c67195483, (...)"
" -> Sort (cost=2138273.82..2160859.54 rows=9034291 width=853) (actual time=161393.524..163148.254 rows=9032851 loops=1)"
" Output: s1.rtime, s1.rnc, s1.mo, s1.c73441236, s1.c73410485, s1.c73410507, s1.c67204515, s1.c67195487, s1.c67195486, s1.c73423362, s1.c73423361, s1.c73423360, s1.c67195488, s1.c67195485, s1.c67194889, s1.c67192365, s1.c67192364, s1.c73424967, s1.c6 (...)"
" Sort Key: s1.rtime, s1.rnc, s1.mo"
" Sort Method: quicksort Memory: 9457815kB"
" -> Seq Scan on public.hup_hsupa_cell_30 s1 (cost=0.00..1094497.91 rows=9034291 width=853) (actual time=29.185..45921.046 rows=9032851 loops=1)"
" Output: s1.rtime, s1.rnc, s1.mo, s1.c73441236, s1.c73410485, s1.c73410507, s1.c67204515, s1.c67195487, s1.c67195486, s1.c73423362, s1.c73423361, s1.c73423360, s1.c67195488, s1.c67195485, s1.c67194889, s1.c67192365, s1.c67192364, s1.c73424967, (...)"
"Total runtime: 323810.357 ms"