RStudio Desktop is unresponsive for long periods of time after chunks complete

I'm not really sure where to start debugging this, but in the last year I routinely have to wait a few minutes before RStudio becomes responsive after executing code chunks. This is not while RStudio is running a chunk but after chunks complete. I have grown accustomed to running beepr::beep() in the console to signal when RStudio is going to become responsive again.

These delays only seem to happen when RStudio is connected to a database, but I'm not sure how to diagnose or even detect the source of delays as they seem to happen randomly. I am at least sure it's not do to memory issue as the delays happen regardless of how much data I have pulled into memory.

Thanks for your report; we'll try to reproduce this. Could you give us a Reprex (Reproducible Example) that consistently shows this dely?

@MikeBess what would constitute a reprex in this case? Is there code I could run to generate a report that might suggest sources of the delay?

a small code chunk that consistently reproduces the problem would be useful, along with any details of our environment; version of RSTudio, R, and details of the database connection if you feel that's related to the slowdown.

I typically encounter the freeze while connected to my company's AWS Athena database. I connect to Athena via dbConnect and RJDBC (athena_url is a connection string):

athena <- DBI::dbConnect(
			drv = RJDBC::JDBC(classPath = '~/Drivers/AthenaJDBC42.jar'),
			url = athena_url
		)

A typical code chunk like the following might freeze RStudio for 5 minutes, although it's usually the 3rd or 4th sql chunk that sets off the freeze. Mind you these are very small data being returned and the chunk is not executing during the freeze. It's after execution that RStudio becomes unresponsive.

```{sql, connection = athena}
SELECT * 
FROM dlprd.SBG_PUBLISHED.qbcommerce_ongoing_usage
LIMIT 10
```                                                                                          .

I am using RStudio Version 1.3.1093 and 
> R.version
               _                           
platform       x86_64-apple-darwin17.0     
arch           x86_64                      
os             darwin17.0                  
system         x86_64, darwin17.0          
status                                     
major          4                           
minor          0.3                         
year           2020                        
month          10                          
day            10                          
svn rev        79318                       
language       R                           
version.string R version 4.0.3 (2020-10-10)
nickname       Bunny-Wunnies Freak Out

A colleague of mine has noticed that this freeze only occurs when RStudio is connected to our Athena database and that removing this athena connections via rm(athena) will prevent future freezes, but obviously inhibit a workflow where connection to an Athena database is central .

Not sure if this is the same as this issue:
https://github.com/rstudio/rstudio/issues/5805'

Does this only happen when running chunks? Have you tried running the same db code in your console?

Yes I can run db code in my console, but my freeze is a different issue than what you linked to. The period of non-responsiveness does not happen while the sql executes. It can happen anytime while RStudio is connected to Athena. During this period I can type code in the console and in the Rmd document, but I cannot execute any of the code nor save my file. I have taken to typing beepr::beep() in my console and waiting for the beep to indicate that RStudio is responsive again. This non-responsive period typically lasts 5 - 30 minutes.

I am going to try to connect RStudio to Athena via ODBC rather than JDBC to see if this prevents the periods of non-responsiveness in RStudio.

@MikeBess I worked with some AWS engineers on this problem and they suspected that RStudio is intermittently pulling all the metadata from Athena (i.e., the name of every table in Athena), and this is bogging down RStudio and causing it to become unresponsive. Is there a way to deactivate this pulling of metadata by RStudio? Or do you suspect that pulling this metadata is driven by the driver? I am using the AthenaJDBC42.jar Driver.

I was already using the AthenaJDBC42.jar driver but have updated with the latest download of AthenaJDBC42.jar available here. We also removed the default catalog from the connection string for Athena and set UseResultsetStreaming=1 in that string. These changes seem to have prevented further sessions of unresponsiveness, but I will return if anything changes.

This sounds plausible. Beyond explicit user gestures in the Connections pane, most of the UI updates are driven by R itself (e.g. by the driver or by the driver interface package).

There's a couple things we can do to get more information.

