Guest User

Untitled

a guest
Mar 23rd, 2019
28
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Append (cost=0.00..9254700.26 rows=79555 width=177) (actual time=0.045..1552466.772 rows=39844 loops=1)
  2. Buffers: shared hit=119539 read=4174474
  3. -> Seq Scan on mimiciii.chartevents (cost=0.00..0.00 rows=1 width=926) (actual time=0.002..0.002 rows=0 loops=1)
  4. Output: chartevents.row_id, chartevents.subject_id, chartevents.hadm_id, chartevents.icustay_id, chartevents.itemid, chartevents.charttime, chartevents.storetime, chartevents.cgid, chartevents.value, chartevents.valuenum, chartevents.valueuom, chartevents.warning, chartevents.error, chartevents.resultstatus, chartevents.stopped
  5. Filter: ((chartevents.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents.icustay_id = 273993))
  6. -> Seq Scan on mimiciii.chartevents_1 (cost=0.00..514731.80 rows=7205 width=83) (actual time=0.040..55051.888 rows=4056 loops=1)
  7. Output: chartevents_1.row_id, chartevents_1.subject_id, chartevents_1.hadm_id, chartevents_1.icustay_id, chartevents_1.itemid, chartevents_1.charttime, chartevents_1.storetime, chartevents_1.cgid, chartevents_1.value, chartevents_1.valuenum, chartevents_1.valueuom, chartevents_1.warning, chartevents_1.error, chartevents_1.resultstatus, chartevents_1.stopped
  8. Filter: ((chartevents_1.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_1.icustay_id = 273993))
  9. Rows Removed by Filter: 18382264
  10. Buffers: shared hit=93833 read=145104
  11. -> Seq Scan on mimiciii.chartevents_2 (cost=0.00..545221.60 rows=11110 width=196) (actual time=83061.291..95694.298 rows=5093 loops=1)
  12. Output: chartevents_2.row_id, chartevents_2.subject_id, chartevents_2.hadm_id, chartevents_2.icustay_id, chartevents_2.itemid, chartevents_2.charttime, chartevents_2.storetime, chartevents_2.cgid, chartevents_2.value, chartevents_2.valuenum, chartevents_2.valueuom, chartevents_2.warning, chartevents_2.error, chartevents_2.resultstatus, chartevents_2.stopped
  13. Filter: ((chartevents_2.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_2.icustay_id = 273993))
  14. Rows Removed by Filter: 19642148
  15. Buffers: shared hit=1431 read=249082
  16. -> Seq Scan on mimiciii.chartevents_3 (cost=0.00..584741.28 rows=15421 width=194) (actual time=73534.610..103647.970 rows=6141 loops=1)
  17. Output: chartevents_3.row_id, chartevents_3.subject_id, chartevents_3.hadm_id, chartevents_3.icustay_id, chartevents_3.itemid, chartevents_3.charttime, chartevents_3.storetime, chartevents_3.cgid, chartevents_3.value, chartevents_3.valuenum, chartevents_3.valueuom, chartevents_3.warning, chartevents_3.error, chartevents_3.resultstatus, chartevents_3.stopped
  18. Filter: ((chartevents_3.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_3.icustay_id = 273993))
  19. Rows Removed by Filter: 20922011
  20. Buffers: shared hit=1440 read=269379
  21. -> Seq Scan on mimiciii.chartevents_4 (cost=0.00..539716.51 rows=8352 width=195) (actual time=69407.843..96484.559 rows=2358 loops=1)
  22. Output: chartevents_4.row_id, chartevents_4.subject_id, chartevents_4.hadm_id, chartevents_4.icustay_id, chartevents_4.itemid, chartevents_4.charttime, chartevents_4.storetime, chartevents_4.cgid, chartevents_4.value, chartevents_4.valuenum, chartevents_4.valueuom, chartevents_4.warning, chartevents_4.error, chartevents_4.resultstatus, chartevents_4.stopped
  23. Filter: ((chartevents_4.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_4.icustay_id = 273993))
  24. Rows Removed by Filter: 19127276
  25. Buffers: shared hit=1440 read=251332
  26. -> Seq Scan on mimiciii.chartevents_5 (cost=0.00..607081.78 rows=9608 width=193) (actual time=83304.082..107759.448 rows=4165 loops=1)
  27. Output: chartevents_5.row_id, chartevents_5.subject_id, chartevents_5.hadm_id, chartevents_5.icustay_id, chartevents_5.itemid, chartevents_5.charttime, chartevents_5.storetime, chartevents_5.cgid, chartevents_5.value, chartevents_5.valuenum, chartevents_5.valueuom, chartevents_5.warning, chartevents_5.error, chartevents_5.resultstatus, chartevents_5.stopped
  28. Filter: ((chartevents_5.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_5.icustay_id = 273993))
  29. Rows Removed by Filter: 21675287
  30. Buffers: shared hit=1644 read=280246
  31. -> Seq Scan on mimiciii.chartevents_6 (cost=0.00..497219.00 rows=8630 width=195) (actual time=66589.267..88970.492 rows=3898 loops=1)
  32. Output: chartevents_6.row_id, chartevents_6.subject_id, chartevents_6.hadm_id, chartevents_6.icustay_id, chartevents_6.itemid, chartevents_6.charttime, chartevents_6.storetime, chartevents_6.cgid, chartevents_6.value, chartevents_6.valuenum, chartevents_6.valueuom, chartevents_6.warning, chartevents_6.error, chartevents_6.resultstatus, chartevents_6.stopped
  33. Filter: ((chartevents_6.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_6.icustay_id = 273993))
  34. Rows Removed by Filter: 17608102
  35. Buffers: shared hit=1664 read=231375
  36. -> Seq Scan on mimiciii.chartevents_7 (cost=0.00..583142.58 rows=7126 width=78) (actual time=88850.728..104044.006 rows=3954 loops=1)
  37. Output: chartevents_7.row_id, chartevents_7.subject_id, chartevents_7.hadm_id, chartevents_7.icustay_id, chartevents_7.itemid, chartevents_7.charttime, chartevents_7.storetime, chartevents_7.cgid, chartevents_7.value, chartevents_7.valuenum, chartevents_7.valueuom, chartevents_7.warning, chartevents_7.error, chartevents_7.resultstatus, chartevents_7.stopped
  38. Filter: ((chartevents_7.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_7.icustay_id = 273993))
  39. Rows Removed by Filter: 20699217
  40. Buffers: shared hit=1664 read=270931
  41. -> Seq Scan on mimiciii.chartevents_8 (cost=0.00..607184.18 rows=1320 width=79) (actual time=76862.276..105905.309 rows=2231 loops=1)
  42. Output: chartevents_8.row_id, chartevents_8.subject_id, chartevents_8.hadm_id, chartevents_8.icustay_id, chartevents_8.itemid, chartevents_8.charttime, chartevents_8.storetime, chartevents_8.cgid, chartevents_8.value, chartevents_8.valuenum, chartevents_8.valueuom, chartevents_8.warning, chartevents_8.error, chartevents_8.resultstatus, chartevents_8.stopped
  43. Filter: ((chartevents_8.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_8.icustay_id = 273993))
  44. Rows Removed by Filter: 21887180
  45. Buffers: shared hit=1664 read=277179
  46. -> Seq Scan on mimiciii.chartevents_9 (cost=0.00..562228.18 rows=3654 width=194) (actual time=99139.706..99139.707 rows=0 loops=1)
  47. Output: chartevents_9.row_id, chartevents_9.subject_id, chartevents_9.hadm_id, chartevents_9.icustay_id, chartevents_9.itemid, chartevents_9.charttime, chartevents_9.storetime, chartevents_9.cgid, chartevents_9.value, chartevents_9.valuenum, chartevents_9.valueuom, chartevents_9.warning, chartevents_9.error, chartevents_9.resultstatus, chartevents_9.stopped
  48. Filter: ((chartevents_9.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_9.icustay_id = 273993))
  49. Rows Removed by Filter: 20000213
  50. Buffers: shared hit=1639 read=260586
  51. -> Seq Scan on mimiciii.chartevents_10 (cost=0.00..549625.45 rows=875 width=79) (actual time=1983.209..97577.222 rows=4281 loops=1)
  52. Output: chartevents_10.row_id, chartevents_10.subject_id, chartevents_10.hadm_id, chartevents_10.icustay_id, chartevents_10.itemid, chartevents_10.charttime, chartevents_10.storetime, chartevents_10.cgid, chartevents_10.value, chartevents_10.valuenum, chartevents_10.valueuom, chartevents_10.warning, chartevents_10.error, chartevents_10.resultstatus, chartevents_10.stopped
  53. Filter: ((chartevents_10.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_10.icustay_id = 273993))
  54. Rows Removed by Filter: 19586749
  55. Buffers: shared hit=1600 read=254160
  56. -> Seq Scan on mimiciii.chartevents_11 (cost=0.00..509148.39 rows=870 width=192) (actual time=76790.316..90323.154 rows=1876 loops=1)
  57. Output: chartevents_11.row_id, chartevents_11.subject_id, chartevents_11.hadm_id, chartevents_11.icustay_id, chartevents_11.itemid, chartevents_11.charttime, chartevents_11.storetime, chartevents_11.cgid, chartevents_11.value, chartevents_11.valuenum, chartevents_11.valueuom, chartevents_11.warning, chartevents_11.error, chartevents_11.resultstatus, chartevents_11.stopped
  58. Filter: ((chartevents_11.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_11.icustay_id = 273993))
  59. Rows Removed by Filter: 18162350
  60. Buffers: shared hit=1568 read=235117
  61. -> Seq Scan on mimiciii.chartevents_12 (cost=0.00..582220.22 rows=740 width=192) (actual time=81593.928..105099.623 rows=849 loops=1)
  62. Output: chartevents_12.row_id, chartevents_12.subject_id, chartevents_12.hadm_id, chartevents_12.icustay_id, chartevents_12.itemid, chartevents_12.charttime, chartevents_12.storetime, chartevents_12.cgid, chartevents_12.value, chartevents_12.valuenum, chartevents_12.valueuom, chartevents_12.warning, chartevents_12.error, chartevents_12.resultstatus, chartevents_12.stopped
  63. Filter: ((chartevents_12.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_12.icustay_id = 273993))
  64. Rows Removed by Filter: 20500300
  65. Buffers: shared hit=1568 read=273135
  66. -> Seq Scan on mimiciii.chartevents_13 (cost=0.00..607012.16 rows=1034 width=302) (actual time=102153.167..107445.933 rows=269 loops=1)
  67. Output: chartevents_13.row_id, chartevents_13.subject_id, chartevents_13.hadm_id, chartevents_13.icustay_id, chartevents_13.itemid, chartevents_13.charttime, chartevents_13.storetime, chartevents_13.cgid, chartevents_13.value, chartevents_13.valuenum, chartevents_13.valueuom, chartevents_13.warning, chartevents_13.error, chartevents_13.resultstatus, chartevents_13.stopped
  68. Filter: ((chartevents_13.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_13.icustay_id = 273993))
  69. Rows Removed by Filter: 21703876
  70. Buffers: shared hit=1536 read=279914
  71. -> Seq Scan on mimiciii.chartevents_14 (cost=0.00..539048.98 rows=943 width=305) (actual time=94674.922..94674.922 rows=0 loops=1)
  72. Output: chartevents_14.row_id, chartevents_14.subject_id, chartevents_14.hadm_id, chartevents_14.icustay_id, chartevents_14.itemid, chartevents_14.charttime, chartevents_14.storetime, chartevents_14.cgid, chartevents_14.value, chartevents_14.valuenum, chartevents_14.valueuom, chartevents_14.warning, chartevents_14.error, chartevents_14.resultstatus, chartevents_14.stopped
  73. Filter: ((chartevents_14.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_14.icustay_id = 273993))
  74. Rows Removed by Filter: 19407331
  75. Buffers: shared hit=1504 read=246435
  76. -> Seq Scan on mimiciii.chartevents_15 (cost=0.00..566440.22 rows=1089 width=304) (actual time=82050.771..99307.797 rows=69 loops=1)
  77. Output: chartevents_15.row_id, chartevents_15.subject_id, chartevents_15.hadm_id, chartevents_15.icustay_id, chartevents_15.itemid, chartevents_15.charttime, chartevents_15.storetime, chartevents_15.cgid, chartevents_15.value, chartevents_15.valuenum, chartevents_15.valueuom, chartevents_15.warning, chartevents_15.error, chartevents_15.resultstatus, chartevents_15.stopped
  78. Filter: ((chartevents_15.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_15.icustay_id = 273993))
  79. Rows Removed by Filter: 20452678
  80. Buffers: shared hit=1484 read=258165
  81. -> Seq Scan on mimiciii.chartevents_16 (cost=0.00..558218.52 rows=954 width=302) (actual time=15861.504..65758.897 rows=604 loops=1)
  82. Output: chartevents_16.row_id, chartevents_16.subject_id, chartevents_16.hadm_id, chartevents_16.icustay_id, chartevents_16.itemid, chartevents_16.charttime, chartevents_16.storetime, chartevents_16.cgid, chartevents_16.value, chartevents_16.valuenum, chartevents_16.valueuom, chartevents_16.warning, chartevents_16.error, chartevents_16.resultstatus, chartevents_16.stopped
  83. Filter: ((chartevents_16.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_16.icustay_id = 273993))
  84. Rows Removed by Filter: 20193963
  85. Buffers: shared hit=1940 read=253360
  86. -> Seq Scan on mimiciii.chartevents_17 (cost=0.00..301719.41 rows=623 width=311) (actual time=35565.257..35565.257 rows=0 loops=1)
  87. Output: chartevents_17.row_id, chartevents_17.subject_id, chartevents_17.hadm_id, chartevents_17.icustay_id, chartevents_17.itemid, chartevents_17.charttime, chartevents_17.storetime, chartevents_17.cgid, chartevents_17.value, chartevents_17.valuenum, chartevents_17.valueuom, chartevents_17.warning, chartevents_17.error, chartevents_17.resultstatus, chartevents_17.stopped
  88. Filter: ((chartevents_17.charttime >= '2128-02-15 21:00:00'::timestamp without time zone) AND (chartevents_17.icustay_id = 273993))
  89. Rows Removed by Filter: 10721694
  90. Buffers: shared hit=1920 read=138974
  91. Planning time: 487.304 ms
  92. Execution time: 1552475.048 ms
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×