The next time the hang occurs, try looking at Help -> Diagnostics -> Request Log. You'll be presented with a graph of some of the different operations RStudio has been doing. If you see a "long" bar (other than 'get_events'), that may be associated with the slowness you're seeing.

You could also try generating an R profile. Within R, execute:

utils::Rprof("~/rstudio-trace.Rprof")

to start the profiler. Then, work with the IDE until the next bit of slowness occurs. When that happens, you can stop the profiler with:

utils::Rprof(NULL)

Then, share the output of:

utils::summaryRprof("~/rstudio-trace.Rprof")

and that may point us towards the function(s) being invoked that are taking a long time to complete.

1 Like

@kevinushey Today when I experienced a lag

  1. I ran Help -> Diagnostics -> Request Log and see several long bars besides "get_events", but I am not sure what remedial actions these bars would suggest I take.

  2. I then began generating an R profile via utils::Rprof("~/rstudio-trace.Rprof") until another lag occurred, at which point I stopped the profiler and generated the output below. Something called .jcall seems to be the culprit.

utils::summaryRprof("~/rstudio-trace.Rprof")
$by.self
self.time self.pct total.time total.pct
".jcall" 86.88 98.13 86.92 98.17
"gc" 0.14 0.16 0.14 0.16
"file.exists" 0.12 0.14 0.12 0.14
"checkConflicts" 0.08 0.09 0.14 0.16
"lazyLoadDBfetch" 0.08 0.09 0.08 0.09
"initialize" 0.06 0.07 0.14 0.16
"paste" 0.06 0.07 0.10 0.11
"paste0" 0.06 0.07 0.10 0.11
"readRDS" 0.06 0.07 0.10 0.11
"%in%" 0.06 0.07 0.06 0.07
"names" 0.06 0.07 0.06 0.07
"importIntoEnv" 0.04 0.05 0.08 0.09
".Call" 0.04 0.05 0.06 0.07
"getInlineHandler" 0.04 0.05 0.04 0.05
"gzfile" 0.04 0.05 0.04 0.05
"FUN" 0.02 0.02 3.48 3.93
"loadNamespace" 0.02 0.02 0.82 0.93
".checkGroupSigLength" 0.02 0.02 0.12 0.14
".makeMessage" 0.02 0.02 0.08 0.09
"is" 0.02 0.02 0.08 0.09
"vapply" 0.02 0.02 0.08 0.09
".recMembers" 0.02 0.02 0.06 0.07
"format" 0.02 0.02 0.06 0.07
"getNamespace" 0.02 0.02 0.06 0.07
"registerS3methods" 0.02 0.02 0.06 0.07
".f" 0.02 0.02 0.04 0.05
".mergeMethodsTable" 0.02 0.02 0.04 0.05
"getClassDef" 0.02 0.02 0.04 0.05
"runUserHook" 0.02 0.02 0.04 0.05
"structure" 0.02 0.02 0.04 0.05
"validObject" 0.02 0.02 0.04 0.05
".getClassesFromCache" 0.02 0.02 0.02 0.02
".getGenericFromCache" 0.02 0.02 0.02 0.02
".identC" 0.02 0.02 0.02 0.02
"@<-" 0.02 0.02 0.02 0.02
"any" 0.02 0.02 0.02 0.02
"close.connection" 0.02 0.02 0.02 0.02
"delayedAssign" 0.02 0.02 0.02 0.02
"dir.create" 0.02 0.02 0.02 0.02
"dir.exists" 0.02 0.02 0.02 0.02
"dyn.load" 0.02 0.02 0.02 0.02
"exists" 0.02 0.02 0.02 0.02
"f" 0.02 0.02 0.02 0.02
"format.person" 0.02 0.02 0.02 0.02
"get" 0.02 0.02 0.02 0.02
"gettext" 0.02 0.02 0.02 0.02
"mget" 0.02 0.02 0.02 0.02
"order" 0.02 0.02 0.02 0.02
"signal_deprecated_cast" 0.02 0.02 0.02 0.02
"strrep" 0.02 0.02 0.02 0.02
"unique.default" 0.02 0.02 0.02 0.02

$by.total
total.time total.pct self.time self.pct
"doTryCatch" 87.50 98.83 0.00 0.00
"tryCatch" 87.50 98.83 0.00 0.00
"tryCatchList" 87.50 98.83 0.00 0.00
"tryCatchOne" 87.50 98.83 0.00 0.00
"withCallingHandlers" 87.44 98.76 0.00 0.00
"" 87.34 98.64 0.00 0.00
".local" 87.02 98.28 0.00 0.00
".jcall" 86.92 98.17 86.88 98.13
".rs.sql.getCompletions" 86.50 97.70 0.00 0.00
"Reduce" 86.50 97.70 0.00 0.00
".rs.tryCatch" 86.32 97.49 0.00 0.00
".rs.sql.getCompletionsTables" 84.14 95.03 0.00 0.00
".rs.sql.listTables" 84.14 95.03 0.00 0.00
"system.time" 84.12 95.01 0.00 0.00
"DBI::dbListTables" 83.98 94.85 0.00 0.00
"FUN" 3.48 3.93 0.02 0.02
"lapply" 3.46 3.91 0.00 0.00
"dbSendQuery" 2.40 2.71 0.00 0.00
".rs.sql.getCompletionsFields" 2.36 2.67 0.00 0.00
".rs.db.listFields" 2.34 2.64 0.00 0.00
"DBI::dbListFields" 2.34 2.64 0.00 0.00
"list_fields" 2.34 2.64 0.00 0.00
"library" 1.12 1.26 0.00 0.00
"require" 1.12 1.26 0.00 0.00
"pacman::p_load" 1.10 1.24 0.00 0.00
"sapply" 1.10 1.24 0.00 0.00
"suppressMessages" 1.10 1.24 0.00 0.00
"suppressWarnings" 1.10 1.24 0.00 0.00
"loadNamespace" 0.82 0.93 0.02 0.02
"namespaceImportFrom" 0.54 0.61 0.00 0.00
"DBI::dbSendQuery" 0.52 0.59 0.00 0.00
"asNamespace" 0.50 0.56 0.00 0.00
"runHook" 0.24 0.27 0.00 0.00
"fun" 0.22 0.25 0.00 0.00
"methods::cacheMetaData" 0.22 0.25 0.00 0.00
".updateMethodsInTable" 0.20 0.23 0.00 0.00
"attachNamespace" 0.20 0.23 0.00 0.00
"gc" 0.14 0.16 0.14 0.16
"checkConflicts" 0.14 0.16 0.08 0.09
"initialize" 0.14 0.16 0.06 0.07
"do.call" 0.14 0.16 0.00 0.00
"new" 0.14 0.16 0.00 0.00
"Recall" 0.14 0.16 0.00 0.00
"file.exists" 0.12 0.14 0.12 0.14
".checkGroupSigLength" 0.12 0.14 0.02 0.02
"connect_to_athena" 0.12 0.14 0.00 0.00
"DBI::dbConnect" 0.12 0.14 0.00 0.00
"paste" 0.10 0.11 0.06 0.07
"paste0" 0.10 0.11 0.06 0.07
"readRDS" 0.10 0.11 0.06 0.07
".encode_numeric_version" 0.10 0.11 0.00 0.00
"find.package" 0.10 0.11 0.00 0.00
"getGeneric" 0.10 0.11 0.00 0.00
"Ops.numeric_version" 0.10 0.11 0.00 0.00
"split" 0.10 0.11 0.00 0.00
"standardGeneric" 0.10 0.11 0.00 0.00
"tidyverse_attach" 0.10 0.11 0.00 0.00
"lazyLoadDBfetch" 0.08 0.09 0.08 0.09
"importIntoEnv" 0.08 0.09 0.04 0.05
".makeMessage" 0.08 0.09 0.02 0.02
"is" 0.08 0.09 0.02 0.02
"vapply" 0.08 0.09 0.02 0.02
".verify.JDBC.result" 0.08 0.09 0.00 0.00
">=" 0.08 0.09 0.00 0.00
"DBI::dbGetQuery" 0.08 0.09 0.00 0.00
"%in%" 0.06 0.07 0.06 0.07
"names" 0.06 0.07 0.06 0.07
".Call" 0.06 0.07 0.04 0.05
".recMembers" 0.06 0.07 0.02 0.02
"format" 0.06 0.07 0.02 0.02
"getNamespace" 0.06 0.07 0.02 0.02
"registerS3methods" 0.06 0.07 0.02 0.02
".getGeneric" 0.06 0.07 0.00 0.00
".jgetEx" 0.06 0.07 0.00 0.00
"attach" 0.06 0.07 0.00 0.00
"cmp" 0.06 0.07 0.00 0.00
"cmpCall" 0.06 0.07 0.00 0.00
"cmpfun" 0.06 0.07 0.00 0.00
"compiler:::tryCmpfun" 0.06 0.07 0.00 0.00
"crayon::white" 0.06 0.07 0.00 0.00
"genCode" 0.06 0.07 0.00 0.00
"getGroupMembers" 0.06 0.07 0.00 0.00
"h" 0.06 0.07 0.00 0.00
"msg" 0.06 0.07 0.00 0.00
"mypaste" 0.06 0.07 0.00 0.00
"packageStartupMessage" 0.06 0.07 0.00 0.00
"strrpad" 0.06 0.07 0.00 0.00
"text_col" 0.06 0.07 0.00 0.00
"tidyverse_conflicts" 0.06 0.07 0.00 0.00
"tryInline" 0.06 0.07 0.00 0.00
"getInlineHandler" 0.04 0.05 0.04 0.05
"gzfile" 0.04 0.05 0.04 0.05
".f" 0.04 0.05 0.02 0.02
".mergeMethodsTable" 0.04 0.05 0.02 0.02
"getClassDef" 0.04 0.05 0.02 0.02
"runUserHook" 0.04 0.05 0.02 0.02
"structure" 0.04 0.05 0.02 0.02
"validObject" 0.04 0.05 0.02 0.02
"::" 0.04 0.05 0.00 0.00
".External2" 0.04 0.05 0.00 0.00
".rs.isBrowserActive" 0.04 0.05 0.00 0.00
"%>%" 0.04 0.05 0.00 0.00
"as<-" 0.04 0.05 0.00 0.00
"dbQuoteIdentifier" 0.04 0.05 0.00 0.00
"eval" 0.04 0.05 0.00 0.00
"fetch" 0.04 0.05 0.00 0.00
"getExportedValue" 0.04 0.05 0.00 0.00
"library.dynam" 0.04 0.05 0.00 0.00
"map_lgl" 0.04 0.05 0.00 0.00
"methods::setOldClass" 0.04 0.05 0.00 0.00
"probe" 0.04 0.05 0.00 0.00
"purrr::keep" 0.04 0.05 0.00 0.00
"setClass" 0.04 0.05 0.00 0.00
"sprintf" 0.04 0.05 0.00 0.00
"SQL" 0.04 0.05 0.00 0.00
"stop" 0.04 0.05 0.00 0.00
"suppressPackageStartupMessages" 0.04 0.05 0.00 0.00
"try" 0.04 0.05 0.00 0.00
"unique" 0.04 0.05 0.00 0.00
"unlist" 0.04 0.05 0.00 0.00
".getClassesFromCache" 0.02 0.02 0.02 0.02
".getGenericFromCache" 0.02 0.02 0.02 0.02
".identC" 0.02 0.02 0.02 0.02
"@<-" 0.02 0.02 0.02 0.02
"any" 0.02 0.02 0.02 0.02
"close.connection" 0.02 0.02 0.02 0.02
"delayedAssign" 0.02 0.02 0.02 0.02
"dir.create" 0.02 0.02 0.02 0.02
"dir.exists" 0.02 0.02 0.02 0.02
"dyn.load" 0.02 0.02 0.02 0.02
"exists" 0.02 0.02 0.02 0.02
"f" 0.02 0.02 0.02 0.02
"format.person" 0.02 0.02 0.02 0.02
"get" 0.02 0.02 0.02 0.02
"gettext" 0.02 0.02 0.02 0.02
"mget" 0.02 0.02 0.02 0.02
"order" 0.02 0.02 0.02 0.02
"signal_deprecated_cast" 0.02 0.02 0.02 0.02
"strrep" 0.02 0.02 0.02 0.02
"unique.default" 0.02 0.02 0.02 0.02
".checkRequiredGenerics" 0.02 0.02 0.00 0.00
".classEnv" 0.02 0.02 0.00 0.00
".combineExtends" 0.02 0.02 0.00 0.00
".find_tzdir" 0.02 0.02 0.00 0.00
".findMethodInTable" 0.02 0.02 0.00 0.00
".fmt" 0.02 0.02 0.00 0.00
".quickCoerceSelect" 0.02 0.02 0.00 0.00
".registerS3method" 0.02 0.02 0.00 0.00
".requirePackage" 0.02 0.02 0.00 0.00
".rs.isPackageInstalled" 0.02 0.02 0.00 0.00
".rs.valueContents" 0.02 0.02 0.00 0.00
".sigLabel" 0.02 0.02 0.00 0.00
".TableMetaName" 0.02 0.02 0.00 0.00
".transitiveExtends" 0.02 0.02 0.00 0.00
"addImports" 0.02 0.02 0.00 0.00
"arrange_rows" 0.02 0.02 0.00 0.00
"arrange.data.frame" 0.02 0.02 0.00 0.00
"arrange" 0.02 0.02 0.00 0.00
"as_character" 0.02 0.02 0.00 0.00
"as_mapper.default" 0.02 0.02 0.00 0.00
"as_mapper" 0.02 0.02 0.00 0.00
"as_utf8_character" 0.02 0.02 0.00 0.00
"as.character.person" 0.02 0.02 0.00 0.00
"as.character" 0.02 0.02 0.00 0.00
"as.data.frame" 0.02 0.02 0.00 0.00
"asMethod" 0.02 0.02 0.00 0.00
"assert_that" 0.02 0.02 0.00 0.00
"assignWrapped" 0.02 0.02 0.00 0.00
"bibentry" 0.02 0.02 0.00 0.00
"bindTranslations" 0.02 0.02 0.00 0.00
"cacheGenericsMetaData" 0.02 0.02 0.00 0.00
"callFun" 0.02 0.02 0.00 0.00
"cb$putconst" 0.02 0.02 0.00 0.00
"cli::rule" 0.02 0.02 0.00 0.00
"close" 0.02 0.02 0.00 0.00
"cmpCallArgs" 0.02 0.02 0.00 0.00
"cmpCallSymFun" 0.02 0.02 0.00 0.00
"cmpSymbolAssign" 0.02 0.02 0.00 0.00
"completeSubclasses" 0.02 0.02 0.00 0.00
"console_width" 0.02 0.02 0.00 0.00
"constantFold" 0.02 0.02 0.00 0.00
"constantFoldCall" 0.02 0.02 0.00 0.00
"DBI::dbFetch" 0.02 0.02 0.00 0.00
"DBI::dbIsValid" 0.02 0.02 0.00 0.00
"dplyr_col_modify.data.frame" 0.02 0.02 0.00 0.00
"dplyr_col_modify" 0.02 0.02 0.00 0.00
"encodeString" 0.02 0.02 0.00 0.00
"eval.parent" 0.02 0.02 0.00 0.00
"factor" 0.02 0.02 0.00 0.00
"findCenvVar" 0.02 0.02 0.00 0.00
"format.default" 0.02 0.02 0.00 0.00
"get_data" 0.02 0.02 0.00 0.00
"get0" 0.02 0.02 0.00 0.00
"getFoldFun" 0.02 0.02 0.00 0.00
"getHook" 0.02 0.02 0.00 0.00
"getInlineInfo" 0.02 0.02 0.00 0.00
"getNamespaceInfo" 0.02 0.02 0.00 0.00
"gettextf" 0.02 0.02 0.00 0.00
"grepl" 0.02 0.02 0.00 0.00
"invert" 0.02 0.02 0.00 0.00
"is_count" 0.02 0.02 0.00 0.00
"isBaseVar" 0.02 0.02 0.00 0.00
"lazyLoad" 0.02 0.02 0.00 0.00
"lazyLoadDBexec" 0.02 0.02 0.00 0.00
"local" 0.02 0.02 0.00 0.00
"map2" 0.02 0.02 0.00 0.00
"methods:::.getGenerics" 0.02 0.02 0.00 0.00
"methodsPackageMetaName" 0.02 0.02 0.00 0.00
"mutate.data.frame" 0.02 0.02 0.00 0.00
"mutate" 0.02 0.02 0.00 0.00
"packageEvent" 0.02 0.02 0.00 0.00
"purrr::imap" 0.02 0.02 0.00 0.00
"rstudio$detect" 0.02 0.02 0.00 0.00
"save" 0.02 0.02 0.00 0.00
"see_if" 0.02 0.02 0.00 0.00
"setIs" 0.02 0.02 0.00 0.00
"sys.source" 0.02 0.02 0.00 0.00
"system.file" 0.02 0.02 0.00 0.00
"tapply" 0.02 0.02 0.00 0.00
"testRversion" 0.02 0.02 0.00 0.00
"transmute.data.frame" 0.02 0.02 0.00 0.00
"transmute" 0.02 0.02 0.00 0.00

$sample.interval
[1] 0.02

$sampling.time
[1] 88.54

Thanks! The output here makes it clear that the slowness is caused by RStudio's completion engine, which is trying to list tables on the completion engine:

"doTryCatch" 87.50 98.83 0.00 0.00
"tryCatch" 87.50 98.83 0.00 0.00
"tryCatchList" 87.50 98.83 0.00 0.00
"tryCatchOne" 87.50 98.83 0.00 0.00
"withCallingHandlers" 87.44 98.76 0.00 0.00
"" 87.34 98.64 0.00 0.00
".local" 87.02 98.28 0.00 0.00
".jcall" 86.92 98.17 86.88 98.13
".rs.sql.getCompletions" 86.50 97.70 0.00 0.00
"Reduce" 86.50 97.70 0.00 0.00
".rs.tryCatch" 86.32 97.49 0.00 0.00
".rs.sql.getCompletionsTables" 84.14 95.03 0.00 0.00
".rs.sql.listTables" 84.14 95.03 0.00 0.00

It may be worth checking if disabling automatic completions makes a difference here:

1 Like

@kevinushey I have disabled autocompletions as you advised, but I am still experiencing frequent lags. I reran the summary after another lag. Do you have any other suggestions? For instance is there a way to disable R from fetching metadata from Athena?

utils::summaryRprof("~/rstudio-trace.Rprof")
$by.self
self.time self.pct
".jcall" 1.12 90.32
"as<-" 0.02 1.61
".mergeAttrs" 0.02 1.61
"file.path" 0.02 1.61
"gregexpr" 0.02 1.61
"is" 0.02 1.61
"sqlParseVariablesImpl" 0.02 1.61
total.time total.pct
".jcall" 1.12 90.32
"as<-" 0.04 3.23
".mergeAttrs" 0.02 1.61
"file.path" 0.02 1.61
"gregexpr" 0.02 1.61
"is" 0.02 1.61
"sqlParseVariablesImpl" 0.02 1.61

$by.total
total.time total.pct
"" 1.24 100.00
".local" 1.14 91.94
".jcall" 1.12 90.32
".rs.sql.getCompletions" 0.88 70.97
"FUN" 0.88 70.97
".rs.db.listFields" 0.86 69.35
".rs.sql.getCompletionsFields" 0.86 69.35
".rs.tryCatch" 0.86 69.35
"DBI::dbListFields" 0.86 69.35
"dbSendQuery" 0.86 69.35
"doTryCatch" 0.86 69.35
"lapply" 0.86 69.35
"list_fields" 0.86 69.35
"Reduce" 0.86 69.35
"tryCatch" 0.86 69.35
"tryCatchList" 0.86 69.35
"tryCatchOne" 0.86 69.35
"withCallingHandlers" 0.86 69.35
"DBI::dbSendQuery" 0.30 24.19
"as<-" 0.04 3.23
"dbQuoteIdentifier" 0.04 3.23
"initialize" 0.04 3.23
"new" 0.04 3.23
"paste" 0.04 3.23
"paste0" 0.04 3.23
"SQL" 0.04 3.23
".mergeAttrs" 0.02 1.61
"file.path" 0.02 1.61
"gregexpr" 0.02 1.61
"is" 0.02 1.61
"sqlParseVariablesImpl" 0.02 1.61
".jidenticalRef" 0.02 1.61
".rs.isPackageInstalled" 0.02 1.61
".rs.strsplit" 0.02 1.61
".verify.JDBC.result" 0.02 1.61
"asMethod" 0.02 1.61
"DBI::dbFetch" 0.02 1.61
"DBI::sqlParseVariables" 0.02 1.61
"fetch" 0.02 1.61
"find.package" 0.02 1.61
"interpolate_from_env" 0.02 1.61
"is.jnull" 0.02 1.61
"setDataPart" 0.02 1.61
"system.file" 0.02 1.61
"unique" 0.02 1.61
"vapply" 0.02 1.61
"varnames_from_sql" 0.02 1.61
self.time self.pct
"" 0.00 0.00
".local" 0.00 0.00
".jcall" 1.12 90.32
".rs.sql.getCompletions" 0.00 0.00
"FUN" 0.00 0.00
".rs.db.listFields" 0.00 0.00
".rs.sql.getCompletionsFields" 0.00 0.00
".rs.tryCatch" 0.00 0.00
"DBI::dbListFields" 0.00 0.00
"dbSendQuery" 0.00 0.00
"doTryCatch" 0.00 0.00
"lapply" 0.00 0.00
"list_fields" 0.00 0.00
"Reduce" 0.00 0.00
"tryCatch" 0.00 0.00
"tryCatchList" 0.00 0.00
"tryCatchOne" 0.00 0.00
"withCallingHandlers" 0.00 0.00
"DBI::dbSendQuery" 0.00 0.00
"as<-" 0.02 1.61
"dbQuoteIdentifier" 0.00 0.00
"initialize" 0.00 0.00
"new" 0.00 0.00
"paste" 0.00 0.00
"paste0" 0.00 0.00
"SQL" 0.00 0.00
".mergeAttrs" 0.02 1.61
"file.path" 0.02 1.61
"gregexpr" 0.02 1.61
"is" 0.02 1.61
"sqlParseVariablesImpl" 0.02 1.61
".jidenticalRef" 0.00 0.00
".rs.isPackageInstalled" 0.00 0.00
".rs.strsplit" 0.00 0.00
".verify.JDBC.result" 0.00 0.00
"asMethod" 0.00 0.00
"DBI::dbFetch" 0.00 0.00
"DBI::sqlParseVariables" 0.00 0.00
"fetch" 0.00 0.00
"find.package" 0.00 0.00
"interpolate_from_env" 0.00 0.00
"is.jnull" 0.00 0.00
"setDataPart" 0.00 0.00
"system.file" 0.00 0.00
"unique" 0.00 0.00
"vapply" 0.00 0.00
"varnames_from_sql" 0.00 0.00

$sample.interval
[1] 0.02

$sampling.time
[1] 1.24

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.